Search results

Hi I have a table with a Long Integer field which is causing me some difficulties. When I try to export it to a text file I get an error: The Microsoft Access database engine could not find the object 'text export#txt'. Make sure the object exists and you spell its name correctly. If 'text...

Hi I've got some code which loops through all a bunch of queries which are looking at linked tables in my database. For each query it runs this: Sub export_tab_to_csv(mytab As String) Dim qname As String Dim exportpath As String qname = "Export " & mytab exportpath =...

Hi I've not tried to do this before and it's not currently working, so may be not possible, but here's what I'm trying to achieve: I've got 2 tables - an address list and a restaurant list. I've got longitude and latitude values for all records, and I'm trying to flag each address with it's...

Hi I have an Access database (which only I use) with a table. I have a Word doc which uses this table as it's data source. I launch the Word doc with via VBA from Access and it works well unless I've been tinkering with the form designs in Access, in which case I get the message: Error has...

Hi Can the Export Wizard be called from a VBA module? (I imagine it could be done by sendkeys, but I don't want to go there.....) It would be great if I could pass it the name of a query I want to export as Excel, and then have the wizard take over from there. Thanks for reading.

Hi I've been having an annoying issue lately when I link to an Access table from a Word mail merge document when the Access database is open and in 'design mode' (ie I may have edited a form recently). I only seem to get this when the Access file is open on a Windows 10 PC (I usually use a...

Hi I've always found the Totals button on the Home toolbar (Access 2013) to be useful to produce this sort of thing: Is there a way to add this row and set it to 'sum' for a given table from VBA? Cheers!

Hi there! I don't imagine this is do-able, but just in case..... Is it in any way possible to add items to the context (right click) menu outside of a form, just in Access generally? The idea is, if I right click a table, I get a custom menu from which I can select to run a certain function...

Hi I have an access front end with form with data linked to separate back end database. Both accdb format, Access 2013. Windows 10. 20k odd records on a single form, not continuous. I have a group of 6 users reporting that they are getting #Name appearing in the fields as they work through the...

Hi there I can create a select query with a combo box in it by changing the property of one of the fields - making the display control to combo box and adding the values. No problem there. What I want to do is to be able to create a query dynamically from vba using a CreateQueryDef...

Hi there This is something I occasionally see in Access and has been bugging me for quite a while. As an example, when I have a table (all text fields except for the ID field which is an Autonumber with a unique index - ie just what Access creates when you import data) and I try to make a...

Hi there! Hope someone can help me with this - I'm using Access 2002 and when I do a new query and add a table, I often can't get select all the fields by double-clicking on the top of the table - it just doesn't respond at all. The problem resolves itself if I maximize the window and then...