Recent content by slogie

No I don't, but it's just a fixed percentage that I would be adding to the prices.

Hi, thanks for replying. No, I don't have an update field. As stated before, I was manually going through the records and changing the values. So far I changed up to the first 100. I only have about 470 records and if I ran the update query, it would change all the records, including those...

Hi again, I don't know much about queries, but I need to update some prices in my database. I however started doing them manually and then the light bulb finally went off in my head and I figured I could use a query. Is there a way for me to run the query on the remaining records without...

So I know nothing about DMax, but from reading, I am thinking that I would use it in VBA on the form seeing that was how you helped me before with my previous problems. But the examples that I see, have the Nz function on it, and that I think would return a null value...

Thanks for replying. Well I did not know that an autonumber would skip numbers. So suppose I change the field to Number, how do I get it to generate a number seeing that it is the primary key? Or does this mean that I have to change it from being the primary key?

Hi I originally had my invoice numbers as autonumber, but I would like for it to begin at 260 and then increase by 1 each time. How do I do that?

Thanks for the link but I am afraid that I really do not understand it. I should state that I really know nothing about coding and vba, but I do think that I would have to use vba for this. I originally just used ID as the invoice number (this is an autonumber, as well as the primary key - no...

Thanks for replying. I already have the inv. number as a field and it is the primary key. The only thing is that I had it as autonumber. I have never used this dmax function before so I really do not know how it works. The name of the field is InvNum. So how do I use it in a function? Do I do...

Hi there again. I just came across a problem that I didn't recognize before. I had an invoice table and corresponding form that had an autonumber for the invoice number. The problem now is that I would like the invoice number to begin at 256 and then increase incrementally, because I had some...

Hi Guys, me again. I did get the cash invoice to work but now after a while of not working on the program, I am trying to create a credit invoice in much the same way as I did the cash invoice putting in the code for the combo box, but the previous records still change after I update the...

Ok so if I was to create another invoice set for credit invoices I could just copy that code into the other combo box?

I am clueless about codes...but I figured it had something to do with it. That was why I was stuck. So you had to write in the code manually?

Ok, so that's where I get lost...the combo box. I can only get the combo box to look up the values in one table. How do I add the code? or whatever it was that you did?

So, let me get this clear... All I have to do then is just keep the price in the itemlist and add a price field in the stock transaction, no changes to the relationship part?

Clear as mud!!! That seemed to have done it! I was close, but I guess I did not get something right. Thank you so much. I will finish working out the kinks and let you know if I have any more problems. Appreciate the help.