Search results

Ok well average turnover is around 5 techs a month so there shouldnt be to many in the list.. One thing i have just though though is this would only work with cards ive ordered for new starters and would take into account cards i order because someone has lost a card.

Ok well that field is already there as the record would be added on the techs start date, as he comes into the office for the whole day to do computer course and filling this out will be part of that process, so if best not to add anything to the fuel card table until the fuel card is actually...

Also can i delete the field FuelCardID from my TblTechs and just us the PK ID instead so my joins to Fuel Card would be TblTechs TblFuelCardAssignment TblFuelCard ID TechID FuelCardID...

Ok well the multiuser bit isnt really a problem as there will only really be one person updating this. i understand what your saying about adding a fuel card record BEFORE having all of the information, and you right its probably not the best way. the actual end goal, is to be able to know...

Ok so this is what ive now got. So the topic may not really be design based, but how can i create a record in the fuel card table based on just the fuel card required tick box in the TblTechs. Basically on my new starters form, there is the tick box to say that they require a fuel card...

So in the Fuel Card Junction table why would i have a field called FuelCardNumber would that not gets its value fromk the TblFuelCard? Sorry and another question, would the TblFuelCard and TblFuelCardAssignment be a one to one join, and a single fuel card could only ever be assigned to a single...

Yes im getting there, i think my biggest problem is understand that the table view is not how you see your data. so what happens if i now change a techs fuel card, so the id will now change but will his old card still be associated to him, so if i did a fuel report it would show whats hes spent...

ok so this is what ive now got now. Ive just realised thats wrong, i was thinking the fuel card to tech relationship was one to one as a tech can only have one card, but if a tech lost his card he would get another one so that would be another record, so this should be a one to many, the...

UserID (maybe) UserGroup Region FieldStore ReasonForLeaving (only if you want to establish domain integrity on this, not if it is to be freely entered) And, it's just a matter of preference, and ease of coding, the primary key PKTechAN I would rename to just ID. In my shop, we give every table...

Hi all below is my table design for Techs, i was wondering if this needs to be in more than one table??? PKTechAN TechID FirstName Surname EmployeeNumber DateOfBirth NationalInsuranceNumber DrivingLicenseNumber Town Address PostCode HomeNumber PersonalMobile WorkMobile UserID VirginEmailAddress...

Found it, many thanks, i had an after update macro that runs on the table which i forgot about, all sorted now.

Hi all, very new to this and trying to take on as much advice as possible, where im basically at the start of this, someone advised me to not use underscores and spaces in my field names, so i thought i would change my fields to suit this, now my problem is on one of the forms the identifer...

Hi all i know this is probably a very basic question, ive got a form that i enter a new starter into the business, this is recorded in my table Techs, on the form there is a tick box asking if the tech needs a fuel card, if he does i want a record to be added to the table FuelCard, but ive no...

More of a work around really I could capture and error but couldn't capture that 2427 the work around I used was on my filter form I used a dcount to say how many records the filter would find if it was zero it would disable the control button. Only problem now is I followed your advice about...

Ive tried to put the below in the control source of my text box but it brings a #NAME error =DCount([QryMissingData]![First_Name],[QryMissingData],[QryMissingData]![Start_Date] Between Date()-14 And Date()-20)

Hi all, i currently have a form that shows me how many records have missing data, on the menu form there is a traffic light system so when you click green it opens my form and shows all records under 20 days old amber does 20 to 30 and red over 30. Now what i want is 3 counters on that form...

i did use the ME. and Virgin_Email_Address did come up, i see what you mean now about no spaces or underscores, one question was does the NZ do??

Thank you mark for the help ive now modified my code. a couple of questions though, if im using the same error handle of both codes be it the button click on form1 or the current event of frmmissingdata, why is the error not picked up on form1, then when it does go to the current event why does...

Hi Mark ive just seen your response, many thanks for that but im now getting another error???

ok i resolved that problem only to run into another the new code is, Private Sub GreenFilter_Click() On Error GoTo err_Handler DoCmd.OpenForm "FrmMissingData", acNormal, , , acFormEdit, acWindowNormal DoCmd.Close acForm, "From1", acSavePrompt err_handler_exit: Exit Sub err_Handler: If...