Recent content by EMoore12

I actually found it on the File tab on the ribbon and not the Home tab as I mentioned previously. I am provided with three options on the Home tab: Compact & Repair, Manage Users & Permissions, and Set Database Password. Manage Users & Permissions gives you the access to the User-Level...

I found it. If you click on the Home tab on the ribbon, the option is available for the user level security.

Thanks for the response. The databases were originally created in Access 2003. I had no trouble when my company switched to Access 2007. All the objects are still secure, but I can't change any permissions or add new users. Thanks.

Greetings, I have read many articles about user-level security no longer being supported in Access 2010. These same articles state that as long as I don't change the file format of my existing database from .mdb to a newer version that I should still be able to update the security information...

Updated code. Sub CheckFolder(objCurrentFolder,objLogFile,State,Yr,Evt,Ship, Header) Const adBSTR = 8 Const adDBDate = 133 Const MaxCharacters = 255 Set DataList = CreateObject("ADOR.Recordset") With DataList Set .ActiveConnection=Nothing .CursorLocation...

Sorry. I emlinated some of the code to try and shorten it. Sub CheckFolder(objCurrentFolder,objLogFile,State,Yr,Evt,Ship, Header) Const adBSTR = 8 Const adDBDate = 133 Const MaxCharacters = 255 Set DataList = CreateObject("ADOR.Recordset") With DataList Set .ActiveConnection=Nothing...

I'm also interested in learning how to sort a file by the creation date using vbscript. I've been reading about the disconnected recordset and can't get it to work with my vbscript. Here is a sample of my code: Sub CheckFolder(objCurrentFolder,objLogFile,State,Yr,Evt,Ship, Header) Const...

Thanks tsuji. Your suggestion worked.

I have code that loops through a directory and outputs files to a .htm page based on a search criteria that the user enters. I would like to have one heading on the page but everytime it loops through the directory it adds another header. I'm trying to determine a way for the code to detect if...

Thanks tsuji for the post. I made the changes and I'm still not receiving the expected results. I'm receiving a page not found error and the link ends in something I don't recognize (/_derived/nortbots.htm). Do you have any other suggestions. Thanks for your help. ...ecm

Hello, I have a form located on a .htm page where someone can select a state. What I need to happen is once the user selects the state and clicks the Submit button, the code should search the specified network location for the existence of that state's document. If the document is found, then...

Thanks PHV! That worked like a charm. ...ecm

Hello, This is my first attempt at writing something in VBScript. I have some code that searches a location on the network and outputs all files ending with a certain extension. The output is written to a .htm file. What I would like to happen is for the output to contain links to the...

I downloaded your sample report and read over the instructions but I still had trouble understanding how to make it work. My headings are not dates. The headings are State Qtr 1, Qtr 2, Qtr3, Qtr 4, Payment 1, Payment 2, etc. The query sorts the headings alphabetically and I want the headings...

I've created a dynamic crosstab report based off a crosstab query. I needed to sort the columns in a certain order and not alphabetically. In the query, I've prefixed a two-digit number before each column name to make the columns sort numerically. I've added additional code to the report to...