Search results

Still looking for help I'm still wishing for some help with this problem of mine. All help is very much appreciated!!!

I only want to change the field in the records that have the 'Yes' selected. When I run the 'master query' it lists all the items that I take on a trip. However, there are times when I only want to take a 'few' of the items on a weekend trip. So, after I run the 'master query' I select items...

Sorry to be so 'dumb' with coding. BUt I need all the help I can get. ***Where do I put the "The syntax for a garden-variety update query is: UPDATE table SET newvalue WHERE criteria"? *** **Here is the code that comes with the button to 'update' a query. ** Private Sub Command13_Click()...

How do I make it 'flip the values'. I've already got a button to run an 'update query'. But I need instructions on how the do the 'flip'. TIA

Is changing a field from yes to no the same thing as leaving the When I run the 'master' query, the yes/no field does not have a check in it, (i guess a check means Yes; and no check means No). If I select the items I want I check the Yes/No field. Now when I close the query, (after i'm done...

Is it possible to create a 'button' on a form that will 'deselect' all of the Yes/No's that I 'selected in a query. I have a query where I select items from a yes/no box by checking the box. What I would like the button to do is 'deselect' all the items I've checked. The query is a 'master'...

I have a query, "tripsupplies", that has 5 fields. (catagory, item, bike1, bike2, thistrip). That query, produces a 'check list' report that outputs all the items needed for bike1 and a different report for bike2. Both reports (bike1 & bike2) list every item per bike fine. However, now I...

I figured it out! If anyone is interested in knowing what I did it's the following: I used the DoCmd.GoToRecord......acNextRecord instead of SetFocus for my last tab. Can't say if this is the best way to make it happen, but at least it works! Thanks again to all who comtemplated my question!

I want to be able to tab to a new record when I have tabbed through the last tab control. I have a from with six tabs. What I would like to do is when I've tabbed my sixth tab I want to get a new record so I can input new info. The code below is what I have used so I can tab my pages...

Thank you for the code...but forgive me for asking a very dumb question!!! Where do I put the code? Do I create a button first and paste the code or does it go somewhere else? Like I said...I'm a beginner! Thanks again for your very patient help :)

Thanks Wayne for the reply. 1) I tried entering 'sounds' in the search and came up with lots! of unrelated info. How do I narrow the search since I'm new to this forum? 2) Is it possible to add a button to play the song on a form? I tried putting in the sound file using both hyperlink and...

I'm somewhat new to DB's especially when adding all the neat toys. I want to have a particular song play when ever a form is opened. How would I go about doing this. I would even consider having a button to activate the song. Again, how would I go about doing this. TIA