Recent content by TastyWheat

That did the trick! I'm very surprised. I didn't even consider that because I assumed it would eliminate any duplicates within a given column (not what I was looking for). I thought of this query earlier this morning and I was surprised it worked too because I thought you needed to use an...

This is probably a really simple query but I'm out of practice on SQL. I have a set of reservations and I need to get each email and any associated reservation dates, but I need to cut out dates that fall on the same day of the year. I've gotten my query to generate this so far: Email...

I did a search around the internet and found the solution. This is such an oddball thing I'm guessing this is an AC2007 bug. Open Access Options Select Current Database Uncheck "Enable Layout View for this database" See, that makes no sense.

Has anyone solved this problem? I'm having the same problem with an AC2007 database. I created a brand new form using the Form Wizard and it still didn't work. I believe records could be deleted in form view though (using the record selector and cut).

It seems like there's no way to use the shortcut menu (right-click) to sort a field on a report [in report view]. The filtering works fine, but the sorting options are disabled. Can I enable this functionality somehow or do I have to use code?

Viewing a report in Report View I don't have any problem filtering using the right-click menu or the Sort and Filter menu. However, any kind of sorting functionality is disabled. I can sort by changing the report properties or using code, but I want the menus to work so users can sort and...

Wow. Okay, that's good enough.

I want to use an ErrObject as a return value instead of a Boolean. So I can tell if the function worked, where it went wrong if it did (ErrObject.Source), and I can decide what to do with the error. I don't know exactly how the ErrObject.Raise function works but if that sets a new ErrObject...

If I use the global Err object as a return value and call Exit Function will my return value always come up with no error? I don't know a lot about the underlying implementation of VBA, but I'm assuming assignment statements are by reference and not by value. If it is by value then the above...

Once again all I had to do was ask the question so I could figure it out myself. This code got me what I wanted: RGX.MultiLine = True RGX.Global = False RGX.Pattern = "[\s\S]*?_____" text = RGX.Replace(ITM.Body, "_____") I thought that the '\W' or the '.' would've handled any kind of newline...

It might be my pattern that's wrong, rather than something being wrong with RegExp, but I'm unable to replace multiple lines of a string using one statement. Here's an example of my string: I'm looking to remove everything above the first set of underscores (in red). Here's the code I've...

On a different report I was able to filter the records with command buttons [on the report] so I assumed combo boxes would work the same way.

I've made a report and I wanted to add filtering options with combo boxes but the drop-down button on every box is invisible. I can click on the combo box and see the blinking text cursor, but I don't have the button or any kind of drop-down list.

Thanks! That's just what I was looking for. I know it's just aesthetic but it was still bugging the hell out of me.

I recently started using Access 2007 and I was expecting better command buttons but I'm still getting the same old crappy buttons. I included a picture of my button and one closer to what I would like. Is there some setting to get a better looking button or do I have to import a new control?