Recent content by brianjessup

Thanks! Newman, I didn't try your suggestion yet, but ghudson, I did and wow that's awesome!!! Works like a charm. Thanks so much to both of you!

How would you play your own sound bites when you want?

The form's properties were set to not allow deletions...

Elsewhere in the code a search is performed, based on some criteria. When a record is found that matches the criteria the bookmark is stored in varEquipRecord(8)- I only allow 8 records (my Base is set to 1), if there are more found the user is notified that there may be a problem with the...

Can anyone think of why the following code wouldn't delete the record pointed to in the bookmark? When I run it, nothing gets deleted. Private Sub DeleteMyData(Subform As Integer) On Error GoTo Err_DeleteMyData Me.Bookmark = varEquipRecord(Subform) DoCmd.DoMenuItem acFormBar, acEditMenu, 8, ...

docmd.cancelevent will cancel you out of the event and thereby close the drop-down. Thanks!

I have a combobox that on the MouseDown event checks to see if it is Null or if there is previous data in it. If there is previous data in it, a pop-up window comes up giving the user some choices in what they are trying to do. All of the "change" options work fine. They return a value to the...

It's a bit foggy I know. That's only because I'm having to work around what I believe to be an Access limitation: Access won't store time down to millisec and still handle operations on it properly. I find this funny because I've managed to get Excel to work with millisec, so maybe I just...

Sorry, I wasn't sure what catagory it fit under.

I have a bit of a twichy on Change event problem. When I first load the form up and change a txtbox, the on change event seems to work fine (more on that later), doing exactly what it is supposed to do, which is loop through a series of records comparing the value I entered to the recordset to...

I have a bit of a twichy on Change event problem. When I first load the form up and change a txtbox, the on change event seems to work fine (more on that later), doing exactly what it is supposed to do, which is loop through a series of records comparing the value I entered to the recordset to...

That has worked fantastically! Thanks much!

How do you call a series of sequentially numbered variables? In a While loop I'd like to store the record bookmark to a variable. So Record1 = rst.bookmark the first time a record is accessed, then Record2 = rst.bookmark and so on. ("Record" & counter) = rst.bookmark doesn't seem to do the...

code correct Hi, Seems that my original code worked fine, it was just a type mismatch problem. Even though the controls were in integers and the rst fields were in integers, the controls read as strings for comparison in VBA. So to make it work, I had to Cint(control.column(0)) before...

form problem Hi, Seems that my original code worked fine, it was just a type mismatch problem. Even though the controls were in integers and the rst fields were in integers, the controls read as strings for comparison in VBA. So to make it work, I had to Cint(control.column(0)) before...