Search results

Hi all, From another post that I have been trying to help with I have a question. Is it possible to create a querie that has, in a criteria Like Forms![Form1]![Lookup].Column(1) Lookup is a combo box with 2 columns It throw up an error message "Undefined function........." Any help would...

Ok take a look at this, Garry

Ok Dunne, Have a play around with this. Garry

Ok, give me 15mins and I will do this for you. But you have to promise me that you will strip it down and investigate how it works and how to change formats, queries etc etc. If you are not sure ie, "QBE" then google it. Garry

Ok, Lets go back a post, It won't, dont change the text box's, change the subform into a "continuous form" No VBA has to be changed (or very little), just the query. If you add another text box just add Me.refresh to one of the event procedures, usualy "on Exit" (((tbl_movies.Title)...

Hi Wayne, I've never really thought about this before, because "obviously" I sort or group them as and when I display them or print them etc, so its never been an issue to me. Cheers Garry

If you left click and then right click on the top left hand side square of the subform and select properties the format can be altered. (lots of different ones) The form and subform are refreshed each time you change the combo boxes or exit out of the text box, this is done by an "event" which...

You should try it with only two fields. Field mechanic mechanic table REPAIRS TABLE REPAIRS TABLE Total Goup By Count Sort Show Criteria Garry

Make a backup of your DB. Now you can play around with the format of the subform so it looks like a list box, Try Changing the subform to display as a continous form, Delete the labels, arrange the text boxes together at the top of your subform etc etc Its upto you to play around with it now...

Hi Niel, On that note, just out of curiosity, If the table has never been sorted (A-Z etc) is it displayed in its indexed state? Garry

Hi naym, What I would do is physically change the size of the subform to only show 10 records. Put a button on the main form with the following code in the "on click" event. It should move the records forward by 10 each time you click the button. DoCmd.GoToControl ("Subformname")...

Hi Dunne, OK, after having a look at what you had I have made some changes to this, I think you will find this easy to understand and a little bit more logical. Let me know, Garry

No its ok, I will get the gist of it. send it as it is. :) Garry

No its ok, I will get the gist of it. send it as it is. :) Garry

Hi Dunne, Can you send me a copy of your db, that way we can discuss on the same level with the same field names etc. Garry

I dont usualy use SQL I use the QBE but it looks ok, Not sure if you need [] or Brackets. It sounds right so far. When you open the Form what happens. Garry

I dont usualy use SQL I use the QBE but it looks ok, Not sure if you need [] or Brackets. I sound right so far. When you open the Form what happens. Garry

In your query do you have anything other than "mechanic - Group by" and "mechanic - Count"? Garry

Hi Dunne, You need to use both Query and VBA, Take it step by step. Delete your list box and add a Subform, (make sure the wizard is switched on for this) Once you have your subform done, do a quick test, open the form and you should see all your films in the subform. Step 2, Now you need...

Sorry Dunne, Off to bed will pick this up in the morning, Garry