Search results

DCrake, you set me on the path to my ultimate victory over this problem. It actually wasn't solved by a module, but when you told me to create the FiscalYear:FinYear([YourDateFieldHere]), it gave me a compile error. I was sure I was doing something wrong, so I ranged Google on it. Microsoft...

This has inspired me to check out the use of modules (something I'm not versed with), and this is an excellent start, I thank you, and I apologize for having more questions: Could you explain the function of the slash? I'm trying to work this code out (I love to learn), but I'm not figuring...

I realize after I had had the nervous breakdown and almost got fired that I never replied to this thread. Thank you both for your help, in the end you did help me understand all of this, and my database has a sane, workably normalized (I don't have separate tables for cities and states)...

I have a query that I need to return results for the current fiscal year (runs 1 June to 31 May) for a database of events. I got code help from another forum that I thought would work, but it's returning a blank sheet and I can't figure out why. The sql for the entire query is: SELECT...

Nono, reps aren't subhuman, it's just that they're filling possibly 2 roles, one of being a warm body at the meeting, and one of being the rep who covers the doc. A rep may cover a doc and not go, or cover a rep and go. I just figured if John Smith was a rep for Dr. Jones, then John Smith...

It wouldn't be backtracking. You'd just be connecting everything with keys, and all of that should be able to be displayed in a form. So the thing looks and sees Hamburger is Item 1 Food Type 1, and a form can draw out the fact For item one, this table says it's Hamburger and this table says...

The tbl_ITEMS would have, say, 3 fields. PK, FK (From tbl_ITEM TYPE), Name. Try to not think of your objects as food and drink, think of them as objects which are CATEGORIZED as food and drink from another table. So you'd have Item 1, Hamburger, the FK for Food. Item 2, Wine, the FK for...

Oh wait. Also, since you're adding an Item Type table, couldn't you just get rid of one of your first 2 tables? For example, you'd just have tbl_Items, and in it would be your PK and description (let's say item 1 is hamburger, item 2 is soda). Now you've got your item type table, as a one to...

I'm even newer to normalization (3 hours), but I think you don't want people into your tables. You can tie all of those together with a form, and use combo boxes to make the filters you mentioned, non?. Wouldn't the Item Type Id just be another FK in Sales_Item_ID? Maybe I'm too new to be...

Help making Normalization seem normal? I'm really not trying to ask noob questions, I promise I'm trying, but there are just some things I can't get my head around. I've finally got an opportunity to make a database the way I want. The boss who demanded messy database structure is gone, the...

Thank you. Honestly, I don't question anyone's knowhow here. I know what the databases SHOULD be, truly. And I've been trying to get the boss to accept facts for 3 years now. Even to get to where I am has been a struggle (you should have seen the week-long argument over using if/ then fields...

There was an add-on that I purchased to make my job here easier. It's called 'Find and Replace'. It let me create a new database for a new meeting (my databases deal with meetings), find table names within the various and sundry queries and forms, and replace them with the new table names...

Thanks Doc Man. I don't have a virgin machine unfortunately. Everything's been upgraded at the insistence of my VP. Strangely, IT grumbled about the upgrade, but I got no resistance on the access downgrade. I'm not exactly satisfied with 97, but until I can learn how to make certain things...

I know that the day will come when there will be no choice but to go with Access 2k7. But: I'm waiting for a day when I actually learn how to import my forms and reports from 97 to 2007 withough having to recreate them - most especially with regards to unbound controls, lookup boxes that...

Same thing happened. Any way to register the older .dll's just so it will run the import wizard? Is there any way to import this spreadsheet without the use of the wizard? Or any way to run excel 97 alongside 2007? I need the 2007 features in excel, I can't roll that back or I'm sunk.

My MS Office had been upgraded from Access 97 and Office 2k to Office 2k7. I had to get Access rolled back to 97, and that worked fine. When I try to import or link an .xls table (created in Excel 2007, but saved as an .xls file), the wizard itself gives me errors. First it says: There is...