Good Afternoon.. I was assisted with writing a query by someone in these forums a year or so ago. However, something recently happened that caused for...

Hi everybody. I'm blocked in my acces learning with two problems: 1)I have a database with data enter by a form which is linked to. Each time I open the...

I have a combo box and a text box on my form. If the combo box is not set to some value (which I assume means it's null), I'd like the text box to be...

Stainless Steel Tie Clip KTC001 Factory Stainless Steel Tie Clip Link...

Hi everyone. I'm very new to these of Access World. I'm planning to make a database to keep track of the historic results os my home soccer team, just storing...

I am using MS Access 2003 and I would like to set up a form with 6 records visible in a 3 wide, 2 high grid. I know how to set the form up in continuous...

I am trying to populate 4 other separate text boxes of an address (road, town, county & postcode) depending on the place chosen from a combo box drop down...

I have a list box linked to a table with 6 entries. what i want to do is when you click on one of the selections in the list box it chances the record...

I have the following in a control source for a text box: =IIf(.! Is Null,"$0.00",.!) I want the output to be black if at $0.00 and Red if a dollar amount. ...

I have a form by that I need to input a date with ttext box.Text box is with ControlSource Date(). It appears in Open/Form as current date but in the table...

My user wants a form in datasheet view as a list to find which record they want to work with. Upon finding that record, they want to click on a button to...

I’m using a PC using Windows XP Professional and Access 2000. When I create a Access Page using the page wizard I receive the message “The wizard is...

I have used the code provided by Allen Browne at http://www.allenbrowne.com/ser-56.html but I was wanting to modify it so that the red rectangle appears when...

Good Day, I have a sub form (in a tab of the main form) which has columns with six rows, each with a combo box. I copied the rows from the first to create...

I need to write data to two tables, but when "setting" the BOM table I get the following error: "You must use the dbseechanges option with openRecordset when...

To: John W. Vinson I'm still waiting for a reply to my response on this item. Thank You

Hi, I have database containing the details of files(in pdf format) and their locations. How can i open these files from access form? reg aneesh

I have a DB with 3 files: TRADE NAMES id - autonumber fields with Trade Name Info OWNERS ID- autonumber fields with Owner Info LINK_TN_OWN ID...

I've got a text box control in a subform whose Control Source is a memo field. I have the Scroll Bars property of this control set to Vertical, but the...

I am curious what the best method for refreshing data on forms is in Access 2007. I have 1 main form used to collect customer information. There is a...