Recent content by geno

Thanks for your post, I got it to work.

HI, I have an order form with an order details subform. When the user enters in a part number the description and selling cost are auto filled. Sometimes the user will change the selling cost on entering through the record. Problem is that the users are entering through these records again and...

Thanks, i'll give it a read.

The debug shows the path correct. The line highlighted is the VBA.Shell line. The image is brought into the image control on the form from this path and it shows correctly. So I don't think it is a problem with the path. I'll do more research on this...thanks for your help. Gene

Thanks for your reply. I tried your code but got an error on the VBA.Shell line: Private Sub Img1_DblClick(Cancel As Integer) Dim strOfile As String Dim strApp As String strApp = "C:\Program Files\Microsoft Office\Office14\ois.exe" strOfile = "\\geno-pc\4WheelPics\" &...

Hi, Need help to double click an image on a form and have it open up in windows office picture manager. Thanks

Hi, What I did was run an update query on this field and set it to "" Don't know why but now the query works. Thanks again Brian

Thanks Brian. I guess I'll have to update this field with something until the customer can enter in his data.

Hi, I'm using Access 2003 I have a query that searches a parts table by description: Like "*" & [Enter in Part Description to search] & "*" I need to add another search to this query, I added another field to the parts table call manufacturer. I add this field to the above query and added...

Hi, I'm trying to use this code to remove some duplicate files. Some of the code gets highlighted in red: If _ var_Previous_Value(1) = var_Current_Value(1) _ And _ var_Previous_Value(2) = var_Current_Value(2) _ And _ var_Previous_Value(3) = var_Current_Value(3) _ Thenrst.Delete Looks like the...

Hi, I figured this out and it works except for one thing. When I run the code directly from the db that has the function everything works great but when I run it from the task scheduler the source db that compacts does compact but when the task finishes running this db is left open at the...

Hi, I have some code that will copy a database then compact repair it if no one is using it. I've put this module in an autoexec macro and am trying to run it from task scheduler. When I activate the task the db opens to the module but doesn't run the code. What am I missing here? Here's the...

I had to change the Call Sleep(300) to 3000. Works great. Thanks for you help.

Hi, I'm not familiar with putting together batch files; I need help with the coding. This is the command I'm testing with task scheduler: "C:\Program Files (x86)\Microsoft Office\OFFICE11\MSACCESS.EXE" with the arguments: C:\Users\Geno\Desktop\2003\NewWebDb.mdb /compact When I run a test I...

Hi, I've read quite a few posts on compact and repair but need some clarification. I have a split database; how often should you compact the FE? How often should you compact the BE? I would like to run a batch file through task manager to trigger the back end compact late at night so no one can...