Search results for query: *

Well here is a sample of how to autofill many fields by selecting a value from a combo box on your form. (copied from one of my other posts) Just set your combo box up to select lname, fname, phone, department from the USER table thus you will have 4 columns display when you click the down...

OK, Well does using the following... Me![CustID] do the same thing? or is it less efective??

Do you need to open a specific web address or do you want to be able to change addresses right there on the form ? One way is to have a sub-form like browser in your form.

You can just use the built in command button wizard by adding it to your form.

OK, I see..your code should refence the name of the combo box. (looks like you are using 'Combo78'). -- Private Sub Combo78_AfterUpdate() Me![firstname_on_Work_Order] = Combo78.Column(1) End Sub -- Secondly- Go to the properties sheet for this combo box Click the 'Format' tab Make sure the...

Sounds like you will just need to create an "Add New Record" button. Select the command button from the toolbox and the wizard will display. Now record operations/add new record. next, next... should be the trick. Regards, ccburn

Hello Kat, Did it work out for you? ccburn.

That's right, forgot to mention that was the reason for splitting in the first place. Create MDE file from the Front End. Make sure to keep the original intact(do not delete it !!) Once you go MDE there is no turning back. So you will need your original MDB to make changes/updates as needed...

Thanks, I appreciate all your help. I just got back to this- This is exactly what I needed to know. It is hard to upgrade table designs when you have to use update queries all the time. Thanks- Thanks- Thanks !!! ccburn.

Sue, You need to open a form in design view -bring up the 'Event procedure' for one of your command buttons. -click debug -click compile dbname. This will compile your application and could possibly reduce the file size greatly. I notice your front end is huge- you mentioned compacting but...

Just set your combo box up to select lname, fname, phone, department from the USER table thus you will have 4 columns display when you click the down arrow for the combo box. (You can hide these by reducing the column widths). I suggest you show the first name also since last names could...

I want to deploy an application(FE/BE). I also want to be able to alter my tables by adding columns and incr/decr field sizes. I am more versed in ORACLE and just can't figure out how this is to be done in Access. As the application needs more columns for tracking more data. I think it should...

Have you tried multiple columns for your last name combo box?

Hello, I had a treeview control in Access 97 that I used to get a quick view of related data. Now I am using Access2000 and embarking onto Access2002(XP). There are links to this most useful tool under 'ActiveX Controls..' but none of them are that particular wizard that helped me in the...

Actually, you would be much happier if you just used front end/back end technique. That way your forms can not be opened in design view, but your tables can be accessed by someone in the reporting world. The "shift" trick only works when you are dealing with non-techies that don't...