Search results

I have a parameter query based on an unbound field on a form. If I open the form and run the query from the form with no value in the field it doesn’t return any records. But if I open the query with that particular form closed (and enter nothing in the parameter box which appears) it returns...

I'm attempting to create a button to allow users to edit records in a form when clicked in order to prevent them from accidentally changing data. I've used the code below (posted in this forum) but the records of a subform for a new record have disappeared. Where I'm I going wrong. Thanks If...

I'm attempting to plot monthly statistics on a bar chart (in a form) for data over the past 3 years. I would like to compare the data for each month. i.e. Jan 2000, Jan 2001, Jan 2002 'bars' next to each other and NOT Jan '00, Feb '00 etc through to Nov '02, Dec '02 as I keep getting...

I was attempting to obtain names of files and place them as text into a database. I succeeded by using Ghudson's function (code below) but can you alter the code to obtain the names of folders within a particular folder??? Public Function ListFiles() On Error GoTo Err_ListFiles Dim...

I have a button on a form with the following code behind it :'FollowHyperlink ("G:\123\Jim\Procedure.doc")'. It links the form to a Word document but when I shut that document I have 2 problems. The main one is a discolouration of the controls on the form. I have to shut the form down to...

I'm attempting to obtain names of files and place them as text into a database using the code below (posted in this forum previously). A problem arises at the last line of code when the following error appears highlighting 'RowSource' : Compile error: Method or data member not found Is it...

Is it possible to loop through the values of a field in a query and if the value of the field is eg. > 100, alert the user. Any help would be greatly appreciated.

I have 2 columns in a report which has one small problem. When the data of a grouped section overflows onto the next page the data starts in the second column, not the first.

I would like to copy the contents of a field to the same field in the next record regardless of which record has been edited. E.g. If I change the ‘Customer Number’ field of Record 3 to 78 I want the ‘Customer Number’ of Record 4 to change to 78 and the focus set back onto Record 3. I’ve...

The problem occurs when I attempt to group the following data on date (Group on: Day). As you can see below the value for midnight on 22/1/2000 has been grouped under 21/1/2000. Date ID 21 January 2000 22:00 1400 21 January 2000 10:00 1388 21 January 2000 21:00 1399 22 January 2000 00:00 1402...

I'm experiencing difficulties sorting a field with a date/time value. The value for midnight falls on the previous day's grouping. Any ideas are welcomed

I require a form which permits the user to input text as well as numbers into the same field of different records. I then need to perform calculations on this field – but I’m not sure whether Access ’97 permits this due to data type rules. I’d be grateful for any help on this matter.

Having succeeded in creating a form which automatically fills in point-in-time data from another form, I embedded it as a subform. Now I have a problem with linking the subform to the main form as I've had to create a many-to-one relationship from the main form (the many side) to the one side...