Search results for query: *

I am using an Access macro to export data to multiple Excel worksheets. I have all of the data going to Excel and most of the formatting working. Now I need to set the Page Setup options for all of these worksheets. I am zooming to 90%, adding a footer, changing margins, and repeating rows at...

I am trying to export a query to multiple worksheets in Excel. I am using TransferSpreadsheet and just exporting the query works. When I try some Excel formatting within the macro, I eventually am prompted to save a copy of the file. I saw some other posts, which suggested it was a memory...

I am trying to pull the minimum of two fields and then add up two other fields from the minimum record in the table. Here is the SQL: SELECT db_history.loan_id, Min(db_history.due_dt) AS MinOfdue_dt, Min(db_history.paid_dt) AS MinOfpaid_dt, [prin_amt]+[prin_bal_amt] AS PreviousBal FROM...

I have a string type field that contains text, numbers and NULLs. I am setting all the Null or strings (like *[a-z]*) to zero and CLnging the others. Then I need to get the max of the new values (or just sort them descending). Whenever I add the sort or max, I get a "Data Type Mismatch"...

Hello, Thanks to this forum, I've learned a lot about controlling Excel documents from within an Access macro. Most of the time, I can record the Excel macro and with a little tweaking (put a . in front of the line) get it to work in Access. I am now converting an old Excel macro and I'm not...

I recently got a call to help someone with an Excel problem they were having and I can't figure it out. It is an old Excel file I believe is pulling data from an external database (ODBC) using MS Query. When I try to edit the query, it says "waiting for data to be returned by Microsoft Query"...

I was using .SendMail to send an Excel document that was just formatted (all of this is done from an Access macro). When I didn't define recipients, the message box would pop-up and the user could edit the body and then send. Now they want the recipients defined, so I added that in, but now...

I am trying to export a report as a text file, which we will send off for import. I am getting the data to come out how I want it using an OutputTo, but there are blank lines in the text file. For example: 0000001 01012007 500000 0000002 01012007 5000001 0000003 01022007 5005555 0000004...

I am using Access to output a query to Excel. I need to do some conditional formatting on the data, which doesn't export easily. What I need to do is export the query, do the conditional formatting in Excel and then send the updated Excel document in an e-mail. I'd like to do all this without...

I am trying to export a report (or query really) to Excel with some basic formatting. I need to change the color of one field if another field is a certain value. If I set the field to a different color, the formatting flows over. Because I need conditional formatting based on another field...

I am using a GoToControl in an Access macro to validate a field. The macro is run from the BeforeUpdate of the field (I tried AfterUpdate as well). The macro checks the condition, if true, I have a cancel event. Then a message box, that does pop up. Then I added a GoToControl to move back to the...

I'm using a table which tracks changes to certain fields. These changes are marked with a date/time stamp. The fields I am looking at are addresses that have two fields, address1 and address2. I want to count a change to address1 and address2 at the same time as one address change. I also...

I'm working on a form that contains quite a few fields and is therefore pretty wide. I am using a scroll bar, so the user can scroll horizontally (and vertically) through all the items. Now I need to add a few more details to the form. What I need is User, Company, Group and then all the...

I am using a Make Table Query, but I cannot get one of the fields to be a Yes/No Field. I have tried setting the values to -1s & 0s and TRUEs & FALSEs and YESes & Nos, but the values come out as -1,0 with a field type of number. Is it possible to force the field type to be Yes/No in the make...

I am trying to use a recordsource to cycle through different report criteria. I need the report to display for every user and then this report will be e-mailed. Here is my code:Dim db As DAO.Database Dim rsUsers As DAO.Recordset Dim UsersSQL As String Dim WhereCriteria As String Dim...

I'm working on an automated letter report and one of the paragraphs is now giving me the "The string returned by the builder was too long. The result has been truncated." error. What are some ways to get around this? The paragraph consists of nested Iif statements that produce multiple...

I have a User tables that contains user information with the login name as the primary key. This is the only place I am storing the full name of users. I have a table that contains requests. The table stores the login name for the person who made the request and also the login name for the...

I have a form which sets a date/time field as now when it loads up. That is working fine. The problem is, when someone overwrites the date with a new one (that is allowed) and they don't enter a time, the field only stores the date. Is it possible to automatically place the Now time in if no...

I am working with my first continuous form and am having some trouble accomplishing some things I think I should be able to do. What I have is an approval form. It lists all unapproved records with a check box which is unchecked (I used the Yes/No field from my query as the Control Source)...

I am trying to create a report that needs a graphic outline with a small graphic box at the bottom. I've gotten the report to work fine on its own by putting the small bottom graphic in the page footer of the report. Now, I need to add this report as a subreport into the report footer of...