Search results for query: *

Hello all, I have a PC serial conencted to capture data on our paging system. Only the standard Startup script is running. Each Monday morning we have a user manually stop the capture that is taking place and restart the capture. Unfortunately due to human error I find that periodically...

Is there a way to modify a query, adding permenantly to it (periodically) through code (function, etc)? We receive our Nextel billing as an Access db and normally the info is only needed monthly and not as a union of the multiple months. Though lately I have had to compile multiple month data...

(I've dual posted this in Access Queries also...) My problem is this.. I now manage phone numbers for an institution and need to identify sequential numbers in a table. tblNumbers:(fldPhoneNumber...and other fields) The issue is sometimes I need to identify 3 sequential #s sometimes 4...

My problem is this.. I now manage phone numbers for an institution and need to identify sequential numbers in a table. tblNumbers:(fldPhoneNumber...and other fields) The issue is sometimes I need to identify 3 sequential #s sometimes 4 sometimes 10. So the ability to have the...

I have a table of details (tblPDS) holding the status (statusID) of a device. When one of the records in this table for the associated device detail(PagerDetailID) is the status "Active" I would like to not allow another status record to be chosen with the same Value. This one value "Active" is...

Hello all, I hope I got all the detail necessary in this... I am tracking cellular devices in our Org. There are multiple records in some cases for an individual, because of upgrades, lost devices, service changes, etc. I need to see only the most recent record (either by choosing the highest...

I have a single Toggle button (tglMultipleTransactions) that I would like to control 20 other toggle buttons on a form( the other buttons make a change to the DefaultValue property for individual fields on a form to copy to a NewRecord for ease of multiple entries) I am stumped as to how to...

Hi, I have a report which details users in database and a function which pulls the User Group assosciations from Sec.mdw file. the function works great on a single detail. (and only on the currentuser when report is run), and I get error 3265 for EVERY other detail on the report. Here is...

Hi all, I need to simplify an email process, here's the details. A. Access2003 to develop for Access2000 and 97 distribution B. Application is a deficiency tracker for over 172 different clinics for a LARGE L.A. area hospital. C. Each clinic would receive a report for their unit only!, and...

Hello all, in a rush I posted this in the wrong place before... I have a field [memo] which i need to extract multiple sets of data from. I am using mid$(instr()) find the strings but I am having a little trouble getting rid of unwanted data before or after the required string. The data comes...

References is grayed out on the tools menu in the VBE objectviewer. Is there a file I'm missing? Thanks Don