Search results

Thank you for your help.

Hi: Could someone tell me please what is the difference between backing up the database via the menus (Tools|Database Utilities|Back Up Database) and simply copying and pasting the database file? Thanks in advance.

Thanks a lot!!!!!!!

Hi: I recently split my application (myapplication.mdb) into the database and the front-end. I put the database (myapplication_be.mdb) in a shared folder. I also made an mde (myapplication.mde) from myapplication.mdb My question is: how do I make changes to the database table...

Hi:(Access 2003) I split my application into the database part and the front-end. Then I made an mde out of my front-end. Now, when I look at the database window (when I open the mde): for the Forms and Reports the "Design" and "New" icons are greyed out. However this is not so for Tables and...

Thanks a lot Paul and John! It works!

Thanks Paul for your prompt reply. Except I don't quite understand your response. Where do I put the code: =ComboName.Column(1) Thanks

Hi: I have a listbox which has a Select statement( which returns two columns) as its Row Source. Now, when I change the listbox to a combo box it works fine except that the dropdown choices show both the columns but when I select a choice, it only finally shows the first column. The Combo...

I used the wizard and to save, I chose move to next record. The code it put for me was: DoCmd.GoToRecord , , acNext Thanks.

Thanks a lot all.

Hi: I am having a problem with saving data entered in a sub-form. I put a command button on the sub-form and used the wizard as follows: I chose "Record Operations", and "Save Record". It filled in code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 But this does not...

Thanks for your help.

Hi: My setup is as follows: I have a Main form which has a listbox (List33) from which I (on selection of an item) want to populate another listbox (List11) on a sub-form of a sub-form of the main form. My code on the main form is: Private Sub List33_AfterUpdate() Dim stDocName As String...

Thanks a lot

What is the code in the main Form please. I want to change the Row Source of a field in a sub-form of a sub-form (of the main form)? Thanks in advance.

Thank you Adam and missinglinq.

In a form that updates a table, it seems that I have to click on (select) each of the fields in list boxes for Access to accept the fields and update the table. Otherwise it complains that a related record is required. (I am --through code--populating the list boxes so I am not explicitly...

Thanks a lot--it works!

Hi: I have two list boxes on a form- one called List12 and the other Program_id. What I want to do is that when the user selects Program_description in List12, the Program_id List box should be populated with Program_id. It does it but only after I get a "Enter Parameter value" prompt and I...