Search results

Hi, Thanks again for the advice. So after re reading some of the above and some further research i, thinking i need to go down the route of using an SQL server. @The_Doc_Man you mention creating multiple specialized web code? i assume if i dont want any form of website, this wont be needed...

Thanks for the advice. its great to know this before starting out down this route only to find it doesn't work later on. Ill rule out a split database and look for alternatives @Pat Hartman, you mention converting the back end to SQL. I am just starting to get into SQL, and have a mock up SQL...

The google drive in question is a team drive we access through filestream so its treated like a network drive (drive letter J: on all computers), would that still not work? Also all users have access to an internal drive access via a vpn, could that work, if the google drive option is not a...

Hi All, first off, i don't really post here, but have frequented the forum a number of times, so thanks for the help thus far. I have question about database design. Currently i have set up that is an excel sheet using multiple macros to essentially replicate some of what a database would...

it feels like forever now though. :( my query SQL code is: SELECT Accommodations.PitchNumber, [PitchNumber] & " - " & [type2] AS Expr1, [Arrival] & "-" AS Expr3, Bookings.Departure, [Name] & " - " & [CustomerID2] AS Expr2, IIf([expr3]="-","-",[arrival]) AS arr, IIf([expr3]="-","-",[departure])...

Hi all, Ok so im well under way with building my database. But now i seem to have hit a brick wall and i dont know where to go. The only condition that my database really has to meet is that i must be able to print out a visual report of my rooms that have a bar and label to show when they are...

Hi, thanks again for the advice. The problem I have at the moment is i don't quite understand the whole relationship side of the database. My table naming was sort of worked out from another tutorial i was trying to follow, but adapting it to my own needs. Does anyone have a good tutorial...

Hay, at the minute thats what i have been trying to do. i have set up my tables as follows: Customer: ID name ref nationality adults (no of) kids (ages) special requests / notes Accommodation: id emplacement number / room number type code no of beds in use by available bookings: date of...

hi all, Here is the point where I have to sound like a complete idiot. I really need someones help - any help is appreciated, SERIOUSLY, anything! I'm trying to create a database (my first one in about 10 years). In my head it should be simple, but nothing seems simple anymore, especially with...