Recent content by Emblem1

Ugh! Figures. I thought it was something like this. I played with that too, but I must have had my syntax off..... geez. Thanks a bunch!!

I am having difficulty figuring out how to correctly launch a program with arguments in the launch script I am using Win 7 64 bit Pro, and Access 2007. Pilfering code from the 'net, and attempting to modify existing code in my DB has proved fruitless to make this work. I am a vba novice. A...

There is actually a .jar file in the same directory as the .exe file, so I think I should just be able to call the .jar file somehow....

I am attempting to call a java application in Access2007 vba via a button on a form, but getting a "Java Virtual Machine Launcher" error. The code works for most any other application, so I assume I need a different routine to call the java application. Here is the code: Private Sub...

Also, even if I manually remove the filter before running the report it still crashes. The record source for the report is a query, and the query works fine when I run it.

Some reports that worked in 2003 crash Access entirely in 2007. I have a form that text boxes on it for starting date and ending date, and code behind the form to build a strWhere condition to filter a report. The report is based on a query, and the filter is applied to the report via the code...

So, just getting back to this. I did some more digging into the database. I found that the error actually lies with the report. Ugh. Running the report manually also causes the same problem. I will repost this thread over there.

Hi All. I have a form in which a user can select records to be placed into a report via dates in a table. The code worked great in Access 2003, but crashes the database every time in Access 2007. Here is the code - what do I need to modify? I am pretty sure the error lies in the "Select Case...

I want to clear an error message automatically, but not sure about the right way to describe it in the code. I am not to worried about fixing the code, but just want to ignore the error. Err_Save_Changes_Click: If Err = "Update or CancelUpdate without AddNew or Edit." Then...

It does the same exact thing. It opens the file. Is there a benefit of doing it your way?

Like this: Private Declare Function ShellExecute Lib "shell32.dll" _ Alias "ShellExecuteA" _ (ByVal hwnd As Long, _ ByVal lpOperation As String, _ ByVal lpFile As String, _ ByVal lpParameters As String, _ ByVal lpDirectory As String, _ ByVal nShowCmd As Long) As Long Private...

Thanks! Here is what what works... cmdOpenTestReport.Visible = Len(Dir("\\s02\s02usr\Traffic Signal Monitor Reports\" & z)) However, when Acrobat reader opens to show the file, it opens up in the back. How can I be sure that it opens it up to the front of other windows..? Oh, and I am...

On a form, if I have a record with a serial number of 123456789 (in a textbox called Serial_Number), I want to search inside \\share\folder\ to find a file with the same name as the serial number, with a pdf extension, eg 123456789.pdf. If it exists, show a command button to open the file. If...

ok...that WAS easy. I did this... Me.CSign1.Value = Me.Sign1Type.Column(6) So I assume that the first column is considered column 0 (zero)? :)

Hi. I just want to say first that Tek-Tips is the greatest things since sliced bread! I sure have learned a lot! On a form I have 2 combo boxes - Sign1Type, and CSign1. Sign1Type gets it's data from a query, which in SQL view is like this: SELECT tblSigns_forwattageForms.[Sign ID]...