On the query tab of the database window click New and then select unmatched query. That will get you started. May God bless you beyond your imagination! Lonnie...
Hello, I would like to automatise the building (and saving) of 200 queries. The queries are based on one table only. They differ from each other only by the...
Thank you very much Lonnie, your code with the comments on each instruction is the VBA teaching i need ! GC [Non-text portions of this message have been...
np. Let me know if it works for you. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit...
Hello, In a select statement, how do you get the value of "TES_1MGMT - ALL_SUBMIT" from a sample field value of AddUserToUserClass,"ADSEN, Audun","TES_1MGMT -...
Not sure what you mean here. Is AddUserToUserClass a table or query? What do you mean by a sample field? May God bless you beyond your imagination! ...
If there are not a lot of columns to convert you could do a union query. Normal query "SELECT " May God bless you beyond your imagination! Lonnie Johnson ...
Sorry. I hit the send button by mistake. If there are not a lot of columns to convert you could do a union query. Normal query "SELECT COLUMN1, COLUMN2...
Sorry. I answered the wrong post before. If there are not a lot of columns to convert you could do a union query. Normal query "SELECT COLUMN1, COLUMN2...
AddUserToUserClass, "ADSEN, Audun","TES_ 1MGMT - ALL_SUBMIT" is a field value. Through a select statement, how do I get 'TES_ 1MGMT - ALL_SUBMIT'. To...
Ok. Forgive me if I sound dense but AddUserToUserClass, "ADSEN, Audun","TES_ 1MGMT - ALL_SUBMIT" is the value of just one field? Is it always formatted the...
Yes, it is a value of one field. Yes, it is formatted that way - always separated by 3 commas. L y a n n e R h e e z a C. O n g ... From: Lonnie Johnson...
Try this... http://www.tek-tips.com/faqs.cfm?fid=37 May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access...
I have created an append query w/o the autonumbering field because I want the added data to continue the number of the table I am adding this information to....
Hello, How do I get the first argument Root User Class from a table in the field. What function should I use? The first argument changes, but the first...
I was able to get it working already getting the first argument through SELECT Left ([Data], InStr(1,[Data],Chr(44))) FROM Export. How do I get the every...
I create a combo box on a test form using a table but the combo box will not populate or display any data at all I then created a second combo box and...
you can reset the autonumber by compacting the database. Then it will resume numbering after the highest value in the table. Peter ... numbers ... am...
I have a set of queries, based on one table, that I use to filter the information I want. I need, once I have the information on a pop up form, so that I can...
I have created a form with a combo box and cannot get it populated, I then created a list box and have the same problem..... I have done this before without...
John If you go to the properties of the combobox and open the RowSource are you able to view the records in datasheet view? What I want to find out is whether...
Liveson the row Source is : SELECT Members.MemberID, Members.Surname FROM Members ORDER BY [Surname]; Control Source is : Surname ... [Non-text portions of...
John So the row source is a query. When you open this particular query are you able to view the records in datasheet view? Click on build button next to the...
Liverson Yes ...I can see all relevant records in data sheet ..... that has been no problem .... every thing works fine ...setting appear correct all querys/...
The advice needed is: How the heck do you get started? I have created several tables that are being used by people in various parts of the world and are...
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.
