Search results for query: *

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

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

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

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

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

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

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

Hi, all! I hope one of you can help me. I am trying to sort by a field [Budgetot]from a Dialog Box VBA to a form. It will sort in ascending order. However, I have tried all kinds of ways and I can't get it to sort in Descending Order. I thought that I just needed to add the string "DESC"...

Hi, all! Thanks for helping me out. I am racking my brain as to why I am getting a Run-Time Error '424' - Object Required. See code below. The highlighted text is where the error occurs. I want to make a bound textbox in a form invisible depending on the contents of a textbox in a dialog...

Good Afternoon! I am getting a runtime error (Syntax/missing operator) when I execute the following statement: DoCmd.OpenForm " FRM_3_8_2007_Budget_Form ", acNormal, acEdit, StrWhere It compiles fine. I have a dialog box in which users can enter one of several filtering fields. If the user...

Hi, all! I know this is probably pretty simple. However, all of a sudden when I create a new form and add a page header to it, the page header will not display. Its probably some control that I turned off by mistake, but I don't know what. Please help! Thanks! Jim.

Hi, all! I'm using a public variable (declared in a standard module)to pass a value from a form to a report using Print Preview Command Button. The variable is not recognized in my private subroutine. How do I pass a value from a form textbox to a report textbox? Thanks for any help!

Hi, all! Could you help me? I have a dialog box that I use to develop a filter for another form. When I open the form, I want to print a report based on the form. I can set the filter of the form to the report and it works. However, when I try to set the form's textbox (unbound) to the...

Hi, all! I have a vba sub that is attached to the ok button on a Dialog box. The info in the dialog box is used to filter another form when it is opened. Now, I want to print a report from the newly opened form based on the filter information in the dialog box. I need to keep the form open...

Hi, I am trying to use sql "order by" in vba. I get a syntax error. Can anyone help? strWhere = strWhere & " ORDER BY [RADue] ". Thanks for any help!! Code section: Select Case Me.RptType Case 1 'For Case Ovrdue Rpts in dialogue Box, find all dates for RADue <31 days...

Hi, I am trying to filter a form from a dialog box. In using DateAdd, I could not get vba to understand that I have an SQL statement and the DataAdd Function i.e. DateAdd("d",30,[RADue]). It got confused with the quotes. So I tried to create a variable called 'DateCheck'. I then equated it with...

Hi, I hope someone can straighten me out (and my code)! I've looked at several books and each book shows me a different method to write SQL in VBA. I am very confused. There must be a simple, understandable method to develop a "where" clause for filtering a form using a dialogue box. I think I...

Good Evening! I am trying to format a form through VBA. I am getting a compile error "Compile Error: Case without Select Case". I can't find the problem. I have pasted the code below. I am VBA Tenderfoot, so it probably is a simple mistake. Thanks for your help! Private Sub...

Hi, all! I have not been able to locate any detailed liturature on Access Security. My challenge is this: There will be 30 or 40 users for the Access Database. The Data will reside on a Citrix Server while the Front end will reside on each user's machine. Each user is responsible for...