Search results

I’m trying to lose our restaurant booking system to save costs and build it in to our MS Access Diary system that logs staffing, maintenance, health and safety etc which we use and it emails management a report at the end of the day, also links to our tills data. More than that I’m keeping...

Mainly it would be to book an individual table up to 4 people, but often it would be to book 2 tables joined together (eg 7 & 8) for a party of say 8 people, rarely you’d want to select all tables in the room for a booking. That’s the challenge here: Table 7 can be used on its own Table 8 can...

Brilliant, thank you for that, I have something similar in my main database, but what you are showing is what I was thinking about where we manually select tables ( T1 + T2 + T3 ) on a continuous form, this does solve my problem, where I was trying to be a little more adventurous and be able to...

Thank you for that, I can create that and I have a way to book multiple tables. The issue that I am facing is table availability with joined tables, especially when they can be used in multiple ways, but only once at the same time.

Thanks All, Mike - Thanks for looking, I agree that joins need to be in a seperate table somehow. Ken - Thank you, I did put your structure in to my database this afternoon and I see exactly what it's doing and I like it, if I use this I will be able to build a grid too, which I'd like to do...

Hi Mike, I have pulled it out as best as I can to make the query work. It would work best I think if you open frmBackground first. Thank you, Malcolm

Hi All, I'm back at this and I have learned so much. One of you (I'm sorry I can't remember who) very kindly gave me a query which I have added to and I must admit I don't really understand queries in SQL view, however I have added to it as I needed. I have now added up to 15 joins available...

Hi, This code is is closest, however it is counting ALL covers in the table - I am looking to count just that day and also exclude cancellations (status is null) =DSum("Covers","tbl_Net_RestaurantBookings","MyToday(CheckIn) And [Status] Is Null") It seems to be ignoring the MyToday(CheckIn)...

Alas Not :-(

Albert, thank you for that, your code below works great for me, I have used it with DCOUNT too. WORKS =DSUM("Covers", "tbl_Net_RestaurantBookings", MyToday("CheckIn")) However, is it possible to add a second criteria to not count cancellations (status column is blank), not sure if this is...

Cool, thank you all. It's still not working for me, but I will come back to it tomorrow. Thank you.

Hi Tom, Thank you for that, unfortunately that date format is embedded throughout my database so I have had to go with it and format it where I need to. Is there a way I can format for this to use DCount and DSum? Thank you, Malcolm

Hello, I'm looking to sum restaurant covers from a day - based upon the date on my form which is formatted dd/mm/yyyy I'm trying to use: =DSUM("Covers", "tbl_Net_RestaurantBookings", "#" & Format([CheckIn], "dd/mm/yyyy") & "#" = [Forms]![frmBackGround]![txtLocalSystemDate]) LocalSystemDate =...

Hi All, I appreciate that my idea wasn't right, so I have gone back to plan A, however i cannot work out how to show tables that are free between times. In my example attached I can show 10 tables available, but when I add times I have nothing available - attached should show all 10 tables...

Hello, I have created a grid using a table Fields are DinnerTable, 18:00, 18:15, 18:30, 18:45 etc On a form I have a textbox named txtGrid1 and a button I'm looking to run a query where if the textbox value was 18:30 then my query fields would be 'DinnerTable' and '18:30' - however I cannot...

I went with this for now :) If [cboEarlyDutyManagerActive] = "Yes" And [cboEarlyDutyManagerStatus] = "Waiting" And [cboEarlyDutyManagerHour] = Val([txtNowHour]) And [cboEarlyDutyManagerMinute] = Val(txtNowMinute) Then Then the next line I change the Status to Running I run the Process for...

Hi All, Much appreciated, thank you. I have gone with Gasman's solution for now - I appreciate the help from everyone tho. Thank you, Malcolm

Fabulous, thank you for that :) I will hopefully sort that problem my getting it to change the status before it does anything else and then they will all be updated again at midnight for the following days tasks to run. Thanks again.

Hi Gasman, nested Ifs wasn't the plan, I moved them around when I was trying to make it work - do you know where I am going wrong with the timing issues please? Pat, thank you - do you have a link? Thank you

Hello, I am trying to build an automated task scheduler for my system where every day it will run a report at the selected time each day, or run some process. Currently I have a few small access databases running in windows task scheduler that open, run whatever then close - works well...