Search results

Ok that works great when i open up the form directly. However if if i open up the query from a seperate form via the form.visible function then i have the same the same problem. Am i using the correct method to open up the form? I have put the ME.Requery function in the form_load decleration...

Thanks for the reply Do i have to requery for every text box and label or is there a way to requery the entire form? Thanks

I have a form that searches a database for certain info. The results depend upon an entry in to a to a text box on a seperate form. I can enter an entry in to the text box and the results will be displayed on the form. The problem occurs when i close the form and the try and enter a different...

Is it at all possible to increment a number in a table depending upon the number in the row previous. Eg Field1 C1 C2 C3 C4 I know it is possible as the auto number field set by access when no primary key is defined carries a similar feature out. I have looked at the field properties for the...

I am involved in a project that involves upgrading a database from Lotus approach to Access 2000. Is anybody aware of any way possible way to change an approach file in to an access file or to copy a table from approach to access and any problems that may arise from such actions. Does anybody...

Thanks for the reply has been very helpful and is enough to get me started Any other advice would still be gratefully recieved

If it is not too much trouble could somebbody please reccommend some literature on Access Database design either web based or in Book form. I have no knowledge on normalisation and the normal forms other than that they exist but i feel that i need to know this as i am to be involved in database...

Is it possible to comnbine two queries such as INSERT INTO tblTest SELECT * FROM Tbl1 WHERE [tblID]=1 and INSERT INTO tbl1 ( [tblID] ) WHERE ( [tblID] ) = ( [tblID ) SELECT '" & ([tblID]) & "B' AS [tblID]; the first query inserts a line and the second inserts a new ID in to a line...

Thanks for that. It seems alot more fiddly than i thought it would be. Thanks for all the advice tho. Ill give it a go and see what happens. Cheers Chris

Is it possible to get to get a sub form to load on toa form depending upon a selection from a combo. Ie list the sub forms in a combo select the form needed an have it displayed on the main form

How is it poswsible to populate a combobox depending upon the results of another using VBA (or any other way) have a query to collect the required data. Is it possible to call the query from VBA and then haqve the combo popluate with the results from the query? Thanks in advance

I work for a companmy that produces PEP tubes (dont ask, i dont know either) each tube in an order may have several identical parts. The database i am working on contains the design specs (what metals are used in prodution) for the parts used. If there is an identcial tube part that is...

Alright colin? again! You msut be sick of me by now. I really must learn more about Databases. The problem with that is that i am copying a single record several times. and then changing one field. I could add an ID collum. How would i tell the query to find a unique ID number tho?

I have a query that replaes data in a database using the update query. The query is called from within a VB module. Is there a way for the query to only update the first set of data? I have tried a do loop from with in the VB code however this didnt work. The problem is in the SQL i think. Is...

thanks colin ill buy you a pint someday. Chris

that sounds about right i dont have a problem creating the functions in VBA do you know how to reference them in the query once they have been produced?

i think so yes something like this (strResult being the result of a formaula that takes place in a command click proceedure. (the click is what will start the query running) UPDATE tblTest SET [Melt ID/Tube ID] = strResult WHERE [Melt ID/Tube ID]=[Forms]![FORM1]![Combo0];

last question. When i have done this bit im finished my task. Unless the answer to my question is "This is impossible" in which case ill be here all day Is it possible to reference a result to a formaula that is calculted in VBA in a Query. Colin if your still there you mentioned before about...

i have managed to do this now thanks colin. I wasnt sure how to design an update using the design grid so i had to write it out. Thats where i was having the problems. Thanks for all your help thias morning I hope I can repay the favour sometime. (I may be back yet tho)

Thats wht i was planning on doing but im am having trouble getting the update staement to work at all. I have limited experience of SQL so am trying to work it out. Is there an easy way to do this rather than writing it in SQL?