Recent content by sithius

I've just started a computing course which involves making a database based on a linear specification. My tasks will involve a variety of things; from having two forms interact with eachother in order to produce results, and to simple formating. Can anyone give me any advice on where to start...

So far I have a query that picks up any collisions between booking dates with the following: SELECT [Customer Details].[CustomerID], [Booking].[RoomNumber], [Booking].[DateFrom], [Booking].[DateTo] FROM [Room Details] INNER JOIN ([Customer Details] INNER JOIN Booking ON [Customer...

It's finally up and working. You've been really helpful man, thanks a lot. :)

Ok, I set up a BookingID and added to the SQL I already have on my query. It appears to be working except it's asking for me to enter the bookingID number instead of automatically picking it up from the field next to it on the form itself. Not sure what I'm doing wrong but I bet it's quite...

I haven't got any primary key either. About having a textbox that automatically indexes 1 with every booking, that seems a good idea. This way it would stay unique. How should I implement it? Sorry for all these questions. I'm pretty bad at Access. Do you know much about VB and if it would...

I haven't actually got a unique field, except for customer ID which won't work I'm guessing. I didn't think I would need a booking ID but now I'm beginning to wonder... Is there any other way?

Thanks. Just got it working. At the moment though, it's also including the date I've just as booked as a 'clash' in the subform when I go to check. is there anyway to remove this? Either way, I'm also trying to use an IF statement to either 'save' the booking or not save depending on the clash...

I'm making a booking system and I've got most of it ironed out now except for one last thing. My start and end dates for the booking need to be made so when I click a button, say 'Check', it'll show me all the conflicting present bookings. Not sure the best way to go about this? I was thinking...

Cheers. Works fine. :)

No one? I really need help with this.

Well basically I have a form with a button on it and some fields. The button brings up another form with that related data of the current record already on display. (Did all this using wizard) How can I get it to show the related data but also have access to the rest of the data that isn't...