Recent content by jamiesuperman420

This will sound very lame - but I changed my settings from "Disable all macros with notification" to "Enable all macros" and it works!! I never had any notifications... but your success made me give it a shot. Thanks, Alansidman!! ...now if I can only get my 6 hours back.

Well, that's good and bad!! ANY idea of a setting that might be triggering it?? Thank you for taking the time to look!!

Hello!! SEEMS LIKE the Combo Box populates fields if I build it from scratch, but then stops working after closing and re-opening the database. I've been struggling for hours and hours, so hopefully you can help!! COMBO BOX SQL: SELECT Employees.ID, Employees.LastName, Employees.FirstName...

Hello!! I designed a database for a company and installed it, which included splitting the database since upwards of 20 people use it at a time. They recently asked me to add a new feature but MS Access won't let me alter the original table because the database was split. Can I localize the...

I guess it should be Multiple Criteria, eh?? Oops!!

Hello!! Here's what I'm trying to do: Make a query that returns results specifically for certain months, separated by county. Here's what I have done: Made it so the counties are separated and they add up the fees if they're active. CC: IIf([PropertyCounty]="Los Angeles" And [SC...

Ah, that must be it - it's Access 2000. Well, good!! Less work for me!! Thank you - I'll just tell 'em to go to File > Export if they want it in Excel.

Hello!! I want to add an "Export To Excel" button in a report. When I add the button and go to properties, there are no options for events or data. I'm trying to put the button in the Report Header... Am I doing something wrong or is it impossible?? Thank you!!

As always, you send me down the right path. Thank you very much!!

I should add: I THINK Find is a little tough to use because you can't "GetFocus" on what I'm trying to search (in an effort to prevent people from changing the information). I want it to open all the records, I just want it to goto the one with the matching [Code]. I hope this all makes sense...

Hello there!! I have a form (SearchCode) that's used to search for a "Code" that's chosen from a combo box. When you hit the "Search" button it opens the proper form (Central) and displays the corresponding [Code] which works perfectly fine(!!) - HOWEVER, it also automatically filters it so...

Ah!! Of course - works great now... Great eye and thank you for the help again!!

Paul - here's the DB stripped down to the current issue. Thank you very much for your help - I'm sure it's something simple and I just can't see it.

Good point about the focus, I double checked that and still no avail. Here's the SQL: UPDATE Central SET Central.Code = [Forms]![zzzUpdateTest]![NewCode] WHERE (((Central.Code)=[Forms]![zzzUpdateTest]![OldCode])); When I run it without the form open, it asks for OldCode, but doesn't ask for...

Thank you so much for your constant help :) I can't quite get it working. Due to the potential for error, I'd like it to be on a form where they can select the [OldCode] from a list, and type in the [NewCode], then hit that button. I can get it to work but it always says, "Replaced 0 rows"...