Search results

Yes!!!!!! It is linked to another table which has cascade deletes but I didn't think this would prevent deletes on the child table . I thought deleting a parent would automatically cascade to delete their children but one could still delete a child independantly? Will play around Thanks

I have tried running it both in vb and as a query. I get no messages. I have already tried both sql structures mentioned. The syntax is fine. The proof is that id does find the relevant records. I doubt parents is the problem since I have been using this for almost 7 years now! The db has been...

Perhaps I have not explained myself clearly. All I meant was when designing a query such as a delete query using the design grid, one can click a button on the top left which is called view and will see the list of records satisfying the criteria of the query. This is not the 'run' button...

of course! I was just saying that in the view it shows the relevant records so I know that the criteria is working correctly Thanks

Why does this sql not work? It brings up the records which satisfy the criteria if one clicks on the view button. Yet does not delete the records! No warning signs appear at all DELETE pupils.*, pupils.[Pupil ID] FROM pupils WHERE (((pupils.[Pupil ID])=[Forms]![Parents]![cmboPupilsDelete]))...

18 views and not a single comment!?

in a Dbthere are 2 fields which contain 'matching' data. (there are other columns too) A Genesis B Exodus C leviticus D Numbers E Deutronomy I want to shuffle both columns so they are both randomly mixed up B Numbers A Exodus C Detronomy E Leviticus D Genesis How do I do it? I have explored...

Thanks again but rnd is not really the problem as I can successfully produce a different order of records each time. What I need to do is jumble the 2 columns so I need to be able to take record 1 from field 1 and record 1 from field 2 and put them next to each other. To do this I need to link...

Thanks. Looking forward to your solution. I still have not been successful!

Thanks! I have tried that too. It isn't that simple to autonumber in a query -it is usually based on code outside the query so two queries using that code would end up with different numbers as the code does not restart for each query

I have read a lot about the rnd function to succesfully randomize the order of records in a db. I want to randomize 2 columns separately . These are Q's and A's so if the db is 2 fields (the second -small- letter is supposed to be under Field 2!) Field1 Field2 A a B b C c D...

No ! I think you have misunderstood me. I need a code which will loop thru each checkbox using for i =0 to end if "chkbox" & i = true then "txtbox" & i=visible etc Besides for that I need somewhere to store my choice and also of course something to list the fields Thanks

I would like to build a form which lists all fields of a report and has a checkbox next to each one. By the user ticking the boxes, they decide which fields are visible on a report. I could hardwire the whole thing, however, I would like this to be a stand alone module that I can put anywhere...

What is an escape character and can I write code to work around it? I'm afraid my client cannot be governed by 'Access rules'! Thanks

I have a dropdown combo which includes some entries which are bracketed e.g. [Bombay] But when the user types in that exact string with the brackets, it traps it as not on list, offers to add it and then hey presto the user has managed to tot up at least 10 of these entries all identical! Any...

Thanks ever so much for that explanation Jon. Does that apply to the "]" as well ? Do I have to put that in brackets i.e []] ?

I have some string entries as [Baghdad] (the square brackets are part of the string) If I query on "[Baghdad]" it finds them If I use "*baghdad]" it also finds them BUT if I query using like "[baghdad]" it does not find them Even stranger if I search on like "*[Baghdad]" it brings up about 70...

Did you ever solve this? Thanks

Did you ever solve this? Thanks

Did you ever solve this? Thanks