Search results

Well I had several of the fields for the subform set to required, so I couldn't close or go back to main form without getting the message "such and such is required" so I just gave them some default values of 0s. So I see what you are saying, it is now saving all the default 0s. Should I undo...

I have a form that has a subform on it and the subform opens with the click of a button on the form. If this button is clicked inadvertantly or in error I have another button to return the focus to the main form and go on with the data entry. When I save the record it saves a blank record in...

I am trying to use the following update query to change a user's password. THis query runs on a command button. There are three textboxeson my form 'frmChangePassword' : current user's ID (txtClockNum) new password (txtNewPass)...

I have a form that opens from a command button that lets users change their passwords(hopefully). There are 3 textboxes: Clock #, new password, confirm new password I can get the check to confirm the password to work but I can't get where the password field updates with the new password. Here...

What about using a make-table query to create a new table. In the query, select only the fields you need. And then link the new created table.

I have a form with a subform on it. These are used for data entry. If a user makes a mistake and catches it after they are on the next record or two they should be able to use the navigation/record buttons to go back. Well it works for the main form like they can hit the back arrow and the...

I am trying the command button with the path. Here is what I tried: Dim stAppName As String stAppName = "c:\windows\system\3d pipes.scr" Call Shell(stAppName, 1) and when I click the button a window opens to set the properties and options for the pipes screen saver tried other screen savers...

I know how to make a shortcut, but how do I get it onto a form?

I know in WinNT you can CTRL + ALT + DEL and you get an option to lock workstation but I am stuck in Win98 land and need a similar function without waiting on the screen saver timer.

I have an application that several users will be using to input data in a high traffic area in a warehouse. Sometimes these users are required to leave their workstation for a few minutes to check things out. I need a way to shut down their screen while they are gone so no one else can alter...

Thanks Rich. Got it going, was just named SUB1 but when I went to design view of subform, that was called frmSUB1, didn't think there was a difference. Thanks for pointing that out. Been trying for days to figure out all those errors I kept getting.

Hey, I tried: Me.frmSUB1.Requery and when the form goes to open I get: "Compile Error: Method or Data Member Not Found" Don't know what else to try

Dave E- I gave it a try: Private Sub Form_Open(Cancel As Integer) DoCmd.Requery (Forms!frmErrorNotice!frmSub1.Form) End Sub But I get the error "can't find field frmSub1" but its not a damn field!!! its the subform name. This is the error I've gotten on every damn thing I tried. Why...

I have a mainform with a subform when it opens I would like to have all the records in the subform listed. It works fine if I click in the subform and SHIFT+F9 but I can't get it to show the records when it opens. I have the main form it is with, opens on a control button from a previous...

I am not using a query with this subform. It is for data input because I need to enter multiple instances for 1 instance occuring in the main form.

I have a main form with a subform on it. The subform is in Continuous form view so that I can enter multiple records. But when I fill out some textboxes in the first one it populates the same info in the second one. And then when I go to enter the second record on the subform and overwrite...

I will get a little more specific There are 6 auditors working on 6 terminals at any one time. Say Auditor # 7020 has done 20 audits and found 32 errors by 8:00a.m. At 12:30 p.m. she has entered many more audits and errors are over 100 now. An employee from her first audit needs to sign off...

Works like a charm. Thanks a lot!!!!!

I have a small application used by warehouse auditors. The main form is a username and password form. The second is the form where they enter the carton number, # of units in carton, employee that filled it, and reason for audit. If there are no errors in the carton they hit next carton...

OK I have a form where the user enters their ID num and password. On this form is a control button that opens a report. The reports source is a query and I had it set to ask the User ID and the Date in the criteria. Well I am trying to make it where the criteria for the user name is not asked...