Search results for query: *

I need to change the design of a form from allowing only one from per customer id to multiple forms per customer id. My database specifics are as follows: 1. The data entry form has two components, a header and a subform linked to the main form based on customer id number. 2. All the fields...

I want to format a pivot table appropriately such that when I have two entries falling underneath the same group both lines say the group number. What I Have Now: Sum of Amount Group Name Total 1 Julie 5 2 Jon 10 Leo 9 3 Tim 5 4 Duane 8 Travis 7 How I would like the table to look...

Is there an easy way to use a data connection to connect an Excel 2007 workbook to an Access 2007 query? The query will then be separated into several different worksheets within the same Excel 2007 workbook. I want the data to be returned into Excel into a table-like format for each...

I have 18 sub-reports, all linked to a master report using region as the linked field. The master report is grouped on region. The 12 regions are sorted in ascending order. Each sub-report provides a count of how many customers fall within any one region. Each region has its own pages due to...

I have a data entry form with 12 fields. The first 11 fields are completed by the users. The last field asks the user if the entry is complete. What is the easiest method to use to automate the last field to populate Y for Yes if the first 11 fields are completed? Should I use a...

28 Dec 09 14:28 I am having a problem with compacting the back end of an Access database. When I tried Compact and Repair, I receive an error that reads, "Could not find field 'Description." When I click on Help, I get "Could not find field <name> Error 3799. A column name that does not exist...

I am having a problem with compacting the back end of an Access database. When I tried Compact and Repair, I receive an error that reads, "Could not find field 'Description." When I click on Help, I get "Could not find field <name> Error 3799. A column name that does not exist is being...

My specific question is: What step(s) am I overlooking with the Requery Method that I receive an error? I have a form with a field labeled "Staff Contact." After a user inputs a new Staff Contact, saves the record and then moves to the next record, I want the requery method to refresh the list...

We are having trouble in my office linking Access 2007 database files to Crystal Reports version 12.2.0.290. Does anyone know of a solution for this? Before the Access file was converted to the 2007 format, it worked just fine.

I need to use the requery command to requery the data source for a combo box, but I'm wondering if I am missing any other obvious steps. My code is below: Private Sub ProviderName_AfterUpdate() DoComd.Requery "ContractorName" End Sub For the sake of argument, let's say my combo box is a list...

I'm trying to change the maxcro this code runs just slightly. This macro is attached to a switchboard button. Right now it creates a backup copy of my database on the current drive of the database. I want the backup to be created on their flash drive and pop up an error message if the flash...

We have a .csv file we are trying to import into Access 2007. One of the columns contains data with decimal places. When the column is imported into Access 2007, Access 2007 rounds the values (i.e. .500 to 0). We've tried to change the field to double v. long integer format, but Access 2007...

I have an Access 2007 database with four tables, and I’m struggling with some of the subforms linked to those tables. Below I've tried to outline my structure. The first table is my main table and contains a primary key field of id number for each record. For example, id number # 12345 serves...

I have a data entry form with three subforms. The form's fields of name, date, etc. are automatically populated from a table. The three subforms require data entry by the users. If the user selects a record (on the main form) with an id of zero (meaning no record exists), I would like the...

I have a report in Access 2007. When I run the report, it functions fine. When I flip to Design view and then attempt to run the report again in report view, Access gets hung up and the data doesn't appear correctly. Any thoughts?

I am trying to correct a minor issue in a database. I have a data entry form linked directly to my main table in the database. The data entry form is also linked to three subforms, all of which are then linked to three other tables. The primary key field for all four tables is a unique id...

I want to add an Event Procedure to my Access Report to ask my users if they want to print three copies of my Deficiency Report before closing it. I want to attach it to On Close. If they say yes to printing, I want the procedure to print three copies with three different labels: 1 - Internal...

I've designed a quality assurance report in which Access creates a customized list of corrections for a particular staff member in a specific geographic area. Each staff member receives a one to two-page-report with only his/her information. I want to add a memo field in order to enable the...

I'm designing an Access report in which my users have asked for a Comments Section of blank lines in which they can leave handwritten notes. How do I add several blank lines in an expeditious manner? I know how to draw one line, but I have a lot of trouble keeping it straight. Once I get it...

I'm helping a colleague with a database of three fiscal years' worth of data. The database has three separate tables as below: Table 1 - Expenditures Table 2 - Receipts Table 3 - Revolving fund transactions. Within each table, each transaction has a fiscal year field as part of that...