| Thread | Last Post | Replies |
|
| server compatability | 19 Jul 2007 20:44 GMT | 2 |
I want to route my form results to a data base, i have 'access' so I wanted to use that . I checked with my server host whether they had microsoft data access components - they informed they didnt as it was a linux server but they had a window server that handle ODBC drivers or i ...
|
| Scheduling an ms Access report to run on a specific day | 19 Jul 2007 20:33 GMT | 3 |
I want to schedule an access report to run on Mondays. Is there a way to perform this within MS Access or do I have to buy a 3rd party tool
|
| Too Many Fields Defined | 19 Jul 2007 20:14 GMT | 8 |
I have a large macro which takes codes and descriptions and makes tables. For each group, there are two tables. In one table, one field is the code the second is the description. In the second table, one field is the description, the second is the code.
|
| Syntax for using a variable as part of an object name. | 19 Jul 2007 20:08 GMT | 1 |
I have 10 cells named UI1 through UI10. I want to put data into the cells through a For loop. What is the proper syntax to use a variable as part of the object name? In the sample below, CELL1 is a variable whose value is the name of
|
| Toolbox Grayed Out in View Menu | 19 Jul 2007 20:00 GMT | 1 |
I'm trying to put together a basic report, but when I try to select "Toolbox" from the "View" menu while designing the report it is greyed out and inaccessible. I thought it might be a permissions issue, but the database I'm working in has no security or permissions set up. ...
|
| Order of records on the form | 19 Jul 2007 19:38 GMT | 4 |
For some reason when I add a new record it is not the last record on the form What is the cause of it and what in fact sets the order of the records Thank you,
|
| Access Doc problems with dao2535.tlb version 3.5 | 19 Jul 2007 19:08 GMT | 1 |
I am opening an Access Document using Office 2007 Enterprise and get the following warning 'Your Microsoft Office Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5' Needless to say the document does not want to open...any ideas ...
|
| Access data in Excel | 19 Jul 2007 19:00 GMT | 4 |
How do I take specific information in Access and plug it into a specific cell in Excel?
|
| Transpose to different sheet | 19 Jul 2007 18:40 GMT | 4 |
Sorry for the cross-posting, but I'm not sure where this is better placed. I need to take the data from an Access table and turn it into column headers in an Excel spreadsheet. I can easily export the data to a spreadsheet (call it sheet A), but it
|
| After update | 19 Jul 2007 18:10 GMT | 7 |
I have a form (based in T_Table) with a Start textbox (Date/Time field), a Finish texbox (Date/Time field) and a 3rd textbox with =[Start]-[Finish] in Control Source to show us the period between Start and Finish. I would like help to after update put this result in my T_Table ...
|
| Query- missing values- Nz function | 19 Jul 2007 17:01 GMT | 1 |
Apologies for anyone who has just read my previous question, I have just read some infomation about Nz functions and so am re-phrasing my question to explain it better. In a query I am trying to create I have one field which is the date. For every date I have corresponding ...
|
| What should i consider when building a multi-user db? | 19 Jul 2007 16:58 GMT | 1 |
Hey Guyz, Was just wondering... I plan to build a db in a multi user enviroment. I'm a complete novice so was just wondering what i should be considering?
|
| Creating query from other queries- dates column | 19 Jul 2007 16:55 GMT | 8 |
I'm trying to create a query from other queries, all of which have a 'date' column. However not all the queries have the same dates in e.g one query may only have entries for 01/01/2006 and then for 05/01/2006 but not for any dates inbetween these dates, although other queries ...
|
| excel formulas to Access | 19 Jul 2007 16:08 GMT | 4 |
HI, I hope someone will be able to shed some light on my problem. I have several HUGH spreadsheets; I have realized that to manage this properly I need to my data over to an access database. My spreadsheet has quite a few formulas from lookup tables, calculation to formulas that ...
|
| Reference Standard OLE types | 19 Jul 2007 15:59 GMT | 5 |
I want to set a reference to 'Standard OLE types' (Access 97) but when I go in to the Set Reference dialog there is no listing for 'Standard OLE Types', does it come under a different name or will I need to download and install the reference.
|