| Thread | Last Post | Replies |
|
| How can I access the description | 30 Jun 2007 23:49 GMT | 4 |
How can I access the description in a table? Back in old dBase days I could use list/export structure extended. I can't find any way to do this. I am usign Access XP Thanks for any help
|
| Refreshing a report from Switchboard | 30 Jun 2007 18:37 GMT | 1 |
I am using Access 2007. I have created a simple switchboard that has an item that runs a report that is based upon a query. This query asks for a range of job numbers. When first going in to the switchboard, it asks me for my range and everything is great.
|
| how can I bold a portion of a text box? | 30 Jun 2007 16:35 GMT | 7 |
Hi - I have a function that returns a value to a text field. I need to bold a portion of the text field to match up with the rest of the form. I'd rather not split it into two separate text fields because the text should only display if certain criteria is met, so it's more
|
| Screen Flicker when running Access 2k with XP style on | 30 Jun 2007 04:41 GMT | 3 |
I am looking for assistance with an issue I am gettting with an Access2k application. When I have xp style switched on, switching from screen to screen causes the first screen to resize to it's 'restore' size before the second screen appears. This causes a 'flicker' affect
|
| Make-Table Query Shuts Down Computer | 29 Jun 2007 23:42 GMT | 1 |
I'm experiencing an unusual problem. When I run a specific make-table query on a computer, that computer shuts down. The computer shuts down completely, without warning, as if a power failure occurred. I can run the query without any trouble on other computers. I can also
|
| Excel Crashing when opened from Access | 29 Jun 2007 22:45 GMT | 4 |
I am using the following code (Office 2000) Private Sub Storage_Click() On Error GoTo Err_Storage_Click Dim ExcelApp As Object
|
| Frustrated re Line method | 29 Jun 2007 22:26 GMT | 2 |
Does someone out there have a better reference on how to use the report Line method than what is in the help file for Access 2003? Maybe I'm just misunderstanding but it seems there are typos in the help for this particular method. For example there is a reference to
|
| Creating a new table as a subset of two other tables | 29 Jun 2007 22:03 GMT | 1 |
I am trying to create a table which is a subset of two other table where those tables have the same uniquely identifying key. I am using Access 2003. The SQL statement that I am trying to use gets an automation error,
|
| "CREATE TABLE AS" (using ADODB Command Object) | 29 Jun 2007 21:46 GMT | 1 |
I'm attempting to create a new table, and populate it using the fields from two existing tables. The code is printed below. I get the error: "Run-time error '-2147217900 (80040e14)': Syntax error in CREATE TABLE statement." For what it's worth, when tested independently, the
|
| Export fast, my code slow =[ | 29 Jun 2007 21:38 GMT | 7 |
I'm doing some speed tests. I created a brand-new table, with just one "Long Integer" field. I'm testing adding 1000 records. If I use the "Export" feature in Access, it takes only a few seconds to export the 1000 records to a new table on the server. If I use my code
|
| Report Graph Object Error Message | 29 Jun 2007 21:00 GMT | 1 |
I hope someone can help. I am trying to use VBA to set the colors for the slices in a pie chart. My problem is with accessing the object itself. I am using the following code in a command button on a seperate form (Form1):
|
| Windows XP tips and tricks | 29 Jun 2007 18:30 GMT | 2 |
Tune up your operating system, minimize background activities, repair registry base, uninstall unnecessary components, get rid of boring errors and make your operating system safer. http://windowsxpsp2pro.blogspot.com
|
| Double Click Syntax | 29 Jun 2007 17:59 GMT | 7 |
e a sub I have created a database for my department, which will display all the users details (name etc), PC details, and software details. The database is just going to be a way of knowing who has what
|
| Using tabs on a form, how to filter by selection by clicking the tab. | 29 Jun 2007 17:43 GMT | 1 |
That's about it, I've put a nine pages in tab-form on a form and have different fields on each tab from the same query. I want to filter by selection (pre-determined by each tab) when I click on that tab. Example, when I click (Tab) page 2 on the form, I see the some fields
|
| error - no value given for one or more required parameters | 29 Jun 2007 17:42 GMT | 1 |
I'm trying to create a combo box using the wizard. It's based on a query with 5 fields - enum, ename, startdate, enddate, and recordnumber. In my query enum is not visible, and that field has criteria that comes from a text field on a form. The query works fine.
|