Search results for query: *

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

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

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

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

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

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

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.

Hi. I am trying to modify some code I have behind a form titled 'Reports'. Form selection options allows the user to filter dates, locations, and detail level of the report via a series of radio buttons using select case code. I wanted to make some changes, so I created some new reports that...

Hi. I am trying to modify some code I have behind a form titled 'Reports'. Form selection options allows the user to filter dates, locations, and detail level of the report via a series of radio buttons using select case code. I wanted to make some changes, so I created some new reports that...

I have 2 tables that list names of locations. I have then built a union query to compile a list of all data that is similar between the 2 tables, which includes things like 'Location Name', 'Location Number', 'Location Type', etc. In an unbound form, I have a combo box (Combo37) that lists the...

Hello. I have a form in which there is a field called 'IP_address'. I would like to create a button on the form that will launch 'telnet' to the address in the 'IP_adress' field for the 'on click' event. Also, the telnet session will get promted by the device it is connecting to for a 'user'...

I am trying to run a macro on my DB which is password protected with Windows Scheduled Tasks. Access version 2003 DB Location "\\s02\s02usr\Traffic_Signal_Database\Traffic Signal Database 2003.mdb" DB Password - newton I want to run a macro in the Access DB called mcrEmailWeekly in windows...

Still learning here. Looking for the basic way to write strsql and vba to do the following. Form Name - frmFailedLoopsAddNew Combobox Name - cboLocationName Textbox Name - location_number Table Name - tblIntersectionData Table Fields - INT # - Location Name Here is what I have...

Here is a good one! I have an unbound form with textbox txtSerial. There are 2 labels - lblRecallYes and lblRecallNo, and a button cmdRecallCheck. I want to be able to put any number in the box and check it againt the range of 0607001761 and 070413756, inclusive. The serial numbers entered...

I am trying to have vba run sql and use a field from the query as the data for strwhere. It is existing code from the net I amtrying to modify. I used to have the strField date location named directly in an old table, but the new table has mulitple dates for the same INT_#. The result is a...

I am using the the calendar picker from peter's software. The form has a button that calls code in the 'on Click' event: =fBuildBasedOnContext("Get Date") However, I want to be able to run this in vba so I can also have some more manipulation to the form for 'On Click'. Any Ideas? Thanks.

I am trying to enable/disable a radio button based on a combo box selection (cboLocationType). The radio button is called Option New calulation. Not sure how the code should go, here is waht I have: Private Sub cboLocationType_AfterUpdate() Me!cboLocation = Null If...

Hi. I have 2 combo boxes. One is a type select, and the select is a location select. There is also a open report button. The 2nd combobox and the report button dynamically change based on the value of the first combobox. The dynamic rowsource works, but I am getting a syntax error with the...

I have a table with 1300+ records. There is a field with date information which has a mix of 2 digit and 4 digit entries for the year portion. I set the properties of the field to use 4 digit, but that only affect editing and adding. I am looking for an easier way to have access change all...