Recent content by HomeALone

The thing that you try to achieve is easy with Access, but will take time to put them all together. Try this website for tutorial, and come back for more questions! http://www.fgcu.edu/support/office2000/access/ good luck!

The shift bypass method that you used is DAO method. I would check whether Access 2003 still have DAO 3.6 for you to select in your references. If No, that tells you why all your DAO methods won't work! Then your option would be re-writing you shift bypass module. I've been use this one from...

Put this code into the command button DoCmd.RunCommand acCmdOutputToExcel Hope it works for you!

I like the idea of using the Title to identify the person. My approach would change the tblCoach to become tblPersonnel, The title will identify the position/function of the person. Just in case you need to add a cheerleader or an intern in the future, you would not need to create another table...

In your reset button, try to make the text invisible first , then do your other reset and make it visible again! Me!TextBox.Visible = False other reset codes. . . Me!TextBox.Invisible = True

For those who don't want to teast the user with the message box to tell her/him to click the appropriate button to exit, you can replace the msgbox code with codes below to click the Exit button for the user. here is the code I used to replace the message box. DoCmd.OpenForm...

In Access World, you can store scanned files internally using the OLE object, or just store the link using text field with hyperlink enabled. The scanned file can be retrieved by one click in this format. The hyperlink choice is a preferred way because it requires less storage space on your...

Actually, the error code for ADO is -2147217911, not 3033, so the code should be CmdChange_err: If Err.Number = -2147217911 Then MsgBox "You have entered the wrong old password, please try again! ", vbOKOnly, "Wrong Password" Me.txtOldPassword =...

I recently use this ADO example code to allow user change their password. http://support.microsoft.com/?kbid=304319 In addition, my error handler does this when it encounter error 3033, make sure you don't On error goto CmdChange_err codes. . . CmdChange_err: If Err.Number = 3033 Then...

Norris68 Thanks for answering yourself! I've learned a good lesson today and avoid waiting my time on it.

I tried dimming DAO.Workspaces before, I even narrowed it down to just have Microsoft DAO 3.6 library in the reference, and ran it in Northwind, I still got that error! What else should I try? or where else should I look? Thanks!

I got this sample function from Microsoft knowledge Base Article - 210331 http://support.microsoft.com/default.aspx?scid=kb;en-us;210331&Product=acc2000 I did exactly that and I got error 3029 which returns its custom message "The account used to create the workspace does not exist&quot...

The complete syntax for the openform method is DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs] The definition of each argument is defined in Microsfot helps file aas follow: formname A string expression that's the valid name of a form in...

Here are my answers for your questions in your second post. 1). You have to do this in a split database environment (FE/BE database). When you are ready to distribute your FE, make a copy of this FE, then disable the AllowByPassKeys function (see helps file for this function) to STOP...

Create an empty Menu bar and attach it to Tools/Startup/Menu Bar Search the help file for “Create a custom menu bar for the current Access database” if you need help on creating an empty menu bar.