Search results

Actually I managed to get the visible property to set correct, but now I cannot get the focus to move to Form C. I've tried setting the focus to itself on the onOpen event, but no luck. Any suggestions?

Rich if I put the code in form A which opens formB (and will set its visible property to False) How do I write the code in form A and where do I put it? I cannot use Me.Visible = False I will need to code it...Forms!FormB.Visible = False, but what event to I put it on? Any help you can...

This seems really straight forward to me. I have 3 forms - FormA, FormB and FormC. When I open FormA the user inputs some information, when they tab to the last field, FormB opens (which I want to be invisible) and Form C opens. I've tried putting this coding on the Open event of FormB...

I'll just add a comment to this post. When I was trying to find keycode constants using the help, I discovered that you had to be in the VBA Help, not the Regular Access Help. If you click on help while you are in VB you will be able to search KeyCode Constants.

I need Numb Y, because once X = Y the form clears itself out and is ready for the next client's information. Up until that point it retains the client specific information and allows you to enter the different transactions without having to rekey the client info. I know there are easier ways...

Hi Everyone, I will do my best to try and explain what I am trying to accomplish. I have a form that has two fields [NumbX] and [NumbY] They way they display on my form is [Numbx] of [NumbY]. These two field show which transaction of the total number of transactions. So basically if someone...

Thanks a Bunch It took me a long time to get around to trying your suggestions, but I finally got to it and it worked!!! Thanks. :) :D :) :rolleyes: Cindy

The unbound forms feeds subsequent forms. I don't want them bound to a table at this point, as they should not be updating the table until later on, there is a whole lengthy explanation behind this, one of which it is a database that is I am replicating for training purposes, it needs to...

Thanks for your help. I've got it working now. :)

Hello Everyone, I have a main form for entering transactions. There are 2 fields which are transaction X of Y (X being one field, Y being the other so for example TRANSACTION "1" or "2") If Y is greater than 1, when the user finishes inputting all information on the subsequent forms and...

Hi There, I have a form with an unbound text box called TrkID. When the user double clicks in the TrkID text box, I want another form to open that contains a list box. From that list box the user makes a selection that will then populate TrkID on the original form. The user also needs the...

Hi Pat, It appears to me this will save the form that is already open (I could be wrong here) I need Form A or Form B to save. Form A or B opens based on this code: Dim stFormVar As String stFormVar = "frmTran" & (Me.TranType) {Me.TranType can be any one of 1 -5} So possible forms that...

Hi There, Pat, my objective is to simulate a system that is used on the longshore for managing containers. The containers are tracked as they enter the site. I am working on a simulation for training purposes and am attempting to (loosely) recreate or mock up an existing system. I'll try...

Hi There, Thanks SO much for your response, this little issue is killing me. No Luck! I put the coding you suggested on the On Current Event of the form. The record did not save, I still have autonumber showing in my record ID field. Do you have any thoughts on why it won't execute. I've...

Hello, My odd situation is that I have a form, this form has some fields which default from a different form. I need the record to save with the default values before the user types anything into the form. I would like to save the information already contained in the form when the user tabs...

Okay, I figured out that the record must be saved before the subform can reference this record. The problem is the first 2 fields on the form default from another form, then the subform fields are supposed to populate, so basically there is no physical input by a user (yet) to trigger the...

I have an unbound form (form A). Depnding what is input on form A another form will open. For this example Form B. Form B has a field called ContNbr that defaults with the value from a field on form A, this field on Form B can be overwritten/changed by the user. Within Form B is a subform...

I get an error mismatch type and it points to the line: Set rst = CurrentDb.OpenRecordset(strSQL) Any thoughts? Thanks for your help :) Cindy

I have a form where I need to populate an unbound box with values from a table, based on an entry in a textbox on that form. As well the entry in the textbox populates a different table: Tables: tblDataInput & tblCont My form is a data entry form based on tblDataInput. The user will input a...

I have th same issue, but I do not know how to use a query to do this. Can some elaborate? Thanks