Search results

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"...

Hello!! I'm building an inefficient database and need your help. There's a field called "Code" that is important to several forms/tables. Because I'm great at setting this up, if I change it in one spot it doesn't automatically update all the others. What I'm trying to do is make a form...

For anyone else who has this problem, I think I figured it out: Before installing MS Access Runtime there is NO MS Access file on the computer... AFTER installing it, one shows up in the Office12 folder under Programs/MS Office/ folder... What's strange is that it SAYS it was last modified...

Hello... I need to install Runtime on my machines, which is no problem. What IS the problem is tying it in with the security file. As you know, when you use the security wizard it creates a shortcut that links the password file with the database file with MS Access. Typically it links it to...

Ah, there I go again - thinking it's going to be harder than it is. Again, thank you very much for the help. I'll open my eyes a wee bit next time!!

I can't figure out where / how to stick Orderby in... Sorry for my lack of independence and thank you for your help.