Recent content by naym

Hi Guys I have a small Issue Which Im not really understanding. I have a main form with a order details form inside that. I have placed a textbox inside the order details subform and using the expression builder created a =sum to work out the amount * qty. Then on the main form a totals textbox...

Thanks Dale, I think I have resolved it. what i was doing is: after the do until eof if rs(x).value = true then Var A = 1 else Var A = 0 so what it was doing is if the last record was false it would put false. I just taken that after else part out and seems to be working ok now. Thanks for...

Hi Guys, I have a small issue, I am trying to run a sql statement in vba in which it selects all the records in a table related to a order Id number. I then want it loop through all the records and check for a check box which is selected. if its selected then "A" variable becomes "1" and i...

Hi David, Michael. Thank you for your reply, sorry for not getting back in touch earlier. David the connection string is simple and its been used for years on xp and on windows 7 before and goes something like.. strTemp = "Select * from postcode where postcode='" & pc & "'" rs.Open...

Hi Pat, Thank you for you reply, Xp embedded is a light version of xp, so a user creates an image and they can choose what to have on the xp ie what programmes and which not to make it lighter. Thats about all I know about XPE. Im not sure about run time or how to add this onto it. Any...

Hi Guys, I have a access 2003 application which needs to be installed on a Xp embedded machine, any ideas on how to go about it? do i install the full office suite or just the access and how? I havent used xp embedded before unfortunatley :-(. Any suggestions would be greatly appreciated. Thanks

Hi Guys, I have a issue which I have been trying to work on all day. I have windows 7 and office 2003 installed. I have access application which was running fine recently but for some reason everytime I run it now it gives an error on the adodb connection string saying compile error. Its doing...

Hi Michael, Thanks again for the reply I will take a look at this tonight and see what i can do or make of it. by the way is this based on sql server?? am just using ms access no sql server just sql statement. lol

Hi Michael Thanks for the reply, Yes i kinda get you know, ive never used this type of class or programming before so sorry if i didnt understand you code. do you my any chance have a working example of this so i can get a idea of how it works and how i may be able to replicate it into my...

Hi There, Thank you for you reply, Yes I was thinking of using a command button or attach the code to the afterupdate event on the textbox. Im sorry but i dont think your code will do what i need to do. I was thinking of the lines of having a vba sql select statement which in my head is...

Hi All, I have a small problem. I have a form with a textbox which when users enter a unique number(barcode) I want to run a query which pics up the barcode number, checks against the product id and fills the subform with the name of the product and price. the basic details of the product...

Hi Mate, I have developed a Epos system in Access and use access reports which work fine for me, the length is set for what i need it for and only gets larger if the order becomes larger. ist this what your not wanting?? if your wanting to cut it the last line of code you can make the page...

Hi Dpw204, Thank you for the reply, no I havent deleted the data, the data is basically details of an order which then prints out a reciept based on a order query. I think I have managed to solve the problem, also on the query was another table field called reciept message which a user can...

I there, I have just come across this problem recently. I have a Ms access epos programme and when changing it to a new takeaway i have deleted the data and compacted and repaired the database but now the problem is the query for printing a receipt is not working all its showing is nothing at...

Hi all, I have a small problem at the moment i have a subform which details get enteredt into and then a report which prints out details in the subform but the order they are in the subform and the order they are in the report are different so if there were items like tea, coffee, latte, on the...