Search results

Problem.. I run an append query behind an OnClick Event. Works fine with one user. The problem arises when two users click the button at the exact same time. This creates a primary key infraction because the db tries to write to the table at the same time from both machines. After this string of...

Thanks jjt- And for those stubborn folk like me, here is the kb article to workaround. 210266

I recently split my database and found that I could no longer use the dbOpenTable constant in my code. So now I have to use dbOpenDynaset instead. The only problem is that I would like to use the "Seek" method, which only works for Recordsets of type dbOpenTable. Any suggestions? Can someone...

If you do the call from a batch file you could do something similar to this post...

Maybe try... Forms!MainFormName!SubFormName.Form!revInc = Forms!MainFormName!SubFormName.Form!revInc + 1 Adding the .Form sets the reference point to the subform explicitly.

Post the .zip file

First of all, you are using "A1" as your range. This means that you are only searching Cell A1. This method works nicely to search cell by cell. Dim d as Variant With objXLWrkSht.Range("a1:a99") 'your range here Set d = .Find("", LookIn:=xlValues) If Not d Is...

revInc should be included in the Form's RecordSource. If you are using a sub form, instead of using Me, try this.. Forms!MainFormName!SubFormName!revInc = Forms!MainFormName!SubFormName!revInc + 1 Where MainFormName and SubFormName are the names of your parent/child forms, respectively...

Add another field to your table, lets call it revInc (type Number). Now include revInc on your form that allows users to change the Date. In the After Update Event of the txtRevisedStartDate put this code.. Me.revInc = Me.revInc + 1 Make sure that the revInc form field is bound to the revInc...

You said you have 5 "Databases" which correspond to 5 .xls Spreadsheets that you would like to continue using. Does this mean that you will simply use Access as a "Front End" to these spreadsheets? Or is it the other way around, will Excel be your "Front End" and, thus, need to transfer data to...

Cool, Did you say you were integrating MS Access with Visual Basic .NET? If so, what is the benefit? Why not use one or the other? Let us know if you need any more help. Good Luck..

Was there a particular flaw in the example posted? You are aware that this is an Access Forum??

Try this out.. Notice the After Updat Event of both combo boxes. Also, notice the Row Source of the combo boxes. Including a criteria in the second box is how you get the two boxes to relate to each other. Remember to requery the second box after updating the first.. Good Luck..

If you're new to Access and VB I would suggest doing just one thing at a time. First, get the controls set up on the form. Then, get the button working to populate the list box. Last, work on opening the form w/ filter.

You said.. Knowing the track record of the person who posted that reply (mile-o-phile) I'm guessing that it will work, you just have mis-translated one of the directions from the post. A better response would be to reply back and inform us where the error is in the suggested code. Here's...

Cool, I don't have a machine at home so I will have to wing it. But I think I have a pretty good grasp at what you are trying to do. I will be home @ 5:30 Oregon Time.

Not quite sure what you mean. Take a look at the new button "Add Similar" on the MainForm. This loads up the "tblEmp" Form with Similar INformation to that which is already on the form and allows the user to add a new tblEmp Record (job posting). Next you will probably want to automatically...

1) I guess I don't know what you mean by predefined. Currently the combo box selects from the list of available department numbers. This makes it a predefined list. 2) Are you wanting to add new positions in this form? Example.. Dept# 01.6000 has a position, Staffing Coordinator with job...

I see.. So this method only deals with .mdb applications that have implemented MSAccess Security. That is where I was getting hung up. I have always just created my own user groups/security settings. Thanks for clarifying..

Wierd... I must be sucking in too many of the SUV fumes up here in the Pacific Northwest. Steve, You must be thoroughly confused by now.