access 2007

Hi all. I updated an Access database form an older version and it now has the .accdb extension versus the .mdb. I updated the VB code where it's pointing to the database but getting an error on the following bolded section. Thinking it's because I converted to .accdb. idrive =...

Good afternoon all, I am getting the following error message when using my combo box to auto fill some fields on my Access 2007 form, "Compile Error: method or data member not found. The cbobox has an embedded query behind it that pulls (correctly from 2 different tables) all the information I...

Hi All, I am creating a user form in Access 2007. I am receiving a Compile Error within my VBA coding. Please take a look at the code below and see if you can help. Compile Error: Expected: End of statment Recived on line: DoCmd.OpenForm “frmPasswordChange”, , , “[UserID]" = ” & Me.cboUser...

Hi, I have 2 forms in an access database (access 2007-10). I am trying to delete these forms using vba in an excel workbook. My access database has NO database password but the VBA project in access HAS a password. In the access database I have created a sub procedure (named DeleteAll) which...

Hi All, I am kind of stuck on finalize a crucial report in MS Access..... and tried to Google it as well but didn’t find any useful solution.... I will try to explain it with an example... Lets Say i have a Table in Access with below data: Table 1: <tbody> Material Description Qty A...

Hello, I have a database that manages employee training and documents. As part of my data structure, employees are assigned a job function which contains a set of procedures they are required to train on. Each employee may be assigned many job functions (there is the company core, department...

Hi, I have a data connection in Excel 2007 linked with an Access 2007 file. On my computer it works fine but on my colleagues computer it doesn't quite work. When he opens and updates the file, the linked table deletes some data. In the table once it gets past 13/08/2015 it does not produce...

Hi, I am using a macro enabled .xlsm Excel 2007 workbook. I have 4 data connection to the same Access 2007 file from which I get various pivot tables. My issue is that the spreadsheet works perfectly for me and others in my office, but one colleague in another office (who has Office 2007)...

Hello - first post here. I have a spreadsheet in Excel 2007 that is pulling from a query built in Access 2007. The formula in the query reads: RetireElig: IIf([age]>=65 And [ServiceYrs]>=10,"65 & 110",IIf([age]>=60 And [ServiceYrs]>=15,"60 & 15",IIf([Age]>=55 And...

On a form, a text field has the three color conditions allowed in the Conditional Formatting dialog box. OBJECTIVE: I need a button to change the color of the text field from one of the three to a new color condition (grey). RESEARCH: In my research I have found a delete condition (I...

Hello I am new with Access and VBA, My purpose is to export Queries in one workbook but different worksheets. I am working with Access 2007. When I add an Ouput file for the Queries to go in a specific workbook I get a compiling error stating: "Compile error.in query expression...

I have true/false data (as yes/no check boxes) where my first field is my record name (record_name = "A" thru "Z") and the remaining fields are titled "One" thru "One_Hundred". The data are checked if my record_name tests positive for my field name criteria. For example: if record_name "B"...

I know enough about the Access 2007 I'm using to be dangerous to myself and others, but hopefully someone will feel pity for me and help... I set up a database to track several different types of data for 300+ "sites". I have a table that has all the site numbers and their names; another table...

I've inherited an Access database. It pulls the amount of pounds sold of our products from our sql server and converts to tons by pounds/2000. However, it truncates after 2 decimals which leads to a huge amount of error. I tried changing the format to 4 decimals but it just takes the existing 2...

I have a form in my database with 12 data input boxes. The user inputs the forms and then they press a "Save" button and it saves it as a new record in a table. I would like to implement a check though of sorts where when the user presses "Save" it checks to make sure all fields are filled in...

I have been trying to build a SELECT query to drop data from multiple tables into one in order to easily build a report off of that table. I am only focusing on one table at a time and have run into an issue with an INSERT INTO statement. For one of the fields in the destination table which is...

I'm trying to set up a default value for a text box. It will be a file path that contains an ampersand. Everytime the form is loaded the text box evaluates the ampersand and so it disappears. C:\J&B changes to C:\JB and so the subsequent code doesn't run. Is there a way to escape the...

I am using the following SELECT statement to remove unwanted characters from a field. However, if the field is blank, a #Error is populated. Can anyone help me with a workaround for this? SELECT MID(table.column,Instr(table.column,"badtext")+3,LEN(table.column)-Instr(table.column,"badtext")) AS...

I apologize in advance for any noob poster mistakes - I am very novice, trying to edit an Access database. I am trying to upload .xlsx data by changing a hard-coded workbook and worksheet name to a more flexible one. The worksheet name includes a date that will be changing every time this is...

Hi, I have a form with several subforms (using tabs). in each of the subforms for multiple fields I have calculations summing the fields in footer sections. These are then brought into the footer of the main form, so the user can see up to date information on the master record (for lack of...