Search results

  1. A

    Solved BLANK SUBFORM

    i do many "experiments" during these 2,3 days. last one i took copy of my backend from network driver to my local pc, then connected (table linked) my both front ends with it now new forms working. what is the problem, is there any issue in network/sharing or something else. why i cannot use...
  2. A

    Solved BLANK SUBFORM

    still have errors
  3. A

    Solved BLANK SUBFORM

    i take copy directly form pc where its working, but failed, i can see order details subform source table, it is accessible now going to last step by making new sample form and subform
  4. A

    Solved BLANK SUBFORM

    i checked its okay, and linked correctly
  5. A

    Solved BLANK SUBFORM

    please tell me where to put this code in subform's vba code window, in general declaration or under specific event
  6. A

    Solved BLANK SUBFORM

    what is wrong here, please tell me
  7. A

    Time filter in query

    i put this expression in query grid, but facing this error
  8. 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.
  9. A

    Solved BLANK SUBFORM

    whenever 1st user close the file, and any otherone user opens his copy then sale form and subform show records (working ok). In short one time one file/user work well. if 2nd user open db without closing 1st user, he get this error" the expression you entered ..... object that is closed or...
  10. A

    Solved BLANK SUBFORM

    everyone have their on fe
  11. 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...
  12. A

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

    I am unable to assign "call button click event" action using an autokeys macro. To assign an action to ctrl+p keys combination, i am using this code Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyRight Call cmdNext_Click Case vbKeyLeft Call...
  13. A

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

    yes i want to disable default ctrl+p behaviour. and assign it to a command button
  14. 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
  15. 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...
  16. A

    populate a subform with data searched and selected from listbox

    thanks for your deep observation on db, i know there is lot of issues, against rules and regulations, i am working hard to bring things on order. most valuable people like you on that forum provide me lot of knowldge which i have forgotten 10 years ago. when the db get completed, i will share...
  17. A

    populate a subform with data searched and selected from listbox

    my db is attached, i am using this code behind add button click Private Sub cmdAdd_Click() Dim strSql As String If IsNull(Me.List390) Or Nz(Me.Qty, "") = "" Then MsgBox "Please select Product and quantity": Exit Sub 'make sure you have a product and quantity strSql = "Insert into...
  18. A

    populate a subform with data searched and selected from listbox

    what is the solution plz
  19. A

    populate a subform with data searched and selected from listbox

    No any other table or tab is open, Moreover PurchaseData Subform is linked with Purchase Form with PurchaseID Autonumber field,
  20. A

    populate a subform with data searched and selected from listbox

    i am trying my best to make it simple not complicated, i am unable to where is the problem, this error is still on place.
Back
Top Bottom