Choose SQL View from the View menu when you're in Query Design. John Viescas, author "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" ...
Did the query run and just not do anything? Or did the query fail with an error? You must be very precise with your syntax in SQL -- for example, you must ...
LTP, The SQL that John provided worked for me. I did have to remove the ";" from one of the lines. I am also new to Access 2000 and I'm learning by trial and...
To simplify matters I have created: 1 table called AllCompanies with only one field CompanyName 2. table called CompanyDelete with only one field CompanyName ...
I just made it work. My thanks to you, John V and many others around the world literally. regards [Non-text portions of this message have been removed]...
thank you John. It worked. Now I have to figure out how to use the CompanyDelete file with the daily AllCompanies. I am sure that I will not have to type the...
Thank you, thank you and thank you. It works beautifully. Now my next problem is how to keep using the same CompanyDelete file and not having to create it...
DELETE AllCompanies.* FROM AllCompanies WHERE AllCompanies.CompanyName IN (SELECT CompanyName FROM CompanyDelete) John Viescas, author "Microsoft Office Access...
Well, as long as you don't delete the CompanyDelete file, it should be there to use again the next time. John Viescas, author "Microsoft Office Access 2003...
the new AllCompanies table would have to have its own Query to delete unwanted records, will that query automatically look for the names in companyDelete?...
Dear All, Anyone knew how to use Access to control over the barcode printing. Or put it this way, how to write a barcode printing program (maybe like the one...
Hi everyone, I've had a couple demo's promised for a while and I finally got motivated and finished them. The first demo show's how to manipulate the clipboard...
Does anyone know the way how to solve the problem like this: A text box with input mask "AAAAAA" is created to capture user input. Few users found that the...
hi, Transaction table with records from Jan, 01 2003 to Dec, 31 2003. How do I extract data from a table with same day for the past 3 or more months. e.g. of...
Well, you can do: WHERE Day([MyDate]) = [Select the day number you want:] .. but what do you plan to do about days 29-31? Not all months have those days. John...
Thanks Brett! I tried but wondering you got any clue how to interact the data from Access to the Barcode font (working particularly with format EAN-13)? I...
... It's a while since I did it Arnold, but once the font is installed - it is installed in Windows, so is available to all programs. - you just set the font...
Hi All: I'm having a bad memory day. Hope someone can help. I am putting a drop down box in a form. I have added the fields that I want the user to choose from...
Hi Neil: I "think" I have that set. The "Control source" is set to "AP_TIME" which is the field I want it to update and it DOES update when "drop it down" and ...
Dave- What's the Row Source of the combo (the SQL if it's a query), the Control Source, and the Bound Column? If the value of the control source matches the...
Hello All, I am new to Access and I have volunteer to build a membership database for a Finnish Cultural Club. I have the database completed but I am running...
Roy- In Access, you can also use + as a concatenation operator, but unlike &, it does propogate nulls. (Null propogation: Any expression containing a null ...
John, Thanks, that did it. Roy ... From: ms_access@yahoogroups.com Date: 07/05/04 16:14:58 To: ms_access@yahoogroups.com Subject: RE: [ms_access] Labels Roy- ...
John, I read that it should be there and it is but when I open the new file it only shows the new table and not the CompanyDelete file. I am sure there is an...
... The only way it can not be there is if you deleted it. Nothing in the code deleted the table all by itself. Brett ... Outgoing mail is certified Virus...
Hi John and Brett, I got a problem with printing out the info on the 4" wide receipt paper. You see, if i got only 2 rows of info to be printed, but it will...
Hello, I am new to email applications but understand that I can send an email from an Access database. does anyone have a generic code snipet that I can use? ...
I can readily see that the code is NOT the problem but the problem does exist and I simply dont understand why. I will try a few more times and if not...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
