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 Rhinorhino 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: *

  • Users: 0212
  • Order by date
  1. 0212

    ExportXML WhereCondition does not work

    Thank you, CautionMP!! Do you have any suggestions on any references on SQL/VBA Punctuation and Concantenation? Thanks! Jim
  2. 0212

    ExportXML WhereCondition does not work

    Hello! I am having trouble exporting a specific record to XML. I would like to pass the Assignment No. from an open form to the report so that I filter and export only one record. I start with a Dialogue Box and enter an assignment no. I attached code to the dialogue OK Button that passes...
  3. 0212

    ExportXML using WhereCondition does not work

    Hello! I am having trouble exporting a specific record to XML. I would like to pass the Assignment No. from an open form to the report so that I filter and export only one record. I start with a Dialogue Box and enter an assignment no. I attached code to the dialogue OK Button that passes...
  4. 0212

    Import Spreadsheet with variable name

    Thank you, pwise!!!!! It works. I really appreciate it!!
  5. 0212

    Import Spreadsheet with variable name

    Thanks, again, HaworthBantam! However, now I get the follwoing error message in the following Line: "The microsoft Jet Database Engine could not find object 'C:\...dlgOpn.XLS' (Runtime error '3011')" DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _ "Assignment Check", "dlgOpen"...
  6. 0212

    Import Spreadsheet with variable name

    Thanks, HayworthBantam! However, I used the following code from Help and received the following error message: "Compile Error: User-defined type not defined" Any ideas? This refers to "Dim dlgOpen As FileDialog". Thanks Private Sub Command3_Click() Dim dlgOpen As FileDialog Set dlgOpen =...
  7. 0212

    Import Spreadsheet with variable name

    Hi, all! I have a form with three command buttons. The second two preview reports. The first will automatically import a spreadsheet to Access and append to a table. My problem is how do I make the file name in the TransferSpreadsheet Method variable? I would like the system to request a...
  8. 0212

    Error When Total Report

    Thank you, Remou and dhookum!! I put the text box in the report footer. I am still learning Access's quirks. Take care!
  9. 0212

    Error When Total Report

    Thanks, for your responses! Remou, the form remains open since the report obtains info from the form's fields. dhookom, I put the textbox w/formula in the page footer. BudgTot is a numeric field placed in the report's record source. I know it's a bit complicated - I hope the solution is...
  10. 0212

    Error When Total Report

    Hi, all! Hope you can help! I tried to total a column in my report and I received "#error" in the textbox. I used =Sum([BudgTot]) in a textbox in the footer of the report. I did the exact thing to total a form (form and report look exactly the same) and it worked beautifully. The report...
  11. 0212

    Minimize Access Window

    PHV and IGPCS, thank you for your very rapid response. I may be getting closer. IGPCS, unfortunately, I think docmd.minimize will only work for the form in the active window (I need to minimize the application, then restore it so users can access other apps). PHV, I can minimize access...
  12. 0212

    Minimize Access Window

    PHV, thank you for your suggestion. I think I must have forgotton something, because nothing happens when I click the command button on one of my open forms. Please see the code below: Private Sub Command112_Click() 'Maximize Access Application DoCmd.RunCommand acCmdAppMinimize End Sub...
  13. 0212

    Minimize Access Window

    Hi, folks! I have maximized all my form windows and have unchecked all startup items so that each form takes up the entire screen for security. However, users would like to be able to minimize the access application window to look at other applications. How do I do this? I can minimize...
  14. 0212

    Append table with data from a form

    Thanks, again, PHV! I really appreciate you help!! Jim.
  15. 0212

    Append table with data from a form

    Hi, all! Hopefully, you can help. I want to automatically insert information into several tables from a form. I want the records appended after I create a new record. I have developed the following code: Private Sub Form_AfterInsert() Dim mySQL As String mySQL = "Insert INTO Policy...
  16. 0212

    Pass Not Null value to Query

    PHV, thanks again! I thought about the 'Like' but didn't think about putting it in the query criteria! I really appreciate your help! Jim.
  17. 0212

    Pass Not Null value to Query

    Hi, all! I have a dialog box with which users type in userid and password. I check for valid info and then open a menu form. I have several forms where I have query based Comboboxes. The queries are parameter queries that take the userid input by the user to filter records. Only records that...
  18. 0212

    Compare Query Results to Dialog Box Input

    PHV, thank you! I can't seem to understand the punctuation. Do you know any resources that may help? Thanks again! Jim.
  19. 0212

    Compare Query Results to Dialog Box Input

    Thanks, PMV, for you suggestions. However, now I cannot get the Dlookup function to work properly using input from the dialog box. It seems to ignore the variable. The below code results in Null for any input of Me.User_ID. Can you or anyone else help? Thanks! Private Sub OK_Click() Dim...
  20. 0212

    Compare Query Results to Dialog Box Input

    Hi, all! I have a dialog box where the user inputs a username and password. Then I attach code to the OK Command Button (See Below). I also have a table with valid Usernames and passwords. Finally, I created a query that I pass the dialog box parameters to to check if the username and...

Part and Inventory Search

Back
Top