I need to know how many records a subform returned (based on job number from main form) in order to position a totals subform. An additional complication is...

Access 2003 MSDE How do I get current_user from MSDE/SQL Server into a text box to use in a before_update procedure on a form? The Access current user...

I have a button on a form that when clicked, will run a parameter query that will ask the user for the ID number of the form (underlying table)and then it will...

Hello, Is there any way to create a form in excel or the web to link to access? I have multiple users that do not have Access but will be providing or...

Hey people, I am using SQL server 2000 as an interface and access as my forms (ADP) I have a subform which is linked via an Employee Id to insert a photo of...

Is there anyway in wihcih i can use a command button on a form to open up the 'Database Window'? I wish to take it away from the menu bar across...

Hello I have an unbound control which allows users to input some parameters to search for data. One of them is a date range. Something like this; between...

Hello, Is it possible to place a command button on the form which if the user clicks, they are able to enter notes or any additional information on a blank...

I have a form with several pages (tab control page). I am creating new controls on page 1 but these controls are then showing up on every page. If I delete...

Thank you so much! This worked!!!

Is it possible to wrap text in a memo field on a datasheet form? If so, please explain how. Thanks in advance.

I want to create a button that executes a Delete query, but Access won't even show my delete queries in the dropdown box. Is there a way to get around this?

I have a table with 3 columns Id Product1 Product2 I made a select query with expression Select Id, Product1, Product2 where Product1=...

Hi: I've linked to an external Paradox table that is used by another software that is in use. I also have information in my Access database that I want to...

Hi I have 2 tables. One is the main and second is temp. Both the tables are identical in structure and data. I will do all the calculations in the temp table...

Hi. I placed the Activex Calendar control (axcCalendar) and a command button (cmdToday) on an unbound form. The command button when clicked returns axcCalendar...

I have access 2003 datbase where I am creating a simple combo box from a query. The list values show up appropriately in the combo box, but I cannot...

Stupid question...is it possible to change the button colors on forms from tan to any other color? If so, how please. TIA -Chris

I have an Access 2000 backend database on a Windows 2000 Small Business server. Front end is an MDE database. I have a subform with a combo box that works...

Hello, I've had some success using the RunningSum property in my reports for a while now, and today was hoping to use it in the footer of a subform - but it...