Search results

It is another form called 'popupbox'. -Chris

After I type that into the After Update Event box, and attempt to run it, I get an error message that says "Microsoft Office Access can't find the macro 'Me' ". This is what I typed: Me.State = Me.ComboBox.Column(1) My text box is called 'State' and my combo box is called 'ComboBox' -Chris

Sorry to keep asking about this, so I can leave it as "Me", or do I have to put my form name there? -Chris

What does the "Me" stand for in your code? Is it the name of the form? -Chris

How do you get the combobox to enter the second column in a separate text box? -Chris

OK, so say I am going to go with the popup box, and then base my queries off that. I really don't know SQL at all, so if that is involved you guys might have to help me out a bit. I went ahead and created a popup box with two text fields; one for SDate and one for EDate. I didn't think that...

Sorry for not explaining totally. When the first query runs, it prompts the user for Sdate (The Start date of week) and also the end date of the week, and then shows all records from that week. I want to somewhat "capture" or "save" that dates that they type in to be used in a second query...

Ok, so now I do know how to 'find' the dates of the week before, but what about capturing the dates that the user enters the first time, so I can use '[Sdate]-7' and '[Sdate]-1'? Thanks, Chris

Hi everybody, I have a table that has 4 columns as shown below: (*It really isn't code, I just couldn't figure out how else to keep the columns in place!) ------------------------------------------------------------------- Store Name Invoice Number Customer Name Customer Address...

Currently, I don't have any forms open when the user types in the dates. What is actually happening is that the user opens a report based on the query, and that is where they type their dates. The reason I need the previous week is that on my report, I need an average of a value from the...

Hi, Currently I have one query that prompts the user for a beginning date, and end date of a week. It then proceeds to show the user all records in that time frame and makes a table. Now I need another query that looks at the dates the user had entered and gets all the records from the week...

Hey everyone, I am trying to figure out how I can get the sum of values that were on a specific day, like Wednesday, and put that sum in a text box on a report. Any help would be greatly appreciated! :) Thanks, Chris