General

DoCmd.TransferDatabase (EXPORT)
When using this command to create a copy of an existing table into another database, what happens if the table already exists in the destination mdb? 1) Does it append to existing table (without creating duplicates of existing records)? 2) Does it add it to the already existing table (potentially creating ... 2 Jul 2008 16:01

How to Change the Data Source of a Form
How can you change the underlying query (not filter) of a form and is it possible when the data source of a form is a table? Thanks in advance! magmike ... 3 Jul 2008 10:26

Make control wizard produce VBA code not Macros
HI I am now using Access 2007, and in general I like it. I have come accross a problem I can't find the answer to. When I use the control wizard to add a combo box to go to a record on my form it now produces a macro. I need it to produce the VBA code it produced in earlier versions of access. What set... 2 Jul 2008 11:54

Pivot Chart Formatting
Hi all, I have a pivot chart the plots items (y axis) over time (x axis). The time is in months and years. What I'm trying to do is get it setup so that the x-axis has only months (which I can do), but there is a graphic representation in the chart for each year during that month. For example, if I have d... 2 Jul 2008 11:54

Excel import
Hi, I am trying to import excel data to access. I have "unusual" charachters in the column title headings. How can I find a list of allowed charachters? ... 2 Jul 2008 14:59

SQL Statement wording
I can't quite seem to write the SQL statement right for this issue - help would be awesome! First, some background: My main table is called ProspectTable. This is where the main company information is kept. The company is identified by ID, and in related tables, ID is inserted into a field called CompanyID. I've... 2 Jul 2008 12:55

Check Box
Hi All I have a Qry with one CheckBox column "True" or "False" . Now I have a form with one checkBox if this box is checked I want the Qry to show all the True Records if not checked I want the Qry to return all records. in the Qry Grid I used this expression IIF(IsNull([Forms]![MyForm]![CheckBoxName]),"*","Tru... 2 Jul 2008 14:59

parsing text field with numbers
I have a field that has numbers and occasionally a letter amended: 1 2 3 3a 30 300 4 5a 5b 6 I need to parse the field ,extracting the numbers. In the end, I would like to sort the field numerically. How can I parse based on the difference between numbers and text? ... 2 Jul 2008 12:55

ole server f
my access application gave an error message "The expression on click you entered as the event property setting produced the following error: There was a problem accessing a property or method of the OLE object". One web site proposed the following solution: 1 verify that the ole server is registered correctly ... 2 Jul 2008 10:52

help with form/table
I'm working on a database that is about server information. Someone has already started this project, and basciall didn't leave me with much information about it. So I'm trying to figure out everything in bits and pieces right now. And I'm still trying to learn most of the access language so if something I say ... 2 Jul 2008 10:52