Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EMoore12

    MS Access User Level Security Not Available in Access 2010

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

    MS Access User Level Security Not Available in Access 2010

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

    MS Access User Level Security Not Available in Access 2010

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

    MS Access User Level Security Not Available in Access 2010

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

    How to sort colFiles by date motified?

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

    How to sort colFiles by date motified?

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

    How to sort colFiles by date motified?

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

    VBScript Code Producing Multiple Headings

    Thanks tsuji. Your suggestion worked.
  9. EMoore12

    VBScript Code Producing Multiple Headings

    ..."T" Then EvtName = "Medical" End If strOutput1 = "<h3><center>Search Results for" & Chr(32) & GetState & Chr(32) & GetYr & Chr(32) & "*" & _ Chr(32) & EvtName & "</center></h3>" objLogFile.writeline strOutput1 For Each objFile In objCurrentFolder.Files...
  10. EMoore12

    Using Entries in Form for Search

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

    Using Entries in Form for Search

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

    Creating Links to VBScript Output

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

    Creating Links to VBScript Output

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

    Microsoft Jet Database Engine Does Not Recognize &quot; ...

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

    Microsoft Jet Database Engine Does Not Recognize &quot; ...

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

    Returning Values From Table to ListBox

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

    Unbound listbox to table

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

    DLookup on CheckBox Not Working

    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 =...
  19. EMoore12

    DLookup on CheckBox Not Working

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

    DLookup on CheckBox Not Working

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

Part and Inventory Search

Back
Top