Search results

Hi, from 1 Form, or, Graphical User Interface (GUI), I would like to dynamically change/load a new Query as the Record Source. I can explain my reasons if required, but, I have tried and failed with some posts already on this forum so I'm tryiong to keep it simple.

Hi DC, How can I create 1 Table with the possibility of numerous 0001's with a different prefix? i.e. PC0001, TC0001, Ex0001, WW0001, etc, etc. Actually, If I didn't do it the way I have started, how would I be able to scroll through the existing entries? And, How could I add a new entry on...

Actually, If I didn't do it the way I have started, how would I be able to scroll through the existing entries? And, How could I add a new entry on one of the processes?

OK, I'll have a re-think. Thanks for all your help.

OK - many thanks. The Form I am trying things is 'Form1' See what you can think of.

How can I attach a Db? Also, the ChangeManagement Database is very primitive at the minute. I'm just trying to conquor these basics for the overall operation. Once I have them cracked then I'd be in a position to create the full ChangeManagement Database.

I am using one form to view and edit the data. and therefore, I would like to select PC or TC or Ex for Potato Chip, Tortilla Chip or Extusion processes. So very simply, with a blank form open, I would select from a Combo either PC, TC or Ex which would then call-up the relevant Query. I...

Yes, absolutely correct. All the tables/queries will have the same structure and similar data. The underlying difference is their unique reference number because they are for descretly different physical processes. WHat are you thinking?

Hi, thanks for your reply. I would like to evoke diffirent Queries because they have unique number references. therefore, when i choose to add a new item with the unique reference number i can easily do so and keep in a uniformed manner.

Does anyone know hoe to change the Control Source of a Form from a ComboBox within the Form itself? For example, I have several Queries with data in. Each Query has a unique name (obviously). The selection from a ComboBox generates one of the Query names. This is confirmed to me in Design...

I'm trying to create a table/query/form that will auto-generate a unique number for a specific field. i.e. "baked" field with 0001, 0002, 0003... and a "pc" 0001, 0002, 0003... and a "tc" 0001, 0002, 0003... , and so on and so on. o I cannot use the autonumber as this is for a Primary Key to...