Search results

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...

Thanks for all your help, I understand how the beforeupdate works, although I never considered a practical use for it! much appreciated - what a nice place this is!

yes, sorted. so the parent forms allowedits property is set to true, then when i load the foam I set it to false in VBA, and the subforms work. Thanks everyone!

yep, I change the parent forms allowedits attribute to ye and it works. Problem is i dont want to allow edits on the parent form. I have an 'Allow Edits' button on the parent form that changed the allowedits attribute to the yes in the VBA code, but that doesnt seem to have an effect on the...

Hi all, I've done a lot of searching on this and cannot find the answer I have form that contains a tab control. on that tab control I have a subform. I simply cannot get that subform to allow any input at all. I have a set of unbound text fields at the top of the subform that i use for...

Hi All, I am new here, looking at developing an access application with some level of user control built in. We are on a domain so the only people that will be able to access the database will authenticated users. However, I would like to be able to limit the users front end access based on...