Search results for query: *

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...

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...

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...

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...

Hello - I have an app that imports a spreadsheet in to a table - I need help with a query that will tell me the date range of the records. Is there an easy way to get the minimum and maximum date values? Thanks

I have an application that worked fine until the user's PC was upgraded. She has the same version of Access (2003) but the service pack level is now SP2. The other users are all at SP1 and the app works fine for them. On the upgraded user's machine, it only partially works. There are two...