Recent content by dpw

I want to run the query from a button on a form with more than 1 unbound combo boxes to provide the criteria. To get it to work for only 1 combo I used Is Null in the 'OR' row and I successfully obtained all records if the unbound combo box is empty and if data was selected, the results again...

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

Apologies to AlanS as when I pasted your alteration into the function I mistakenly deleted 'vDir='. Thanks very much for your help. D

I want to list the directory names

Dir[(pathname[, attributes])] is the syntax but being a novice at VBA this doesn't help me.

Changing it to 16 didn't work either

No joy Alan I replaced the code as you suggested but it simply turned red. Do I have to adjust my references? Thanks D

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

Sub Folder list to text Thanks a lot for all your help. I got the code to work (eventually) but I've got just one further query. Can you easily alter the code to obtain the names of sub-folders within a particular folder??? I used ghudson's function so how can it be adapted accordingly?

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

No success Changed the period to an exclaimation mark and it resulted in a compile error. Any other ideas?

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.