Search results for query: *

Is the data source for your ""Products Subform" which brings in all of the informaiton from the "Product" and "Transaction" tables onto one page" derived from a query? Or is the control source for each field drawn from one of the two tables? Chris

Your calculated grand total has to be in the form footer - not the detail section or any group footer. You would use the same formula you used for TotalValue, except when used in the form footer, it will sum all the values together instead of on each record. =Sum([WeightOnHand]*[Unit...

Hi Lisa, I believe all you need to do is refresh the information before the query is run so it registers the value you have selected in the combo box. Try this: Sub Combo40_AfterUpdate() Dim strquery As String me.Refresh If Not IsNull(Me.Combo40) Then strquery =...

Good Morning, Thank you for responding :) Ideally, each recipient should get only one file. Unfortunately I have several states that don't use Excel, so for those states I have to create the file in Rich Text Format - I know that can be accomplised with another If---Then, I just haven't...

Well, so much for getting it working :( Now the powers that be have changed what they want! I have read all the email treadss & faq, but haven't seen this addressed. Please forgive me if my questions doesn't make sense - I am pulling my hair out! Now, my db queries data by state from a...

Thank you for responding! I read all 135 entries in the other email thread and still couldn't fix this code :( I actually had to do both things suggested to get this to work. This is a database I inherited with the job & got the lovely task of "fixing". The command button that...

Good Morning, I am having trouble sending an email with report attachment to all recipients in a table. The code I have written creates a report merged with the recipeint's specific information and then emails that report to that recipient. The report merge works correctly and moves through...

Good Morning Mike! Thank you so much for all your help last week! I ran the macro today and everything worked ;) Just wanted to let you know how much I appreciate all your help! Chris

Hi Mike, I think I already had the qry naming the table dog_date and never "ran" the code. So if I understand now: 1. If I run the qry, it makes a table called "dogs", 2. then if I run the code it makes a new table called dogs06062003 3. I need to create a macro to...

Mike, OK, I made a new module called modTest and copy/pasted the above. To "run" it, do I just double click on modTest in the modules tab? I just see the same screen where I pasted the code....... if I type ?sSQL at the bottom of that screen and hit enter it changes it to Print...

Mike, I'm running Access2000 Here is everything in the VB code: Option Compare Database Sub dog_table_make() Dim sSQL As String sSQL = &quot;SELECT Table1.* INTO dogs<<DATE>>&quot; _ & &quot; FROM Table1&quot; sSQL = Replace(sSQL, &quot;<<DATE>>&quot;, Format(Now()...

Option Compare Database Sub dog_table_make() Dim sSQL As String sSQL = &quot;SELECT Table1.* INTO dogs<<DATE>>&quot; _ & &quot; FROM Table1&quot; sSQL = Replace(sSQL, &quot;<<DATE>>&quot;, Format(Now(), &quot;MMDDYYYY&quot;)) CurrentDb.Execute (sSQL) End Sub This is everything on the...

I tried putting the &quot;new&quot; short code into the module, still created a table named dog_date I deleted short code and replaced with long code, same thing, table named dog_date Maybe I'm shooting too high - this is a qry that will be run once per day and each day I wanted it to create a...

Mike, Hey that's closer - it named the table &quot;dogs_Date&quot; I just cut/pasted and named the module modDogsByDate... almost there :) what did I do wrong? Thanks! pooksa (Chris)

Steve, Thank you for your prompt response - unfortunately I have no idea how to incorporate what you said to do :( I'm sorry to sound so ignorant - I don't know VB at all. If you have any additional suggestions, I'd appreciate them. Thanks, pooksa

Can someone please tell me how to include the current date in the name of the output table from a make-table query? For example I want the table to be named &quot;dogs06062003&quot; today and when I run the query tomorrow it would be named &quot;dogs06072003&quot; I'm thinking it's something...