Search results

to check for a table you need to checkt he tabledef collection for the table.

try this strStartSql2 = "WHERE (((qryVisitListVBA2.supervisor) Like ' * " & [Forms]![frmSupervisor]![Search3] & " * '));"

sound like you need to group on division and acct

You need to set a reference to the Microsoft Scripting Runtime

Here is a link to info regarding the FileSystemObject. http://www.techbookreport.com/tutorials/fso1.html

Also you can use the FileSystemObject to retrieve all files in a folder.

You will need to build a custom form with a listbox in which the user can select the files.

I don't see what your question is?

Why can't you open up the VBE when the form is is design view?

What error are you getting? Maybe try putting the query name in brackets [query]

Check out the FileSysteObject class. You have much more flexiablilty creating and working with directories using this class.

You can use user level security to create user groups to limit access

What do you mean by warning system? What do you want to happen? Maybe a message to pop up when the user open the db?

It sounds to me that you have a flaw in your db design. But not sure because I havn't seen your table structure. Are you saying "on" and "fd" are in the same field? You could use "ON" or "FD" in the criteria

It depends, we don't really have enought info. But with the info we have I would guess you should have more than one table. Read up on database normalization.

Let say textboxA contaims fieldA data and textb contains fieldb if textboxA="Regulatory" then docmd.openform "FormA" elseif textboxA="non-Regulatory" then docmd.openform "formB End if

there is one posted below. I have not looked at it though. http://www.access-programmers.co.uk/forums/showthread.php?t=151480&highlight=survey+sample

try usercombo.value

You can use the Redemption .dll

Just use the combobox name instead of the text box name. For the security... goto Tools securtiy and you should see some options. Unless you are using Access 2007. For some reason MS disabled User level security in 2007.