Search results

I have a query that I have been using for several years without any issues, recently I have noticed that some records are missing (not sure if is something that I have done while making some adjustments) There are 2 tables "Completed_Jobs_Addressed" and "Payments" SELECT...

Hi All, I have a form that I enter item no's into. What I would like to achieve is to open another form when a particular item no is entered. GeoffK

Hi AllI have a DB which tracks my daily work that currently I am adding inventory control to this and have found that the "MS Access 2007 Inventory Management" template could be manipulated to suit my needs.In the current DB I have a table "JobCodeSubForm" that contains the following fields...

Hi All I have just purchased Office 2007 and I have a problem with queries & macros. How do I stop the warning messages from appearing every time I run a query or macro. Thanks in advance Geoffk

Hi All In my DB I have 2 tables "Customers" and "Job_Input" The "Customers" table is updated daily and each customers is identified by a JobNo. The "Customers" table is a contiuous form which displays todays customers, each customer has a command button ("Update"). The objectives are to: 1...

Hi All I am currently compiling an Access DB to manage my work in progress, Payments due etc. The DB is starting to work well and have requests from fellow contractors to purchase a copy (there are over 400 subcontractors in the group), with this in mind I have decided that when I complete the...

Hi All I have 2 tables "Customers" and "Work in Progress (WIP)" The "WIP" table is result of the form "WIP" where I input all my data for each job completed. I use a lookup control "JobNo" to input the customer details from the table "Customers". The objective is to call up the customer...

Hi All I am seeking the solution to a problem with calculating stock adjustments We use a job code which comprises several stock items and labour which = a $ value I have a form "work in progress" where I enter all the job details including the job code, the aim is to reduce the individual...

Hi All I enter data in a form "WIP" that is based on a table named "WIP" in the form I have a command button. When I activate the command button it takes me into another form "Materials" which is based on a table named "Materials". The data that I enter into "Materials" is not linked to the...

I have used this code which was submitted by Anthony George to open an Exel worksheet Private Sub Command16_Click() On Error GoTo Err_Command16_Click 'Dimension the Variables Dim xlApp As Excel.Application Dim xlWkbk As Excel.Workbook Dim xlSht As Excel.Worksheet 'Set the application Set...

Hi All I import data from exel 2000 into access 2000 how can I remove duplicate and unwanted data (ie Blank rows) I recieve my daily work via an e-mailed exel spreadsheat which is then transposed before being exported to access. I have allowed for upto 12 customers per day in my transpose...