Search results

Hi all, I'm currently making a pretty Excel graph but I've just thought of a new way to present the data - however, I am not sure how to go about it. Basically, I have month and quantities of items shipped on that month - but I also have the history of the previous years and wanted to also...

Hi all, I'm not sure if this is the right forum, but thought that it would be a good place to start - I've been trying to find the time to put together a database but sadly find that my new role does not allow me the time to put aside for the development of such things - as such I'd really...

Hi all, I've been working on a database on and off for a while now, and am at the point where I've entered some test data and want to develop forms so I can display this neatly as opposed to as in a table. For one of the forms I would like it to list Company name, and then details of the...

Hi all, I have an access database that I've been developing on my main PC; I now need to demonstrate this to someone who does not have a version of Access on their machine - I wondered if there was a 'read-only' version of Access that I could download/buy and use to demonstrate the system, and...

Hi all, I've fallen horrible out of practice with Access over the past few years (and only had a basic grasp of it when I knew what to do); but I think that this is a basic question about database relationships; and if it becomes too complex I'll end up digging out the old books to re-educate...

Taken from the site itself, via Slashdot: Certainly would be nice to be able to play Freespace 2 again...

Hello all, I've recently been working on an Excel Spreadsheet that has grown to rather huge proportions - and was wondering if there's any easy way to port the data from my Excel Spreadsheet into an Access database? This is all just preliminary musings as I may not be asked to do such...

I have a report, and, quite embarassingly, can't seem to shrink the 'Report Header', 'Report Footer', etc sections down - I've tried clicking and dragging as the help file suggests, but this isn't working at all - the cursor doesn't turn into the appropriate shape. Originally the report was...

Hello all, I'm doing a travel database of sorts, which logs requests for flights, taxis etc - the report/query I'm currently putting together logs all travel requests within a date range - the only problem is that there's often more than one travel request per day, meaning that there's more...

'lo all, I've been altering a database in a 'test' enviroment for sometime now, and am reasonable happy with the way this one has developed - however, in order to save me from having to make many changes all over again to the 'official' database, is there anyway I can transfer the data over...

Hello again, In my report I have Flight_requested, and Flight_booked (both tick boxes) - What I need to know is, is there a way so that if Flight requested is ticked and flight booked isn't, the totals at the end add one to the flight requested tally - however, if both requested and booked are...

Hello all, Straight into the question, before I confuddle myself more.... There are two date fields, date requested and date booked - I need it to be so that when the user enters the date range - both of the fields are checked independantly, and the relevant records are processed.. This...

No sooner do I figure out something than I stumped by another, I have an options box on my form - one that produces a number from 1 - 3 to indicate the priority of the task - 1 being the highest, 3 the low - these are shown up as numbers when a report is produced. Question is: Is there...

Since I seem to have forgotten all about them... What would you recommened as a good book for the more advanced versions of reports? It'd be handy if it'd be available from my local Waterstones or something, but if it needs to be ordered online that's fine too... Thanks for any suggestions

Hello, I've been busily working on an Access database for the past few days, and would like to see if it was possible to make a (purely cosmetic) change - basically, there's a set of fields - Flight Requested, Flight Booked, Flight Booked with - Flight Requested and Booked are both tick...

Hello all - third post in less than two days, I'm on a roll! I was wondering if there's a way to get a numerical value out of a Yes/No field (say Yes = 1, No = 0) - for the purpose of reports (and more importantly the totals) Cheers

Hello, I've recently been asked to update a work Access database - which would've been no problem a few years ago, when I was fully versed in such things - however, since those heady days - ring rust has crept in, and some things I thought Access did are actually things from other programs...

Hello all, Be gentle with me - its been a while since I used Access, but have now been asked to update someone elses Access database at work, and to add some new features - I can remember most aspects of what goes where, I just have a few queries about some of Access' other features (if it has...