Search results

I would like to popup a form after a button is clicked. I would like the button click event code to wait until the modal form is closed before continuing. The code will be reliant on the values returned from the modal form. This is a simple task in c++, but I can't seem to find a way to do it in...

Some of my users have MS Office Service Pack 10.0, others have Service Pack 9.0. I developed a DB using SP 9.0, it does not work for those users who have SP 10.0. They are forced to manually go into the Tools->References Menu and change the MISSING libraries from 10.0 over to 9.0. Is there a...

I open my database via batch file, but the batch file hangs at the final line (as if it is waiting for the MsAccess.exe line to complete) It never makes it to the "quit" line, so the batch file continues to run infinitely (or until I shut it down manually) Here are the final few lines of the...

Half of my development was spent using a Win2k machine and the other half was spent using WinXP. However, both had the exact same version of MS Access. My db works perfectly with 1 and even 2 users, but when a third user starts parusing around I get a 3343 error: "Unrecognized Database Format"...

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...

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...

Will VBA continue to loop through code as the Shell runs, or does it see that the Shell is completed and then continue to run. I call the following Shell (it copies the active .mdb into a temp file) Call Shell("""" & batPath & """ """ & projPath & """ """ & copyPath & """", 3) And then I take...

I have 9 Inner Joined Tables that I would like to export to a temporary database every night via code. Here is the long and short. I'm doing a data dump once per day across networks. I don't want to dump the entire .mdb file (its too big), so I'm just going to get the data I need and store it...

I am creating a database to log Quality Assurance data. Every unit that is inspected will have around 35 records in the "Master Inspection" table. If there are approx. 100 units inspected per day, that means 3500 new records per day in the table. 5 days a week means roughly 15,000 records a...

I would like to loop through all of the records on a subform as soon as a button on the MainForm is clicked. Something like this: Private Sub PassBut_Click() 'MsgBox Forms!frmCategory!frmSubCategorySub.Form.CurrentRecord & vbCrLf & _ Forms!frmCategory!frmSubCategorySub!txtCategory &...

Does anyone know if Access Forms can be integrated using a touch screen? If someone could point me in the right direction for touch screen commands and "how to(s)" that would be greatly appreciated.

I want to find the location where posts were made in "tblHistory". [DateMod] is the time stamp that the post recieved (using the Now() function at post time). I am getting a syntax error in regards to my Dlookup Date when I run my query. [DateMod] comes from a previous field in the query, is...

I have 3 tables in my relationship... My relationships work like this: 1 SerialNum ("tblUnits") --> Many RmaNum ("tblRma") 1 RmaNum ("tblRma") --> Many Locations ("tblhistory") This lets me track multiple points in history for each SerialNum (Everytime an entry is made regarding a SerialNum...

I have the following code working behind my button click. It works great when there is only one user. The problem arises when the DB goes up on the network and multiple users begin to use it. The problem is that the search function does not always seem to be querying form the most up to date...

I would like to Open a word Doc and Go To a specified Bookmark in that document. The document will be recieved in the OnClick Event. I want to do something like this... On Click =GoToDoc("help.doc", "#CheckIn") 'The Call Function GoToDoc(whatDoc As String, whatBookMark As String) 'the...

I don't suppose I can use two seperate Recordsources for the same report. I would like the Report Footer to hold just the Ship To Address of any given serial number that may be reported on. This would require using a seperate recordsource for the Footer because the Ship To address is not exactly...

I am trying to requery all of the subforms in my tab control when information from a certain unbound form is entered into the tables. Here is what I have so far, but it doesn't seem to want to cooperate. Dim myObj As AccessObject, db As Object Set db = Application.CurrentData 'get...

Is there a way to grab the data from a form BEFORE the On Current Event. i.e. when the record changes, I want to gather unbound data from the form BEFORE the record changes (the old data on the form, not the new data coming in).

What is wrong with this Sub Procedure? Private Sub Form_Open(Cancel As Integer) Dim whichSet As String whichSet = "SELECT tblHistory.Comment, tblRma.SerialNum, tblRma.RmaID " & _ "FROM tblRma INNER JOIN tblHistory ON tblRma.RmaID = tblHistory.RmaID " & _ "WHERE (tblRma.SerialNum)=" &...

My company table "tblCompany" currently has a one-to-many relationship with my units table "tblUnits". I would also like my company table "tblCompany", to have a one-to-many relationship with my "Ship To" table and my "Bill To" Table. Is this possible? Here is the current structure of my...