Recent content by Geoffk

Thank you all for your replies I have found the problem. I import the data from an Excel spreadsheet after it is sorted by an Excel macro, during the sorting it was randomly adding an Ascii character to the "Payments.Job_No" field Thanks again for your valuable comments. Geoff

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...

John Big Booty Thanks for your reply, I have tried every combiation to your code but cannot get it to work. If ItemID.Value = 61327 Then Me!UsageSubForm.Form.Visible = True End If On the main form is 2 SubForms "ItemsSubForm" and "UsageSubForm" The control "ItemID" is in a subform...

Thanks John Big Booty and Speakers 86 for your replies, Speakers 86 I have tried code and it works ok, I have tried to modify it to open a subform that is visible=false basing my modification on: if controlnamehere.value=x then Me.controlnamehere.Visible = True Else...

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

Rabbie Thanks for the reply Each customer is an individual job and never duplicated Geoffk

ajetrumpet Thank you for your reply, I have tried but still cannot get this to work. I am not very experienced with code, could you please point me in the right direction Thanks again 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...

Thanks for your replies The customer details in the customer table is only used once it then becomes redundant, (the basis for this DB is to track materials used and payments due, after the details are entered ie: JobCode, COD collected inventory used, the customer details are not required)...

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...

Thanks MicroE I give it a go Geoffk