Search results for query: *

Thanks again for your help. I think I have the basics of it working. Lena/Ellie

Thank you for your insight. I know if I don't program in a way to remove the award from the list of available awards, then I will have that problem of two people selecting the same thing at the same time. I figure if I plan for it, then it won't happen (my luck seems to run that way...buy a...

Good Afternoon, I am creating a database for employees to take a "Quiz". Once they complete the quiz they get to choose from a list of available awards. I have the combo box set up to show only those awards available when the form is opened. If an employee leaves the form open for a couple...

I guess we will just agree to disagree because what I am trying to do did work at one time. I am not the only one that has noticed the difficulty in trying to debug the form's code. Oh well...I will find the answer.

Why would I think it would do anything? Cause it is suppose too. It always has in the past. If I have the following code on a form and in a module: Private Sub QuitThisDatabase() DoCmd.Quit End Sub pressing F5 in the module (with the cursor within the sub) will cause the application...

I am creating a new database. I put a button on the form with the code: docmd.quit When I view this code in the code window, put my mouse in that function and press F5 I get the macro window pop up. It doesn't execute the function. Any idea why? Thanks! Lena

Duane, I have figured out how to do the dynamic crosstab report (thank you for the link). What I am looking for it how to have group headers for the different Functional Areas and Categories. I will read the FAQ you provided and see if it gives me any hint on how to have these group headers...

I need to create a dynamic crosstab report that allows me to group the results. I need to group on Functional Area and Category and then do a count of how many times each Control Number has been used. The report will be for the last 12 months. Each time a new month starts, the oldest month will...

Your welcome.

Does your query look at the date stored in the control storing the date you selected using the calendar? If it does, you should be able to requery the subform if the subform is based on that query. Lena

Did you see the questions that I posted for you to answer? You shouldn't be getting an error when two people have the same form open. I am sure there is a way to do what you are asking but it seems that the problem should be solved at why two people can't have the same form open and not try to...

Is your database set up to have a backend (on the network) and a frontend (on each users computer)? If not, it is advisable that you do this. What happens when another user tries to use the form? Does it give them an error message? If so what is it? Lena

In one of my databases I open another database using the following lines of code: stAppName = "msaccess.exe \\rdc1\CPRP\WorkingEmployeeRoster\DBMaint.mdb" Call Shell(stAppName, 1) Make sure you change the \\rdc1\CPRP\WorkingEmployeeRoster\DBMaint.mdb to reflect where your database is...

If you make your text box as wide as you want your text to be it should wrap on its own. Fields that are text fields can have up to 255 characters. Memo fields can have many more. HTH, Lena

Remou, Yes, I see that now. The other line I was seeing was the one passing the "+". Thank you for pointing that out. It ended up being where this form was being opened from another form. Not sure why it wasn't just opened as a new record from the other form, but at least I have learned a...

Skip - no control named OpenArgs. Remou and PH - I found another instance of the OpenArgs used in the database. I guess I don't understand how the OpenArgs is set to "+" in the first place. I tried doing a search for + and found alot of them, but they were being used to concatenate fields...

I have a database that was built by another person and it has the following bit of code in it: Private Sub Form_Load() If Me.OpenArgs = "+" Then DoCmd.RunCommand acCmdRecordsGoToNew End If End Sub I am not sure what the Me.OpenArgs = "+" means. I would greatly appreciate an...

How about something like: IIf(Month(Date())>=6,Year(Date()) & "/" & Year(Date())+1,Year(Date()+1) & "/" & Year(Date()+2)) Lena Lena Using Access 2003

You are very welcome. I am glad that I could be of help! Lena Lena Using Access 2003

Hi Ali, You could join the fields together in your query and display that field in your combo box. I am assuming that you have a primary key that makes each record unique and that is what would be used to determine what record will be shown. In your query create something like: CustomerName...