Getting Started

Error 2474
"expression entered requires the control to be in the active window" Any idea what causes this and how to fix it? The statement is 'subformname = screen.activecontrol.tag' In debug, referencing screen.activecontrol causes the error This is being run from the current event of a form. The focus has been set to a... 26 Feb 2007 10:44

Importing excel into access
I read about a similar problem but didnt find any help... When I import from excel to access, one column, which has values that are mainly number and a few letters mixed in, i have erros. For example... if the import row was 3900000458 it will work, but if it is 0805C45, it will give an error and come up blank in m... 23 Feb 2007 16:09

Referring to a control by using a variable
I'm trying to change the FontBold property of a contol whose name is stored as a variable, but I can't figure out the correct syntax. Here's one of my attempts that doesn't work: If CurrentLabel <> "lblCustomerList" Then Forms!Form1! & CurrentLabel & ..FontBold = False I know I'm treating those as strings and... 24 Feb 2007 12:41

Adding Color, Bold Etc. To Query Results
I was working with a Yes/No field in my query and happened upon this custom format in the ACCESS help menu: ;"Yes"[Blue];"NO"[Red] What it does is change the yes/true/on value to "Yes" and colors it blue and the no/false/off value to "NO" and colors it red when I run my query. What I want to know is the bas... 23 Feb 2007 16:09

repeated installation
every so often, when my computer is botting, on the desktop screen I get a popup telling me that windows installer is starting to install my fully legal copy of access. if I don't let this go through, i cannot use the database program. how do I stop this please? because it's a right royal pain. ... 23 Feb 2007 21:16

Access Form
I would like to know how to get information that is on the first page not to repeat it on the following pages. What do I need to do to stop the repeating and have a clean new second page? ... 23 Feb 2007 21:16

How to print last 2 records from a report in .mdb
i wanna set no of records to be retrived in a report how can i do this in a ..mdb.how can i set a report to print first page only, leaving rest of the report. ... 23 Feb 2007 21:16

Subform question using two tables
I have an Orders form that has three subforms based on many to many tables. One of the subforms takes an order for food and beverages to be used in a meeting. With this subform you can order a variety of items (Coffee,Doughnuts, Orange Juice, etc.), with the quantity needed for each. This order form and the thr... 23 Feb 2007 16:09

Outlook emails populate Access database?
Is it possible somehow for emails containing a certain subject line and emailed to a certain email address to automatically be added to an Access database table? Would this be ac Access issue or better be posted in an Outllook forum? ... 23 Feb 2007 16:09

Access Use
I created a database call list. Now I want to move the contact information to a table to create mailing labels. How do I move the data from one place to another without retyping all the information? ... 23 Feb 2007 05:47