Recent content by Aidanb

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...

Thanks Dave and Spoole, The Sample is not what i am after i want to be able to just have a list of products and just type in the amount counted like the spreadsheet. is there any way that you can all the products from one table to a sub form say based on the week start date? if there is no...

Hi Spoole, Thanks for the info have you got a sample of this just strugaling a bit to understand what you mean also i am having problems bringing all the products in to the form so all i need to do is add the amount of stock we have in. as we need to do a closing stock at the end of the week...

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 Bob, would this work with the system date so all i would need to do is tie it in to a command button so when i click it, it would print the report with the actual figures up to todays date then add the forecasted figures after todays date. and how would i do this in a report so it would...

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...

To be honest i have not been doing much past few weeks as had alot on with work so have put the self taught programming on the back burner for a while.

Thank you speakers_86 looks just like what i want will try it out. Thanks again.

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...

Thank you for the advice will take a look was just scroling through the links not doing a actual search.

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...

what i have is a form with multipul records on it and this is then linked back to an employee table through the employeeID the weekstartdate links back to the takings table. what i want is to have all the employees names put in a table then this will populate the employeeID in the labour table...

Hi, think i am getting there have tried to do this in the filter condition in the DoCmd bit to try and stream line the code a bit but comes up with type miss match not sure what is wrong this is filtered through a query then shown in a report is there a diffrent process to this or is it the...