Search results for query: *

Well after some searching, I ran across thread705-993512 and a perfect solution by jbpez... Here is my finished code: Private Sub cmdMakeReport_Click() Dim strReportName, strReportOut As String strReportName = "Report3" strReportOut = "Test.xls" DoCmd.OutputTo acOutputReport...

I saw PVH's response to thread705-997479 and I am trying to do something very similar... Here is the macro that I am trying to run once Access creates the workbook Option Explicit Sub FuelCard_Report() ' Cells.Select Cells.EntireColumn.AutoFit Cells.EntireRow.AutoFit...

PVH - thank you very much. is a "Standard Code Module" the same as when I (in the VB editor) select "Insert" - "Module" on the toolbar? If so, I have done something wrong, as when I press F5, the "go to" dialog opens and it is blank... Also, I did get this to work exactly as I needed by...

Thanks for the quick reply - I have a really stupid question: How do I initiate the code? I am more familiar with using VBA in Access... Excel programing is fairly new to me. Can you recommend a FAQ to get me started? Should I save this as a Marco? Sorry for such newbie questions.

I am somewhat experienced with Access VBA (but NOWHERE near an expert) but would like to start working more with Excel VBA programming. I have spent literally hundreds of dollars on various Access VBA books - and sadly, only one or two of them were really helpful in the end. Before I do the...

I have a spreadsheet that has several columns - every time this report is ran, the amount of rows will vary. Can you help me w/ the VBA that would do this: let's say column A has dates in it. The first date will always start at A2 (first row is a header row). If the date at A3 is the same as...

I have a report to make in Access that will indicate several metrics dealing with my companies fuel purchases. I need to calculate "cost per mile" and "mile per gallon" but need help with the query... What I have right now for a data source is a table that has the vehicle VIN, transaction...

I have a report that is generated in Access and is exported to Excel as an xls file. My problem is that while in access, my leading zeros are fine, but when I export it to Excel, they are dropped. I have tried several things: I tried to force a format "0000" which works fine in Access but not...

Is there a "proper" function in Access that is similar to that in Excel? Or - is there some way that I can change the results in a query to be in proper case? Right now, most of the data is in all caps.

Is there any way to limit the available choices a user has on the control? For example, in my application, the only valid "start date" is on the 1st or the 15th of each month. Is it possible to disable the other dates? Also, what if I just want to capture month and year for an expiration...

I am trying to enter a credit card number into Excel - they are generally 15 or 16 digits. When I put a large number like that into Excel, the last digit is changed to zero. If I enter it as text (by placing a ' in front) that works, but the file is uploaded into another system that is looking...

After reading some more posts, instead of making a report as an Access object and exporting it, should I instead write code to create a new Excel object and then populate it with a query - then I could designate what each cell would contain? If you think this is the way to go, can you point me...

I have a report that has a few sub-reports and a few labels that help tell the person reading it what they are looking at. When it is viewed as a normal report object inside of Access, it is perfect, however when I export it to Excel (which is the format I need it in) I loose a lot of...

That works perfectly - thanks

I am trying to get a count and sum on invoices for each month that were not paid (i.e. sent to AP) for that month. I have a query that works fine for 1 month at a time, but is there a way to combine the past 12 months (May '05 to May '06 in this case) into just one query? Here is my (one month...

I was able to get it working by making this change to the SQL: Between DLookUp("[tblDateRange]![StartDate]","[tblDateRange]","[tblDateRange]![DateID]='1'") And DLookUp("[tblDateRange]![EndDate]","[tblDateRange]","[tblDateRange]![DateID]='1'")

Question: I am trying to query a table (tblInvoice) based on the Min and Max dates of records in another table (ImportTable) I need to temporarily save the dates for later use, so I have them in a table (tblDateRange) With help (see previous posts above) I was able to come up with this to...

I got it to work by removing the "=1" part SELECT tblInvoice.InvoiceNo, tblInvoice.InvDate FROM tblInvoice, tblDateRange WHERE tblInvoice.InvDate Between tblDateRange.StartDate And tblDateRange.EndDate Thanks Again

Thanks PVH - but I am still getting an Error: "Data type mismatch in criteria expression" - I'll keep plugging away it it, but any suggestions would be greatly appreciated.

How can I use these min/max values to query a different table? I modified your query example to save the dates in a table (which would have only 1 record) - I thought I could use a Dlookup to get the dates, but I get a type mismatch error: SELECT tblInvoice.InvoiceNo, tblInvoice.InvDate FROM...