Search results

When testing with the above I'm getting the debugger highlighting the On Error... line of the code and saying "Compile Error: Label not defined"

I created a simple form with 2 textboxes and the command button with this code. One textbox named "OldPassword" and another named "NewPassword". I have Microsoft DAO 3.6 Object Library selected in VB.

Dave, I am getting an error with that code when I try to run it. It is highlighting ".OldPassword" and says "Compile Error: Method or data member not found" Here is the code I entered: Private Sub ChangePass_Click() Dim usr As User Dim wrk As Workspace Set wrk = DBEngine.Workspaces(0) Set...

I have been working with the Users and Groups security permissions on my database, and I wanted to offer an option on my switchboard for the user to change their password if they wanted. I was thinking a button that ran a macro to bring up the password change form...but I cant figure out how...

Ok Thank you all, I'll try these out. And no, they only have access to the table via a form, not direct table access.

Hey everyone, I have a database that users use monthly for some financial reporting, I'm trying to prevent users who use the database from going back and editing data for previous months. (Ex: going back to January to edit data when it is March) The database is based off of 1 table. I was...

Ha I just figured it out... something interesting to note: I had an extra table selected (see the FROM "YearlyBudFcst" in the SQL) and didn't have any fields being pulled from that table. Once I removed that table from the FROM it allowed me to edit the values on the form.

I don't see anything in my query that violates any of the things on that page... The sql is: SELECT AllSites_KPIs.Site, AllSites_KPIs.Region, AllSites_KPIs.Month, AllSites_KPIs.Year, AllSites_KPIs.[Local Currency], AllSites_KPIs.[Total Doses (Act)], AllSites_KPIs.[Total Doses (Bud)]...

Hey all, I have a form (based on a query) that displays a variety of data in text boxes. I have the form properties set to allow edits, but I am not able to change data/numbers in the text boxes. The text boxes are not locked either. The form uses parameter values passed from another form to...

Right now I just have the user select which month they wish to view from a form. Values like "Jan";"Feb";"Mar";... etc are in the combo box. That drives to the report query and filters based on their month selection. How can I use the DateSerial to total the months up to the one the user...

Hey everyone, I have a report that shows sales by month. I have it set up so the user selects which month they want on a form, and then that filters the report. Values in the month field are: Jan, Feb, Mar, Apr, May, etc. Is there any way to include a YTD (Year to date) column in my report...