Search results

Depending on how you set it up, using a subform with Continuous Form selected in the "Default View" property might do the trick for you. Edited - Man, that Ken's a quick one.

This isn't very elegant, but is THIS what you meant? And if it is, then I'm sure ____ can find a better way to implement it, especially without triggering the VB code. All I did was put "Choose an option" in the Default Value property, as well as part of the Row Source. I've started to do this...

OH! The dreaded confirm box!!! NOBODY here likes THAT. Man, nothing frustrates me more throughout the day than the constant confirmation my computer asks from me. I click "SEND" and my computer asks "Are you sure you want to send?" I click "Log Out" and my computer asks "Are you sure you want...

I believe Access updates records by default when they're changed. There are ways to make it so Access will ask you whether you want to save changed records. Why, are your records NOT being updated when you close a form?

If you just want the form you created to open on startup, then go to Tools->Startup and choose the appropriate form from the "Display Form/Page" dropdown. If, however, you're trying to prevent users from having full access to your database (i.e. restricting design view, deactivating Shift-key...

Make sure you're in "Queries" in the database, then click on the "New" button. A window will appear with a list of some possible queries you can build/ways to build queries, including "Design View", "Simple Query Wizard", etc. The one you want is "Find Duplicates Query Wizard"

Hey ____, that's exactly what I was looking for w/r/t the menus - the removal of the "Go" button, however, has already raised some serious discussion around the office. Make the menus automatic...or make the user consciously accept the dropdown? Oooooooooh, what to do, what to do? :eek: :eek...

If you hang around awhile, you'll find that many of us patrol/troll the boards all day, and with users scattered all around the world (Europe, Australia, N. America, etc.), there's almost always someone handy to help. Well, you don't actually have to click Save to save your data, or changes to...

Funny, MS Word tells me that "ReAn" is spelled wrong, too. :D

This isn't a data thing - this is an 'object' thing. Access won't let you change the appearance of Forms while someone else is using the database. Two users can modify data to their hearts' content, but not the structure (i.e. Forms) of how you view the data. The solution is to do what ReAnn...

"Should"? No, I say we go with the Stalin approach to database design, and declare MUST absolutes. M_Tag - You'll find an option under Tools to split the database for you. It will put all the tables in a Backend (which Access will helpfully rename "YourDatabaseName_be.mdb"), linked to your...

Hey Maxmangion, I like your menus, although I think I'm more inclined to follow ____'s lead as I was already trying to use dropdown combo-boxes. I can see where the mouseover might be useful in other places, so thanks! Hey ____, how would the code change if, instead of form names for the values...

Oh, buddays. I have a hefty database with a series of full-size forms which act as navigational menus. The VicePrez has asked for some dropdown menus which will further open particular forms (to cut back on the number of buttons per screen). I tried using the combo-box dropdown wizard to put...

If you want Access to always ask you about record changes, you can go to Tools->Options->Edit/Find tab and then click the appropriate options in the "Confirm" area. If that's not what you're looking for, you can use some of the "Confirm Changes" code found elsewhere on these boards and put it...

As someone who's worked with Access since 95, but only started developing in earnest a year or three ago, I often find myself spending an inordinate amount of time going back and fixing silly mistakes - correcting naming conventions, correcting forms built on tables instead of queries...

:eek: Oh man, I bust out laughing when I read that - that was all I wanted from the beginning, and I had no idea what the function would be! I'm so oblivious; that's as obvious as eating food when you're hungry, or taking a nap when you're sleepy. WHY DIDN'T ACCESS HELP SHOW ME THAT AFTER HALF...

That makes sense, since each contract (actually its exhibits) will be related to each consultant, but I still want the chain to be grouped by year, according to the Date/Time fields of the tblCorrespondance and the year of the contract in tblContract, and I don't know VBA at all to pare down the...

You're probably right about the normalization issues; it gets away from me more often then I'd like. But there are some Real World restraints that made me set it up as I did, and I probably could use some help breaking out of the spreadsheet mentality. EVERY consultant with whom we work gets...

But what is that foreign key going to be? An extra field in tblCorrespondance and tblContracts where users have to put in "2004", as well as putting in the actual date of their correspondance as it occurs? That's what I'm currently using, and while it's working, it would be an improvement if I...

After lurking around the forums for a couple weeks, I've decided to undertake some DB redesign, and I could use some guidance towards achieving my goals. At my company, we send out a contract (consisting of many exhibits) to our consultants every year, while tracking correspondance with those...