Search results

  1. S

    Great Trouble need VBA or something

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

    Check in out

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

    Advance Calculation

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

    Set Focus

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

    Restart Numbering

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

    Warning messages

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

    Copy Paste form Record

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

    Online Access Database

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

    Copy Paste error of DB

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

    CrossTab Query Date Range

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

    Error on Click of command button

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

    Month Name from Date range

    I have two date fields in table one is "From" and another is "To" i want in query or report that suppose if date from is 31/08/2016 and to is 30/11/2016 then month name should be displayed like this in new query field or report text box Aug-16,Sept-16,Oct-16,Nov-16
  13. S

    Error on audit trail

    i have a module which i have copied, but in other forms it is working ok but in my form sales form it is working and filling audit trail table with updates but with a error msg "Operation is not supported for this type of object" even this message when escape then audit trail table update also...
  14. S

    Login and User Name

    I am looking for someone to guide me like that i have a DB and i have 4 users on it i want to create each user name with password and with different user access level for forms and reports. i need one more thing that when any user get print of any report so that the login name (User name) to be...
  15. S

    Linked Database

    Regards, I would like to know and get help in the context that i have a completed DB with forms table reports and module, now i created another DB with nothing in it else only a single form, i want to create command buttons on this form and on click of button the form from the previous DB to be...
  16. S

    Change in StrSQL with condition

    regards i have a Sql below i want it to be little bit conditional ; Private Sub Form_Close() Dim StrSql As String StrSql = "UPDATE (SELECT Purchase.Product, Purchase.PQty, Purchase.PRunTot " StrSql = StrSql & "FROM Purchase ORDER BY Purchase.Product, Purchase.PDate, " StrSql = StrSql &...
  17. S

    SQL to modify

    i have a sql below what i need runsum figure with 2 decimal places. Private Sub Form_Close() Dim StrSql As String StrSql = "UPDATE (SELECT Purchase.Product, Purchase.PQty, Purchase.PRunTot " StrSql = StrSql & "FROM Purchase ORDER BY Purchase.Product, Purchase.PDate, " StrSql = StrSql &...
  18. S

    Receipt Printing in thermal Printer

    I would like to get info that how to adjust page size for thermal printer to print point of sale receipt, i need width of 3" Inches and height of maximum till 48" inches mean continue till long item printing...
  19. S

    Correction required in Module

    I have attached a db here, ArnelGP had written it ... now for second project i need the module to change a bit, Like everything is ok, but in Status field of QrytimeSheet i need module to look for Roasters table where field Hfrom is a date field for Holidays and same as Hto. I need to use these...
  20. S

    Minimum / Maximum Time

    Regards, I have a table name Data_Mac where is storing employees daily time-in and time-out i have some duplicates or multiple entries there for every employee what i want is that query to eliminate all just pick day first or say minimum time as time in and day last say maximum time as time out...
Top Bottom