Search results

I'm trying to apply some conditional formatting to some rows in an excel spreadsheet via access vba code. basically, i have a list of tables, lets say A thru D. I have a routine that exports these tables to separate sheets in an common excel file. I am doing this by looping through a recordset...

So, I have a report I send out monthly. The end user needs both the source data and a pivot table summary, and both must be in Excel. So my thought was to export the source query from Access to an Excel sheet, then use Access vba to build a pivot from the data. Then the problems began. First...

So i have an rtf file with some tables within it. There is also extraneous data. This file is generated from an application written by Quilogy and I have the task of taking this file and putting it through access to create a payroll file. There will generally be 3 to 4 lines of heading...

I currently have a macro in Access that generates and emails an Excel file from one of my stored queries. I have it set to edit the email, then I open the file and perform a formatting macro I wrote in excel to clean up the output into a more readable format. I then save and send, then the...

I have searched and can't find an answer that suits me, although many have asked. I have 2 users who will be often concurrently in a database. They need to be able to access it at the same time. Each has a shortcut on their desktop to a database .mdb file on the network drive. This is...

I am using access to generate a payroll file for upload into our enterprise system. the enterprise system requires a field called "File #" and the pound sign is a required part of the field. everything is fine until i try to export the actual file. when i export the file, this field comes across...

okay, I've searched all over the forum and found many answers to this but none will work for me. I have a form that is basically a data entry form to enter information into a table. I have a combo box that has two fields listed (Employee_ID and Name), and the user chooses an employee from that...

i have the following code which will basically has the user enter a start and end date, then runs a query using the start date as a criteria, then adds 1 to the start date and does it again, etc., until the end date is reached. Function Float_Macro() On Error GoTo Float_Macro_Err Dim...

Anyone have an idea how I can have access copy the entire database, zip it up, and send it via email with a button click?

So, my company uses snapshot for almost every report we do. I'm responsible for the reports, so I send a gazillion of them out each week using macros. However, when i send the snapshot, all of a sudden some users are having odd viewer problems, like a simple landscape report explodes to a size...

Is there a way I can print something that will tell what each table and/or query is dependent on and what depends on each one? I don't mean relationships, just the dependencies. I'm trying to clean up a database but it was built before I started and I use some of the prebuilt stuff and don't...

Hi! I've written a macro and converted it to VBA which takes an average employee headcount for the 2006 calendar year by taking a sample headcount from the 15th of each month and then averaging the 12 numbers. I have the macro doing this just fine. -Currently it works something like this (I'll...

Currently, I have a report that checks for expired licenses for employees who are in positions requiring a license. I have it set up in a macro which runs a separate query for each department (i know there is a better way to do this, but i don't know how), generates a report of the output, then...