Search Result

Is there any way the table data in Mysql will be automatically updated from the Access database after exporting the first time?
My Access table is updated every hour. How can i synchronize the transfer of data between the two database?

Big Picture: I am trying to open 2 recordsets and test the results against a set of rules prior to loading data into my database. I have created this as a Sub attached to a command button on a form in my Access 2007 database.

Problem: My Recordsets are not opening. I am receiving a recordcount of -1 and a "Object Required" error when trying to verify the recordset loaded correctly. When I copy to SQL Statement to a query...

Greetings,
.
I have a WinXP sp3 machine running Access 2007. I have a report that would like to show a jpeg image of a building diagram for various customers. Each page shows a different customer, and would like to have their particular image showing the map layout of their building.
.
In the customer table I have an attachment field that allows me to specify the jpeg file for that customer. I have the report group by...

Is it possible to set the file permissions on an Access 2007 database file stored on a Windows file server to allow users to only write data TO an Access database, but not allow them to open the database file or read data from it?

I'm trying to find a mechanism to capture usage data from users who are using a local web application, but I don't want those users to be able to access the data.

The mechanism uses ActiveX...

Can anybody solve this problem?

ENVIRONMENT:
Application is built in MS Access 2007. Data are stored on SQL Server while users run compiled Access projects. User PCs run Windows XP and Windows 7 utilizing Access Runtime (no access installed on client PCs). Some reports use specific paper sizes and are printed from designated printers through printer server.

PROBLEM:
On developer's PC reports see non default...

Multiple rows based on a date range

I have an MSAccess 2007 DB to record our employees Personal Days Off (PDO). Until now I have only had a form to record each single day taken. This results in time consuming repetitive entry when an employee takes multiple consecutive days or weeks off.

My database consists of two tables:

• tbl_PDO (to hold the Worker, DateTakenOff and TimeTaken)
• tbl_Employees (containing the Employees

...

I am a new user to Access 2007. I have to design a report that uses date prompts.
My database has the following fields:
date, total, under 30, service level

I need to make a calculation on service level = under 30/total

with the following date ranges:
previous 2 months
previous 4 weeks where the week starts on Thursday and ends on Wednesday.

can someone help me?

Hey all,

I'm a little new to Access 2007 and need help coding filters in VBA.

Right now my report has 3 fields:
FirstName LastName Grade

In the header of my report are 1 checkbox for each grade (9 - 12).

I want to be able to display, for example, only students in Grade 12 when I click the "Grade 12" checkbox.

The ApplyFilter method won't work because, according...

In Access 2007 ADP connected to SQL Server Express, most forms allow Text Format attribute of Rich Text, but a few do not.
In each case the SQL Server table field connected to the Access Text Box is defined as varchar( MAX ). I see no differences between the sub forms where I'm setting the Text Format attribute to Rich Text and the sub forms where I get the error: "The setting you entered isn't valid for this property" when I try...

I have a client that has all their reports, data, and code in Access 2000...They also have a copy of Access 2007 that they want to copy or somehow trigger a report in access 2000 and email it to 150 employees since emailing in access 2007 is much easier and more robust than it was in access 2000.

Just in case this gets confusing, they are wanting to press a button in access 2007, which emails ReportA from access 2000. Let me know...

Hi everyone!
I have a form with 6 checkboxes (getting their values from a table/query)
When the form loads, I would like the buttons right of the checkboxes to "react" to the values in the chekcboxes.
For example: If "Value1" is 0, then disable "EDIT" button and enable "ADD" button Else enable "Edit" button and disable "ADD" button.
Here is a screenshot:
...

I have a form "PartsAndInvoic es that has all the parts in the database listed in split form view. I want the user to use Access 2007's filter section on the ribbon to choose mutiple filters. Me.Filter may equal ([Lookup_cboDNRCI D].[DNRCNUM]="dnr1940"). I tried pass ing me.filter to the report but get all the records in the report not the custom filtered set.
Private Sub cmdPartsNInvoic eReport_Click()
Dim strFilter...

When I designed my database, it was the first I had ever built and my knowledge was practically none. I designed it for use by around 20 people and to hold approximately 20,000 records. Be it a blessing or a curse, the demand for the usage of this database has grown inconceivably quickly. I now have 100 users (around 50 at a time) and hold over .5 million records. This number grows by approximately 20,000 ever day.

In light of this,...

I would like to place a command button on a form that would ask for a client id and then pull up that clients record. (Essentially, all it has to do is filter the [Client ID] field to whatever parameter the user enters.

I would think this pretty simple, but I'm afraid I don't know how to do it.

Any help would be greatly appreciated.

Thanks.

I currently have an access database that is a 2007 file that is operated through Access 2010. It has as many as fifty users on it at any given time. All of the user's workstations are set to lock edited records in their Access client settings. The problem is that it is routinely locking up still.

Some background: it is not a problem with more than one user accessing the same record. They are all divided to not allow this and when we...