Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by haerion

  1. haerion

    Error saying my subform is empty when it is not

    Hey Ace :) I tried the DAO recordset, still get the same error as before, there is 2 lines but he come up empty. and for those following, my version is Access 2003
  2. haerion

    Error saying my subform is empty when it is not

    Hi TheAceMan :) Been a while hehe. I have been good, and you? As for your code, I think the DAO recordset would work, but I seriously need to read on that, as for now, I use them but I don't understand them (I mean the recordset). It is like trying to decipher a text when someone splatter it...
  3. haerion

    Error saying my subform is empty when it is not

    Excellent suggestion, I change my code as you suggested, will see if the error come up again, be back in 2 days to update you :)
  4. haerion

    Error saying my subform is empty when it is not

    Problem is that I use a loop with .movenext to copy my data on my other program. so if the rs.BOF And rs.EOF doesn't work, then the following code will not work: rs.MoveFirst Do Until rs.EOF With rs Check = !Check If Check = True Then Item = !Itemno & ""...
  5. haerion

    Input new form value on main form

    Thank you MajP, everything works perfect now :) here is my final code: Dim StoreNo As String DoCmd.OpenForm "StoreNo", acAdd, , , , acDialog If CurrentProject.AllForms("StoreNo").IsLoaded Then StoreNo = Forms("StoreNo").ChkStoreNo Else StoreNo = "99" End If AppActivate ("Versys -...
  6. haerion

    Input new form value on main form

    Hi Guys, I have a vba code which need a value I need to select from another form. What I wanna do is click on a command on my main form that will open a form which have an option group command, then the user select the option he needs, click the ok button then the form close and the code...
  7. haerion

    Error saying my subform is empty when it is not

    Hi guys, I was just wondering if someone could help me on that: I got a form which have a subform on it, and when I click on a command, it take the info on my subform and copy it in another program, problem is sometime, even if I have 1 or more line in my subform, it give me the no entry...
  8. haerion

    Trying to simplify my coding

    Hi all, I'm having difficulty to simplify my coding. It is on a command button which is making a new line in my table then go to this line on my form. This action take 7-8 seconds and I'm trying to reduce that as much as possible. Here is the code: Private Sub cmdNewTicket_Click()...
  9. haerion

    Work on my comp, but not on another computer

    Thanks Duane, It is working without problem now. I was sure it was something like that :) Have a good day!
  10. haerion

    Work on my comp, but not on another computer

    Hi guys :) By not working, I mean that the field INVDFR2.ITEMNO1 should return the line selected in my subform. It does exactly that on my computer, but when I sent the file to my coworker, seem like the query return nothing for him. It is supposed to return one line depending which item is...
  11. haerion

    Work on my comp, but not on another computer

    Is it this hard to solve? Was thinking of a better formula that would work in ANY case. But I don't have enough knowledge to find one :(
  12. haerion

    Work on my comp, but not on another computer

    Hi all, I got a query that work on my computer, but when I tried to send the file to a coworker, then the qry was not working. Here is the sql of the query: SELECT INVDFR2.ST, INVDFR2.ITEMNO1, INVDFR2.DESC1, INVDFR2.DESC2, INVDFR2.PRO, INVDFR2.LSTCOST, INVDFR2.AVGCOST, INVDFR2.[$EIGHT] FROM...
  13. haerion

    A simple code that only work 1/2 the time

    I just realized that it is always working on the same item#. It is not that sometime it work and sometime it doesn't, but more like some item# work and other doesn't. And moreover, I tried to add the following at the end of the code: msgbox desc2 This one always work on all item#, but seem...
  14. haerion

    A simple code that only work 1/2 the time

    My main form (Entry) is based on the query Main Table which is as follow: SELECT [Table Header].IDTag, [Table Header].Date, [Table Header].Status, [Table Header].PO, [Table Header].ShipVia, [Table Header].ShipDate, [Table Header].FollowUp, [Table Header].SO, [Table Header].Acronym, [Table...
  15. haerion

    A simple code that only work 1/2 the time

    Ok, I tried in continous form view, and the result is the same, sometime work, sometime don't :(
See more

Part and Inventory Search

Back
Top