Recent content by Henryklassen

Thank you Mark, I will give it a shot this weekend.

I'm trying to find the best practice for comparing two file, what I need to know is has the file changed. So here's what I'm trying to achieve and my setup I have a table where I store Parts each part has two files a production file which can be either a dxf, dwg, or iges file (CAD file types)...

does anyone know how to pass the file location to this activex control?

I'm using Autodesk DWF Viewer Control in a form to look up dwf files on our server and it works just fine, how ever I'm having a heck of a time getting it to work in a report. The Autodesk DWF Viewer Control gets its date from a textbox I call "FileLocation" which is stored in the table...

Now that I have that working I'm trying to trap error 3022 by using this code Private Sub Form_Error(DataErr As Integer, Response As Integer) 'If an error occurs because of missing data in a required field 'display our own custom error message Const conErrRequiredData = 3022 If...

I'm very please with the wealth of information on this site, and the prompt help when asked a question. I signed up with the right site.

Access_Guy49 you're the MAN! Works really well, Thank you!

Lets see if I can explain it better. On the main form the employee enters a new sub assembly part, once entered the new subassembly shows up in the listbox. The user can now double click on the subassembly part in the list box which takes him to a new form where he can enter the parts used to...

What is the best way to prevent duplicates in a filtered list box? What I have is a form that pops up and the list box is filtered based on the previous form's ID Field, what I would like to do is if "Description" exist then another "Description" could not be enter.

My area usually floods this time of the year but we got an early spring so no flooding

Thank you for replying Brain, it worked like a charm.

In issue I'm having is I have three table, "Description", "History" "Allocation". Description has a one to many relationship to the other two table. What I'm trying to do is subtract "AllocationQty" which is located in the Allocation tbl from "Qty" located in the history tbl. My problem is that...

Live in Canada, hate snow, love MS access.