I recently ran up against something I hadn't run up against before (though I'm sure many have). I needed to build a report to show totals of items for...

I have a a form "formAccounts" with a subform "formAccountInvoices" (subform control is named "formAccountInvoices1") with a sub form...

I have a table with separate date and time fields which I've pulled into a query. I need to query based on a start date and an end date, however, on the end...

Is it possible to populate a combo box with the names of controls on the form whose Visible property is set to No/False? Thanks in advance! magmike

I've got a report that shows when a date is overdue. However, I'm trying to get the report to show the overdue date in a red text as apposed to the standard...

I have a cluttered MDB. I created a group and moved tables I wished to delete into it. Clicked on the new group name, all that I had flagged to remove were...

Hi I'd like to auto fill a field called "Update", which is a date of record's last modification. Modifications are only entered manually via form. Which event...

Hi, I need some more help sorry if I am being a pest LOL. In the database I am building, I have several tables that will contain customers data, each table...

its a question

Hello, I'm currently using =Now() to auto populate a form. Although it adjusts based on the moment even with datasheet view. How can I auto populate a date...

There is an Access DB on a shared server. Permissions allow for sharing. IF people go to the shared server and folder and then open the DB all works as...

How can I get the current Object, Subroutine name, function name in VBA so that I can make a generic error message that automatically shows the right...

I am experiencing the database window re-appearing. I hide the database on startup; however, I have a double click event to open another form, which causes...

I'm using ShowCase Query (7.0) to extract information from an AS400 system. The information is output to a dBASE IV file. When I attempt to import the...

my son has microsoft proffessional 2007 installed on his computer and I want to install it on mine - how can I get an extra licence for my computer and what...

Hi. I have 2 queries: VBA: "SELECT Pracownicy.ID, Pracownicy.Nazwisko, Pracownicy.Imie, Dzialy.Pion, Dzialy.Dzial, & _ "FROM Pracownicy RIGHT JOIN (Dzialy...

using access '03... I’m trying to open a subform (filtered) related to a table called tblIO2… I’m using the following code to no avail (it opens the form...

Hi there, I was trying to import a spreadsheet from Excel into Access. There are around 30,000 rows and 17 columns. Could it be a problem that causing the...