Search results

What you need to do is use a transaction. For an example of how to write transaction code, look at this thread. Transaction Example Hope this will help.

Change your primary key to an Audit Number. Make the carton number a foreign key to the Carton table. You may need to do some re-design of your application before it is ready to be implemented. Ask your boss if there are any other specifications that you need to know about before you...

Thanks again, but the information that I require is stored in the .ldb file. It will tell me which connection has caused the database to be marked as corrupt. I already have utilities that can identify all connections to a database including the NT machine name. My problem is that the LDB...

Thanks for the file. I have checked out the sample code on the Microsoft website, but it only identifies the machines that are logged into the database. I have been having a very large problem with corruption on a custom made application written in Access 2000. I need to be able to correctly...

Does anybody know where I can find an ldb viewer for 4.x version databases. I have downloaded a viewer, LDBView.Zip but it does not correctly identify the suspect state of the database in the database header. Any help would be appreciated. Duane

I have actually had the same problem, and was hoping someone may know how to do this correctly. I have a combo-box that is populated by different tables based on another combo-box. Eg: Select Case strCriteria Case "WIP" 'choose WIP table to populate combo-box 'put 3 columns in box 'make...

For some reason (I don't know why) Access seems to not execute code on an event. I have had this happen, and this is what I did to solve it. Delete the Event Procedure in the properties box, and then use the code builder to re-link the code in the form module to the event. This could be a...

By entering On Error GoTo Err_cmdpass_Click, you are instructing the machine to go to that particular "label" when an error is encountered. You need to add the line. Err_cmdpass_Click: 'Your error handling code goes here Duane Barker

Put this function call in the Report's No Data Event =ThereIsNoData() Function ThereIsNoData() MsgBox$("There is no information for the criteria that you specified." & Chr(10) & "Please choose the Menu item and try again.") DoCmd.CancelEvent End Function

You can avoid the issue of duplicated invoice numbers in multi-user environment by generating the new number on the Before_Update event. That way the number is incremented only moments before it is posted. This would not work very well for a sub-form, though Just a thought Duane Barker

I find it is always helpful to replace any SQL calls in my code with string variables. It makes the code easier to read, and like Mike said, it is easy to check the SQL statement for errors. I like to use Debug.Print strSQL Duane Barker

I've had this problem occasionally. Try deleting the Event procedure call in the properties box, and then use the code builder to have Access reset the code link. The only other reason I have had this happen was when I changed the control name, and forgot to modify the Procedure. DOH!! HTH...

Do you need to store the number, or just display it? I would save all 3 numbers as separate fields, and then concatenate them to display. Eg: CustNum field Control Source = [1Digit] & [Autonumber] & [2Digit] To ensure no duplication, use all 3 fields as the primary key. Duane Barker [This...

Sure. You need to use Recordset objects. *Note: This code will only work if you have Microsoft DAO object library referenced. if you don't add it in the Editor window from Tools -> References * Dim db as DAO.Database Dim rst as DAO.Recordset Dim strSQL as String Set db=CurrentDB strSQL =...

At any time during code execution, you can ask for the value of any variable. Use the syntax: Debug.Print Variable This is very handy for checking concatenated strings, etc. Duane Barker

Use the following format to reference a bound forms' control. Forms![SubFormName]![ControlName].Property Duane Barker

Go to Tools -> StartUp Under Display Form/Page, choose your password form. Duane Barker

First, how are your tables set up? To use "autofill" feature, you must have a specific table structure. I'll assume an Employee, Time Card scenario. Table: Employees Field:EmpNumber - Indexed, Primary Key Field:FIrstName Field:LastName etc. Table: Time Card Data Field:EmpNumber - Related...

The only way I can see to make your msgbox() loop is to add. Dim bolSuccess as Boolean bolSuccess=False Do Until bolSuccess=True If MsgBox("Receipt# Not Found, Click Ok To Enter A New Receipt# Or Cancel To Stop.", vbExclamation + vbOKCancel, "IDC Receipt System Message:") = vbOK Then...

You can do this by creating a recordset object. Dim rst as DAO.Recordset Dim db as DAO.Database Dim intCount as Integer Set db=CurrentDB Set rst=db.OpenRecordset("TableName") 'Move to the last record to populate it. rst.MoveLast intCount=rst.RecordCount 'You can then inform the user of the...