Search results

u all have been very helpful, thank-you for the reply :) perfect I like that sample, that is the one I like to have...... I am wondering, instead of using a combo box, can we just use a text box, and then on the (maybe) the enter event, it should display all the customer details? Thanks again :)

Thanks :) but I prefer to have it like, the user types in the product number in a text box and all the appropriate info comes up..is it possible? So, all I have now: a Product table in the query with the fields: Product number Description Finish Room Unit price Number in stock so, what do I...

Hi there. I am working on a group project and need help ASAP with every detail please. I am making the Database for a company (imaginary!) which is to computise their system. Right, I got the order form, now I need to put in the product details form etc.. the thing is that, I want it when the...

?? I don't quite understand.... There is no query involved yet......unless this is the only way to work then put this query as a subform...but then, if we do do it this way, there is no way that the query would allow us to enter new data, if the customer does not already exist... please...

Hi there. Right, I am now on the hard part and need some help, ASAP if possible please :) I have created an order form, this order form will have the customer details (which a table has been made) and the Product Details (Again, table has been made for this) I created forms for both of these...

really stuck and frustrated on this database

it's not in the samples folder...still can't find it :(

thanks, will have a look. I'm really going mental here, crazy lol. I haven't yet started the database yet and having problems. Right, so, you are saying that it is possible if, I make a database with a customer details subform in an order form. The order form may contain these fields: product...

I can't seem to find the northwind database in MS Access (I am using Office XP and Office 2000), would u be able to email me it or something?

Thanks, I will try it. I haven't had time to check it out but please, I need to know from a good person like urself, will it do what I have said I want it to do? I mean, of course, Not everything but will it do the part where, if u have a subform in a form, and u enter a customer number, if...

another quick question that is bugging me: in VBA, if we have a subform on a form and it has some txt boxes, how do we tell VBA to get the values of that txt box? cause in VB it would be: x = formx.txtemail.text etc.... any ideas?

I will try...thanks :)

Hi again, firstly I like to thank the people who helped me through a coursework i needed help on, you have been great! THANK-YOU I trust u ppl I am now in the second semester and it's a project type module. I need some help before I continue. On paper, I have done/drawn up some...

Hi again, firstly I like to thank the people who helped me through a coursework i needed help on, you have been great! THANK-YOU I trust u ppl :) I am now in the second semester and it's a project type module. I need some help before I continue. On paper, I have done/drawn up some...

just solved it heheh. I just put in to group it in client, name and address, that's it. thanks

the problem i just found out, happens when grouping. I got the thing working but now I need to only show the name once! it says : "the report must be ordered by client number and must show the name and address of every client once" so far, I JUST manged to get it but I forgot about the name...

tried that lol..didn't work, i think i nearly got it..........

Hi there. I made a query, and sorted it acsending (from hi to low (1 2 3 4.....)) and saved it now making a report on the query but either way, if I choose it to sort by ascending or desending it won't sort it. it always makes the last number first and i don't want that. what should I do?

no reply here.... :)

sure, sorry Sir. u can upload ur version and rename it....or email it to: ahmeda86@hotmail.com thanks again