Search results

Greetings, I'm having an issue with two similar forms which change the status of Instructors and Students from 'Atcive' to 'Inactive' with a checkbox, See attached Form Issue ZIP file. Whenever a student's or Instructor's status is changed, the name is written over with the table's ID number...

Greetings again, For those involved, so far the lesson record BD is running well. However, I wanted to ensure data accuracy for a certain case. I added the unique Student Id (ManabiID) control to the Student Status form (see attached). My intention is to have the ID update to the correct value...

Greetings once again, I created a database to record lesson information (see attached sample). When there was only one student per record, everything worked fantastic. However, management would like to have one record per lesson, which means that up to eight students would need to be accounted...

Greetings, I have a BE database, that when opened, opens a form for saving the results of a query to a text file on the desktop. It works fine, if the full path is entered. The problem is, I want this saved on any users' desktop. I did some digging and found the %userprofile% variable, which...

Greetings, I have a form on which are two combo boxes. In the first, the user selects a course type. In the second, the user selects the text for that type of course. I've gotten the second control to filter the appropriate texts. The problem lies with the "Private Course". For this case, I...

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 '*'...

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

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

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

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

Greetings again, Well now that the Months in Service coding is working properly (99.999%), I would like to use this calculation a bit further. I've set up another textbox, Current Contract (Textbox name: CCN), with the coding: =Int((MIS/12)+1) This works fine as well. It's using this result...

Gretings, My employer is using Windows XP Pro and Office 2003 (a few machines have Office 2010, but not mine). Furthermore, the machines are running the Japanese language OS, which has caused some compatability issues with my English XP/Office 2003 at home. I have a form containing an...

Greetings, I have more problems with this project I'm building. Suddenly one of the forms has decided not to open. The attached JPEG shows the dialogue box that opens. In one copy of the DB, only one form is affected. However, in another copy, all three forms built on the same Dynamic Multi...

Greetings, I am in need of more assistance. My apologies if this is in the wrong place. I have a form, which is bound to a table, with an unbound textbox. I am trying to get the number of months an employee has/had worked. In the table are two dates, Company Start Date, and Resignation Date...

Greetings, I am new to access and have found some great tip sites online, including this one. However, I cannot find a tip on what I am trying to accomplish at this time. I am unsure as to post this as it pertains to reports, forms and VBA, so if it gets moved I hope I get an email informing me...

Greetings, My name is Mark, and I'm from the U.S. (don't hold that against me, please as I was born this way). I currently reside and work in Japan. I currently work in the 'Training and Guidance' section of a company. I have never really used Access, but I am plugging away at developing a...