Recent content by bluedemon186

Sorry, I am not an advanced user of Access so wasn't sure what you would need. I hope this is what you were requesting. SELECT Import.Client, Import.Year, Import.Location, Import.[Product Line], Import.Month, Import.Revenue, Import.[Total Jobs], Import.[Shuttle/Express Jobs], Import.[Average...

I am not using VBA for this query. Just a simple query.

I tried doing it 1 by 1 already, but as soon as I add the second 1 in, it stops working. I used Combo115 as the name as these 5 fields are all there will be for this database. However, I will still go ahead and change it as per your suggestion.

Hello, I have a query that I am using to generate a report. The criteria for this query is pulled from Combo boxes on a form. I have 5 combo boxes on the form and I am using the following as my criteria; Client: [forms]![frm_report]![Combo115] Location: [forms]![frm_report]![Combo125]...

Found it! It was the Microsoft Outlook 14.0. Thank you!

Can you please advise what reference would that be?

Hello, I have been getting this error for the below code which is for a command button. It generates and email in Outlook with data from the fields in the form "frm_rush". It used to work great on another work station, but when I created a new database on a different machine, it started giving...

Thank you, Pat. I tried something similar yesterday. I changed the data type to text before linking it to access so access thinks its a text field. Then I went back to excel and change the data type back to number which changed the FedEx Tracking to what I wanted. It is working as of right now...

Hi Pat, The issue I am running into is that both the UPS and FedEx Tracking are in the same column. The spreadsheet gets updated daily and its a new file with the same file name so I don't have to link it everyday. I tried using Clng (Expression), Val (Expression) in a query and a form, but...

Hi rzw0wr, Thank you for the feedback. I understand I cannot have two different data types, but is there a way to convert the number back to what it originally was? Thru a form or query maybe? The data type would still stay as text. Hi Isskint, Thank you for the feedback. I already tried...

Hello, I have a linked table to Access 2010 which contains tracking numbers for shipments. United Postal Service tracking#s is Alpha Numerical and FedEx is just Numerical. When I link the spreadsheet to the Table, the FedEx tracking numbers are changed to for example - 9.813842152e+014...

I am a total newb at VB so not sure what code to use. Is it possible for you to help with that?

Hello, I am working on a website which has over 1000 pages that has the same code, but only a link that is different on each page. So, I thought that I will create a database and work my way from there. I was able to work the code and combine everything. Now would it be possible to export...

An Expression You Entered Is the Wrong Data Type for one of the Arguments. I put the error in the title of the thread.

This is the lient hat was highighted. DoCmd.SendObject acForm, "SampleNotification", "PDFFormat(*.pdf)", Me.ClientEmail, "", "", "Sample Notification", "", True, "" However, it didn't give me any error when I tried it for the same records before doing what you asked me. For some reason it...