Search results

Finally I learn something new today, which make my day Thanks to all Be happy alway

Hi there Thanks for your help in advance I search over the form and learn how to create the simple Update query in VBA, BUT I am unable to break the UPDATE statement into multiple lines and now I am getting "Syntax Error in UPDATE statement" Following is the multiple line Update Statement Dim...

Thank you, it works perfectly Yahoo! I learn something today

Hello there I am total green in access specially in VBA world and trying to learn during my free time I am able to learn to learn how to assign values to LISTBOX, based on already created Query (using Wizard) Now I am trying to learn, HOW to create the query through VBA and assign to listbox...

Thanks works perfectly

Hi there I am trying to learn Access during my free time, to learn something I learn a lot through this web form Anyways, here's my situation, I am getting following error "MS Access can't find the field "|" referred in your expression" I am trying to validate the field behaviour before SAVE...

Hi there I am trying to learn Access, therefore, any help will be grateful I find the following CODE online (Print to PDF) Which work perfectly for me, the only issue and/or modification I am looking for "Popup Window to save the file at any location", instead at fixed location I would be...

Hi there I would love to know how i can save two textbox into one field I am totally green and using unbound form E.g. Input Year - Period - Month - # of working days 2014 - 01 - January - 22 2014 - 02 - February - 20 would like to save the record as follows 2014-01; January; 22...

Thanks Missinglinq I am using following update statement for editing/updating record with one unique variable field (however, my current table i don't have any unique field other than combination (Year & Month) field - hope i clear now, question is in "where statement", how i can use (year &...

How to check duplicate record before saving based on two variable

Hi Mihail, thanks I can understand update is working, but adding it creating duplicate record

Hi there I am newbie in access and trying to learn, based on different Thread I am able to learn how to Add/Update record including existence of record based on single unique field Now I trying to learn how to check existence of record on multiple field before adding (at least two) and how to...

Hi there I am not sure, but I usually try to learn access during my free time and I usually play at unfound form level, no table nothing Being an Accountant I usually try to create the different forms based on accountant requirements during my free time I am trying to develop a form in the...

Hi Pat It's just an example, there's no table behind the form, I just learning therefore, I usually play with form, I can understand that every month is separate record My question is, can I sum all the number which I put in the field in a particular field on the form just for viewing purpose...

Hi there I am totally new and trying to explore the Access during my free time, anyways, what I am looking for, is that to show the total/sum of the input fields (unbound form) I tried sum function in control source for "Total working day", but I am getting #Error...

Thanks and be happy always Now, it works perfectly

Hi there I using combo box as input to run the query and to show the result on the on the form, using subform feature (not sure correct approach) The only problem, when I select the value from using combo box the values on the subform does not change automatically even after pressing the run...

Hi there I am trying to learn the Access need help from the guru of Access Below are the code, which I am trying to use to update the field in a record, What I am trying to achieve, is once I press/click the update button, cursor needs to move to next desire field which is "txteditcid", but...

Thank you Bob I am just trying to play with Access during my free time at form level, which mean no table behind it Anyways, thanks for your help Be happy always

Thanks Bob I am trying to learn controls at form level (unbound form) Specially event behaviours how to control field with event e.g. at character field Private sub on change() if len(field name) > 10 then Msgbox "Field characters can't be more than 10" End if End Sub Same way, I want to...