Recent content by Coxylaad

edit, made it even easier by setting the master field to be [cbCustomerContact].[Value] I mustnt have been happy that i was just reference the field of the current record and not a specific item on the form.

I've managed to sort it. it just wouldnt work when trying to link a combobox with the contactid as a control source, so I created a text box and populated it with the contactID on the afterupdate event, then linked that with the subform. works perfectly. weird.

Hi everyone, I have a bit of a strange on here. I have a form that displays estimate details for a customer. part of the estimate record is the ContactID, that references the contact in the CustomerContact table. I have a combobox on the estimate form that is bound to the contactID and...

very true. Im really loving developing in access, its so easy to get on with

Oh my god. so sorry, thats working, its the weekday field thats a day out! Well that was embarrasing!

well I do 😄

yes that is correct, now instead of using todays date, try using this sunday 10/04/2022 It puts the sunday in the wrong week

Hi All, Im building a date dimension table with all sorts of values in for a given date. one of the things I was to build is for a given date, I want to be able to reference the first and last day of the week. My working week goes from Monday to sunday. Ive wrote a little module to...

I get that. and I am aware of what I was trying to do, the issue I was trying to avoid was the engineers being able to see all their data, as well as every piece of data every other engineer has uploaded also. So approaching this from the other end, if I create a sharepoint list to contain all...

Hi Everyone, I'm looking for a bit of advice, I am planning to smarten up our timesheet entry process at work, and integrating it into my new access database. The plan is to have a sharepoint folder for each field engineer, and on the click of a button access will create a blank custom...

this looks exactly like what I am trying to build - where abouts is the ribbon form!?!

thanks, so far access has allowed me to speed up the development of this project. I was originally using .net but access is so much more user friendly.

ive managed to get it working, so I changed the even to 'onkeypress' put this in it Private Sub fltrEstimateID_KeyPress(KeyAscii As Integer) If KeyAscii = 9 Then Call btnfltr_Click End If End Sub so it checks for the tab key being pressed, (09) and it runs the filter code when it detects...

yes it does fire when i exit the textbox, but what happens is the code runs and something makes the focus stay on the current textbox and not move to the next one

Hello again, Looking for a bit of advice, I am building a filter panel at the top of my form to filter the results displayed on the form. I have 3 or 4 textboxes. I am using the 'on exit' event to trigger the filter code to build and apply the filters, and its working, however its not...