Search results

I am currently using Access 2010, and have successfully split a database, using the Access wizard. However, whenever a second or third user opens the database - with their front-end database file - they encounter the following message; The Microsoft Access Database engine cannot open or...

I am using Access 2010 and am developing a form where the user provides a full address - street number, street name, city, province and postal code. I want a control to calculate the distance from this address and a fixed address. I'm not sure where to start. Any input would be greatly...

I am using Access 2007 and have created a split form that is bound to the fields in a table. It was working fine in terms of Tabbing through certain controls, and successfully Tabbing onto the next record, as intended. Then I added a calculated control on this split form, that is based on...

I am using Access 2007 and created a split form based on a table. There is a field called cost code. A cost code may have one or several records from this table. I created a combo box based on cost code to select the records that appear on this form. I have raw data (hours) from the table on...

I am using Access 2007 and have created a split form. Using the wizard I then added a combo box for the user to select records based on a field called Formatted Cost Code. The wizard left a macro in the After Update property of the control for the combo box. I converted this to VBA using the...

I am using Access 2007. I would like to create a function in a module for a text field, similar to the function created by Bob Larson on 10/12/2012 when answering a thread called "Default Value in Forms based on value in another table". It appears that he is creating a function for a numeric...

I am using Access 2007 and have created a parameter query, and then a Form based on this query. I do not want a parameter prompt for the user, but instead a combo box drop-down list of all valid values! How do I accomplish this? I have been researching the 'Net and am getting confused. Is...

I am using Access 2007 and have created a simple query using two linked (Excel spreadsheets) tables. I have now created a Split Form from it using the wizard(?). That is, I high-lighted the query in the navigation pane and then clicked on the Create Split Form button in the ribbon area. A new...

I am using Access 2007. Form A is based on a query with a parameter prompt for Formatted Cost Code. Later on I developed Form B based on a query that also has a parameter prompt for Formatted Cost Code. I have Form A in the Main Menu. I then set up a button for the user to open Form B. As...

I am using Access 2007 and have inherited a database. It has linked tables of Excel spreadsheets that are information extracted from our main system. The user wants help in developing a much faster and customized approach to billing the customer based on payroll related information. There is a...

I am using Access 2007. I have a form with a control that does a calculation based on two other controls, and all three are fields in the same table. The table is called tblWorkFile and the controls are RegRate and RegHours, and these are multiplied together in the control source for...

I am using Access 2007. I have a subform that has a control (ControlA) and its input value must populate a field in a table, TableA. There are two other controls (ControlX and ControlY) on the main form which provide possible values for the user to select from when inputting to ControlA. The...

Hi everybody. I am using MS Office 2007 (Access and Excel). Back on Sept 26/12 I posted a request for help. I wanted to create a macro (or VBA code) that would help test whether a particular spreadsheet has been opened. Trevor G came to my rescue and supplied the following VBA code...

Hi everyone....Happy Holidays! I am using Access 2007 and have a database that is working fine but would like to install a control-check on an input form. At the beginning of this form the user must enter a job identifier (JobID). However, this value may be closed out and therefore no...

I am using Access 2007. I have a simple subreport that appears - as intended - beside a subtotal amount in a main report. I want to suppress/hide this subreport when the subtotal amount is greater than $1,000. How can I do this? I'm fairly new to VBA code and event procedures. Any help...

I am using Access 2007 and struggling with what I think should be a simple action on a Form. I have set up a form that reads all the records from a table. This is a result of a make table of payroll based transactions for billing purposes. I called this new table a WorkFile. My form is designed...

I'm using Access 2007. I have designed a database for one of a two division set up. All of the raw data in the tables is similar yet there is one unique identifier for the two divisions. Let's call it DivID, four characters in length. To keep the maintenance simple I want to have one set of...

I'm using Access 2007 and have developed a database where most of the tables are linked. The performance is very slow for the main report I generate in this database. I think I need to create indexes. How do I do this? Or, if anyone has any other suggestions that will help the performance I...

I am using Access 2007 and having trouble getting a running total in a query. Here is the basic data coming from a table called tblLabourHours2 ID (autonumber generated) Formatted Cost Code TransDate Hours My goal is to get a running total of hours for each cost code. A cost code may have...

I am using Access 2007. I would like help creating a query (queries?) that would give me cummulative/running totals for each cost code. Here is some sample data, Cost Code A; October 10/12; 100.0 Cost Code A; October 17/12; 87.0 Cost Code A; October 24/12; 55.0 Cost Code B; October 17/12...