Recent content by jcmeyer5

If it were just me using it, I would be right there with you. Unfortunately, the people that will be using these have trouble making hyperlinks in their emails. I dont want them to have to think about this.

I have 4 queries that I want to export. I want them to be 4 tabs in the same Excel file. I want to do this in a macro (a form has a command button that will run the macro). I found a few options for exporting in the macro commands, but none of them want to add a tab... they all want to...

Actually, what I did was pretty DUH. I have a command button that runs several macros. What I did was set the first macro to SaveRecord. This put the information into the REPORTHEADER table. I then pull the values from there into my query, using the control from the report as a criteria to...

I have a form that I enter information into a table. I want to calculate 2 queries based on the current record in the form. I have the whole "using the control as criteria in a form" thing working for me. What I want to do is mark the records with a report ID. The report ID is an autonumber...

I have a subform within a form. This form is good for entering accounting records. The form is HEADER, the subform is DETAILS. In DETAILS there are accounting transactions. In the accounting world, debits (positives in my case) and credits (negatives in my case) need to net to zero. I dont...

Ahhhh... muchos gracias!! I was able tyo modify that to get to where I wanted (I needed $100 increments up to $10,000). Thanks! I gotta get me an SQL guide or something!!

I have a table I created with a make-table query. It has 4 fields. Order Number - Ship Method - Catalog - Amount I want my table to look like Ship Method - Catalog - count of orders $25.00 and under - count orders $25.01 to $50.00 - count of orders $50.01 to $100.00 - count of orders $100.01...