Search results for query: *

I have this in a query and it results in almost 4,000 records from Table1 SELECT * FROM Table1 LEFT JOIN Table2 ON Table1.RunIndex = Table2.RunIndex WHERE (((Right([Table1.RunIndex],6))="070108") AND ((Table2.RunIndex) is null)); I then tried to put this SQL into the VB behind my form...

I have a spreadsheet (Format Reports.xls) that when it opens kicks off a macro. The macro then opens a different spreadsheet file, does formatting, closes the file, moves on to open other files to do the same type of formatting. This is an excerpt of my macro code in "ThisWorkbook" of file...

I have a form with fields and a combobox based on two tables. The fields I'm working with from tbl_impound that are displayed on form frm_impound: Vehicle Date Time Class I also have a table tbl_class_op with fields Vehicle Date Time Class On form frm_impound I have a combo box for the...

I have a database that will be running on a private "home" network. The backend will be on the C shared drive of the primary computer. (The primary computer is serving as the network drive) The primary computer as well as two secondary computers will run the frontend. The frontends will...

I want to link my frontend to my backend tables using VB. I want to do this when I open the database and then drop the link when I close the database. I am only using Access 2000 for both the frontend & backend. I've seen a lot of posts saying you should do this & I've seen several with...

I have a Main Form which has a subform within it. They both open visible. I have a combobox named type on the main form. I have a combobox named class on the subform that through a query uses the type combobox selection to limit what is displayed in the class combobox. When the type value is...

(posted in forms also but only got one response) Here's my scenario: User opens form. First field is Vehicle. They MUST key a vehicle number before doing anything else. I have code in the BeforeUpdate of the Vehicle field. It works fine. The user cannot leave The field without entering a valid...

(posted on Forms section also) In a form's onOpen I was setting several fields to enabled = false. I could set most of the fields but a few of them couldn't be set. When typing them in, the autoformat drop down would only show "value" where the others would allow many controls like locked &...

In a form's onOpen I was setting several fields to enabled = false. I could set most of the fields but a few of them couldn't be set. When typing them in, the autoformat drop down would only show "value" where the others would allow many controls like locked & enabled. When I try to run it...

Here's my scenario: User opens form. First field is Vehicle. They MUST key a vehicle number before doing anything else. I have code in the BeforeUpdate of the Vehicle field. It works fine. The user cannot leave The field without entering a valid value. I have the same code in the LostFocus of...

Let me start by saying I'm really lost! I know I don't have the terminology down right so I'm just going to state what I want to do & hope that someone can lead me along in a simple way with a simple example. I have a few different questions. I’ve made some complex code work but I haven’t done...

Would someone be so kind as to give me some generic VB code I can use to fill a list box? Thanks in advance! :D

I have a 6 digit number (ie: 123456) I’d like to be able to look at one digit at a time. For example isolate the first digit of (ie: 1) then take an action. Then move to the next digit & take action. I’m thinking this can be done in an array but I can’t quite put it together in my mind. Can...

I've set up a Select statement to grab a specific record. I need to test if the record is not found. Can someone give me the syntax, I can't seem to find it. Thanks!

I'm using the following to change the format of a numeric field: formatspeed = Format(cr.Speed, "###.000") The data, for example, is 123.4567. I'd like to end up with 123.456. I want to drop anything beyond the 3rd decimal but I do not want to round. How can I do this without...

I tried to run an Apend Query in which one of the fields is a Yes/No datatype. The yes values are not carried from one table to the other. Any ideas how to make this work in a query? I can probably whip up some VBA code but an apend should be simple enough. Tia for any help.