Search results

A user requested a change that would change the form header and detail back ground color to white when they click the button print record and then change the color back all in one click after the record prints. I keeping getting a run time error, type mismatch on the line where to code is to be...

I get an error in my app when a user enters an apostrophe in text box during data entry, I use an before update event to check for duplicates and thats when the error is triggered. Here is the code for the before update event If DCount("*", "tblAccount", "[accSchoolName]='" &...

I have a user that is unable to edit records, He can click in the fields but he could not delete or enter data in the fields. He has the ability to edit records but its fields are locked. I created a split database and created a secure front which I distributed it to multiple uses. The other...

I am updating an existing database and I have a parent/child form and I want to filter the subform for the current parent form record? The two forms are linked together by woWorkOrderID/deWorkOrderID.

I want subtrack a value on the current record from the previous record and display the result in text box in subform datasheet. This is done during data entry. The calculation works most of the time and randomly it returns the wrong value. I have the code in an after update event after I enter a...

I have this scenrio, I have drop down list that inserts the number 1 in a subform in datasheet view, the field name is Base Number, is there way to auto increment the previous base number by one in the next record of the datasheet? Base number 1 Base number 2 This is not going to be...

I have two tables, Account and SystemConfiguration. Account primary key is accAccountID, this is tied to SystemConfiguration table by sysAccountID, foreign key. SystemConfiguration has its own primary key sysSystemConfigID. How can I group records together? Example accAccountID...

I am sure there is a thread related to this and I apologize for adding this thread if there is. I am having problem with duplicate detect. I have written a some VBA code to detect if a school name exist in the account table. The problem is I get my error messge ever time I enter a different...

Hi all, I am having trouble with or dont know if its possible to accomplish. I have a table with a field called Hop 1 that house a numeric value. I have created a textbox control called hop spacing. I wan to subtrack the hop 1 from the hop 1 in the first record and display it in the text box...

Hey all, I am having a problem figuring this out. I am developing and database app that house numbers for frequency pattern. I have a form with a subform in datasheet view. The two forms are form two separate tables linked via accountID. My problem is I have this field called network number...

Hi, I am still new to Access VBA and was wondering if you could help me. I created a user login form that checked the value of a dropdown box for user name and text box for password. I have a table called privileges that has the following fields ID, username, password, and privilege level. The...

Hi members, my name Evanark and I have just join the forum. I have started using Access about a year ago and have learn on my own so I am still new to the VBA program. I hope to learn a lot from you all!