Recent content by AccessHope

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

Thank you for your comments to help me on that. For sure, that I joined this customized work group file before I do something else, and put this database and work group file on share drive. :( I don't know why. It looks didn't use this work group file when open the database from other users...

Hi, Banana: Thank you for your response. From your pervious comments, I thought it maybe the database owner (it was Admin) caused this problem. So, I removed default admin from admins groups, gave no rights to default admin. I logged in as myself (in Admins group), I recreated the database, and...

Hi, Banana: I followed your idea, I recreated the database after created myself as admin and removed default admin from admins group. I checked the database owner changed to my name instead of default Admin. The Login screen asking for user name and password only pop up on my local screen, when...

Hi, thank you “The Doc Man”. I think I did exactly what you have explained. I created myself as administrator, assign a password to default Admin and removed default Admin user from Admins group. I took off all the privilege from Users. I did exactly what you have said. I just don’t know why the...

Thank you Banana for your advice. I have a work group file call MBS.mdw. This database is joined on this workgroup file. is this correct? Do I need to join the workgroup file since I didn't modify the default work group file? I gave a password for Admin user and remove Admin user from Admins...

Database security Why, other user still uses their default system.mdw file when they double click this database on share drive. I joined the MDB.mdw work group file to this database. It works fine when user open database through the shortcut, but when they double click it, they can get in...

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

Hi, FoFa: Thank you so much for your replay. Yes, I tried followed your suggestion, still got error. the problem is when the form is loading, those control box every time load those text box with different order. I noticed, for example: if Field2 load before Field1, It show #error in Field2...

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

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

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

Thank you for your response, because this form is “collection screen”. Avoid confusion, I want user only be able to see the current record without see others. I tried the link you provided at “Another mousewheel solution”. The code doesn’t work for me. I am trying to disable the form_MouseWheel...

How to prevent the Cursor move to next record? Hi, ghudson: I saw you name a lot on this Access forum. I really appreciated for you sharing your MA Access knowledge. I just wondered base on the comments “Change the forms ‘Cycle’ property to Current Record to prevent the user from jumping to...

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