Search results

  1. A

    Solved Two Combo Boxs for Name & Number

    Dear All, I have two combo boxes on a formA, Combo A row source is id, number and name from tlbA, Combo B row source is id, name and number from same tlbA, but i applied criteria that Combo B shows only related Name which number is selected in Combo A, (Working FIne) i set the limit to list...
  2. A

    Duplicate Records in Main Form and Subform

    hi members, i want to duplicate form and its subform record where invoice number matched, but i am facing an error 3201, you cannot add or change a record because a related record is required in table tblcustomer..... while this code rstSale.Update got highlighted yellow. my code behind click...
  3. A

    alternative of dlookup and aggregate in spllited database

    dear members, some of mvps like Richard Rost recommand to avoid aggregate queries and dlookup functions in splitted database. then what are alternative of these important features. please guide.
  4. A

    Append query duplicating records

    dear members, i am using this append query in start it was working good, but after few days, now it is behaving like this and adding about 32k records in one click. what is going wrong with it.
  5. A

    Time filter in query

    dear access users, I can filter date by using this expression on date field Between [Forms]![ShiftReportF]![StartDate] And [Forms]![ShiftReportF]![EndDate]+1 but what express is to used to filter time, i already extracted time using timevalue.
  6. A

    Solved BLANK SUBFORM

    HI EVERYONE, My sales order form with order details subform is part of spillted database. It is working well only on 1 user, while on other users subform is showing blank. What could be the possible reason. I checked most of the settings related like, >db "open in share mode" option enable...
  7. A

    Assign Ctrl+P for Print Command in VBA instead of Alt+P

    dears how it could be possible to assign ctrl + p key to call print command event through vba, instead of using hotkeys. thanks
  8. A

    Setting Focus on Navigation's Subform's and Its Control via Button Click VBA

    i am trying to get focus on subform control which have two parent forms Main Form>Navigation Subform>OrderlineSubform.Control ProductID combo how it is possible to get focus on this subform and then its control via add new button located on navigationSubform i tried these two codes but...
  9. A

    populate a subform with data searched and selected from listbox

    dear all, i have this purchase form with subform, when i search data from listbox, its temporary stores both two fields in temporary text box on right sides, and opon click on add button, both two values added in subform. but problem is when i try to add another product, it shows error that...
  10. A

    Update stock table after purchase save button

    Hi dears What is the best method to update stock table. I have Purchase form with purchase data form. I want when we press save button on purchase main form, it will add a new record in tblstock, where tblstock.productid = tblpurchaseData.productid, and...
  11. A

    creating multiple copies of sales order forms

    dear all, i want to create multiple copies of sales order form with its subform, as like in we create new page in word by pressing Ctrl+N(new) key, or in excell we get new workbook, i hope, i describe my point correctly
  12. A

    Order Form Saving Behavior

    Dears, My order form have order details subform. When i open the order form, i set customer bydefault value so it can generate new order id automatically, (because i want that before entering the customer name, user firstly enter products in order details, then user can change customer name)...
  13. A

    Solved Set combo box value after closing another form

    hi guys, how it is possible that when user add a new customer name and mobile number, and click on save/close button on AddNewCustomer form, it save the record, then close form, and then set combo box value of customerID on main form which is newly entered.
  14. A

    Solved Sum #Error in Form

    hi guys i m facing this error on my order details subform. the fields (which sums i need on subform footer) are calculated fields order details table design view i need the sums of RetailPriceT and SalePriceT fields, which later i will refer on mainForm.Footer.Field Design view of order...
  15. A

    Solved Sales Order Form Coding

    dear access members, please check where is trouble in the coding. need assistent to make here is view of my sales order form, there is some issues with coding behind it. i am trying to make it like northwind form, (there is some difference) i need, when ProductID combobox get focus...
  16. A

    Solved serial number in subform product list

    how can i add sr no automatically starting from 1 for every order i enter
  17. A

    Solved get textbox value on subform from another querry based on combobox

    trying to make my question more simple here is screenshot of my ORDERS FORM (which include a subform of ORDER DETAILS) i need to get retail price and sale price for my ORDER DETAILS FORM from a purchase query based on latest dates here is snapshot of purchase query is here how it is possible...
  18. A

    new to this forum

    Peace for everyone here, I am not new to ms access, this is my favorit program. Now a days I am doing my job as Cashier in a pharmacy. The software, which we are using have less features, I want to create my own software. I hope this forum will be helpful for me :)
Top Bottom