Search results for query: *

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

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

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 :)

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 & ""...

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

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

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

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()...

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

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

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 :(

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

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

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

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

I tried to delete/reconstitute the listbox, but i still got the same problem :( The main form is "Entry" The subform is "ItemCustWant1_subform" The listbox lboItemno is on the subform The Event is on the afterupdate of the lboItemno The subform is in datasheet view. If you need any more info...

I can't use a combobox, since it is a subform that is used in a datasheet view

I removed all the "me." and still got the same error :(

No, column 0 is the item, seriously, the information is taken from the right place. It's just that something everything fill out perfectly and some other i got the error... that's just plain weird!!!

So you guys got any idea?