Search results

Ah, I see where I was going wrong and now have a fully working first combo box, so thanks for all your help guys. :) My problem now is that I've written up a form (coredata4) which is to display the filtered records, based on the query. The form with the combo box on has 'Table/Query' in its...

The SQL in questions reads: SELECT coredata.Name FROM coredata; 'coredata' being the table holding the main database records, 'name' being one of the fields I'm trying to set up a filter for. It's obvious to me that it's currently just reading everything in that table's field, instead of...

Ah! There it is! Thanks again, Rich. The only thing I have noted though, is that I can alter the Unique Values to 'yes', but in testing the form which contains the combo boxes, they still list all of my records (i.e. multiple occurences of data appears multiple times). Apart from even...

Firstly, thanks for the advice, Rich, it was much appreciated. Hokay, still a few problems, most notably with this eliminating multiple records. I'm following dcx693's directions on point 2, but don't see a 'unique values' line anywhere...umm....on any screen. The 'group by' method example...

Apologies if I'm sounding impatient, but any luck with tracking down those examples, dcx693? I've had a search myself, but can't find what I'm after.

As I said in the thread, I had to remove the pictures to make it small enough to upload. To put it back, open up the database proper (either by holding down shift as you load it, or loading it and hitting F4 twice). Once in, select Forms, then highlight 'Background' and click on the 'Design'...

...and unfortunately I don't know how, which is where you lovely people come in. I'm trying to create a form which contains a number of list or combo boxes (never really understood the difference between the two), that allows users to select a number of different filters, then click a button...

Is this what you're looking for?

Thanks. No idea why my original query string was going wrong, but the new one works fine now. :D

You may be right on the syntax front, but I can't for the life of me see how it should be presented. I tried your advice, same problem I'm afraid... :rolleyes:

Right, I'm a little bemused by something which is happening in my database following the addition of a new function. Essentially, I work in the education sector, and have a large database filled with student details. A lot of our students are foreign, and so stay with host families whilst in...

That's curious. I just downloaded my own example and tried to run it on my home machine (same Access version, same OS) with the same result as you guys. Wierd. There must be something on the office machine it's referencing that isn't on other machines.

Well, my first suggestion would be that you have a poke around inside the Northwind example database which comes with Access. Pretty much everything I've learned about Access has come from taking apart other people's examples and examining the code myself. You may also find that you can simply...

If your referring to the example is posted, Fizzio, I'm surprised. I get no errors of any kind with that type of setup, either on compile or when being used...

Cosmos75, see if the attached example is what you're looking for. The password to enter 'Admin Mode' is password (case sensative). The background is used to hide the fact that Access is running, so the finished database just appears as a series of pop-up windows. You can achieve all of the...

Not too sure about bringing the print options up, but I use a similar kind of thing in my work database. I did it by having the 'Print' button on the form run a Macro, with the Macro being setup like this: Action: OpenReport Report Name: [my report] View: Print Filter Name: [my report] When...

here is an example of the MouseOver text I use for my switchboard.

The Situation: I have the misfortune to have a seagull for a manager (i.e. he who flies in, makes a lot of noise, craps over everything, and then leaves). To make matters worse he is convinced that he is exceedingly computer literate, despite all evidence to the contrary. To date, the witless...

This may be a little presumptious of me, but I've noticed a lot of posts here requesting help with disabling or hiding the Access window behind a database. I personally like to hide it with an attractive picture, and then run my database as a series of popups over said picture. I've included...

The 'ou' diphthong is - AFAIK - pronounced exactly the same way in both the UK and the US, so 'flour' sounds the same as 'hour'. It seems to just be your single vowel sounds that are altered slightly ('ant-eye' instead of 'ant-ee', when pronoucing 'anti', for example). Oh, and your spelling...