Search results

And here's another. Hopefully next one will let me add pics.

I'm a couple of posts short of being able to post graphics - here's one to make up the numbers.

Hi there I can create a select query with a combo box in it by changing the property of one of the fields - making the display control to combo box and adding the values. No problem there. What I want to do is to be able to create a query dynamically from vba using a CreateQueryDef...

Update in case it helps anyone - memo fields affect sort order dramatically. Removing them seems to help, thought I had none of them in my original query.

OK guess I'll just have to accept that then. Thanks for the replies guys.

So there's no way to create a table from a query that's in a specific order? Surely there must be - or else why even have the ORDER option?

Hi there This is something I occasionally see in Access and has been bugging me for quite a while. As an example, when I have a table (all text fields except for the ID field which is an Autonumber with a unique index - ie just what Access creates when you import data) and I try to make a...

Graphics card eh? - could be, I remember just getting a basic one as that was all I needed. Guess I'll just have to live with it. *** UPDATE - just got the latest graphic driver available - no change.

Thanks for the replies - nice to know it's not just me going nuts. The chap who works next to me NEVER has the problem though, and he opens the same files, has the same version of Access, uses XP Pro same as I do etc etc - in fact our PCs are the same model bought at the same time. There has...

Hi there! Hope someone can help me with this - I'm using Access 2002 and when I do a new query and add a table, I often can't get select all the fields by double-clicking on the top of the table - it just doesn't respond at all. The problem resolves itself if I maximize the window and then...