Search results for query: *

rvnguy, Thanks for the information. I will check it out. Thanks, SHallman

Folder Redirection intermitten problem: redirects to wrong users location. I have about 30 users created on a small Windows 2003 SP1 system. There are 8 client PC’s (Windows XP, SP2) that are shared by the users. We have a group policy that enables Roaming Profiles. We have Folder...

Changes made to a users "settings" (folder redirection here) by a group policy is not un-done by only moving that user from the group that set the policy. Once that the settings is set, it will stick with that user until another group policy changes that setting. What I do is creater a basic...

We have a Win 2003 Server, which is our domain controller, our TS server and our TS License server. The name of this server is PHL1, it's IP address is 192.168.100.7. We have 6 CAL's installed (per device) and all worked fine. The client PC are all XP Professional. Recently to implement...

RoyVidar, Here is a star for you for helping me better understand recordset issues!

I have resolved this issue! I found that when I go into "Relationship" under "Tools" in the VB editor and selected "Microsoft DAO 3.6 Library", I would get an error "C:\Windows\System32\DAO360.dll" not found. I did the same on the working PC's, linked to...

Interesting enough, I get the exact same error after making the code change you suggested. --------------- Private Sub AccountID_Exit(Cancel As Integer) Dim X As Integer enteredID = Str(Val(Me.AccountID)) If Me.Dirty Then DoCmd.RunCommand acCmdUndo 'Clear event stack so cursor...

Roy-Vidar, Thanks for your reply. I think you may be right in that I may be mixing DAO and ADO types together and I may be more confused than ever. I assumed I was using only ADO for the 2 following reasons: 1) I have the "ActiveX Data Object 2.5 Library" selected under...

I have an Access 2002, SP1 application that runs fine on 4 PC's, all running either Win2k and WinXP Professional. I moved the application another PC running WinXP Professional also with Access 2002, SP1 and now one of the forms that looks up a record in a table gets: Run-time error...

Please disregard, I found it right under my nose. The "recs" variable contains the value of records affected by the SQL command. Thanks!

How do I get the number of records altered by a SQL command returned to my program using ADO. The code I am using is below and works great, but I want to be able to pass on to the user the number of records the SQL command actually affected. Thanks! ------------------------- Sub...

I have a form with 3 controls, an unbound control for entering a customer "account" number, and two control buttons, one for "Lookup" and one for "Cancel". When the user enters a number in the "account" text box and clicks on "Lookup" a query is...

Thanks, Just what I was looking for! SHallman

Freinds, I have a form that opens for edit only and has a subform that opens allowing new records to be entered in it's corresponding table. I want the subform to open so it does not allow the entry of a new record, only dipslay and edit of existing records. What is the best way to do this...

I have also been watching this post and trying this. I get an error: Microsoft Visual basic, run-time error '70'. Permission Denied. It seems that since the VB FileCopy command is being run from inside the 'mdb' it is trying to back up, it get's this error. If I make the source file in...

Thanks, this works great!

Thanks, I'll try that.

I got it figured out. I put in an error handler: On Error GoTo errorhandler ... errorhandler: DoCmd.Close Thanks for the help!

This works, thanks! The only problem I see now is that if no changes were made to the form, clicking on "Cancel" button produces the VW error: Run-time error '2046': The command or action 'Undo' isn't available now. If changes were made to the form, it works great. How would I check...

This is similiar to a previous post. I have a form bound with controls to a record in a table. I have two buttons on the bottom of the form, "Save" and "Cancel". I want the user to be able to change data and then either save and close the form, or abort and close the form...