Search results

Sounds like you may have a parameter associated to your Query on the actual report. You don't need a query parameter on the report since you are passing the parameter in the OpenReport command.

I see no resolution for you yet. I wonder if it is because MS Access is not installed on the server, therefore doesn't associate the mdb extension with a program.

Chose not to use acCmdDeleteRecord and just performed an SQL "Delete" command for the selected record. This worked great

I have a form that displays search results. After I have performed the search I want to have another button that exports certain data to MS Word to a label template. Any examples out there?

I changed my form to use a command button for the delete, because I need to do some other checking and updating, but now I get the following error. I have listed my code for my command button. "The Microsoft Jet database engine stopped the process because you and another user are attempting to...

Here is the SQL SELECT BallotUsage.bau_auto, BallotUsage.bau_type, BallotUsage.bau_date, BallotUsage.bau_loc, BallotUsage.bau_pre, BallotUsage.bau_low, BallotUsage.bau_high, BallotUsage.bau_first, BallotUsage.bau_last, BallotUsage.bau_spoiled, BallotUsage.bau_prov, BallotUsage.bau_total...

I have a form that displays data from 1 table, but I have a join on my query to reference data from another table for conditional formating on one of the fields on the form. When I want to delete a record from the form, it is deleting both records from both tables. I don't want the joined...

Thanks for the input. Yes, I agree about getting rid of the macro.

Thanks for the quick reply and the solution. I can always count on this forum to help me out with my questions. I hope that I can be of help to others soon.

I have a form that on the "AfterUpdate" it calls an Event Procedure that does three things. 1. Runs a Macro that does a "Set Value" to another field on the form 2. Executes a SQL statement that performs a Sum on the field that just got updated in the macro. 3. Executes a SQL statement that...

Yes I was able to enter data in the query after I changed the RecordSet as instructed, but I also had to set it in the Form Property as well. I will look more into why my INNER JOIN is causing a problem. Not sure why the INNER JOIN would be failing because the data is there. Once again, thank...

I noticed in my other database too the same problem occurs. I have the same form, just without the filtered variable. I know this was working because I have entered data on this form before. Now I don't know what is going on.

Ooops! I thought by changing the property this would resolve it. BUUUUUUUUUUUT, I do want the user to be able to update the information on this form. When I use the DATA Entry Property to NO the existing data show up, but I can't update the records. If I change it to YES then I can't enter the...

Thank you! Thank You! I don't know when I would have changed this property. You have been an awesome resource and I love this forum! Thank you for your patience and helpful directions. Marnie

Sorry I couldn't upload the database yesterday, my internet connection was acting funny. I actually have two databases. The one that has the problem uses linked tables to the other. When you open the one called soe_poll you need to login as nonadmin, test, which will load the variables and...

Sorry to have caused such a ruckus here. I chose to use the hidden form and have most of it working. But when I open one of my forms that is using the loaded value it gives me nothing. I run the query and the data is retrieved, but the form displays nothing. I do have another filter going...

So if I use a hidden form I assume I am making a regular form, but with the property of Visible set to "NO". Then how do I reference the data that I want in another form in a query? I'm open to whatever works best.

Please continue. I didn't understand the hidden form anyway. I have created a module with my Public variable. In my login form I load my public variable. This will be the only place in the application that the global variable is loaded. Now I want to reference it in my queries as explained...

OK I am a bit confused with the different options given here. First how do you create a hidden form and should I use this method over the others recommended. Here is the process that I would like to happen User opens database application Login form comes up Type in valid information Open...

So I have setup my public variable. On my login screen I read my user table to get the information I want to store in my public variable. Now I want to reference that public variable in a query for one of my forms. i.e. MyDefaultLocation is my public variable In my query on a table I want...