Search results

I have a form which allows employees to signoff on what they have done. They enter an account number on the main form, along with their Empl id and password. All the transactions on that account appear in the subform (datasheet view). They can click SignOff button(main form also) and it...

Ok, I have a form with a subform. 1 textbox on main form, 6 fields in datasheet view on subform. Subform's record source is a query. The query runs fine on its own. No problems. The subform when I try to view it works fine. But when I try to open the main form in form view, I get pop up...

I am trying to create a new form and in design view I had added 1 text box for input and a subform to display data related to what is entered in textbox. I have saved and go to form view all I see is a blank gray screen, no textbox, no subform, What is going on? Thought I'd try again with...

I am using the DoCmd.RunCommand acFilterbyForm command on a button which brings up a toolbar with the filter button on it. It works ok to find the record in question but then when I am done with that record and want to record others, (I hit next record to save and blank out screen for the next...

I have a table with 5 fields. I am trying to make a new table with a make table query. In the old table there is a field called 'code'. We are changing coding structure and reason codes so I am trying a calculated field called 'new codes' in the new table. What I would like is to somewhere in...

I am trying to print 2 reports with a button. Both have the same query as the record source. The query has a date input parameter that prompts the user for a date. I tried a using macro to open query and then print first report and print second report. But it asks for the date 3 times. I for...

I have the following code that compares the password the user enters to the one stored in the table for them and it works fine and checks in the textbox SIGNED OFF as it is supposed to. Private Sub txtpassword_AfterUpdate() If DLookup("[Employee Number]", "tblEmployee", "[4SSN]= '" &...

The form can do calculations, put the calculation in the OnExit event of the second control of the 2 you are adding(or whatever) but this will only work if you have the tab order set so that a user can't skip the textboxes on the form. But... It is probably better a practice to let a query do...

I have the following on the AfterUpdate property of a control on a form: If DLookup("[Employee Number]", "tblEmployee", "[4SSN] = " & Me![txtpass]) Then..... After I enter the password on the form I keep getting the error "data type mismatch in criteria expression" 4SSN is a text field in...

I have a form that has a subform on it. On the main form there are two buttons. One that makes the subform visible and shifts focus to the subform for additional data entry. Well it seems as though the users, who aren't computer literate at all, click the subform button and then realize they...

I have a report that is broken down and grouped by carton number and then by an audit code. What I need is for a "1" to show for each line of the audit code and a "0" to show for each following record (if there are any) until the next carton , then another 1 followed by 0 etc. etc. carton...

Running Access 97... no problems till now Open database to try create a new report with wizard and when I hit finish I get the neverending hourglass, and I ctrl +alt+del and access is not responding anymore. The report is not long and fancy just 6 fields from a query that works fine on all...

Here's what is in the form(This application is used by warehouse auditors): 6 textboxes txtCartonNumber txtEmplID txtUnitsInCarton txtSOunits txtAuditType If there are no errors in the carton great, they go to the next record. If errors do exist they click "errors" button and get the subform...

I have a main form for data entry with about 5 textboxes and then there is a button to make the subform visible. Now the subform has about 10 textboxes that need input. And usually there are anywhere from 1 to 6 records that need to go on the subform. For most of the records entered on the...

Hey, I have a text box on the detail line with control source as: =+1 the running sum is set to Over Group to increment so if there are four records in the group it looks like: ..............................1 ..............................2 ..............................3...

Tyring to query for the last 5 days: In 'date' field of query I have tried with the criteria as: [Date]-5 =Date-5 Date-5 Now()-5 =Now()-5 Can't get any results!! Please help.

But the command button is "wizard" built and doesn't give an option to open to preview. It acts more like a print screen. Here's the code behind it; is there anything I can add to specify a printer? Private Sub PrintNotice_Click() On Error GoTo Err_PrintNotice_Click Dim stDocName As String...

I have a command button to print the form on the screen. Is there a way to change the default printer either just for this application or this button?? The default printer for the workstation is in the supervisor's office (not convenient) and that is where most of the work needs to be printed...

Since I already have the Carton Number textbox and all that linked to my table and some other forms, would it be safe to scan the original long number into an unbound textbox and have my present carton number textbox be filled with the number I need. Could I make this initial textbox invisible...

I have a warehouse application I have been working on. The auditors are scanning a carton barcode and this number goes into a text field on my entry form. The problem is the barcode number is:(00) 0 0052177740894485 the actual carton # is : 74089448 How do I get it to just enter the 7...