Search results

Do you mean you want to choose a company from a combo box and have it populate a subform with the contact info?

Someone called Colin from this forum very kindly sent me a auto compacting add-in for A97 last year, does anyone have a similar thing for XP?

I converted a A97 database to XP and tried to print a report. It failed giving me an error saying "Run-time error 2213. There was a problem retrieving printer infrmation for this object. The object may have been sent to a printer that is unavailable." Anyone had this before?

Lots of very good advice as usual....thanks. The_Doc_Man - Wow, you must need a wheelbarrow to carry all of that! I don't think I'm going to produce quite that much, but I will certainly beef up the comments in my code and add some more info on the structure and design to the documentation...

Thanks Travis thats exactly what I need. I spent ages looking through the knowledge base but couldn't find it.

That is what I mean, but how do you do it?

What nobody?

You could use something like this: Dim errDb As Database Dim errRec As TableDef Set errDb = CurrentDb For Each errRec In errDb.TableDefs If (InStr(1, errRec.Name, "ImportErrors", vbTextCompare) > 0) Then 'if error table found do something with the table here End If Next errRec...

Can anyone tell me how to grab a list of worksheets from an Excel workbook? I am writing some import functions that use mutli sheet workbooks as a data source and need to create a list of the worksheets in a workbook, so that I can use this list to populate a list box and ask the user which...

Very helpful link, thank you.

Do any of you knowledgeable folk know if it is possible add a task to Outlook from Access? If so how?

Does anyone know of a good source of info on synchronising a replicated database via VPN?

Thanks for the replies, that clears up the doubts I had and confirms that it probably isn't worth the effort in making so many changes.

So to be clear, even if I set the type size limit to 6, Access still reserves for 255?

Thanks, that pretty much bears out my thinking except for one thing. When you set the data type of a field to string, even if it's length is only 6 chars, does Access still reserve for the full 255 chars in memory or only the 6 you have specified? I have a nagging doubt about this in the back...

I have a table (which holds several hundred thousand records) with a 6 character string field that acts as a reference and forms part of the indexing for the table (it is not the primary key). Would there be any real benefit, in terms of performance, in changing the data type to long (this...

Is there any benefit to using the Execute method over Docmd.Openquery or Docmd.RunSQL, is this just a matter of personal preference?

Does setting the FailOnError property to yes mean that the query is actually executed on the server as Access help suggests? I have a number of delete and update queries and, in order to try and maximise the speed with which they execute, I have set the 'Use transaction' property to no and the...

Just to let you know, I broke the process down into two stages. The first is a query that groups the 3 fields required from the 450k table and appends the data to a temp table. The second part joins the temp table to the other tables and appends the relvant data to the summary table. The upshot...

Good idea, I'll try and cut back on the sorting.