Search results for query: *

That sounds right, do you know where it is located?

If I wanted access to run a macro when the user clicked on a report how would I do that. I have two reports that both run on code that is in an AutoExec macro, one of the reports needs extra automation, so as soon as the user clicks on that report I want access to run the other set of code that...

Thanks, I ended up using the workaround

Does anyone know what "Reserved error (-7711) there is no message for this error" in Access means. thanks, Layth

When I run a union query the I see a message box that says "To Many Fields Defined". What does this mean and how do I get around it? Thanks, Layth

Actually, I figured this out a few days ago, sorry I havn't written back, my whole database runs like a dream, Thanks so much!!! Thanks again, Layth

Alright, this is very cool, one more question How do I get this to immediately update in vba when someone opens this access database, or perhaps have the update linked to a command button. THANK YOU!!! Layth

Thanks for the help, I'm not really familiar with append queries, I think this is what I want to do, but if you could elaborate I think I could use this method more clearly. thank you for your help. Layth

I have an access database that has multiple linked tables. One query pulls out all of the information I need, I then turn that query into a make table query and query the subsequent table. From there I use other queries to count records, manipulate records mathematically based on their fields...

Thank you this works well.

I have a report that shows all 310 records from a query. I have one field called stopdate, I want to do search in the field stopdate so that it only shows the records that correspond to the date that the user will insert in the beginning of the report in a text box. The report would look like...

Thanks a bunch! This works very well! Layth

I'm making a report based on a query with 30 fields. When I run the report I get an error message, "The wizard is unable to create your form or report you chose too many fields, please try again with fewer fields." I have made a form based on the same amount of records, so how do I get around...

Close, the city field was just used as an example the code actually unioning total prices, this is what ended up working for me. Also I had to tweak the queries a bit submasterpiece=MASTERPIECE, thanks for your help SELECT *, [MASTERPIECE].[Total] AS CombinedTotal FROM [MASTERPIECE] WHERE...

I actually have fields in all three of the queries that are the same that I need to have in the final union as well, what happens to those fields

I have three fields in a query that each give a decimal amount, the three are unique meaning if one is not null, the other two are null. What I'm trying to do is place all three of these fields into one field I'll show an example City Code 1 Code 2 Code3 San Juan...

either or, both of these work great! thank you, layth

sure I have data that will end up as: 101 132.3 45.3243242 I need 101.00 132.30 45.32

I need to return a decimal dollar amount, to decimal places, from the code below, I know its something simple, but I have tried decimal, float, double and none of these work. Here's the code [START THE EQUATIONS HERE].[MIN Of INSERTIONCOST] * ([START THE EQUATIONS HERE].[Total Of AMPORDERFK] -...

Thank you very much, this is exactly what I needed! Layth