Help

ODBC Linked Table provided by Web Service
Does anyone know of an ODBC driver which will send HTTP requests to a web service, process the response (be it SOAP, XML, text etc.) and provide a flat data source to MS Access (or Excel)? I am trying to build a service whereby a client database (e.g. Access) can access data that drive an existing website, and th... 9 Jul 2008 10:36

Adapt Lebans' AutoSizeFont\AutoSizeFontVer2.mdb tools to report?
Was hoping to make use of AutoSizeFont\AutoSizeFontVer2.mdb procedures to auto-resize fonts in a textbox control on a report when the fixed physical size of the textbox was insufficient to display all the text in the source table's memo field. One could, I suppose, simply count the displayable chars at various acce... 9 Jul 2008 13:42

SQL/Query to retrieve top two records from a panel of data?
Hi, I have a panel of data organised as follows: id1, 1990, 100 id1, 1991, 101 id1, 1992, 100 id1, 1993, 103 id2, 1990, 80 id2, 1991, 90 id2, 1992, 81 id2, 1993, 83 id3..... etc. Is there any way to -- without re-structuring the data -- write a query that will return the top two records based on the t... 11 Jul 2008 21:15

Invisible Tabe Names in Access XP Database
Hi I have an Access XP database backend (data only) that is linked by VB code to a frontend application. While the application is still working correctly, linking and passing over data, when I open the data backend using the Access application, the table names are missing - not visible. I can access the ... 10 Jul 2008 12:22

SQL/Query to retrieve top two records from a panel of data?
Hi, I have a panel of data organised as follows: id1, 1990, 100 id1, 1991, 101 id1, 1992, 100 id1, 1993, 103 id2, 1990, 80 id2, 1991, 90 id2, 1992, 81 id2, 1993, 83 id3..... etc. Is there any way to -- without re-structuring the data -- write a query that will return the top two records based on the t... 9 Jul 2008 06:30

Conditional Formatting anomoly
I've got a continuous form that is just for display, so hence all items on it are set to Enabled = No, Locked = Yes. This has the desired effect of making the item unclickable - exactly what I want. However, if I then apply some conditional formatting to change the background colour when a condition is met the fi... 9 Jul 2008 08:33

SQL/Query to return the top two records from panel of data??
Hi, I have some data in panel format: id1, 1990, 100 id1, 1991, 101 id1, 1992, 99 id1, 1993, 103 id2, 1990, 80 id2, 1991, 83 id2, 1992, 78 id2, 1993, 90 id3..... etc. Is there any way I can -- without re-structuring the data -- write a query that will return the top two records from each panel? Simila... 9 Jul 2008 05:29

Access 2002 won't create new record
Environment; Win2K PC with 1Gb of RAM and plenty of HD space running Access 2002 Issue; Access presents a blank data entry form in the Forms view when the New Record icon is used. However, it won't allow any fields to have data entered into them. I can edit & save existing records without problem. When I go in... 12 Jul 2008 12:32

Chart type is changing after export.
Hi Everybody Chart type is changing after export of MS Graph chart using OLE Export. Can anybody help me? Roy ... 8 Jul 2008 16:11

Removing Old Queries
I have a database with about forty different queries, and I'm trying to clean house. Is there a way to easily see which queries are needed by reports, forms, and VB? Thanks! ... 9 Jul 2008 09:34