I created a database (Access '07, MS Office XP Pro) with a front end and a back end. The back end has the data tables and the front end has the forms, queries etc.
My friend has been using the database for about three weeks and has asked me to make minor changes to the front end a couple of times. Each time I made the changes and sent he the new front end, he would load it, relink the to the backend without any issues.
...
AirborneBob
Last Activity: Mar 4 '08, 12:45 PM
Joined: Feb 20 '08
Location:
-
Database Corruption issues
-
Linq,
I have made the location of my files a trusted location but I am still haivng problems with the code.
If I make a macro through the macro wizard and then convert that to VB Code, The code will appear in the VB window and will act like I expect. But if I try to add lines to the code (i.e. textbox.setfocu s) I get an error on that line telling me that the Setfocus method cannot be found.
I am making... -
mshmyob,
I really appreciate the offer although I do not know how to send it to you. My contact email is <<Removed due to site rules >> if you would like to contact me to give me instructions on how to get it to you.
Again Thanks
BobLeave a comment:
-
Thank you for the replies to this question. Linq, you link to the information page gave me some good information and I also read some other pages that are getting me in the right direction.
Right now I can get to the VB Window just fine, but still there is limited functionality with VB.
When you use the wizard to create a button, it does write a macro and not VB. To convert it into VB you have to use a tool on the...Leave a comment:
-
I have no problem getting to the VB Window. When I used the wizard to place a button in Access '03, there was code automatically placed in the VB Window for that control. When I look at the VB Window there is no code at all.
Here is the simple code that I am trying to put in for the cmdAdd button:
[CODE=vb]
Private Sub cmdAdd_Click()
On Error GoTo Err_cmdAdd_Clic k
DoCmd.GoToRecor d...Leave a comment:
-
Visual Basic in MS Access '07?
I just installed MS Office Enterprise on my system today and jumped right in to MS Access. Because I am familiar with Access I had very few problems navigating around. Here is the big question.
Where is the Visual Basic Code???
I made a form and placed an Add Record button on the form. When the user clicks this button, I want to focus to go the the first field on the form. I usually do this with the setfocus command...
No activity results to display
Leave a comment: