Search results

Is there anyone out there that can help me with this? I'm desperate!!!

I have a form it has several text boxes, fields and a subform. it has a parameter that prompts for a SerialNbr. The fields on the form are SerialNbr, cboCartStatus, CartDate, CartID, ServiceID Subform fields: cboCartEvent, CartID, CartEventSubType, CartEventDate The control source for the form...

here is the code behind the close button: DoCmd.Close acForm, "Add Cart", acSavePrompt yes it is a separate form

yea I did that but unfortunately it did not decrease the size enough.

yes the zip file was too large...

i tried to upload the db but it say's "a security token is missing"

I'm sorry I didn't mean on the actual on Exit event. there is a command button called "Exit" that I put the code behind. but it didn't work.

the listbox is on the mainform. So when I use that code on the other form of the Exit event it's not recognizing the .Requery part

I have a main form with a listbox and a command button for the listbox. When the use clicks the command button (called Carts) a new form opens for the user to enter information that pertains to the Cart. When the user enters the data in the new form and clicks save I need the listbox on the main...

I have a form that has several fields on it and 3 command buttons. I need each the command button to open a new form based on the record that's showing on the main form. can someone please tell me how to go about bringing that record that's showing on the main form to the new form when it opens.

I have a form that have several command buttons one of which is a save record button. ON LOAD 3 of the command buttons are disabled if it is a new record. If it is not a new record the buttons are enabled. Now my problem is this.....The Save Record button is controlled by a macro that is done by...

each form is using a different query. I would love to be able to do something like you have attached but I wouldn't know where to begin to put all the subforms together like that.

Right, I know that to be true. the problem is when I create the query using the appropriate tables, I'm having problems retrieving all of the corresponding data because of the fact that in the beginning there was only one table then the tables were broke up and some of the fields were name...

here are a screen shot of the forms that is associated with the tables. it may make more sense.

that is true GinaWhipp. The other thing is, they had only one table. all the fields were in one table. So when I broke the tables down and normalized them. All of the data is just not syncing back up together.

I think what's making this so difficult is that there is already data out there in the tables from the users. btw this has a sql backend. This is an Access application that a user created ( a total mess) and I am taking what they had already and doing a redesign to make it more feasible. so...

Hello guys, I need a little help relating my tables. I pretty much know how they should be related but I'm not sure about some of the fields. I have a Cart management system. (This system is to track the Carts (the big green garbage carts everyone uses). I have 4 main tables. Here is how I...

curious....how come that works for one form but doesn't work for another. I am trying to do the same thing but opening a different form.

thank you so much!!!!!! That worked! I love this site!

hello, I am doing something similar to this. How do you move to a new record in the On Open event?