Recent content by chrisd49

Hi All I have a button which 'Opens@ a form based on a query. The first time I open the form this way all is OK and I can see all the records. If I close and try to reopen the form using the button I get an error message 'the table is already opened exclusively by another user, or is already...

Hi Gary Thanks for the input but I think I may not be explaining this to well. I have a form for task entry. On this form is a drop down list which enables me to pick if the task is a recurring one at he intervals specified. I want to generate a list of dates for the task, including the entered...

Hi All I have a form which allows for a subcontractor to be allocated new tasks. Most of these tasks are repeating, ie weekly, monthly, quarterly, half yearly and annual. Try as I might I can't get my head round how to do this. On the form I have a drop down list and I would like to be able to...

Hi All It's now nearly 4 years for me reading this post and the answers given have helped me with exactly the same problem, so I for one am grateful for any advice which helps. And it was the title of the post that made me look. I would like to thank whoever helped Elloydtke401 with his post...

Hi Wiz47 Thanks very much for your help on this. I've looked at what you suggest and have finally managed to incorporate it into my DB. It works a treat and my client is happy, so I'm happy and the wife's happy (I'm still getting paid). ChrisD

Whats wrong with my Code I have attached my DB incase anyone wants to have a look and see whats wrong ChrisD

Hi All I have now changed my form so I only have a main form but with the same fields as before. These fields are all generated from a query to display all the records for an over view of the sites in the tables. I have also changed the code slightly but now I get an error message when I double...

Hi Whatever Thanks for the suggestion but I've added your suggestion and I still get the same result. Every contract number only brings up the first site record. Thanks Chrisd

Hi All I have some code which allows me to click on a contract no and then display the details for that no. It works perfectly for the first number but displays the first nuber details for all subsequent numbers. Here is the code I'm using Private Sub ContractNo_DblClick(Cancel As Integer) On...

Hi Lagbolt Your absolutely right, I didn't read your reply thoroughly enough and it now all works well. Thanks for your time. Obviously in my case less speed more progress. ChrisD

Hi Lagbolt I think I may not have explained the problem to well. I need to show all the records for SiteID in the query qrySiteView. Where there are no records in the two queries, qryVisitDue and qryVisitOverDue, it doesn't return an entry. The query qrySiteView gets data from the table tblSites...

Hi All I have a feeling that this is an absolute newbie question. I have three queries, qryVisitsDue, qryVisitsOverDue, qrySiteView. The query qrySiteView uses SiteID to produce a listing of all sites which includes a count of visits for those sites. If there is no visit data the site does not...

Hi All I have a main form, frmOverview, which displays a list of current sites. On this form is a button which allows a user to enter a New Site with its Agreement. On this form, frmNewSite, is a drop down list of the current Clients. When the client is selected I need to be able to pass the...

Date Problems Hi FoFa The date is held in two seperate fields which are populated by lookups from two seperate tables. Should I use a different method to get Month Year data? Would this make it easier to use the DateDiff function? And now that you mentioned it no the recurring tasks are not...

Hi All I am having problems with querying and displaying dates. My first problem... I have a table named Tasks which has a date entered by two drop down lists for Month and Year. I need to be able to count the number of tasks that fall either before or after the current date, ie they are either...