Search results

Thankyou Travis for getting back to me, I had a few problems adapting the code, I ended up using CreateQueryDef. Working fine now, except I can't delete teh query that I create each time!!! I've put at the end: rstContMaterials.Close Set rstContMaterials = Nothing 'FindMaterials.Delete Set...

Can anyone see where I'm going wrong? I'm trying to click on a button, which goes to a form called 'RelatedMaterials', this works fine. I want this form to have the check boxes on which are ticked according to the Query. This was working fine, exect ot gets to the end and produces an error...

What would I do without you??!! I get 'Argument not optional' for EOF, what am I doing wrong? Before when I did 'Do until .eof I got that it wasn't defined. Thank you (again and again!) Elise

I've got a form with several checkboxes on, ticked according to whether th evalue is tru or not. -Well sort of. The code I have so far: Private Sub Form_Current() If Material <> "" Then Do If Material = "composites" Then ChkComposites = True End If If Material =...

Thanks for the advice, I can sort of see what you mean, I just have a couple of questions. (I'm new to Access) Temporary table: to you mean the same as creating an ordinary table, just with ContribID and Materials in? Is it only open for the life of the form? How do I make it temp? Query, do...

OK, I've got a good 'un here... In a form called RelatedMaterials, I have several checkboxes, either ticked or not according to the appropriate ID. (still not working properly yet, but anyway..) I want to be able to add or delete records from these boxes. SO.... Ticking 'ceramics'...

Thank you for your your response, but what you were saying about it being mutally exclusive, I don't want that do I?? Several of the boxes may be checked. There could be up to 5 possibilities per ID, which is the problem I have. Your suggestion of using Form_Current does enable each of the...

I can get my looping to work!! What I want is to be able to load a form up with several checkboxes. According to the ID that has been chosen, the appropriate check boxes should either be selected or deselected. I'm pretty sure a loop is needed, I've got it working soi that the first record is...

I have a form which I want to show checkboxes that are checked according to the results from a query. If got the code under Form_load, this works that for the 1st record the box is checked, but goin to the other records there is no change. I'd like the results not to be displayed by individual...

Looking back, I don't think my description was very clear, more detail: The Macro: Select Object: Select the Query which is being used Object Type: Query Object Name: Contributer/Age_Link In Database Window: Yes Apply Filter: Apply the filter to the query (Contributer/Age_Link) to extract...

Thanks a lot, I'd done both them things before, but not together!! (Told you I was new to this!) Yes it worked fine, (of course), thank you again. Elise

I have a form which is filtered to display the records according to what button is pressed. I need to show all Age Ranges for example, for a given ID if the Age Range button is clicked. I've got a query which has combined the Contributer ID with the appropriate age range, but I can't seem to...

I'm an Access newbie, not sure what I'm doing and would appreciate any (simple) help. I've got a combo box, which I want to keep the value read from a table. It shows the status of records, so each record you go to,the status is shown in a combo box i.e active, inactive etc. I want to be able...