Search results

Hi, Is there a way in access which will show me how many users are currently using the db file. This should show up as a form label control property on my form banner? Any VBA code one can suggest!!

There is only one condition that of the number entered in the field already exists in the table it should ask this is duplicate but by clicked do you want to continue it should take the new number.

Hi, I'm looking for the before update VBA code which will ensure that when a value is entered into that field. It checks the table and returns message "this is a duplicate entry would you still like to continue" if no it should erase all entries. If yes it should continue updating from that...

Will this be part of on load form?.. Will help if you can provide the complete code.. Sorry

Hi I'm trying to set up a tab which should only be visible on load form function based on a text field value. Can someone suggest the VBA choose for this?

Hi Can someone help me with this, I plan to create a tab in access, which has text box and two buttons on it. when I click the 1st button "Get Me Next" it should get the record from an excel sheet. and when i click the 2nd button "Case Closed". this records should get save in an other excel...

Hi Sparks80, UR a genius man... I will implement it and confirm you the outcome...soon

hi, the table names are the names of the 16 advisors All have same field names and similar data type as well.

Hi, The problem is only the top management has access to MS Access, the subordinates here has only access to excel that to as "excel viewer" and viewing there own stat. is important for them that the reason . Hope this explains the necessity....

Hi, I want to do it for analysizing the data and to come up with a pivot table. for Management Information purpose... or is there a way where without combining those 16 link tables I can put all of them on excel on one go.....????

how can i achieve this when there are 16 link tables?(yes.. all have same field names). where will i input this code/query. b'coz after doing that i want to analysis the entire table in excel....!!!!

Hi I have a db , which has link tables from other separate access files.now within my db I want these links tables to be in one table again. how can i achieve this...

Hi All, Sorry for posting this query here. Can some one help me with this problem. I want a set of pages when copied from Adobe Reader individually to automatically append on the word file i am using , I want to use this function on Word occasionally so should also be able to stop the macro...

well..that good but what i was looking was like ham 25 cheese 1 chicken 1 etc... instead of a total count... !!!

well.. as of now its only on paper, can you please advise me how that can be achieved by simple steps... so that I can carry it out... sparks80 do you have a gmail id so that i can contact you directly...thanks

Hi, I've a form with some data input control. what I want is a window on the form itself, which acts as a counter on the no. of volumes I've entered. eg: my combo box contains values like Card Queries, Charge back, Authorization, etc. when ever I select the value and hit save. it should show...

Hi My dear friends, thank you one and all for the prompt response you have given. gud news is I was able to achieve this on another system and with that bit of confidence I managed to figure the problem as well... Next time I've a doubt I now know where to look for ...

sparks80, can you please make changes to my file and send it to me. as on my system i still feel this is not working... sorry for the trouble...

r u saying that refer to combo box is disabled when the form is loaded and only becomes enabled when the value "refer to tl" is selected from status combo box? If its working at your end .. i will surely try it on access 2003 as well...

Hi i am still not able to make it work , i am attaching the file can you please chk what is missing?