I have set up an ftp server and would like to know how i can automatically send certain data from my .mdb file (on an hourly basis) so I can log into...

Hello, As our staff tab through a screen while doing entry I would like the fields to be highlighted or coloured so that they can see which field they are...

Dear all, I know how to export the query data to excel using file dialog. How can I do to import the excel file "excelfile.xls" of "sheet1" to access file...

I inherited an Access Database and am trying to create a pivot table from a query. In the Pivot Table, a Lookup field (The lookup table itself has 3 fields,...

Hi! In a main form I've placed a subform with a vertical scrollbar to view all the contents of the subform. The subform consists mainly of textfields, next to...

I have 5 tables with various filds. Using the Form Wizard I can select fields from up to 3 tables and create and display a single form with the selected fields...

This question is about Forms, There is an ID field which is self incrementing field where the first umber is 0, the next one will automatically be 1, then 2,...

Im trying to create a data entry form with a subform. I use the wizard and evrything works fine. I created a commandbutton that closes the form. Again,...

I have a form that collects builder and site information. I have a command button which lets me go to another form to enter details of houses on these...

I am creating a form that pulls fields from a query. Whenever I make a change to the tables that the query is pulling from, the changes pass on to the query,...

I have a form that shows a volunteer's name and details, then the subform links to the time spent working. It shows the date, amount of time, and comments. I...

School Group form has a subform for Students. When I'm in the School Group form for Manhattan High School and I enter student names in the Students form the...

When the primary key is null and a record is being inserted I get this error: "Index or primary key cannot contain null values" I just want to change what the...

I would like to create a dialog box that pop up to ask user to provide start and end date to retreive records for viewing or printing?? Any help.

I am using Access 97 and need to create a simple form to calculate a date. I need to allow the user to enter an Effective Date and then I need to calculate a...

Hi - I have a form with several subforms, each of which has a combo box whose record source is a query with a parameter supplied by a value on another main...

I've read the posts for last year, but I'm still having a problem I can't identify. I have two tables: DeptID Description ------ ----------- 11 City...

Currently print a report based on whether a customer exceeds any one of nine different standards/criteria. A query does the selections and a customer could be...

When a form opens the first field in the tab stop order is highlighted. I want the user to conscious select a field so they do not inadvertently edit the...

Hi, I have a form showing fields of Departments and its Employees. A combo box is used to filter all records of the Department I select. Then I click a command...