Search results

Yes, I plan to delete the new file immediately after sending to avoid the garbage. They will all have the same unique name with the exception of the date so spotting any non-deleted ones will be an easy task. Thanks for all the feedback!

Yes, that makes sense. I will try Atomic Shrimps idea using automation and also try using CopyObject to copy the query to the desired name and then send the new query. Thanks for the feedback.

Thanks David, that is a great advice! Will do. I am still unable to get around the fact that DoCmd.SendObject acSendQuery will only recognize original query name and will not use the new file name. Any ideas on how to get around this issue?

Thanks Atomic Shrimp. I'll give it a try! I was also thinking of trying to have the macro copy the query to the desired name, run the query and email the results, then delete the new query. Any thoughts on this approach?

Thanks for the input guys. I have tried both suggestions and the process advised by Bob worked like a charm to format the date correctly. I must be doing something wrong using the DatePart function as VBA would not allow it to accept that format. However, I continue to get the same error...

Hello, I have searched and followed many of the suggestions in the forum and have gotten to the point where I can send a query via email. The only thing I need to complete this project is the abilty to add a specific date to the end of the file name being sent. Specifically, I have a query...

I have a process in Excel that I need to migrate to an Access2003 database. We need to calclulate a percentage of the value of a Part# based on how long it has been in Inventory. The table I have contains GroupType, Part#, Value, ReceiptDate. In excel I have a matrix with 6 GROUPNAMES down the...

Okay, I found the answer. It is a bug in Access 2003. You can either download the update to fix it or simply type in the table and it will find it. Hope this information helps someone else.

Sorry. Adding the database.

Hello, I have created a database to track onhand inventory. I am having a problem with appending data from one table to another. When I try to create the append query the destination table does not appear in the dropdown list of tables to append to. The destination table GROUPSLOOKUP contains...

Darn, I knew I was missing something basic! Thanks for the help, I really needed it!

Hello, I have a form and subform, both based on a separate query. The box I created to show the total of the datasheet subform is working correctly in that it does show the correct results as I expect. My problem is that I can not get this total to show on the main form. I have been through...

That did the trick! Thanks for everyone's input and help!

The form will be used by several people and the resulting data must always be negative. I have tried entering positive numbers and negative numbers and each is saved to the table exactly as how they are entered. If someone could look at the file attached to my original post and explain what I...

Hello, I have a form used for data entry purposes and the numbers entered must always be negative (to show a credit). I searched the posts and found information explaining to use =Abs([Freight_Credit_Value])*-1 in the control source of the control. I thought I did that but it still doesn't...

HI Beersnob, Thanks for the advice, it did the trick!

I have a database of freight invoices that I need to create a crosstab query to see the month the invoice was paid compared to the month of the invoice itself. The problem I have is the month the invoice is paid (INVPAID) is not the calendar month but a custom fiscal month. For example...

I finally got it all to work. Thanks for all your help NightMayor!:)

I wish it were that simple. We are the recipients of whatever data they enter so we can not count on always having a "SO#" or something else as the prefix. We expect to get some false hits but are counting on the majority being good.:)

My aplolgies for not bein clear. Each line is a separate data field. All our Sales Order Numbers are 7 digits in length and begin with a 10, 20 or 80. The data field contains information from the shipper and can contain any information the shipper chooses to insert, including data that can...