Hi I have a form named Frmcustomers. in this i have a field called "PartyId" which was auto number generating field. I used the following code for...

I need to convert a textbox string value in the form of 31-12-09 into a date in the same format, can any one help please, thank you.

Hello, I am trying to create a payroll data entry. I am trying to know how many attendance days i have by employee, this sql is not working because it is not...

I have found http://www.lebans.com/verticaljustification.htm that applies to text boxes and labels. Are there any references to vertically center COMBO BOX...

I want to create a (non-modal) pop-up form that acts like a subform -- i.e., it opens from a button on the main form, it's linked to the main form and will...

Using Access 2007. I’ll try to describe my issue as detailed as possible. I’ve got a form with tblComplaints as its “Record Source�. One Combo Box...

In a combo box based on a Table/Query how can I display something like "Plase make a selection" as opposed to the cbo being blank prior to making a...

Dear All, I have an access file for the employees attendance. The main Table Includes all year long attendance. how can i create a query that will sort them...

I have a fairly long code that I'd like to space out over multiple lines for easier reading and future handling. I know I've seen a code that tells the...

Hello Guys, I have a combobox that displays the total transaction amount for a customer. If the customer has no transactions then I want the combobox to...

I have a table(ABC) with the below three columns as shown...

I have an unbound text box in a subform which is one of 4 subforms on my form - all of which have a one-to-one relationship. I am using the DLookup function...

I've embedded a calendar control in a form. I've replicated the database to a file server so users can access the form. If *I* access the form from the file...

I have a large amount of text to concatentate and Dlookup that I want then displayed in an unbound text box on my form. I am not being able to get any text...

Sometimes novice Access programmer he I would normally do this in drop down, but the form will be a tool for switchboard operators and needs to be a quick...

In my form, I have a set of 3 list boxes that have the multi-select option turned on. I would like to have some kind of box open when the user is in these...

I have a button on a form that opens a report based upon that form. I want to be able to change the data in the record, then simply click the button to...

Hi, I've created a database to manage the results of a very lengthy questionnaire. Due to size constraints, I have five tables that hold my data. Each field in...

I would like to give a space to write some comment in the form. Is it possible to create a notepad kind of in the forms

Dear all, I have a form with 11 subform, withdynaset constent update all of them are viewed as datasheet once i click on any of these subform i receive cannot...