I have a small Inventory DB, main field is Part Number. I am trying to remove different amounts from different part numbers when you remove 1 item. Multiple...

Teste

I have a database which I wish to supress repeating values. The Hide Duplicates feature won't work, because it hides the duplicate even when the record...

Hi All, I've comeup with an issue in my .adp file. I've created on .adp file in Access 2003 followedy by providing 'sql sever 2005' server name. Once it...

I have a DB that was created in Access 2000 that ran fine. Once upgraded to Vista and Access 2007, the linked Oracle tables are extremely slow to the point...

Using XP Home SP3. Have full install of Office Standard 2007. Also have Works version 4.0.3.458 (I know, very old!) and Access 97 upgrade installed. Now...

Hello, Is there a way to control the format of a form when it is displayed as a datasheet ? Every change I make to the properties only works if I display the...

I need to be able to place much more than 255 characters into a field in ACCESS. Is there some way to have a field linked to a WORD file but look to the...

Hello, I'm wondering if anyone can help me create a query statement for a registration database I'm working on. The query goes like this.... "Event ID"...

I'm trying to help someone and I'm stuck. There is a check box that shows Yes and No. If this is checked the item is funded. What she wants to do is add the...

Where can I read simple instructions how to setup a switchboard? Maybe something that has some easy to follow examples. -- David Chambers

is there a problem with compact and repair in access 2007? when i use it it corrupts the database. i tried it on other computers and with different databases...

Everyday, I receive a dump of about 20,000 records keyed by an account number. There are about 20 fields in the table. Each day, I need to determine which...

Hi all, I have read several posts on this issue, but no one has replied with an acceptable work around. i have an Access 2007 database that requires a...

Access 2007 does not appear to compact. For example, I had a database containing 50K records and it created a database size of approx 70MB. I deleted all...

We seem to have an issue that the 'Compact and Repair' function in Access 2007 is not reducing file sizes of Access databases network drives. Is there any...

Hi. I have two linked tables (via ODBC) to a data base. I see the DSN name in the MSysObjects Table, but I'd like to edit it to add the UID and PWD, so the...

I have read on various boards that some advanced developers create forms/combos that don't pull any data until the user chooses some record from a combo. Both...

I am using the following calendar in one of my databases: http://allenbrowne.com/ser-51.html Is there anyway to control where the calendar pops up at? I...

I have a fairly simple Access database that I am intentionally trying to keep as flat as possible so that the primary table can be exported to Excel. Some...