Search results for query: *

I want the table ordered because I am a lazy coder, basically. I want to ensure the table contains no duplicate entries. Adding Distinct into my original query is no good because when I copy bits out of the fields there is a reasonable chance that the same name may be copied out of several...

Sorry, yeah. Awfully written question. That's Friday afternoons for you. I am using select queries to pick certain fields from tables. These queries I am using to populate other tables by opening recordsets on the query and table and copying from one to the other. I am not always copying whole...

I know it's a fairly basic thing but I need to know how to order a table. I have queries which I have ordered using the ORDER BY keyword but I have never attempted this with tables and I'm not really sure where to start. I'm sure someone is now going to give me a very simple answer. I hope so...

Cheers. I'm pretty new to designing databases and writing in VB, I guess my inexperience is showing. The overall aim was to have tables that the user can create, check the contents of and amend as required. But I only wanted them to have 4 of the fields showing, so they don't get scared by...

I am trying to create a number of tables from within VBA code. I want the tables to have 10 columns, 6 of which are hidden. I also want 2 of the unhidden columns to be combo boxes, populated from queries that I have already set up. I know how to create a table and append fields to it. What I...