Hi, I have a special kind of key that is : I wanna prevent duplicate value for my key .in addition I wanna allow null values too. so I couldn't use a unique...

Hi. I have a combobox on a form that is not limited to list, and when I type into it the words are entered backwards. Probably an easy fix? Kinda...

Help! I'm trying to write an event procedure to close a form and the report or subreports within a report. I'm using the following: DoCmd.Close or...

hi all I have a question on database design concerning the hot topic of primary keys. Here is the scenario: I have two lookup...

Table name is tblWIP1 Form name is frmWIP1 I am using Access to track loan customers. I currently have a field in the table/form that is Borrower Name. ...

An old procedure just stopped working, the first lines a Dim frmPop as form Set frmPop = Forms!frmPopPayCC Access error msg says "access cannot find...

I want to add a command button to an existing form to allow entry of additional data for another table or tables via form. Can I control what form is opened...

I am using Access 2003. I made a letter in form(this will be main form) and I also made many other forms of regulations. Then, I made click button in main...

I am making a form with both employee ID's and Inventoried parts. what i'm trying to do is have multiple combo boxes fill in the appropriate fields. for...

I'm trying to put pictures into a form where the pictures are on the internet. I have a text field that has the url and I'd like to have the picture at that...

I have some Combo Boxes on my Form that once I select an item in them, several other related fields are completed. I then set the fields that are...

Good day, I have a button in a form that is supposed to link to a combo box. In the combo box, I have "sectors" pulled from a table. Each sector has many...

Ok, slowly learning more about all of this... I have a form featuring Employee Profiles (attached to tblProfiles) that is filtered down to a single...

Hi, I have a login form which has suddenly started behaving oddly. Not only that, but every prior version (I backup regularly, so a years worth of versions)...

I have two text boxes on a form - one is for my start date and the other is for my expiration date in the future. I have used the following expression but...

Hello, I have a table "tblNonCompIPOPAllStandards" this table has the email addresses for an outlook (email) that I want to send an attached snapshot. the...

Hello, I have a list box with 3 columns. Two are text with varying lengths and the 3rd is a decimal - how do I get the listbox to display a precision of 3...

I created my first search form last week; and in today's thread "Using only one record" Allen Browne offered his sample search form: Here's an example of how...

Hi, I have a form that I have created that I intend to use for obtaining component quotes from suppliers all over the world. I open the form fill out the...

How do I set the back ground color of a datasheet view form. It's defaulting to a crappy grey. Or I guess a better question would be how do I style the...