Search results

Hi the database i am trying to create is very similar to that of a shopping list the user would like the database to price up all goods in a list. however say for an example the user wanted to buy something different the following week i would need to edit the shopping list. but the user would...

Hi Does anyone know if you can make a filter by form button on a form, i know it is on the toolbar but i am trying to see if it can be put on to a form. many thanks everyone

hi thank you for your reply i do understand what you mean, what i am trying to do is do a query where the user is asked to type in a purchase number to open up another form, from that page the user can edit data. however to edit data the user will need the correct purchase number, however if...

many thanks Rich hi Rich i have finally solved my problem, just wanted to say thanks alot for all your help

Hi does anyone know if there is a way of doing a query where if a user does not type in something or they type something in that is not correct into a msg box, an error message will appear on screen many thanks

hi thank you for all the help, i have been doing what you said and so far when i select the item and then click on the button to open the report it appears blank the code i have put into the query linking the report is [Forms]![project query]![Combo2] = [Reports]![totaltender]![ProjectID]...

sory got your msg after i sent this out

Sorry what do u mean the wizard and code builer will do the work for me, i have been trying to do this but to no avail At present my report if you click on it it brings up a list of all items in the table PARTS but what i want it to do is depending on what i choose on the drop down box i want...

Hi I am trying to do a report linked to a query using a drop down box(as i want users to select what item they want to view not type in what they want) however i have been advised that this is not possible. Instead I have to do a form wher i use a drop down box from the form and make a buton...

Hi you were clear enough i just wanted to find out if anyone else any ideas on doing it an easier way as i am not very good at VB codes so i try to avoid them as much as possible i do use VB for my database when i really have to other wise i try find easier solutions you mentioned some code...

hi i am trying to a query where i can view using a report all items matched by what i type in however what i am trying to do is have a report linked to a query where when the msg box appears, instead of the user typing in the item they can select from a drop down box. i am not entirely sure...

query for report hi thank you for your advice however i wanted a drop down box for a report, at present if i wanted to view a price for an item i have to type in the item in the msg box which i have created using a query however i wanted to make life easier so i was hoping there is way of...

thank you Hi i just like to say thank you so much you have saved me alot of bother thanks once again

hi i am trying to select an item from a drop down box and when i select the item i want the price of the item to appear on a sepearate field called price. i have seen another database do the exact thing i want but on that occasion the address selected was imported into another table called...

hi just wanted to ask does anyone know if there is a way of making a query where you can use a drop down box instead of typing in the search item i have been trying to no avail many thanks

thanks Hi thank you very much i see what u mean however i tried this method yesterday and couldnt find a way of saving the default values in the change table therefore my report came out blank when i did it do you now what i can do thank you

attachment option hi there is a option to attach a a ttachment but when i do attach a zip file it doesnt seem to posted onto the forum kabir

thank you Hi thank you so much for your advice i didnt understand what you meant at first but then reading it more and more i understood what you meant and now have a logical way of fixing my problem Once again many thanks p.s do you know why i cant post any attachments by any chance

attachment sorry didnt attach for some reason, i have sent a msg to web master to help me on this

Hi Thank you for your reply, what i wanted to get from the tables is price differences, quantity differeces etc. i do like the sound of the change form where i could use a button that would move the data from one table to another however i do not know how to do that. i have attached a screen...