Search results

  1. A

    Problem with Exporting report to Excel file

    Hi, Everyone: I have a table with 35554 records. I am exporting those records to Excel file. It allow user to choose the location to save the file, the code like following: DoCmd.OutputTo acTable, "Output Extract Data", "MicrosoftExcelBiff8(*.xls)", "", False, "", 0 It works before when it...
  2. A

    Help needed

    I have a multiple user access database on share drive with user-security level created. I created myself as administrator, and remove default Admin from Admin group. Removed permission from user group and joined workgroup file which I created as "MBS work group.mdw". I created shortcut on user's...
  3. A

    Text Box with #Error, How can I get ride of it.

    Friends: I have Two control Boxes(Field1 and Field2). Field1 text Box wit expression Look at Database table field using Dlookup() function, Field1 expression like this: =NZ(DLookUp("[up_rt_cp_only_flag]","[SubType2]","[SubType2].[Single_Name] ='" & [TextRDW39R] & "'")) Field2 text box...
  4. A

    PivotChart report

    I have a report with an embedded PivotChart. When I export this report, the PivotChart can’t display in MS word file. How should I do to export a report with a PivotChart to MS word file format? Thanks
  5. A

    Please help Error message "Method or member not found"

    I have two similar forms with similar controls. I copy 20 pieces of controls to another forms certain tab. When I run code to update database table using the control box value, access can’t find the control box. I got this errors message. Do you guys know why I got this error? Thanks
  6. A

    how to save Data value for each field entry on a bounded form

    How to setup MS Access database to let the system automatically save Data value for each individual field entry on a bounded form? I have a table call “Employee” with employee ID, Employee first name, and employee last name. Have a form bounded on this table. I want the data in the table...
Back
Top Bottom