Search results for query: *

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

I have a form that has a combo box that contains items and a multi-select list box that contains values. The multi-select list box is populated based on the item that is selected in the combo box. What I want to happen is once the user selects an item from the combo box, if that item already...

This code below inserts a new record into a table for every item that is selected in the list box. The code is attached to a command button. Also make your second listbox a bound field to the table. 'Counts the number of rows selected in the list box For i = 0 To Me.lstItemValue.ListCount - 1...

I was able to figure out another solution to this problem without using the message box. I placed the following code on the OnCurrent property of the form. Private Sub Form_Current() Dim strState As String Dim strEvent As String Dim varYear As Variant Dim strFinal As String strState =...

Thanks for the response. I'm still having the same issue with DCount that I'm having with DLookup. The form that I'm using has buttons that allows the user to scroll through the records. When I click on the first record where the Final File checkbox is not checked and I try to check it I...

On the OnClick event of a checkbox I have the following code: Dim strState As String Dim strEvent As String Dim varYear As Variant Dim strFinal As String strState = Forms!frmLogCriteria!cboState strEvent = Forms!frmLogCriteria!cboEvent varYear = Forms!frmLogCriteria!cboYear If (Not...