Recent content by newbee2

Hi, Through a macro call up a query when I select a button on the switchboard. This query acts as an initial search feature. There is a feild called key_Words, where words are typed as markers to distinguish what is on the form record. I am trying to get the query to look at this feild on the...

Cheers and Thanks Bill

Cheers. Thanks Bill

Hi, I have 2 tables one with a text field and one with a number field (heh its Vantage). Using Access I can run these queries via an ODBC link but cannot link the feilds in access "type miss match" they both contain the same information. Is there a way to change the datatype of a query - run...

Is it possible to export a text feild to become a number feild usinG vba code? If so how? Reason. 2 separate tables one has a job number as text the other as number feild. The two will not link in a query. Thoughts. Thanks for ideas in advance Bill

Arrrrrr and the result to make it work. Was changing the line from Set xlsheet = xlbook.Worksheet(20) to Set xlsheet = xlbook.Sheets("Five_Market_Union") Getting rid of the numerical reference as the subscript was out of range. FWIW Bill

Thanks for the input, My guess was basically right, so this is what I did, I am playing with the following, running from access but the code grinds to a halt. Function Clear() Rem On Error Resume Next Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Dim xlsheet...

Greetings, I use the following, DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Five_Market_Union", "C:\My documents\Work in progress\KPI", hasfieldnames:=True From an access 2000 project, To paste a queries results in a worksheet whilst it is closed. The Spreadsheet must be...

Thanks so much Mark. Best Regards Bill

Greetings, I have 11 option boxes , Series,B,T,W,D,V,E,X,C,K,A on a form. I would like to take each of the values made by a selected checkbox in each of the option boxes and create a word from them in a feild or text box somewhere on the form in the shape of 375.203.1.3.0.2 etc. When the form...

Hi, Is there a quick way to take an Excel Spreadsheet which has 2000+ row entries, and for specific columns to convert them to Yes/No for a new access 2000 database. There are 3 columns which set up a specification, they have been marked with a dot or no dot. When I import these into access they...

Hi, When I run the following part of code it returns an error at the strTemplatePath or states that the Template can't be found. It exists and its where its supposed to be for this application. This is a snippet of it. The code is part of a module, of which there are 4 to produce the automation...

Hi, Using Office 2000 Is it possible to get an excel range to fit to an A4 size landscape document. I can save a range of size A1:G19 and copy to clip board, when the range pastes it occupies two A4 sheets. Is it possible to make it fit to the one A4 sheet. Kind Regards Bill

Hi, The following code gives me the run time error 429. Active X can't create object. I am atuomating from Excel 2000. 'create a word instance if there isn't one 'or use an existing instance if there is one in use Set objWord = GetObject(, "Word.Application")...

Hi, Using Access 2000, is there a way to change the information stored in a table via a combo box to read/ display the other column?. A combo box allows a user to choose a name, the initials of that name are stored. A make table Query is run to select a particular record and its information. One...