Search results for query: *

Frequently, I am asked to change the starting and ending dates for a report. There are several locations in several cascading querys that require modification. A sample of the working model is: between #9/26/05# and #10/30/05# What I am looking for is something like --- "Between...

I have a text field, Lname. When the last name is entered as TATH, the field automatically changes to THAT. I've cheated by putting a semi-quote "'" as the 5th charector of the last name. Does anyone have any ideas what is turned on. I have not seen this before in Access. Thanks Paul

I have a datasheet (sub form) with 6 columns, the left most column is already populated. The clerks want/need to be able to move to the next row upon pressing enter, rather than moving to the adjacent column. How would I set this up in VBA. Thank you.

This DB was originally developed with all the tables internal to the program. I am attempting to mirgrate the raw data to a separate Access DB tables. The process worked fine using the orginal table inside the current Access program. When I attempt to use the external table (tbl_Drops), I get...

Is it possible to select the max value -1? Thanks in advance.

I have the following data. Date Period U PC G V 04/12/2004 12:15:00 AM 2 2 0 NOV 04/12/2004 12:15:00 AM 3 3 0 MMT 04/12/2004 12:15:00 AM 18 19 0 VGT 04/12/2004 12:45:00 AM 1 1 0 NOV 04/12/2004 12:45:00 AM 1 1 0 SDG 04/12/2004 12:45:00 AM 1 1 0 SED 04/12/2004 12:45:00 AM 6 6 0 MMT...

I am using this code to get the results of the last time a bar code scan was performed. SELECT Max([Date]+[timeMS]) AS lastScanEvent, Format$(Now()-Max([Date]+[Timems]),"hh:nn:ss") AS Ago FROM tbl_FSACDATA; How can I get these results to display on the switchboard, and continually update? The...

Our operation requires a lot of bar code scanning. Right now the data is coming in and we are using the data without verifying the data. The scanners are periodically downloaded and appended to the working access table by use of a DOS shell command. 1. We need to verify the data in some of...

I need to compare the time difference (gap) between one record and the next record. The query produces data like this. Date Time 9/1/03 15:45 9/1/03 15:46 9/1/03 16:02 9/1/03 17:08 The output should look something like... Date Time Next Time Gap...

We have a customer form that opens in Edit mode. We want to add a field "referral" that onces that field has data, it can NOT be modified using this same form. But the rest of the data, need to still have the ability of being modified. Thanks Paul

Access allows for Row printing, with a row heading. ex: col1 col2 col3 col4 Jan Feb Mar Apr Data Data Data Data Dat1 Dat1 Dat1 Dat1 Dat2 Dat2 Dat2 Dat2 What ideas do you have related to printing the data in column format, currently I am getting the following: ex: column1 column2 column3...

I have a small table, ID, EventID, and serial(customer ID number). When we do our mailout, we currently send out just a barcode with the serial normally located in a store coupon. What we want to do is to have the EventID and serial included in a single barcode. That way when it is scanned...

I am printing three different forms. Each form is identical, *except that each copy is identified with who gets which copy, Cashier, Audit, and records. Is there a way to print only one form 3x and provide each department with a labled copy. In my experimenting I am printing three copies just...

Has anyone seen a situation where the Access program “DB1” may fail (as a result of some unknown reason, network problem possibly) and a duplicate file “DB2” is created. If that has been seen, is it also the case that if the Access program name was something other than the default (DB1), would...