Recent content by Rob500

UPDATE: Done it

Hi guys I'm a little stuck on three of my nine queries. Bascially, three of them display records for a given day, three for a given week and three for a given month. The criteria for days and months was pretty easy; I just got: [Enter Date] for a single date DatePart("m", [Date]) = [Month] for...

Hi there guys Basically, I have finished a mammoth sized database and I'm now thinking of what I can just bolt on to the end of it. I want to code a way to back up the database using VBA code; I've seen it done so I know it's possible. I was going to put a button on the main switchboard to...

Hi there Basically, I have a global variable and when that is true, then the user has administrative privilages and is able to access the whole database. I have coded it such that when this boolean is not true, the user only has limited privilages. This is controlled by a boolean flag for each...

Jeez how could I miss that? :( Thanks :)

Hi, I'm making a database for a club at college. As per the user requirements I have enabled it to allow just 7 users access, two of which are administrators, the other 5 having limited permissions - I am having problems with the permissions as well. My major problem at the moment is that I...

This is probably blindingly obvious but I'm unsure about it. We'll refer to three tables, call them Table X, Table Y and Table Z. Basically, I have a database with 10 tables. Table X links to Table Y via the Primary Key. Another field in Table X has a relationship with the Primary Key in Table...

I wouldn't upgrade to 2003 from 2002(XP) as there is no difference in functions whatsoever. 2003 is just a re-release of 2002. All of the features in 2002 are exactly the same as 2003, in fact, 2003 has fewer features. The only real difference is the interface, which in 2003 matches the XP...

Update: Me (idiot) forgot to change the 'Visible' option to 'Yes' :rolleyes: :rolleyes:

Hi there I appear to have a problem with a report I am creating. It is, in essence, a payment report sorted by contact details (title, forename, surname, address). The contact details I have put on a grouping level so that they are all in a header. The problem is that the information I need to...