Recent content by Solaron

Hmm Just realised that isn't possible.... so i was gooing to have a button that will bring up an input box which will then add a new value to the combo box (or the underlying field in the table)... i know how to bring up the input box and how to assign it an argument, but how do i then add the...

I've got a form with 2 subforms inside. All linked nicely... On the main form there are about 10 fields, and the top field is a combo box. When i seletct something from that combo box, all the records update as necessary - nice. BUT i need to be able to add to that combo box. I only want to...

Cheers guys, i understand what needs doing now - but to be honest, i haven't a clue how to do it! This is my first access database (other than an a-level project), so my knowledge of controls in acess is very limited. So, how exactly do i make the control on the form?

This may be simple, but it's annoying the hell out of me! I want to be able to have 2 subforms, both in datasheet view, and both linked. But i want it so that when i select a record on one, it will change the subform below it to the relevant records. Confused? Sorry. I can do a simple...

Dont worry - solved it. God bless help files.

Yo, I dont think this is a toughy, but i dont know how to do it. I am trying to be able to automatically genertae dates in a table. there are 2 fields that i need to generate. The first is the date when the record is made (todays date basically) which is easy (=now()), BUT i want the...

Not quite so all good! Well, i take that back. I have managed to do it APART from the filename. I know you can specify a filename, but i want to be able to have the days date as the filename to export to. Any ideas?

Cheers guys, i've managed to get what i wanted now - all works good.

Cheers guys, i've managed to get what i wanted now - all works good.

Cheers, i can see your point. the problem is is that this database isn't for me, it's for my parents and i've been told which layout they'd prefer - hence the trouble. Otherwise i would just create a normal standard database with little complication. Feel free to check out my .mdb. E-mail...

i have come across a serious design flaw in my database. It consists of takings from vending machines which are updated every month. I'm sure there may be similar posts like this on this forum so apologies if this has come up already. WHat happens is that i have written a query that will go...

Cheers dude, although doesn't 100% solve my problem. I had a feeling that calculating values within tables is 'bad manners' for access, using a query seems simple enough although access help doesn't actually tell me how to perform calculations in queries! But i was hoping to keep the layout...

This may be hard to explain, but here goes. I am creating a simple database which contains a few tables and nothing more. They are all linked together, so in access xp there is a lovely function that when you load up the table (my main table in this one), there is a little cross to the left of...