Search results

Any chance anyone has the updated code for Access 2007? I loaded it and let Access do the update on the code, but it has user defined security parameters that fail. I am planning on using this script for the model for lots of other reports and was wondering if it is possible to add a module...

I am using Access 2007. The issue I was having was on table creation. I also see the issue of deleting a record and Access assigning the next number. I assumed that was because the record was was already assigned the unique ID and Access would not reassign. I have not tried to delete a...

After having the previously discussed issue numerous times. I created the table structure and without adding data, saves the table adn that seems to have solved the issue. I have no idea the cause of the autonumber wierdness, but at least I found a work around

I was just creating a table with the default ID with autonumber in place and as I would tab across the table to add data to the first record, the autonumber would increase with each tab. I tried to delete the record and add a new record and it took the next number. Then I deleted the table and...

ok, so in an attempt to work all this stuff through...I created three tables. tbl_Job: JobID (PK), Job Title tbl_Courses: CourseID (PK), CourseName, Expiration jtbl_ReqTraining: JobID (PK), CourseID (PK), Required (Y/N) So I complete the table with all courses by id and jobs by id and...

must have had it open...once again I have shown what a noob am I. Thanks. Everytime I get some sample db to look at I can learn how to make on. Thanks for the sample.

Rainmain...I tried your db. I typed in a person who was not on the employee list and the box appeared asking to add the employee so I selected yes. The problem was the employee was added to the combobox, but does not appear on the tblEmployee. Any idea why?

Thank you for that link, I have been reading and it is already helpful. I am working on my Db design now. I have started to identify the data to which I will capture and am working on the questions I need to have answered from that data. I am definitely buying a book this weekend as well. I...

So moving this from the forms section. I have a table (tbl_CourseList) of training course (CourseID, CourseName, ExpirationPeriod) and I have a table (tbl_NCS_Role) of Job Roles (NCS_Role, TDLR_Code). To clarify the TDLR is a code which could be made of multiple NCS_Role records (e.g. roles...

Thanks, I will have to do some research on junction tables and see if I can get that to work. I think I will have to move this to tables for further discussion. Thanks Bob.

I am fairly new and have not found what I need through searches. If you have a link to something that could help, that would be great. I have a form for a Required Training table. The table contains the Course ID, Course Name, Job Titles. Each Job title is set to a yes/no to indicate if the...

You need to chage the Visible format on the property sheet to No. This will cause the selected item to not show on the load. Then add an AfterUpdate code to make the next combobox visible.

Yes that worked, I don't know what I was doing wrong. Maybe google-eyed from tryign to do this all day. I will move on from this to convert to VBA so I can learn more. Thank you very much Bob, you have been a tremendous help already. I am sucking up because I will have many more questions...

Thank you for the welcome. So how much trouble am I in if I couldn't do what you suggested? I have the table built with some made-up data. I used the create form to make the form with all of the data from the table. No problem. I added the combobox using the wizard to the header, but the...

I am a total noob to Access (this is day 1), though I did teach myself VBA in Excel. I am having a lot of trouble with this and I am not sure if it is my thought approach or that I am not comfortably finding the automation in 2007 fun. I am trying to make a simple employee training dB and...