Search results

Greetings, I'm converting the, reworked, Instructor database to FE & BE. Creating the individual sections is not a problem; as they stand in MDB format, everything works. Things go awry when the FE is converted to to an MDE file. In 2010, a security warning appears upon opening (se Security...

Greetings, I am having trouble filling the Instructor_ID field in the TBL_Visa table, see attached file. The information is entered via FRM_NIE, which has the sub-form FRM_NIV embedded in it. The former uses QRY_NIE and the latter QRY_NIV. QRY_NIV has been inserted into QRY_NIE, in which the '*'...

It was solved through that thread. Hopefully the ADD won't make me forget;).

Greetings once again, I'm trying to understand how data is passed using foreign keys. I'm using Allen Browne's 'Don't use Yes/No fields to store preferences' at: http://allenbrowne.com/casu-23.html I've also downloaded his sample DB, RelationBasics, to use as a guide. Attached is my version of...

mike60smart. Yes, he's replied to the thread posted there.

Here's the real deal.

Mike?? Sorry, I've not been on this forum long enough to know this person. Also, looking at the database I uploaded, I realized it is the wrong one, as the relationship image does not match it. I will upload the correct version within 48 hours (it's at my very busy home). Thank you for your...

Greetings and Happy New Year, I hope you enjoyed, or are still enjoying, your holiday time. I have normalized the tables as per mike60smart’s diagram, http://www.utteraccess.com/forum/index.php?showtopic=2024487; the visa table was missed in that, but it is done in mine (see illustration). I...

I spelled out what I have done and will be doing as clear as possible. The company I work for uses Excel files as 'data bases'. I knew a little about true databases, but hadn't dealt with them until I made the attached one to #4. I tried to 'normalize' since I understood compartmentalization...

Greetings, Presently, we only keep track of the seminar and date for the Instructors. The table fields are: EmployeeNumber (Key) FUT1 FUT2 2IW PreCourse Math Nursery TOEFLiBT This was sufficient. Now the management wants to include the old style training reports (Excel ‘forms’) as part of...

Greetings, Currently, we have a table which contains a field for each type of training that can be taken (FUT1, FUT2, ...). Once an Instructor has taken one seminar, the table is populated with the date taken, via their employee number (the key) through an update form. Now, the company wants the...

JHB, Even though the code listed is for the other form, the method worked! I looked up LEFT JOIN and found out how to do it in the query, ICEFQ, which was mad to run with the form. Thanks a bunch! MNM

Greetings again, My continuing saga with the instructor database has hit another snag. I created a table to keep contact information such as address, phone number, and email address of instructors. I also modified the New Instructor Entry form to add an email address, since we usually have this...

Epologue A "Duh!" Moment The current contract start date shouldn't be "N/A", but if the Instructor resigns, the contract end date can. With this in mind, the start date code has been modified to: =Year([NichiiGakkanStart])+Int([MIS]/12) & "/" & Month([NichiiGakkanStart]) & "/" &...

Forum Members, This little problem is solved. I'd like to thank everyone who contributed to the final solution. Below are the codes used to calculate the start and and dates of the Instructor's current contract, which is 365 (366 for leap year) days long. Current Contract Start Date...

Thanks CazB.;) That was it. The test worked correctly in both cases. It ended up there because I navigated to it in the expression builder. Now that the test works, I can focus on creating the actual contract start and end dates. Cheers, MNM

OK. Tried Uncle Gizzmo's test. =IIf(IsNull([Instructor]![ResignationDate]),"YES","N/A") I get '#NAME?' :confused: MNM

Oh!:o A reply in another forum was more direct about the typo. FYI: in mathematics, there is an 'iff' statement, which means 'if and only if'. I'll correct it and report back Cheers, MNM

Chris, Go here: http://ss64.com/access/iif.html The site has Access, SQL, and VB script commands;) MNM

See my reply to Uncle Gizmo, If his idea didn't help, neither would yours, But I appreciate it nonetheless. MNM