Search results for query: *

You have to open the record by using .edit, write the data, then update the record with .update. I'd do it something like this: dim x as boolean Do While rst.EOF=False If rst.Fields(1) = DatePart("m", Date) Then x=True else x=false end if rst.edit...

Oops, code in prior message: dim str as string, strSQL as string GetParameter(1) = str strSQL = "SELECT * FROM " & str currentdb.execute(strSQL) SHOULD BE: str=GetParameter(1) strSQL = "SELECT * FROM " & str currentdb.execute(strSQL)

Try something like this: dim str as string, strSQL as string GetParameter(1) = str strSQL = "SELECT * FROM " & str currentdb.execute(strSQL) '(Or whatever you need to do with strSQL)

There may be an easier way to fetch a filename, as this code has been around for awhile. It works fine though. This will bring up an "Open File" dialog box. You can set the default drive and path it will open up to, the extensions to view, and return the drive, path and filename...

This is an ancient thread by forum standards, but I have a client running Access97 in need of a simple DataGrid control, and came upon this post. I've been searching for a couple of weeks now. Did you ever come up with anything?

Here's my challenge: Display a subset of data in a subform, in DataSheet format (so header-widths can be adjusted & used to sort columns with), based on a value entered into a textbox on the Master form. Unfortunately it has to be done in Access97. What I've done so far: From a Master form I...