Recent content by Steven.Ashby82

Thanks CJ I really appreciate your help, is there any examples out there of these points?

Good Morning All, I'm sure this has been asked in various levels but I haven't been able to find an answer suitable for my needs. I have created three databases and until now I have managed them by disabling options within the "Access Options" menu and subsequently entered the databases by...

Sorry, So i've attempted to use "best practice" I've a dependent cbo within my main table (JobSheet), I've designed the dependent cbo as numeric values with IDs and then used the 0cm column width trick in my form. The user select there name, the date etc and then selects from a drop down which...

Hopefully this will make sense. I'm compiling a monthly report based on data from my table "JobSheet" I want to count how many times last month a specific field was entered, it's a drop down list which is formed from it's own table "Problem" Is there a simple way of doing this?

Sorry Pat do you have an example of this I could see? Thanks

Thanks Pat, Although I've been fairly busy on here I'm still getting into the terminology and what not. I've heard of hidden controls before but not understood them. How do I do this? Kind Regards Steve

Dear All I'm having problems with my split form. (I know that is already causing some to scream no!) Is there a way to lock the row source fields in the properties menu as currently it keeps creating exceptions (WHERE) onto the end of the SQL this is subsequently causing me major issues in the...

Hi Guys I'll try and get to the point carefully. I have a form designed with only a combobox called 'cboTechnician' Once a value is selected from that box I then want it to open a form called modJobSheet and filter the records to only show the ones with the technician that was selected via...

Just to give a bit more detail I want to have a combobox called cboTechnician filter the entries on the Datasheet to only select that Technician. The field on the data sheet is called 'Technician' so I used the code... Private Sub cboTechnician_AfterUpdate() Me.Filter = "[Technician] =...

Is it possible to filter the table view of a split form based on both the date value on the form and the value of a cbo? Thank you

Sorry Paul, the form all this is for is the one called JobSheet I don't know what the hell is going on but I don't seem to be able to get anything to work. Everything just keeps kicking up errors.

Paul could you detail your method, I'm not following how to do this still? Or anyone Thank you

Ok guys, So I'm trying to create a new database which would replace a system that we (team) are currently using excel for. At the end of every day each team member (upto 10 people) have to complete a daily job sheet. This needs to contain the following... Technician Name Date Shift/Role Room...

If I try and change the field type then it deletes all the records. Everything is now displayed correctly in the table it just won't detect the values in the table on the form

Thanks Paul I've attached screenshots which will hopefully explain more