Search results

  1. N

    Error 3061expected too few parameters, Expected 1

    Dear Friends i have created a function that will populate the values in a report from a query if i set month value in query as "JULY" then the report shows all the values and below function runs perfectly. as shown below the report shows all the values...without error Then added a form with...
  2. N

    Auto increment of invoice number

    Hello team i am in access so have less knowledge i have primary key that is the code of the customer i also have a Invoice no with a pattern of XXXXX/XX that is Text and controlled by the MASK i want that when i enter a INVOICE Number, when i go to next or save the form and new form opens...
  3. N

    Dloookup with Table name is from a textBox

    Hello Team i want to get the values from two tables. both table have same filed names but different values. i want to choose the table name via a textbox that have a list of table. =DLookUp([Bdgt Aam_Amd],[tbl_FileName]![FileName],"[code] = """ & [txtCode] & """") i am getting #Name...
  4. N

    One form to update Two tables ID

    Hi Team i am new, i have Two Table PersonalDetails (Code, Name, Contact) and other Table EducationDetaits (Code, Degree) i want to have a form that will populate "Code" in both tables. can you please help me how can i do that. Code is primary Key in Both Tables. kindly suggest Regards Nasir
  5. N

    Total sum in Subform After filter

    Hello Team i have a subfrom, that filters the list and then shows their payments. i want the total at the end of sub form that my form filters. the code i wrote to filter as below, but i am confused how to get their sum that changes as the form filters. please help. regards Nasir Private...
  6. N

    Want to count entries in form

    Hello team i am Nasir Ashfaq, new here and new in programming in access i need a small support from you.... i have a form, and want to count how many times New form button pressed. also need to reset that count when i press reset button. idea is that i want only 25 entries with one CODE...
Top Bottom