Search results

Hi All, I have a form that i want to print in to a report. i have set the report up and it works ok i am just having trouble with a look up field in the table that will only produce the value not the associated text. the lookup field is a combo box on the form that pulls from another table it...

Hi All, I am looking for some help on creating a stock control database. I have looked at the templates online and cant find one that helps me create what i want. I need the system to produce a consumtion report off this is the opening stock figure(this is the previous weeks closing stock)...

Hi all, I am wondering if it is possible to have a value put in a text box in a datagrid from a Listbox. I have a recipe database and i want to be able to quickly select items out of a list box for each supplier which needs to be filtered through a combobox. once double clicked the item needs...

Hi All, I have been asked at work to create a report that uses actual data and forcasting data. This will be monthly figures entered in to the database, from this we would like it to produce a year to date figure based on the current date and then projected earnings figure based on current...

Hi all, wondering if someone could help me i am wanting to do a search for room availabilty and suitability but haven't got a clue on where to start i want to search through all the rooms we have but through the input of 2 pieces of information these will be date required and numbers attending...

Hi Might be a Thread in here with this but wouldn't have a clue what to put in to get a result so here i go. I have a database system in 2003 2000 compatable and i want the user to be a ble to login to there personal area so they can request days off and request holidays, ect. I also want my...

Hi All, I am building a database and am wondering if it would be possible and how this would be done, to have a room locked out so it can't selected reducing it from being double booked out. This needs to be checked by date and time as we book a room for a time frame and the room can be booked...

Hi All, I am trying to send a filtered report with on record on it for takings and sickness i can filter through macro but cant get it to send the report by e-mail if it can be done through macro please let me know. if not i want to do it through vba but am having problems in creating the...

Hi all, I am wondering if it is possible and how it would be done that if a new employee is entered in to a database table that it will add a new record in another table so we can enter in the hours that they do each week the date will act as the unique identifier through out the database as...