Search results for query: *

Is there any way I can suppress the following error when opening forms? "There was an error executing this command." Its error number is "0" and it only happens when a read-only user is logged in and tries to access a form he/she shouldn't be accessing. Any clues as to how...

Hi, something has gone wrong with my main form in my database. When I open the form I get a blank error message, if I try to catch the error number, it tells me the error number is "0". I can't see anything wrong with my code, the only way i can stop the message box from appearing is...

Is there any easy way I can prevent users from accessing a record on a form if somebody else already has it open? I.e. a message box popping up saying "Another user is looking at this record right now, come back later."? I have implemented record level locking but it doesn't really do...

Hi, I have a multiuser database set-up using Access 2K. I have split the database so the data resides on a network drive, and the application is on each user's computer. I have tried to implement record-level locking but I cannot get it to work. The main form in my database which will be...

I have a switchboard item called "enter new client" which when clicked, goes to a new client record. When a user logs in who is read only he/she is bombarded with error messages if he/she clicks that switchboard item. Is there any way to suppress these errors? Thanks in advance.

Hi, I have a main form on my database, and in turn I click on a command button and it opens another form with the same Autonumber primary key as the first form. Here's the code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Dim stDocName As String Dim stLinkCriteria...

Hi, I have spent all morning working on a report and sub-report and now when I click on this to run, nothing happens. The report is still listed under reports on the database window, but if I go into Visual Basic editor, the Class Object for the corresponding report is no longer listed in the...

Hi, I have a command button on my form which when pressed opens Internet Explorer: Dim stAppName As String stAppName = "C:\Program Files\Internet Explorer\IEXPLORE.EXE" Call Shell(stAppName, 1) This works fine, but goes to my homepage. I would like it to go to a specific...

I have a continuous form which displays the results of a search on my client records. I set this form to "popup" and i CANNOT get it to show more than one result at a time, you have to always scroll down through the recordset, I don't want it like that, I want it a nice size than...

Hi, Could someone tell me how I bring a report to focus? (I.e. bring it to view so it's not stuck behind some form). I tried Reports!ReportTitle.SetFocus and it didn't work. Many thanks, Mark Waddington.

I'm positive this is a simple query, but it eludes me. I have a table entitled Projects which has a field called ProjectPrefix that has a one-to-one link with another table called Project_Prefix which contains the fields ProjectPrefix and ProjectDescription. Now I am trying to get a field on...

Hi, I am using the following code to try and update a table named "staff" with the current username: Private Sub Form_Open(Cancel As Integer) On Error GoTo ErrorHandler Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs =...

Hi, I want a table that I have called "staff" to automatically populate with values of whoever logs in to the database. And to ignore adding an entry if a username that logs on is already present in the table. I'm sure it's simple but I just can't figure it out! Please help. Thanks...

I have this code attached to a command button, which when pressed, opens up a popup form (based on another table with a One-to-one relationship with my main form). Private Sub EmploymentHistory_Click() On Error GoTo Err_EmploymentHistory_Click If Me.NewRecord Then Me.Recalc...

Hi, is there any code I can use that will prevent code from being executed if the particular database user is read-only. Basically, I have a user-update section on my main form which updates itself with the username of who edited the record last. This causes errors when somebody logs in who is...

I know this has been asked before, but the responses given were so confusing to me (as i'm an Access newbie), i'm going to ask again!! I have two boxes on a form, Date of Birth and Age. I want the Age to be worked out automatically from an OnUpdate event handler on the DOB field. At the...

I have added a main "client details" form on my database and on the form I have put an "Updated By" subform which automatically adds the username of the person who has inputted data on the form. Basically I have attached a macro to the Beforeupdate event handler which fills...

Ok, I know this is probably simple, but what is the condition I would need to put in a macro in order to check that all entries in an "email" box on my form contain the "@" symbol? Cheers, Mark Waddington.

Hi there, I hope somebody can help me out here - this has been driving me crazy. I'm not terribly technically minded, so please go easy on me! I have two linked forms on my database, "Clients" and "Employment History" The underlying tables have a One-to-One relationship...

Hi! I have added a chatroom script to my website, and every time I enter the room the following error occurs: Error: 'top.wOut.document is null or not an object' To put it into context, here's the script of the page.. toOut = '<font class=&quot;sysmessage&quot;><center>You have entered...