Search results for query: *

Below is a copy of the function I use to import new tables from “NewDB.mdb” into my program. It works fine, however, I need the user to rename this DB to something new after it is imported. I’m not sure what I have to do or where in the code I need to put it. Could use your help. Thank you…...

Thanks John - I'll try decrypting the file to see what happens. Jeanne

I am a developer of a stand alone access 2003 program. I have two modules: one backups my tables in the db and the other restores them to the db. The file created when I backup the db works well, however, if the user would open that file, they would be able to change all of my preferences to...

Is there a way to enlarge the toolbar icons for my program without enlarging all the toolbar icons in Microsoft Office? If I right-click on the toolbar and select "Customize", "Options" you can select Large Icons. However, all the icons in Microsoft Office enlarge. I only want those for...

I want to convert all of my Macro's in my Access program to vba. My question is this: I have a toolbar "Select Table" that appears when I open one of my forms. From this toolbar I can select the (eg. Members form)to open. Is there a way from the "On Action" property to create an event...

Maybe someone can point me in the right direction. I have a standalone DB that I created from Access 2003, and plan to convert this into a runtime program. If the user installs the program and inputs information into the DB for some time, then purchases a new computer and installs the...

I am using MS Access-2003. I want the user to be able to delete a record from form view. I have a field called "Serial #" that is an auto number. Is there a way to protect the auto number so it does not get deleted when the record is removed? Thank you for your help.

I have a text field bound to a table. The table field is set to memo. Is there a way that when I press "enter" to have the cursor move down to the next line, in order to start a new paragraph. Now when I press "enter" the focus goes to the close button. Thank you...

Randy Thank you for your response. I will continue to work on this with your suggestions. Jeanne

I have set up my database with several forms that can be viewed but no changes can be made on them. In order for the user to make changes, they need to select an Add/Edit button on the toolbar, which opens a restricted dialog box, asking the user for his password. When the correct password is...

I have set up my database with several forms that can be viewed but no changes can be made on them. In order for the user to make changes, they need to select an Add/Edit button on the toolbar, which opens a restricted dialog box, asking the user for his password. When the correct password is...

VBrock - Below I copied my event procedure from the CmdButton Click event. When I run this code a message is returned stating (Ambiguous name detected: Option2). Not sure what is happening. Private Sub CmdButton_Click() On Error GoTo Err_CmdButton_Click Dim strControl As String Dim...

Hi vbrocks.. When I do the above I get an error message saying "Variable Not Defined". That command must not be able to locate the Form2 "Switchboard". Any other suggestions? Thanks

I have a form for the user to select the type of DB form he wishes. There are two Options. If the user selects the first command button, it will take him to the switchboard form. I would also like it to enable the second command button (Option2) on the switchboard form. Private Sub...

Anyone know if I can create my run-time version in access 97 to allow me to import my table of data when I have created the program by using VB-5. I am not splitting my DB. Thank you

Follow this link. It's happened to me before. Good Luck. Jeanne http://support.microsoft.com/default.aspx?scid=kb;en-us;141373

I have created a DB program and using the setup program in the Developer Edition 97, I have created a run-time version. I am not planning on splitting my Db. The program works fine, however, I am not able to access my db window thru this program. Is there any way of designing my program to...

Paul, Thanks for the help. I had check this. Found that data entry on my forms was set to no. Thanks again, Jeanne

I've created a DB with two forms. Used /runtime to evaluate my program and it works fine. Created a setup program and installed onto second computer. I get no error messages and all appears well, however, I am not able in input data into either form. I have inclued Microsoft Access Run-time...