Access 2003 I have an ODBC connection to Lotus Notes. I did File Get External Data Link Tables to create a link to the b_Claim_Data_Projects table in Lotus...

Hi, I am creating a database for our Machine Maintence Report (access 2003). I created a combo box from table1 and I want to have the selected fields (i.e....

I have a chemical product DB with the following hierarchical structu - ProductVendors. Record for each vendor who carries a given Product. - Products ...

I have two forms. Form I consisting of a field "Clients" & "Products". Form II consisting a similar fields "Clients" plus "Products" in form of...

I have a query that selects a subset of records. I need to add a "run number" to that subset, starting with 100. That is, the first record is 100, the...

how do you add an image, a photo, to a database that i've set up?

I've got a DB that exports to Excel by opening an instance of excel, then record-by-record it dumps the fields into the cells of a workbook that has been...

Another Question from Andrew. I have a table with a field , text field, no duplicates. This table is maintained by in house (Back end). Users of the...

I've figured out how to execute a sub on a subform initiated on the form. !!.Form.btnSave_Click I can't for the life of me figure out how to do...

Does anyone know if it is possible to run an append query referencing a column in a combobox. In otherwords, my combobox is bound to column 0 - ID and...

Newsletters are like doing WWC (world wide chat) Witch Is Awesome!

do i know u? im just wondering?

It takes such a long time to sign up for hatena. So don't try it. I tried 10 TIMES. and the never read the thing that you sign.

I saw a Chinese Newsletter. They know we are Americans. Right?

Please someone explain to me how I can alter the order of the items in my legend in a report. It currently goes in alphabetical order, but I would like it to...

Hello, I have been using Access to enter our loss information for a few years now. Recently our office updated to Access 2007. When I go to Forms to enter my...

I'm an absolute beginner on Access. I've constructed a database for patients on a clinical trial. All Patients are "Screened� some are then...

I am trying to create a best fit distribution program for assigning kids from several schools to seating areas in a theatre. -- Greg Ledenbach

Can these 2 conditions be added together? Me!cmdSendMailButtonCI.Visible = Forms!frmMain!ckbShow2ndCompany Me.SendMailButtonCI.Visible =...

I'm using 2002. The problem has just recently started. In updating a form, moving from Design View to Form View, or just saving the form, Access will just...