Recent content by androomc

hi. can you guys please help me with a problem? i have a form with a print button on it. this print button will print a report for me. once it has printed this report, i would like to go through every record in my 'REMINDERS' table and change all records with reminder_PRINTED = false to...

yeah i see your reasoning. usually i'd go down that road, but i'd much rather do it in VB and have just one form for each function, its bad enough keeping track of them all just now, without near identical ones. thanks for the input. andy.

you are a genius. i tried that code at it worked without a hitch! such a feeling of hardwork (and a lot of help) finally paying off :) the only thing is, every time a problem is solved there's another waiting. ;) thanks again.

hmm. i've been messin with that code, and i wanted to use yours because it was more concise. but the problem is, execute doesnt seem to exist as a method. i get a method error when i try to add those lines into my command button in VB. so i figured i'd just create them as queries and run those...

cheers :D i had only solved part 2 so your post helped me a lot :)

hey folks. a little of your help needed (im quite new to this and your wisdom seems infinite) a quick summary of what i have... customers table vehicles table linked by... sales table (1-1) interests table (1-N) a vehicle is either 'in stock' or 'out of stock'. whilst a vehicle is 'in...

i have a slight problem with my customers form. if customer details have been entered, and they need to be changed or 're-chosen' for some reason, i'd like the customers form to open at the last entered info. otherwise i'd like it to open at a blank page. is this possible? right now it's...

...me ...again well, i managed to fix that error that i was getting. turns out i wasnt saving the record before i was doing all the other stuff, so i cloned a save buttons VB code and put it in my customers form on the OK button. that sorted that. i even managed to implement the other side of...

hey me again. so i did some more tinkering and through the use of a subform i managed to get access to fill in the summary details that i told you about earlier. this means that the whole thing does pretty much what i wanted at the beginning. there is only one problem. when i close the sales...

HEY! i finally got something working. i made a public variable in a new module and on the close event of my customers form i made the customer_ID on my customer form become equal to it. then i made the customer_ID on my sales form equal my public varaible. this passes the customer_ID of the...

i've taken your advice and will use the customers form simply for adding a new customer. i will add another form elsewhere in my switchboard for reviewing old customers. i've updated the picture to reflect this. i'll post a photo of my relationships. i've hidden a few mundane tables but the...

yeah that seems about right. ill post some screenshots to give you an idea of what it looks like... (its looking rather untidy so dont laugh too hard) a few things to note about the above pics. on the sales form, the customer summary (surname etc.) is locked. i intend for the vehicle...

actually, the way you tried to help me solve the problem highlights why i made this thread. all of the similar answers on this forum seem to go the other way i.e. if you already have sales data then you can get to it by customer. but i think in my case its easier to look at my problem from...

ok that probably will work. but it doesnt let me do what i want to do. the fact is, the only reason i'd be in the sales form is to make a new sale. when you're making a new sale, you need a customer and so i figured the best way to do this would be a button that says 'choose customer' that...

ok tried that and the status of the sales form changed to 'filtered' but the customer_ID still remained empty. one quick thing, you said as long as record 15 exists in sales table, but the sales table is empty right now because no sales have yet been made. i intend on letting the user choose a...