Search results

I need to identify pairs of records by their ID and date fields, then compare their number values to get a text result. I have a query that has the following fields AuthInstanceID, ConsumerID, AuthNumberID, AuthStart, AuthEnd, PSRUnits, BSTUnits. Sample data is below (PSRChange and BSTChange...

I have a table called tblAuthorizations. It appears as follows AuthInstanceID....ConsumerID....AuthNumberID....AuthStart....AuthEnd....PSRUnits....BSTUnits 1374006036.........356679..........20255102..........4/22/13......7/21/13.....0..............416...

I have a form whose Record Source is a query (lists consumer information), with two subforms. One subform is for data entry and has a table for a record source (lists of authorizations, with foreign key ConsumerID). The other subform is used to view and edit the same data entered through the...

With any luck this should have a simple solution, but I can't figure it out. I have a form (Consumers) that displays consumer information. On the lower half of the form are two subforms. The bottom subform (Authorizations) shows records from the many side of a one to many relationship, linked...

I have a form with StartDate, 3 Comboboxes (Employee, Consumer, Service), and a button. What I'm struggling with is code to do the following: User enters a start date (mandatory), and values in all of the comboboxes (mandatory), then hits the button. The subform then creates 7 records with those...

I'm trying to set up a combobox on the subform that will let a user choose one of multiple values (value from Auth Numbers Query) and when the record is entered it fills a field in tblAuthorization via Authorizations Query. I can get the combobox to display the correct information, but I have...

I have a fair-sized data set going into a form that I want to filter based on a checkbox. I have a table with records of all of the consumers we have worked with, with current consumers identified by a checkbox (Active). I've created queries that show either all active or all inactive based on...

Table Arrangement: Timecard, Consumer Tracking, and Billing I apologize, in advance, for the novel. I'm making a fairly involved database and my knowledge of Access is barely scraping past mail merge. I'm improving and I think I have the general concepts (small number of forms display and feed...

The introductory post asks you to introduce yourself. Hello expanding void! It surprises me how quickly this community is growing (Based on the number of "I'm new here" threads started just yesterday), and I can't help but wonder how unprepared the welcome party is to such an onslaught. With...