Search results

Hi all I am having trouble getting my function to add data to an Excel worksheet before saving it to the desktop. It opens the template and saves the file just fine, but for some reason I can't get it to add anything to the sheet! I've tried writing it from scratch and copy/pasting it from a...

I'm not sure if this is the right section or if the subject is worded correctly, but I am building a small database to automate the process of producing sales reports for our sales staff using data from our customers (distributors). They provide us with Excel spreadsheets with detailed sales...

I am trying to export data from Access to Excel, so I can use it to populate a spreadsheet that we use as an in-house form so I can save myself the step of manually entering data. In Excel 2007, I can connect to my database using "Get External Data" but it only lists tables and *some* of my...

Here's what I'm sure is a stupid question: I can't seem to pull data from a table for a form. I have a combobox that when a user selects an item, I want it to populate three or four text boxes based on data from a table that the user selects. They select an item called "Product123" from the...

I'm having a heap of trouble getting a scatter chart working. My report lists records from a query, including AvgDiameter, MinDiameter and MaxDiameter. The chart is supposed to have all three of these as their own series of points. My problem lies in the X Axis. Ideally I want them simply...

In an effort to make my code portable when I copy a form to change minor details, is there any way I can add "Me" to the SQL expressions that populate my combo boxes in certain locations? There are a lot of them that inherit and filter selections based on other selections, but they all refer...

I've built a simple complaint tracking system, and part of the data collected is a tracking number. With the year turning over to 2010, the first digit is now a zero. This zero gets dropped when entering, and one some products that end up with two leading zeros, our tracking number loses two out...

I used the wizard to create a switchboard, and modified the design a little. The form view is essential a vertical list of command buttons with labels after them. Clicking on the label or the button will of course launch the form or report that it is set to. In design view, it looks much like...

I have built a few simple forms for data-entry at this point, as I'm the only user of my database currently. At the bottom I've added two buttons, one called "Create &Another" which closes the form and then re-opens the same form so another record can be created. I did this because I don't...

Hello! I'm very new to Access and have only just recently set up a small database for our customer complaints. It's pretty bare-bones; there is an "incident" table that has fields for customer name, phone, product, etc. The ProductID field is linked to a ProductID key field in another table...