Search results

no you havent realy confused me. I know little bits about programming in C++ and Java but i have no experience at all in VB (A). I`m a student doing a year out in industry so i`m learning (or at least trying) all the time and what you have just helped me with will hopefull impress my bosses...

Sorted thanks for all your help. I really do owe you all a drink. Thanks chris

sorry that was my fault i miss read you original message and thanks for all your help it is very happily recieved and i appreciated you have you own work to do. I must surly owe you a night out. Unfortuanatly the code you presented If Not (rst.EOF And rst.BOF) Then now gives the error...

Thanks for the reply. I have implemented the code and adjusted it to fit my needs. Now i have a a run time error message claiming that there is an error in the string in query expression 'tblESTIMATE=(the number entered in to the inputputbox)" i have checked this i cant see an obviouse...

Thats great its saved me alot of time and pain thanks. Ive persuaded my boss to send me on a course to learn VB so hopefully i can repay the favor one day. I have changed the Query to contain a where statement. Whcih works fine Set rst = Db.OpenRecordset("SELECT * FROM tblESTIMATE WHERE...

okay i have done that and the keywords are now regognised. How is it possible to get the code to place the query on to a selected area of an excel spreadsheet?

Ok thanks for the advice. I`m not a great VB programmer tho and am not to sure about referencing the Micrososoft Object Libary. Also the code you suggested fires back several error messages such as the opendatabase is not regognised. To i get these error messages becasue i am not referencing...

Is there a way to get VBA to write a query for an Access Database? If possible I would need to get this to run from an excel template.

Does anybody know of a way for a value value in a criteria search reference a text file. Ie: If the value is 20 in the text file the query will reference this number, look for the value 20 in the database and retrieve the required data. I have tried a search for Dynamic search queries with no...

I am aiming to search a database for required information as entered by a user and for this info to be displayed in a spreadheet. The info is enterd in to a message Box within Excel which is named strFileName. I need the criteria to be enterd by the user in to the message box and for this...

I need the SQL if possible because i have to link this to VBA within an excel document. This allows the user to request a the info they need via a text box. I have discovered that i can assign a variable from the control in excel and then use the variable from within access. I diont know much...

Is there a way of creating a query to search a given collum in a table and then find a specified set of figures. Ie search collum 1 for all cells containg the number 25 and then diplay that entire row of information.

I have the follwing code that opens up an Excel Template i have two errors with it Private Sub Command3_Click() 'Open, and make visible the Excel Template (Request.xlt) Set objXL = GetObject("J:\DATA\ESTIMATI\Chedley\Quotation Files\ACCESS 97 TEST Static.xlt") objXL.Application.Visible =...

Is it neccessary for the user to have to carry out a command for the process to take place? It is possible to automate the entire process automatically and for the data to transfer itself at at the end of each week without having to be commanded to do so. It is also possible to set up a...

Does anybody know if there is a limit to the number of tables that can be stored within a single databse?

Assuming that you are using a version of Excel as the spreadsheet then it is possible to transfer data from a spreadsheet to a databse using 'Template wizard' locate in the data menu. (you may hav to install this as an add-in as it isnt installed as standard). This creates a template...

I`m not to sure how to pervent the pasting of field names by simply copying a table and pasting it in to excel. If you use 'Database Queries' from the 'Get External Data' meun to automate the data transfer process then there is an option within properties to prevent a field name from being...

I have a complicated problem with tables. I have a table in an access database that is linked to two excel spreadsheets (both are templates). one is used for input of the data. The scond is used to output the data to. The problem occurs becasue i need to be able to create new tables within...

The atteatchment below may be of some use to you. I think it is a near example of what youm are looking for.

Books Matt Try doing a search for books on the search function it brings up some good advice on what books to buy and for what skill level try the link below for a start http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=25479&highlight=books k209310