Search results for query: *

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...

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

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...

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...

Hi, Please give me some guidance. i'm not really a VBA person so any attempt I make is a stab in the dark intil it works. Things have changed somewhat since the last time I posted. Well I can get the Range to copy to clip board,I can get the template to save as a doc minus the Range. But I acn't...

Sorry to repost, Having a bit of aporplexy with this problem in VBA. I can get a Range to copy to clipboard.(The range is bigger than an A4 sheet) Case Is = 8 Rem MsgBox "it works", vbOKOnly Set rng7 = Sheet1.Range("A130:G154")...

Hi, I want to take a range from an excel sheet and paste it to a new word document laid out in landscape. I am using the following. I can get word to open but no document shows. Case Is = 8 MsgBox "it works", vbOKOnly Set rng7 = Sheet1.Range("a130:g154")...

Hello, I once had a copy of the way to take a date and from it resove the month as a number. so if I have dd/mm/yyyy or that Date() function I can get the month as a number. Can anyone be kind and help me again. Kind Regards Bill

Hi, Don't know the best way to describe this. I have a table that has a field populated from a combobox. The combo box selects engineers initials and there full name. Only the initials are stored. A parametric query runs and returns a result and this is turned into a make query for mail merging...

Hi, When i use the following code to ouput to screen i get a window view without the standard toolbar. What is the correct way to output to screen if I need to show toolbars etc. 'Highlight the entire Word Document and update fields, so the data 'written to the custom doc properties is...

Hi, Sorry to bother. Using the following code snippet,I was hoping to test an application to output a report for later e-mail. The code runs but stops with no indication of error but there is one. Where am I going wrong? 'open the Database With accessApp .OpenCurrentDatabase...

Hi, Is it possible to transfer a report once it has been opened in VBA to a file on a hard drive. What would be the easiest way to do this in VBA. The reson is the report has to be sent on a monthly basis via e-mail. Thanks Regards Bill

Hi, What is the correct code to print a report to a file. Thanks in advance Regards Bill

Hi, From access I can mailmerge to a word document, save it, and then display the Doc in a window so that it can be added to etc. What I can't do is get the toolbar etc to show, I can only get the Window view. Using the following code. 'Highlight the entire Word Document and update fields, so...