Search results

Dear experts, Would like to ask your advice. My QA department asked me to make a small Access database where staff can watch video tutorials. As the video's are company owned, they aren't allowed to access and download them directly so idea is that they access a dbse and then can select a...

Dear experts, I'm breaking my head over the correct setup of my tables in order to be able to enter value in a combobox based on the selection in another combox in the form :banghead: The database I'm trying to build will keep track of all office related purchase records (desks...

Hi Everyone, My first post for 2016. Happy New Year! I'm getting a return without GoSub (Error 3) the first time I open the main form when I start my dbse. The form shows several labels which give a count result. Private Sub Form_Current() If Me.NewRecord Then...

Works perfectly, thanks!

OK,thanks for your help!

Dear access experts, I've been browsing the Modules & VBA discussion groups in the hope to find a VBA code example for sending a record to Outlook. I don't want it to be sent as an attachment but in the body of the e-mail which the user then can send out to his recipient(s). Hence once the...

dear arnelgp, Thanks. When I open the form and place the cursor over the hyperlink the first time it shows a pointing finger. Once I click on the link and open the form behind the link I need to refesh the form to get this pointing finger back. I'm looking for a way to get this pointing finger...

Dear Experts, Appreciate if you could help me out with the VBA code for displaying record count of a subform in a label on the main form. I found following code to display record count in a label. Private Sub Form_Current() If Me.NewRecord Then Me.lblEvent.Caption = _...

hi everyone, I have a hyperlink on my main form (frmMainMenu) which, onclick opens another form (frmSlowSteaming). When I close that form I return to the main form but need to click the refresh all button in the home tab to be able to use the hyperlink again. Can I reffresh this action...

Dear JHB thanks for your help, indeed 2 corrections in the code Control Source: = Format([TakeOverDate];"mm/dd/yyyy hh:nn")

Befor I confuse you more. Attached screenshot of the properties.

CORRECTION: I renamed the textbox: Name: DateOfDelivery Control Source: Format([TakeOverDate],"mm/dd/yyyy hh:nn") Still getting the #Name? error in the texbox on the form? Box is marked with: This control has an invalid source. What am I missing?

I renamed the textbox: Name:DateOfTakeOver Control Source: Format([TakeOverDate],"mm/dd/yyyy hh:nn") Still getting the #Name? error in the texbox on the form? Box is marked with: This control has an invalid source. What am I missing?

Dear Smig, I need date with time e.g. 07/11/2015 14:45. Dear JHB, I've entered the code in the Control Source ofthe Text Box DeliveryDate but when I go to the form the box displays #Name?

Dear Access experts, Can you help me out with subject error? I'm trying to display the date and time entry in the textbox DeliveryDate on my form frmVessels without the seconds, but keep getting #Name? and #Type? errors. I'm spuzzled...:confused: Made following module: Public Function...

Thank you Uncle Gizmo!

Dear Access experts, Would like to ask your help. I'm building a dbse in Access 2013 to centralize certain data about the vessels we are managing. I want to get rid of the dozen of excel files, with incomplete and or duplicate information, and consolidate all information into this dbse...

That solved the problem. Thanks

Would like to ask your advice, I was trying out following option: Using following function: Option Compare Database Public Function CalcAge(DeliveryDate As Date) As String Dim intYears As Integer, intMonths As Integer, intDays As Integer intMonths = DateDiff("m", DeliveryDate, Date)...

Thanks Plog & Jdaw for your reply and feedback, appreciate your help with my question. I started doubting on when to use a junction table with a distinct primary key and when to use one with composite keys. I got confused about this and thought that only one of both options would be correct...