Search results

Guys I really need your help, as this is doing my nut in !! Just to explain first - this is a stand alone home PC not connected to a network. I took the decision to move from Win98SE to XP, so reformatted my drive and installed XP no problem so far. Set up my email account in Outlook Express...

The following control source on a form field is designed to determine the age of a person: =DateDiff("yyyy",[Birthday],Date()) However, a person with say a birthday of 20/07/1944 (UK date format) who is currently 58 years old, returns an age of 59 due to the fact that the calculation of age is...

How can I stop a table displaying a blank new record? My problem is as follows: One of my tables contains the details of monthly expenses for team members, from which is driven a query and subsequently a form, which ultimately appears on my Contacts form, as a subform. With me so far? The...

I currently have a parameter qry which calls for the operator to enter the current month in order that the required records are returned, and am looking to automate the operation. What I need is for the qry to look at the 'system' month and return all entries between day one of the month and...

Hi, The following code selects a list of surveyors and a list of dates. What would be the next line of code to select just the oldest date per surveyor? SELECT [Current NBIs Grouped qry].Surveyor, [Current NBIs Grouped qry].[Allocation Date] FROM [Current NBIs Grouped qry] GROUP BY [Current...

Hi, With reference to query by form - could anyone please explain how the Tag property works as I cannot make sense of the help file in A97. The following line appears in the tag property of a qbf form I am using, I know the function works, in that the correct data is returned, however I am...

Below is the code from a qry in my database, which shows the work due per individual per month. However, what I need it to show is the totals grouped by month due. Example: The qry results currently display say 5 or 6 entries for Jul as the underlying data is the actual day a site is overdue...

The following code returns the data I need, but places the 'Totals' within the list. How can I force the code to place the Total at the end, ie after the last Z entry? Select Targets.Surveyor, Targets.[2002 Target], Targets.SS, Targets.MAP, Targets OOA From Targets Order by Targets.Surveyor...

Hi guys, In A2K. I have created 2 columns on a report set the page to landscape inserted page breaks and displayed the data in recordsets absoulutly fine. Left column shows header details with the records listed below, right column shows just the records without headers. I have tried...

Hi guys, I am not sure where to start on this one but here goes: Current Situation: I have perameter qry which requires me to enter both and Engineers Name and a postcode. Once the data is displayed I run the REPLACE function and change the ownership of the postcode to another engineer where...

Hi guys, I have a table, in which is stored the names of my team members, location of work to be done, date work due, and a numeric value relating to the amount of work outstanding. I have created qrys which select the team members and the work they have outstanding by setting criteria such as...

I have a table which contains a field called IU value which contains information about outstanding work for a given site. The field is a numeric value ranging from 1 to 20. I run a qry from the table which display the data correctly in a subform. What I want to display is a stand alone field on...

Is is possible to create a macro which runs the Get External Data function. What I want to do is create a macro which runs off a command button which does the following: Deletes the contents of a table Opens Excel (to a specific file location) Imports the data into the existing table Runs a...

OK, so now that I have grouped records together successfully within a qry and displayed them in datasheet format in a form (which looks superb), why is it that if I attempt to delete a grouped record from the form I get an error saying 'cannot delete record - read only' although the field...

I know there must be a simple solution to this, but I have been pulling out what little hair I have left for two days now. I am fairly new to databases so please be gentle with me !! Problem: I have a qry which runs fine against a table and shows all the entries (around 1000 rows of data)...