Replies

Thanks for the response.

As you may have gathered I am very much a novice and learning ‘on the hoof’ so to speak. In the first part of your answer you said use a simple If statement, would this be an event procedure, and if so where shoud it go. Once I know I will play about and try to write something and then shout help when it fails badly!!.

Thanks

Steve

Is this what you are looking for? it is by Getz and automatically finds all printers on a PC.

Steve

Thanks Willy

Steve

Thnaks Jordan, a little more help though please. I assume that this should go in the EventProcedure for After update but nothing happens when I put in a false number, I then tried it OnExit with a false number but it just carried on. I am obviously doing something wrong but could you tell me what.

Thanks

Steve

Hi Charlotte

Thanks for spareing the time to help. I have the combobox set to lookup all of the records from my Customers table but only have it set so that when the combobox is clicked only the CompanyName shows up (o”;1″;0″ etc.). I have then placed text boxes on the form, the first of which is called CompanyName. My expectation was that one I picked the CustomerName from the combo box all of these other fields would be populated.

To try not to bother you I opened the N/W db but on all of the forms the only one with a combo is the ‘orders’ form, however the afterupdate event is nothing like what I was trying to do. I copied this piece of code though and then named boxes appropriately on a new form and even that did not work.

If you could tell me which form in N/W this example is in so I can try to solve it.

TIA

Steve

Hi Charlotte,

Thanks for the quick response. I think I was getting the error because I left the . out between rst and findfirst. However even though I am now not getting the error message nothing seems to happen, perhaps I am expecting the wrong thing.

To try this out I made a form based on my Customer table and in the header info put the combo box and named it cboMoveTo and then put the code into the AfterUpdate Property.

What I expected was that when I selected a name from the cboMoveTo the rest of the fields would be completed on the form.

Is that right or am I missing the point of it.

TIA

Steve

I think I read somewhere the other day that there are 3 examples of this in the Northwind database, I don’t have time to look right now but if I find anything I will let you know later.

Steve

Even as you typed it Charlotte I imagine a frightening thought running through your head “That idiot is going to try this isn’t he?).

I assume, hopefully correctly, that this code would go in the ‘OnClick’ event procedure?

If so, I have done this and faithfully reproduced word for word what you have written, I have checked it about 5 times and even come back here and copied and pasted it into the event procedure. But sadly when I click my button, nothing.

I have read here many times that you should use the Debug and Compile feature so I have done that and get a Compile Error “Member already exists in an object Module from which this object Module derives”.

Sorry to try your patience but please tell me what this Country Bumpkin has done wrong, thanks.

Steve

Thanks a milion Wendell

I had missed the point about the command button, I assumed that just making the box a combo would trigger the query when I selected on of the items.

Cheers

Steve

Thanks for your help so far, I have spent the last fee days trying everything to get this to work but can’t seem to grasp it, if you have a moment would you kindly look at the attachment and tell me where I have gone wrong.

TIA

Steve

Hi

Thanks for the response, but probably due to my inexperience I am having trouble with this, I raised the form and simply called it frmGoods with a combo box cboGoods. In the SQL query however I cannot seem to get it to reference to this combo, I have tried several things, and the latest is below

SELECT frmGoods.cboGoods, tblRates.Origin, tblRates.Destination, tblRates.Rate
FROM frmGoods, tblRates
WHERE ((((frmGoods.cboGoods)=[Please Select Goods]) AND (((tblRates.Origin)=[Origin of Goods]) AND ((tblRates.Destination)=[Destination of Goods]));

Any pointers greatly appreciated

TIA

Steve

Thanks Francois

But where do I put this (think carefully before you type something you shouldn’t). I made the assumption that it was above and below the original code in my NotInList event procedure but it doesn’t seem to work.

It lets me type in the false part without a query but when I type in the True part it says it is looking for an arguement.

Any ideas please

Steve

You could always insert a hyperlink that points to the other DB

Steve

Thank you so much Francois

I am going out today to buy a cap so that I can ‘doff’ it to all you people that spare us mere mortals your time and expertise.

I noticed that creating the message box disabled the MS message box so I experimented and before my requery line added another message box along the lines of “Now please select the new account from the drop down box” which worked fine but the MS box saying a similar thing still appears, is that easy to get rid off or am I in above my Wellington boots.

Thanks

Steve

Eureka, the idiot finally got it

Thanks Mark, I assumed that Access always called a combo box cbo on its own, obviously I need to read more on naming conventions. It works a treat now.

As I can’t get you a beer I will have a nice cold Tiger beer in a sleazy bar in your honour tonight.

If you ever get stuck and need help shipping infectious research samples anywhere, I’m your man!!

Thanks again

Steve