Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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