Search results

:eek: Hmm, not sure if thats exactly what i want. Ok let me break it down: Tables and there content EmployeeDetails = Info on the Employee. Each Employee has a unique ID Courses = The details of each course. Each Course has a unique ID CoursesAttendees = List of all of the...

My EmployeeId is the PK and allows no Nulls, so it returned no records in my combo. I was thinking wont i need to have the row source something similar to this? SELECT EmployeeDetails.EmployeeDetailsEmployeeID, EmployeeDetails.EmployeeDetailsForename & ' ' &...

My EmployeeId is the PK and allows no Nulls, so it returned no records in my combo. I was thinking wont i need to have the row source something similar to this? SELECT EmployeeDetails.EmployeeDetailsEmployeeID, EmployeeDetails.EmployeeDetailsForename & ' ' &...

I am looking to be able to select multiple people to one course, i use a subform on my course bookings form and i want to be able to quickly select people which havent been previously selected in the above record, if that makes sense.

SELECT EmployeeDetails.EmployeeDetailsEmployeeID, EmployeeDetails.EmployeeDetailsForename+' '+EmployeeDetails.EmployeeDetailsSurname AS FullName FROM EmployeeDetails LEFT JOIN CoursesAttendees ON EmployeeDetails.EmployeeDetailsEmployeeID = CoursesAttendees.nEmployeeID

Ive done the join, how do i limit to only include the rowsource where the table is null, and where do i put this? Sorry im just a beginner.

I have a continous form which has 1 field in which is a combo box which has a list of names. Once you select a name, the next record down is available for selection. This is because my tables PK is a autonumber. How do i filter the records to only show the names which have not been previously...

And how would i do that?

Hi, I have a 20 filtered dropdown selections, but you can only see 1 at a time. So once you fill in the 1st dropdown the other appears to select what name you want. I need to know, if say Joe Bloggs was selected in the first dropdown, i dont want him to appear in the second dropdown or any...

Hi, Ive just recently changed my database from a *.MDB to a *.ACCDB. Once i done this my ''New ADODB Recordet" no longer exists. and i ashume i need to use a DAO recordset. I need to add a new record and make the employeeId to + 1. Here is my code i had with the ADODB recordset. Can someone...

JHB, That didnt seem to work. It give me run-time error '2448' Any Suggestions?

Hi, Ive recently changed my table from a *.MDB to a *.ACCDB and ive found an error which worked fine in *.MDB format but when i changed it over it gives me and error. Im wanting to change a field value from "Active" to "Archive" if i click on the archive button. Here is my code: The red...

Hi, I am creating a training database and i have a courses table. and i need to somehow record all of the different employees that attended a course? Any ideas on what i can do to make this happen? My employees have an employee number so is there a way of putting all of the employees...

Ive tried a me.refresh on the on click event of the tab i want to refresh but this doesnt seem to work. What do you suggest i do to get this working how i want it then?

Hi, I have 2 issues. I am new to vba coding and i am creating a new training management database for a colleague. Firstly i have a tab control which has 2 tabs, a required course tab which is a list of the courses that a enployee needs to take and i have a course dates tab which is the dates...

I have a database with alot of data regarding maintenance jobs. I can create reports no bother from queries... but I want a more flexible way of doing the reports. I have a dropdown list with all the different buildings the maintenance team go to, so when I select that building from the drop...

I have a database with alot of data regarding maintenance jobs. I can create reports no bother from queries... but I want a more flexible way of doing the reports. I have a dropdown list with all the different buildings the maintenance team go to, so when I select that building from the drop...