Search results

Nah wasn't that bad it was only 27 miles away and I've just got back :mad:

Somewher I've seen a routine or function that displays days but I can't remember where off hand but, basically if you just want to show certain dates then set 'between dates' as a parameter for the query What I gave you is an example. Use that to generate 2 seperate queries; One for F.O.H and...

here ya go

Maybe I'm just being blonde but what are you expecting to store this information in a table or do you just want a document to open. :confused:

No probs. It only took about 10 mins. It took longer to post the reply :D

What like This? If you make the input form for shift a single form and use a date and time picker to enter the data it will be better. Then you can use the shift query to display the info. You need to add the department but I've left you to work that one out. I have, however, corrected the...

OK I'll take a look tommorow if I get a chance.

Use a table to list type and a seperate table to list colour. Join these together Your choice of display on your order forms then has a number of options but I would use a pick list from cascading combo's Your Y/N for the kitchen I would forget as it is not necessary the other just put a...

Take a look in the samples forum. there are a few samples in there including one from me

Err what help would you like? If I'm guessing right you want to put 26 tabs on a form? Don't know why you would want to do it but mine is not to wonder why. Have each tab display the results of a query. That means you will either have to have 26 queries or 26 pieces of code. A better way...

Theres loads of stuff already here on that topic so do a search and you'll find all sorts of options for doing what you need. Your systems are no doubt different in the states but here I would talk to the people who handle your mechant account. We process cards all the time and with the...

Read the help files on relationships and search here for 'relationship' & 'primary/foreign keys' Again LOOK there is tons of information here already in hundreds of threads there are even samples in the samples db section. 2 things here. You do not need the name of the employee any other...

There are various solutions to your problem but in basic terms: Create a table to hold all the possible links to your BE in both locations then use a routine fired by a command button. But an easier solution may be to just import the tablesinto your front end when you take it home and split it...

I believe the Northwind db has an example of how to link in code or take a look here

I think I would use four tables Employees Store information about all employees Department Departments; Kitchen, F.O.H, Cleaners, Admin, etc. Availability Dates and times available Shift Dates and times of shifts All tables related to Employees. tblAvailabilty and tblShift need a one to...

There’s a moral here---------Don't agree to nufink until you know what’s involved :D I don't think I would do it like that but post a zipped copy of wht you have and I'll (and prob. others), will take a look too see where you have gone wrong. Use a calculation query to work this out. Once you...

Doh. Thanks Pat. I was trying to do it the hard way

I have a table (call it table ‘A’) Linked to another table ‘B’ I have a calculation query that runs on some other tables and produces calculated information on some 160 items. I want to add a lookup field to table ‘B’ that pulls the calculated information from one item in the above query. But...

I would take it one step further than that and create a new work book with just one worksheet. Let your users continue to use the origonal and link the two. Sorta like a middle man. That way you can make the new work book exactly what you need for Access with no formating or formula. It also...

A lot depends on the type of query. Some write to tables some don't. If you are using append or update, etc. then users need to be able to write to the tables. If they are using select type queries then they don't. Without implementing some sort of security it is immpossible to stop users...