Search results

Indeed - much cleaner - thank you! Using all those individual tests instead of a simple loop... /me smacks forhead - HARD --Idiot Mac

Public Thanks ...and another 9.9% coming from the rest of the forum gurus, who (IMNSHO) don't get enough gratitude. My deep thanks and appreciation to all those who have helped me and everyone else so much around here, including (but not limited to): Mile-O-Phile Rich Collin Essex The_Doc_Man...

At that point I suddenly recalled the way we used to figure out if a number was even or not by comparing the results of (number/2) with INT(number/2). At least, I used to use that as a test, back on my C64 :rolleyes: Anyway, using the same idea and a known date (Jan 1, 2001 was a Monday), I...

So Pat, would you set the Index property to "Yes - NoDuplicates" in the table design and then trap the error at the FORM level? Would you do that in the control (for that field), in AfterUpdate event or it's ValidationRule? Or somewhere else? -- Greenhorn Mac

Me Love Pat Of course, that's true of about 90% of what I know...

Excellent. Thanks! --Always-Learning Mac

Brian: Another trick lots of folks use is to declare a public constant at the top of one of their modules: Public Const QUOTE As String = """" Then you can use this everywhere you need to add quote literals within a string: If IsNull(DLookup("[Password]", "tblCustomer", "[Password] = " & QUOTE...

Jack - Out of curiousity, why not just set the AllowDuplicates property to No in the table's design? --Curious Mac

Chris: There's lots of code and info in the forum archives on this, as it's been covered many times. Search for the phrase "notinlist" and you're bound to find the answer. --Searching Mac

What's missing there is the other side of the operation. You can't just pass the form an openarg and expect it to know what you want done with it--you have to have code in the OnLoad event of the second form that takes the openarg and puts it in the control you want it in. That said, I would...

You will also need to put criteria on the column of your query that contains the employee in question. Also, search Access help on the Nz function to handle controls that are left empty. But yes, it will work "any data [you] type in". --Fan-Of-Mile Mac

First, you're setting yourself up to lose some data, since you're copying the text of a memo field into a text field of limited length. That said, dcx gave you a straightforward solution--it may be that you need to clarify the problem a little more. Is your difficulty in copying the info at...

The first place to try might be the Database Splitter Wizard. Search Access help. --Split Mac

One table each for: Rooms, Stations, Staff, Departments, Equipment, EquipmentTypes (monitor, desktop, printer...). Your workhorse will be tblEquipment: autoEquipmentKey txtEquipmentSerialNumber fkEquipmentTypeID fkStationID fkStaffID mmoEquipmentNotes (no need to store related rooms here...

Which Ones? D -- Not sure which of these many tables I'm supposed to be commenting on. Suggest you start a fresh project and import only the "current" version of your structure. Based on what I see, though, I would say you can consolidate substantially. You don't need a separate table for...

Insufficient Data You're going to need to fill in some more details. Is each Staff member related to only one room? To only one workstation? Also, tblInventory doesn't need to relate to all four tables--so far, just tblStations and tblStaff. Based on your description, your tables thus far...

Testify! This kind of thing is exactly why you want to get your table structure right from the beginning. Adding something new later is almost impossible if your app consists of a million work-arounds. If you have good design & structure, however, you should be able to look at your db and...

Return to the Beginning You definitely need to rethink your structure. On the current topic, the way you're trying to set this up means that your DB will have no "memory" of any past transactions--just whether the tenant has paid their current month's rent or not. Also, as Rich advised you on...

(1) Why do you "need" the values in the PK field to be consecutive? (2) Have you searched the forum archives? This general topic has been covered many times. --Dual Mac

:( No file? --Searching Mac