Search results

Hi there During my free time I try to learn Access and/or other applications and with the help of ONLINE forums I really learn a lot Anyways, Now I am trying to learn/create Company's Fiscal Calendar I am using following approach, but unable to figure-it-out how to handle this Therefore, need...

Hi there, please be patience English is not my first language, therefore, nor I am technical persons in terms of explain my situation related to Access First and foremost I am not professional developer nor I have any advance level skills and or any formal education, however, based on...

Hi there During my free time I try to learn, so bear with my wish list Here, what I am trying to learn, that background of the form change its colour automatically after sometime let say 1 min or after 2 min I find the link on the web where more than 500 colour code are available, but not...

Hi there I am just trying to learn during my free time Anyways, I am trying to learn display counter I try to google but unable to find anything what I am looking for Below is my code, which works, but only problem is result shows once counting is done - whereas I am interested in upon changing...

Hello New to this world, just trying to learning during my free time specially during the weekend I have table [table1] which have 4 fields EMPID - primary key EMPFirstname EMPLastname EMPDOB Input box as txtempid as string I am trying to learn how I to display other field based on one...

Hi there I am totally new in VBA, just trying to learning during my free time with help you forum, I have a very basic question I am trying to use Public Function and getting Runtime Error upon execution Here's is my simple code Public Function CCname() Dim cname As String cname =...

I am looking for Access VBA code to count number of Day Name in given range e.g. March 01, 2014 to March 31, 2014 Mon = 5 Tue = 4 Wed = 4 Thu = 4 Fri = 4 Sat = 5 Sun = 5 Thanks in advance

i have question, I am trying to learn Access during my free time Here is my question, i am trying to calculate the working days Based on all web searches I am unable to find the specific scenario I am working in Auto industry, which means auto industry usually close twice a year for any reasons...

I am totally new in Access VBA, plus I am trying to learn during my free time, I am able to create the following Unmatched query (using Wizard), but now I am trying to learn using VBA code Table1 Curr CurrName CAD Canadian Dollar USD American Dollar...

To all Guru of Access I am totally green in VBA world and trying to learn therefore, need special help from Access’s Guru What I am trying to learn, to filter the record based on combo box value and find the unmatched data between two tables, instead of using in build query, I am trying to use...

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

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

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

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

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