Search results

Hi guys. I'm at a loss...someone PUHLEESE throw me a frickin' bone, here. OK so. I'm in Access 2002. I thought it would be easy to create ONE report containing nothing but ONE graph based on ONE query with 4 columns: Product Category [PC], Time, sum(LY Inventory), sum(TY Inventory)...

Hiya- I'm using the self-teach method for VBA, folks, and so far it hasn't been very effective, so bare with me... i am performing a pass-thru query in VBA using code that i updated from another db. it works fine, however, i would like to have the results appear so i can do a quick, one-time...

Hello all! Quick question. WindowsXP, Access 2002. I have a table that shows sales and inventory levels for an item for each day of the week. Let's say the week starts out at 100 units. On Sunday, 7 units were sold, so the ending inv level for Sunday would be 93. Monday was 5, leaving...

It's been a while and I'm a little rusty, but I have created a report in access that I have formatted to go in columns. I was hoping I could have the header stretch across the page and just have the detail portion of the report be columnar. Is this possible? (Access 2002 by the way)

Hey guys... Does anyone know of a bug in Access 2002 with some of the form properties not working? I have an agitatingly simple Access 2002 form. No VBA, no macros, just 2 measly columns that come up in datasheet view (although the same problem happens in form view, as well) when opened...

Hello! I have written a small piece of code for an Access 97 database to import multiple text files into 1 master table on a weekly basis. Each text file contains approximately 10 columns and 96 rows. Now for the tricky part: Each text file may contain rows that are identical within another...

Hello - this should be an easy one for you gurus! I am in Access 97. In my table, I have a STORE column that is formatted in the design view to be 3 digits (i.e. Store "1" would show as "001"). In the query based on the table, this format is also specified for the STORE field. My report that...

Hello - this should be an easy one for you gurus! I am in Access 97. In my table, I have a STORE column that is formatted in the design view to be 3 digits (i.e. Store "1" would show as "001"). In the query based on the table, this format is also specified for the STORE field. My report that...

Hello: I've got a VERY general question. If I am running Office 97, what version of the jet database engine do I have? 3.51? Thanks in advance for your reply!

Hello all. :D I have a customer who was just upgraded to W98 and we are working in Access 97. She has a database that has many macros with one line - the sendobject function. In it, she has "Edit Message" set to "no" so that it automatically sends. The recipients are automatically addressed...

Hello all. :D I have a customer who was just upgraded to W98 and we are working in Access 97. She has a database that has many macros with one line - the sendobject function. In it, she has "Edit Message" set to "no" so that it automatically sends. The recipients are automatically addressed...

Access 97: I need to have a button in a form that, when clicked, will save a designated report as a .pdf and then take that file and put it into a Novell GroupWise note... I have referred to the link below, but it is hard to follow. http://www.mvps.org/access/reports/rpt0011.htm...

I know this question has been asked before, but I've searched this website and every link and suggestion has proved unsuccessful: I'm trying to download reports from access to Word and Excel and losing the formatting...I don't want to create a .pdf, and Snapshot is not an option. I also don't...

Hello all. I was wondering if anybody could help me: I'm a newbie when it comes to VBA. I need to write some code that will take a query(s) in Access, and put it into a specified tab within an existing spreadsheet in Excel. The spreadsheet contains 8 charts based on the downloaded information...