Help

Can't export a pass through query...
Hello. I am using docmd.transfertext to export a pass through (to SQL Server) query to a txt file. When I execute DoCmd.TransferText acExportDelim, "MyExportSpec", "qryPassThru", sFile, True I keep getting the error Operation is not supported for this type of object. I've tested it using tables an... 5 Apr 2010 17:12

What do people actually use Access for?
I am writing a paper on the use of Microsoft Access, and consequently, I am trying to find good data on who uses the product, what they use it for, and what industries it is used in. Do people create their own databases, or do they tend to use experts? What are the primary goals of an access database as opposed to ... 7 Apr 2010 05:40

Converting app to ASP?
A company that I'm doing a couple of projects for have a main application written in Access for their production side. It maintains the employee and customer tables and schedules their technicians. Their reports are written to Excel, not using the report writer. If they used a report writer the reports would... 8 Apr 2010 19:40

Library Reference not recognised - comdlg32.ocx - Microsft Common Dialog Control issue
I have used an application developed in Access 2003 very well previously. I bought a new machine with Windows 7 and reloaded Access 2003 (Office 2003). It now does not run a function within the application. I believe comdlg32.ocx is the problem as the reference for the modules is not recognised. I unselected Mic... 4 Apr 2010 09:19

multilingual application
"Roger" <lesperancer(a)natpro.com> wrote in message news:d38b6057-6710-497b-a4bc-7552527ef4f5(a)33g2000vbe.googlegroups.com... On Dec 14, 12:38 am, "Tony Toews [MVP]" <tto...(a)telusplanet.net> wrote: "Tony Toews [MVP]" <tto...(a)telusplanet.net> wrote: Now a key performance tip is to arrange and read the da... 3 Apr 2010 15:55

Datumveld naar tekst veld.
In MS Access 2007 heb ik een datum veld aangemaakt v.b. datum_u1 in notatie D/M/Y Na koppeling met word 2007 krijg ik de notatie in word M/D/Y In access nieuwe velden aangemaakt in Tekst format van de goede lengte Onder mijn invoer formulier heb ik in VBA Mode enkele eenvoudige bewerkingen uitgevoert zoals Titel ... 3 Apr 2010 11:29

2007 extremely slow
Has anyone else noticed this behavior? Double clicking a form's title bar in design to maximize it takes about 3 minutes. Saving takes at least 5 minutes. I'm running Windows 7 Ultimate on a P4 with 2GB ram and 60GB HD with 20GB free. I also have Access 2003 installed. I have tested with no other apps open... 5 Apr 2010 00:43

How do I query column headings?
I have a bunch of columns e.g. Day1-A, Day1-B,... Day2-A, Day2-B, etc. and want to write a query to for example, return all Day2 columns only. How do I do this please? ... 31 Mar 2010 18:48

My database window objects became hyperlinks
I'm not sure why but all objects in my A2003 database window are underlined and are basically hyperlinks. Access seems to use the single click instead of double click for hyperlinks so I find myself opening the object instead of clicking and hitting the Design button. Any idea why all objects would become hyp... 30 Mar 2010 20:39

Setfocus going to wrong control
Hi Everyone, I am stumped. I have a form with multiple listboxes (cascaded if you will) that 'lead' to a final listbox and under this listbox is a textbox. On the final listbox (lstProduct), when clicking with the mouse to select a row, the subform shows the related records from a table. So far so good. I have t... 31 Mar 2010 07:36