Search results

Perfect.Thanks!!!!

Hi, Can someone help me with some vba code which is able to get the last updated or last modified value of an excel file stored in a folder in a shared drive and update a field on a form in ms access. Thanks Viren

Sorry here is the attachment

Hi, Thanks for your response. I have attached the database. There is a note on the main form that explains what i am trying to do. I hope it makes sense. cheers Viren

Hi guys, I have a table listing about 20 elements as field names eg FE, CR, NI, TI and so on. I have built a form which has a combo box listing these elements by selecting "fields" in the property settings of the combo box & next to this combo box i have 2 text box's where the user can input...

Thanks Peter, Your solution worked perfectly

Hi How do i check if any records exist in a subform... if there are records then tick checkbox , else untick. The code I 'm using doesnt seem to work If IsNull(Me.Unissued_material_list_subform) Then Me.Check92 = 0 Else Me.Check92 = -1 End Ifthanks.

Paul I had to set the visible property to false in the else clause. Thanks for your help

Hi Paul Thanks for a quick reply Attached is a sample db. When opening report (print preview), input "5401" in first parameter and leave the next two parameter's blank,

Hi I need the visibility of a line to change based on a field value Line : Line241(Visible property set to "NO") Field : Notes4 The code below does not seem to affect the visibility of the line241 Please Help! Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If...

Thank you!!. it works perfectly. Thanks for the quick reply.

Hi Can someone tell me what i am missing in the code below. what i want it to do is when "yes" is selected on msgbox then go to command1.set focus which is an OK button, if not set focus to the finish date field.. Thank you ! If me.Percent_Complete= "100" And me.M_Status = "Complete" Then...

Hi I have created tbl_A,tbl_ B & tbl_C. and appended them all to tbl_Main. I Have staff input info in the main table but this does not change related info in table a, b & c. how do i change this to reflect the changes . An example would be really helpful. Cheers !

Hi guys I am searching for a vb script that can copy a specific file from my local computer to an ftp:// site. Is this possible? i found a few code examples on the net but nothing seems to work. Please help!

Hi John The Dcount didnt work. but i tried .listcount and that works perfectly thank you for all your help.

Hi john Big Booty How does the dcount() function work? could you please send me an example. I m going to try the latest code you posted. i'll let you know if it works. cheers for your quick response

hi lagbolt When i hit the create button, if the combo box has any values it doesnt prompt with a msgbox.

it doesnt seem to like it. i have got the focus set to combo box (qengines )before running the if statement.

Hi guys Need help with an isnull function for a combo box. Combo box name : Qengines Record source for qengines is a query with criteria set to a value on the same form. When i hit command button (Create) on the form i want the combo box to check for null values. if it has values then...

thanks for your help KenHigg. cheers!