Search results

I am using AC 2010 where i am having a query named Payrol through this query i am updating (Append) a table named Payroll everything is going fine but query geting slow on appending data and this slow increasing gradually after data of months increasing i have used multiples of formulas in this...

I have a table from time machine i am having two fields, Emid which is unique employee ID, Adate a date coming from machine in general date format, what i want that the employees are checking in out several times in a day i want a query to show IN as minimum time with respect to each day and...

I am looking for advance calculation suppose i have a Client table and have a CID as client ID now if i am recieving payments against Client ID and making Purchase again Client ID so the system to calculate previous advance first for e.g give advance to CID 360 is 2000 now purchase stuff from...

I have a main form "Registration" have two sub forms one name is ADJ second name is SERVS i have a command button on main form to open another form i am opening that form fine when i closing that outside form i want to set focus on second subform i.e. SERVS of the main form Registration, with...

Thats Perfect !!! Thanks a billion

First of all thank you very much for your valuable reply, now i tell you that i exactly required what u mentioned above above i am not getting how and where to use this function i am not very much handy with vba if kindly elloborate this as i am mentioning you my exact field names, Table TOK...

Thanks for the reply! Sorry i think i missed something during explanation above, I am having an OPD for in that form i had a field token i want with todays date the token to be populated automaticaly but with below mentioned criteria, like to increase token number from 1 to so one for one...

I have a table with a field OD_Number now in form i want a command button to restart numbering from 1 till so on unless again the command button pressed to start numbering from 1

Thanks work done !!!:D

Regards I am looking to get solution for the warning messages that comes with append, delete, update query and more.. I want this to be done by VBA which i will do subjectively but wanna stop this query popups or message

Regards, Me using access 2010, i need a VBA to copy all records from the current row and paste in new record. I will use "on exit event" of form last field that will copy current and will paste in new row. looking for vba

Regards, I have a DB created in AC2010 could anyone tell me how i can use it online through internet is it possible ?

Could you please guide how to do this ?

I have a DB created in MSAccess 2010 i have a problem that i have created it in my laptop and when i am copying it on my desktop with same access 2010 and same windows 64bit but it is causing different errors like out of memory and some others. Then if i open visual basic reference and i am not...

Correct and Apology for that really,, Yep i got the desired result as what you given instructions, actually i was not confident about the parameters but now its okay.. Thanks a billion for you and Minty and well

Right but tried no result

Regards I have a crosstab query and which is doing fine for me, what i need more is to get a date range criteria based on form as below; Between [Forms]![frmReports]![fdate] And [Forms]![frmReports]![TDate] I have a Tdate field in query which i want that rest all calculation (sum) to be made...

ok i will post you once it again happen

i have sometimes getting error on on click event of a command button to open a form, and sometimes it works ok i have written the code like this; me.refresh docmd.openform... so on whats wrong here as this works fine sometime and sometime error saying the "on click event of the ..... produce...

Tested done and absolutely accurate to my requirement.. Thanks a lot Markk...