Search results for query: *

Hi Guys, Thanks for all the advice (learning more about vba by reading your posts than at uni!) I've found this database which suits my purposes pretty well, with a bit of modification to the forms and the class module, it works well. http://www.mvps.org/access/modules/mdl0013.htm I've added...

Ok have set up the references, it's bought up an error: sub or function not defined: strTbl = "tblSpecWorksRS_" + GetEV("USERNAME") it seemed not to like the GetEV function. Is this one of functions that needs comments / changing to suit the computing environment? Please...

I've tried the code (was well written and easy to understand which is always good!) Access threw up a the following error: "user defined type not defined" that was referring to the line where the recordset is declared: Dim rstQuery As Recordset Dim strFyle As...

Dim strSQL As String strSQL = "supplier = "&Me!Combo95 And _ &"code = "&Me!combo98 DoCmd.ApplyFilter where condition := strSQL

That would be a good solution, but it uses ado...unfortunately this database is using dao and forms bound to the data by access - not my work btw :o( If I used the dialog box code provided by Bill (see above), how can I get the module to set the target path of the dialog box to be the same as...

Er, some good ideas there but... This form is used to display a collection of photos related to the various records in the database. One set of photos per record. The photos associated with a specific record are stored together in a directory. Each set of photos is stored in a different...

I'm working on an access database using access 97. I want to be able to display a list of files contained within a directory inside a list box. I already have a variable within the form that holds the path that I want to look in, this is stored within the database and is different for each...