Hello all, I have a database of archived information that I don't want anyone to be able to change. Accordingly I have set AllowEdits to false on all...

hi all: use on access(xp+sp3) + SQL SERVER (MS SQL 2000 sp3) many users ID ID_s Fa Fb Fc Fd Fe (auto int)(prgset int) 1 10 ...

I've created a pivot table from a query. The data numbers are displayed, however, I cannot drilldown to the underlying names that corresponds to the numbers. ...

I tried to creat a field (where the Control Source is an expression "=DLookUp ("","Rent_Roll_Calculation","=")" in a form with th default view set to...

I have about 100+ charts (each chart is a group of trendlines with data points and labels for each point, and the x and y axis may vary between charts) and I...

I am calculating a total from a table called "allocation" and using the Dsum function below on an update query to put that total in the table...

I have two forms: Form "Names" and Form "Details" Here's what I need to do: Form Names only has ID and Name on the form Form Details has check boxes, drop...

Hi all I'm using AccessXP. I have a supplier form with a details subform. I can find any supplier and populate the main form and subform with details. A...

Dear Group, I'm just starting to run an Access MDB in Access 2003. It was created in Access 2000. I get an error when I open a form, to wit: The...

Hi, I'm working on a form at the moment with a combo box that has a variety of choices (value list), one of them being "Archived". When this particular one is...

I have a form which always shows a single record via a filter on the recordsource. This form also shows a menubar. When the user hits the NEXT button I...

Hello, I am using Access 2000 SP3 on XP Home SP2. Can anyone tell me if there is a way, in a form used to enter data for a table, to have a field sum the...

I need help with a pop-up search box that will be used to search and then have the results in a subform on my main form. I would like to have 3 unbound field...

I used to be able to easily control the scroll feature in forms view , but now it goes "snakey" & will not stop untill reaching the end of the table.

Hi How do i jump to a certain tab on a tab control via VBA? Thanks

Why are check boxes grayed out? I'd like a solution for this. Thanks!

I am trying to create a form with information from 2 tables, 1 table is for hardware and the other is for software by user. When I open the form it is putting...

Trying to refer a control on a sub form another unrelated sub. I looked at the Access Web sit and tried to tweak how I reference it but no dice. This is what...

I have a combo box 'returnscatagoryCbo' based on a query. The text selected in the combo box is too long to display in the combo box. Is there any way of...

Hi, Why are tooltipText of controls on a form not displayed? I have checked, this property if these controls is set to a string. thanks Nhan