I have a very large database to which I need to add new data on a regular base. Because of its size, I have split the database into two and linked them by a...

Access 2003 is what I'm using. I have a list box with 3 columns (MLS, Street Number, Street Name) on my form. Right now, only the bound column (Street Name)...

=DCount("OrderID";"" Between " " And ""='" & Forms!""Between"ÙŽ"And"""') Hi every body, this expression is written in the form to count orders between 2 dates...

Where, on the Internet, can I find help on writing macros for Access? Pref from a beginner upwards.

I have a form that creates new records. As soon as I begin to populate fields, the AutoNumber is assigned for the new record and is displayed on the form. ...

Hi! I have an "order" form whit a subform whit orderdetails. I would like to get records from the orderdetails subform (sform) put in a textbox (tbox) in the...

have a form that has 48 text boxes. The user enters data into the unbound text boxes first then after they review the information I move the information...

On Form received an error that led me back to the is line in my sql: REVNUM GRID = list. 10 column(5, list 10. list index + 1) I was told from post to make...

I have a dumb question that is stumping me (I'm a spotty Access user -- use it for a while and become fairly proficient and then don't use it for a while and...

I have a linking table with the following structu Project Organizations -------- ID ProjectID (links to a record in Projects table) OrgID (links to a...

I have two forms, lets call them A & B, A forms Record Source is from Table A and B Forms record source is from table B. On the open event of the A form, if...

Does anyone have any sample code that invokes automation to write values from an Access query to a column of cells on an *existing* Excel worksheet, ie...

I have two subforms sitting on a form that I am attempting to write to the same table. On the two subforms (A and B) exists the same/identical fields from...

Last year (2008) it calculated the work week corectly, this year (2009) it is off due to the way we use the first week with at least 4 days as WW 1. I think...

Hi, I have Access 2003. I created a combo box using the wizard. I have compared my combo box properties to the Northwind database combo boxes on the...

Can someone help? I click on my Command button, which brings up a subform of part numbers and pertinent information (which all comes from one query). When I...

Hi Everyone, Using Access 2000. Currently use the properties dialog to set my form preferences because I am not yet ready for code but have pasted it...

What is wrong with the following expression? calc date due: (DateAdd("m",! ,!)) This calculation works when I do it in a query, but when I try to create the...

I am using Access 2002 and for about a week I am trying to migrate to SQL Server, but I still want to use the Access interface that I created....But I've got...

I thought my database had been working but I just now discovered a problem with a combo box. I have two tables as follows: tblTasks TaskID :autonum Status ...