Search results

Good Afternoon My trouble today is as follows, i want to count the number of times a company buys from us. How i was planning on doing this was counting the number of dates they have baught from us, however a company can buy multiple purchases on same date So using the example below it would...

Good morning, hope everyone who read this is well I am trying to do a running Total for my marketing database my company has asked me to produce A client buys Product A, B, C the quantity is entered and a total (price*quantity) is figured. now in my form i created a text box that works out the...

Good Afternoon I want to disable a field (ClientGender)in a form (called frmSales) if ClientType does not = "Private Individual" , iv done this before and remeber it to be reasonably simple but that was a while ago and im afraid iv forgotten nearly all i knew about VB (i was never that good at...

(I have made a similar thread before, however this sites the problem more clearly) I have a parameter querie, im using the instr function so that i can type in 1,2,4 and it shows me every1 with option 1 or 2 or 3, however i want it to show only who has 1 and 2 and 3 below is the function i am...

Firstly sorry if the wall of text is abit well walley I am trying to design a querie which lets you select multiple criteria from a drop down combo box (job skill) so when it runs you are promted to enter skill1, skill2, etc and then shows a table of people with all the skills selected. i am...

this may just be a simple solution it may not be so be patient if im a tad vague. basacly i want to copy the data (im guessing my client means the tables) from one copy of a database to another, merging the files where they overlap. i not had much chance to play with the database myself (only...

is it possible to make a certain field in a form password protected to edit (but avaliable for everyone to view) if that makes sence, just say if more detail is needed

Hey all, i got another small problem with this bloody database! The problem today folks is this, im making a booking system (well the booking is a small part of the overall system) so i have DateArrive, RoomID, and all the usual. now what i want is to make a query that says if DateArrive &...

hey again, i usually don't post this much and prefer to work it out alone but i have no idea why this isnt working (and the error im getting) below are screen shots, i am trying to make an improved booking system, but i don't know why its saying i have a null value (i went through and made sure...

I dont know if this is possible, im making a booking system, and i want to link menu items to a package, basacly below is what i have, and i want the receptionest to be able to enter in a list of starters and a list of main etc into one field which can thus be selected for reports,and linked to...

Just a small query for today (if you pardon the pun) basaclly my problem is, i am creating a booking system, and i want the total for the length of stay; attributes are Date Arrive | Date Depart | Room Number | room price i want to add an total column at the end (i was using the query by...

I am creating a hotel management system, and chose to use SQL server as the main database, the problem i have is how to implement a good GUI for a basic user to use, i am not the worlds strongest programmer (though i do have a good grasp on the basics and advanced options of SQL (or why would i...

I have taken on the project of creating a hotel management system, that will allow different access levels for different levels of users (e.g. managers all reports, receptionists just booking, chefs meals etc). i have been researching different formats, and was thinking of SQL server, the...

im in the process of designing the framework for a hotel managament system, and so as to keep it similar to the paper based system that is in force now i wanna create a calender so the receptionists(and/or managers) can access the information for that day just by clicking on that date (if u get...

Last year i used a MAcro that will automatacly open a Database file when Access is opened, since then i have formatetd mycomputer and lost the criteria for the event boxes, does anyone have a copy of the events needed, as the end user of my ststem requested this feature Chears for any help Scott

Could somebody please tell me what a intermediate relationship between two tables intales please, i thin this may be interfering with my DB

When i attempt to create a query between two perticular tables (Bookings/Extras and Bookings) a iget an error message about Type Mismatch, all field types are the same though :confused: . On relationships the Bookings Bookings/Extra relationship is a Intermediate relationship, could this be...