access 2007

Hi I have created 2 tables - tab1 - contains category tab2 - Category, sub_category In relationship, I have linked both tables with the field category. I have a form with 2 drop down. DD_1 - gets category list from tab1 DD_2 - based on category selected, DD_2 should query and list the...

What is the best training material for Access 2007 that I can get. I am most interested in taking all my Word and Excel forms into Access. I am a "Access Dummy"

I have created a link from Excel to Access and import my data to Excel from a query. This all works fine, however when I close down Excel and then try and try and run the query in Access, I get the following message "The Microsoft Office Access database engine cannot open or write to the file...

So, I have a db with various tables and forms to update the tables. All was going well and the forms were fine until I put it on sharepoint. Now when I try to update the tables I get readonly / recordset not updateable errors. Any suggestions?

I'm doing an attendance database with Excel as the entry form and Access as the database. My fields are: | SAP_ID | LAST_NAME | GIVEN_NAME | TIME_IN | TIME_OUT | Entering a new record is no problem if TIME_IN is still blank. But if TIME_IN is not blank, I want my code to edit that...

I am in the process of creating an Employee database, and have multiple levels of data, thus I split it to different tables. Table 1 - General information (Name, Birthdate, phone number and Address) Table 2 - HR information (Start Date, Employee type, Drivers License, SSN, Insurance) Table 3 -...

I am relatively new at building Access 2007 databases and would like your help in answering two particular questions. I was so glad to find this message board. I have a simple database to track individuals participation in multiple volunteer programs throughout the year. Individuals all have a...

I haven't used Access before and am trying to generate a Report from a Query. I have built the Report successfully, however am having trouble adjusting the height of the rows in the Detail Section. I want the row height to fit the text, if there are two lines in the row, then have an...

I have a database in Access which I am trying to import into an Excel pivot table. I have been successful in the past with that task from Excel by inserting a pivot table from an external data source. I currently have a pivot table linked to Access, and I made changes in the Access database...

Good Morning, I am wondering if it is possible to import an excel worksheet into access to partially update records in a table. I know how to import worksheets to either create a table or create new records within a table; however, I have, as of yet, not been able to figure out how to update...

I hope that I do not make this sound confusing. What I have created currently works but I would like to improve it. I have created 2 tables Table 1 and a Table 2, In Table 1 is only one field "Last Name" and is a text field. Table 2 is a populated database with information and one of the...

Hi all, I need some professional advice. I'm new to VBA and have very limited knowledge. But I need to create a macro that will automate some information me. See below for my problem/situation. I have multiple accounts that have different product codes on there such as… Act 1. Prod Code...

Hi, I'm trying to get Excel 2007 to send some data to an existing table in Access, the amount of data can vary in size so needs to be dynamic. Sub DAOFromExcelToAccess() ' exports data from the active worksheet to a table in an Access database ' this procedure must be edited before use Dim r...

When revising a linked table in the '03 database window and then returning to frmSwitchboard, an OnActivate event would occur. Now, in 2007, leaving the frmSwitchboard to revise a linked table in 'Navigation Pane' and returning to frmSwitchboard does not trigger the OnActivate or GotFocus event...

I have an ACCDB file and I want to read it using Access 2003. Is there a way to convert or do I need some file converter? Please advise.

There is my computer that I will pull reports to.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> There are 5 locations entering current inventory (each with a wkbk)<o:p></o:p> I than have a separate sheet for the backstock req'd for each inventory...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Easy question, i think.<o:p></o:p> I have 2 tables. One with data containing file names and paths for old and new projects. Another that contains a list of current job numbers. <o:p></o:p> The...

Our company database is now sending out an error message that reads "record is deleted" when we attempt to query anything. There was ONE person here who had access to or knew anything about the database. He was canned before I got here, and this has landed in my lap. There were NO data...

I am running Microsoft Access 2007 SP1. I have a table (called CAL_INFO) and form (CAL_INFO_FORM) setup in a simple Access database that tracks equipment in my company. One of the fields in the form has a date that the equipment was last checked for accuracy. I call this field "DATE_LAST_CAL"...