Search results

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

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

Hi Can any one help me with a quickey. I have a form which shows short details of a building ie name town postcode etc. I have another form with 3 subforms to be able to enter new details of a building, the new client and the new agreement. This works well and is feeding the new data into the...

Hi All I need to be able to do a count before and after the current date. My table has fields named month and year and I need to find the count before and after the current month. Any help would be much appreciated. ChrisD

Hi All I have a main form which displays some basic info aboute a site. I would like to be able to place multiple buttons down the right side of the form. This would be similar to having a seperate column which is not affected by the number of records on show. I have considered placing them in...

Hi All Is it possible to display two result in one field. In essence i have a table of tasks with a due date. I would like to display a count in red of overdue tasks in reference to the current date and a count in green of the tasks which are after the current date. The date is based on month...

Hi All Can someone help me with opening a form from another form using the OnDblClick event and to open the form using the data in the record to open it at the same record. ie Site Name = CP House so the form opens with CP House data showing, Site Name = St James so the form opens with St James...

Hi All I posted this earlier but don't think I explained it that well, so here goes. I have a main form which displays a site name, city, post code. I have 6 tabbed subforms which display a full record set of site name, address, contacts and telephone numbers for a client, site and other...

Hi All Its late:( and I'm probably missing the obvious:mad: . I have a Main form with a number of tabbed subforms. I want the main form to show a list of records entered that the user can scroll through. When I change it to continuous forms it give a message saying it cant be changed as it...

Hi All I am building an app in access xp and the client has a set of excel spreadsheets which contain a text identifier for a time period, (ie w=weekly, m=monthly, q=quarterly etc). I know the contract start date and I need to convert this text identifier into a date. The contract start date is...