Search results

That's exactly what I have been looking for, Thanks very much Ian

Hi After creating a module & a macro to run the module I get the message apiShowWindow sub or function not defined Ian

Thanks for that, Are there some references that need adding?, my list contains the following at the moment Visual basic for applications access 11 obect library ole automation dao 3.6 object library activex data objects 2.1 library common dialog control 6.0 sp3 scripting runtime I am running...

Thanks for that, however I was looking for help with the code to perform the websearch through VBA Regards

I think that your problem is in the sequence of single quotes & double quotes. I use the following code to lookup queries, may be it will help. sql = "select * from areascoveredbysocieties where Area = '" & AreatoMatch & "'" It reads singlequote double quote (nospace) space & space...

Can anyone help, I am wanting to lookup place locations from a field held in a table. eg 'barnby dun', I need to know which county it is in. Can anyone suggest any method or code that can help? Thanks in anticipation Regards Ian Clegg

Sending Mail Via Lotus Notes Hi Am I missing something, I have the same problem and need to automate mail using Lotus Notes. We are using the Version 7 Client and cannot get this code to work. Are there some additional references to add. I have included in my list Lotus Domino Objects & Lotus...

Backing up Access Databases Checkout Helen Feddema's Website for accessarchon 151 http://www.helenfeddema.com/access.htm Hope this helps. Ian

Variable Length Records Thanks for the early reply. The While/Wend did not work correctly, but the example code did enable me to fix the problem Regards Ian Clegg

HI Can anyone help? I have a need to read a file containing variable length records. Each record type has an identifier as the first 3 characters of each record. The records can contain as many as 35 fields but as few as 10 I need to write selective records to an output file An example of...

Thanks for the info, it worked a treat Regards Ian Clegg

Help I am trying to use a command button to rename selective tables with a MonthID number but am failing to rename after I have identifield the tables. Can anyone help? The code I am using is shown below. To find the tables I am using With application.filesearch .newsearch...

My database application has now grown to over 2 Gig in size. I have approx 900,000 records in one of the tables. Sporadically I am now getting an error message RT error 3001 - Invalid argument when trying to update the file. Is there a maximum size to access databases or *.MDB files is it...

I need to browse an access table after creating it - I seem unable to run a select query from vba. I have read somewhere about docmd.runcommand accmdquerytypeselect but am unable to workout the syntax. The table name is incorrect records. Can anyone help?

Is it possible to show a progress meter in the status bar whilst running some sql (using syscmd acsyscmdinitmeter etc, if so how?

Thanks for the info it works a treat. Is there a method using SYSCMD to display the progress whilst running some SQL to extract records and insert them into a table Ian

Does anyone know of any code useable to show a progess meter whilst access is performaing a query or printing a report

I have 2 tables in an access database, one is real and one is linked (docmd.transferdatabase aclink) the link & unlinking of this table works fine. However I need to create a relationship of One-to many between the two tables, to do some reporting. I have tried with createrelation but have...