Search results

Thank you, I tried the help before but couldn't find the right thing. How can I format it so that there are only two digits after the decimal place. There are ten digits right now. I went into the properties and changed it in there but it didn't work. Any suggestions??

I have never done math on a report so I need some help at this. I have two date fields and I have another column that calculates the number of days between these two dates called DaysElapsed. Now I would like to calculate the average of this column and store it in the footer section. First of...

That worked!!! Thanks for the help.

I tried that, here is what I put: DateDiff ("d", Date Orig, RelFloorDate) and it told me invalid syntax, what does that mean??

What expression would I use to calculate the number of days between two days. Say one date field says 12/20/01 and the other says 1/20/02 and I want another field to display how many days are between these two date.

"You could also set a global variable when you enter the data into the first form and then use the variable in the On Open event of the second form instead of using OpenArgs. " Could explain this approach to me a little more. Does the form have to be open? What code do I use? Thanks!!

There is a field on a form that I would like to carry over onto another form. Let's see if I can explain this. The user opens the form and fills in all the date. Then I have another form (based off of a different table than the first form, both tables have the same field for the primary key)...

Thank you so much for all your help!!! It works!!!:)

The combo box is called Combo22

Nothing appears in the MsgBox

I forgot to say that the code to open the comments form and put the data in the field is in the After Update event of the combo box, does that change anything?? Should I still try what you suggested??

I put " " around the A and now nothing happens when I choose A.

I am not sure if I understand what you mean by this: The next possible problem could arise from the way your combo boxes are set. Is the bound column actually equaling A or is an A just being displayed? I created the combo box using the wizard and put A and R as the two options. My email is...

I have a field called AcceptReject that is a drop down menu with the choices A or R. When A is chosen I would like the comments form to open and todays date and the A to automatically fill into the comments field. If it is R I want the date and R to fill in. The first problem I have is that I...

Well the database has been set up and in use for aobut 6 months now and unfortunately the way I set it up, the primary key is an autonumber so whenever data is entered a record is generated so a save button would not work because even if they don't save it and close the form the number was...

ONE MORE QUESTION!! Since I cannot prevent CTRL ALT DEL from closing a form is there a way I can display a message box before it closes that says it is going to close and the record will only be partially filled in?

While that does make sense, it is not an option because of the way the database is set up (it is done wrong and I know that now). I have used an autonumber field, so once info is placed into one field that record is begun in the table and the number is assigned. That is why once a user starts...

still a bit confused Well I found some topics on this site about Autokeys. And this is what I have so far, I created a new macro and named it Autokeys. I clicked the macro name button on the toolbar which created another column called "Macro Name". In that column I typed {DELETE} and under...

I have placed code on the Unload event of a form to check if certain fields have data in them (once the user has started entering in data), if not the form will not close. However, I have realized that ctrl alt del, allows them to close the form with only half the data in it. This is causing...

Thanks!