Recent content by lico

Hi Boyd, thanks for your replay, i thought it'll be ok since, aacess itself gives you the option of input mask that includes both dailing code and the phone number in the same field. anyway i didn't think about editing the data, which would be a problem if the controls are unbound as you...

hi guys, i have a form that contains two controls, one is a combo box which contains dailing code list and the other one contains phone number. both controls are unbound. i want to store the values from the two controls in one filed on my table. the reason i wanna do so is because the dailing...

hi guys, i'm working on an access DB however my knoledge in VBA is very poor, here is my question: i have a main form called client_orders which include subform called client_order_details. i created a close button on the main form, when user trying to close the form it will popup a save...

Hi Simon, Thanks for your response, I think you guys didn't get my question because of my bad English, or i didn't get your answer. I'll try to rephrase and be clearer this time. First here is my goal: Creating an inventory DB. What do i need? I sell some products; these products are...

gemma-the-husky AWF VIP hi Gemma, thanks a lot for your response.

hello again, thank you for your response, i read this article and got more accurate picture. still, my situation is a little different so i wasn't able to get the answer from it. thanks any way

hi everyone, I'm building a database for stock management, all the incoming supply that I get from every supplier goes into one table, and of course the sales I make goes to other table. Say I'm selling a products package that includes some products, so for that I create a table which includes...

hi SOS and John, thanks alot for yuor replays, i'll give it a try soon. :)

hi John, thanks for your replay, i tried to do as you said, when i'm moving to the combo box that based on the populated list i get a parameter box that askes me for the ID number insted of giving me the list. when i posted my question i wrote that the list is based on the main form but it's...

Hello, i have a form based on a table, in the table i have a field called ID which is an Autonumber . for every record, the form lists a new Autonumber in the ID field. the same form also includes a sub form in which i'm trying to create a list box that lists the values of the ID field from...

Hi Evan, i did as you said, it still a bit complicated for me since i'm new to VBA so i didn't got the idea completely but i'm starting to get the feeling, took me a little time but i got it to work. again, thank you very much for your time and patience i really appreciate it. Lior:)

yap, thanks again, i wish i could see it so clear as you do. i'm trying to create the messeage box that says "this client owes money, would you like to see debts details?" with YES and NO bottuns, when the user click NO the meesage will cancel, if the answer is YES then the form that i created...

Hi evanscamman, Thank you very much, it did it!!! is there a way to create a button in the message box that will run the clients debts query for the specified client so i can view the missing payments? i alredy have a query built that show all clients in debt based on the YES/NO Check box...

Hello, very new to vba, i have a data base that contains CLIENT ORDERS TABLE and a CLIENT ORDERS FORM that feeds this table, in this table i have a YES/NO field for payment status, yes = paid order. i also created a CLIENT DEBTS QUERY that shows qlients that have a debt based on the YES/NO...

thanks again for your help, i managed to do it with the query grid. i still have small problem but i'll get over it. thanks:)