Recent content by steallan

Thats all im trying to do. I need a button on a form to run multiple macros that rename a table one after the other. Unfortunately im not the best when it comes to VB Can anyone help please?

Well isn't access a bag of $hit! when it comes to printing anyway thanks Andy at least thats resolved, ill export to excel i guess

one item type can go into many baskets, but one item (i.e stock item) can only go into one basket, coz once it's sold its gone right?

HI If i set the print settings (page orientation, size etc) when i have a query open, Access has forgotten it next time i open the query. How the smeg do i get it to remember the print settings? Please help me im running out of hair! Thanks

YES! it works, hopefully it will work multiple times in the same query for different fields? Cant work out why it works!!!?? thanks

Hi can anyone help please. I have a form where users can specify crtieria for a query. The value that the user enters via a combo box on a form is entered in a query. The user then hits a button to run the query. Problem is the entry i have in the criteria of the query that links to the form...

Seam to have solved my problem, dont understand why. At first i had as the "raw source" of the Combo box SELECT [CWT_Room].[HospitalZone] AS [Hospital Type] FROM CWT_Room GROUP BY [CWT_Room].[HospitalZone]; I removed the AS and now it works! SELECT [CWT_Room].[HospitalZone] FROM CWT_Room...

Sorry i didnt explain to well. I want the user to be able to specify criteria but if they leave one, two, all etc blank, then it just displays the records for the criteria that has been inputted. If none of the option critieria have been set then all the records are shown. I have found this...

I love you! Just spent an hour looking through the threads trying to find the answer to this exact problem. Works a treat All Hail WillEllis, HAIL! HAIL! HAIL! er....i mean thanks

Hi I have a combo box displaying a list of values from a field in one of my tables. The criteria of a query is linked to this combo box. So when the user selects one of the values in the combo box, then hits the button to run the query, only the records with that value appear. Works fine...

Sorry.... Worked it out now, sorry to waste your times with this STUPIDLY easy question

Hi This is simple im sure but i am a thicky How do you allow a user to enter a value in a form; have access set that inputted value to a criteria in a query? Then ill have a button to run the query which i can do thanks thicky ste

i know that.....not that dumb.....just ment what particular example database out of the many would be the best. Found good one now anyway.

ace that's not exactly what i was after but it will be really useful, thanks found what i wanted in example database. just got to work out how to repeat it now. thanks again

So dumb.... can you point me to the right one? I canny find the stuff me is looking for!!