Search results for query: *

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

ok, you can have a star too.

Thanks a bunch.

What is the correct syntax for this? IIf(Me.Sign1Type = "Case Sign" Or Me.Sign1Type = "Street Name Sign", Me.CSign1.Locked = False, Me.CSign1.Locked = True) I want to lock the combo box CSign1 if Sign1Type is NOT "Case Sign" or "Street Name Sign". Thanks.

I figured this out by just reconfiguring the subs a bit. Also, alhtough the Option Explicit would tighten up the code, it would require me to go through the entire module and my coding abilites aren't quite up that caliber yet. Thanks for the input though. Here is the final code that...

ok, reposted over there.