Search results

Just a question tho: do you really need to store all the colours as separate fields? What's your reasoning for doing that? Because whatever your reasoning is, ANY table with that many fields is probably going to become unmanageable... It may be better to store the 'required' colours for a...

lol ok.... I can see it would get complex with that many colours!! Guess we'll have to leave it to the gurus ;)

A possible solution, albeit a not very elegant one, would be to use: ProductColour: iif([product type]="multi","multi",max([red],[yellow],[blue])) I'm sure someone else will come up with a better solution tho ;)

it'll be on here..... http://rogersaccessblog.blogspot.co.uk/search/label/*%20Index%20to%20Access%20101%20*

As for the combobox: If there are two columns in it, the first being the ID and the second the 'text', then you will need to set the properties as follows: ColumnCount: 2 ColumnWidths: 0 cm;3 cm BoundColumn: 1

Have you looked at the 'DisplayWhen' property? ... or: is there any code on the form which runs when the form opens/loads/oncurrent, which sets the fields visible property to false?

you might find the info in this thread useful.... http://www.access-programmers.co.uk/forums/showthread.php?t=252431 and also some suggested reading http://allenbrowne.com/AppInventory.html

It's a bit of a bodge really - but what I did in the end was to create a Public mailing list on our mail server, and then just use that email adddress rather than using a loop to get the data from a table... thereby getting around the fact that Notes doesn't like sending to more than one...

this might be on completely the wrong track, but if you use the Snipping Tool, you can save what's on screen as a JPEG.... or of course, there's always good old Alt-PrtScr... not sure if there's a way to automate either of those?

Never did get to the bottom of this, but I found a workaround so I'm marking this as solved ;)

Eventually solved this.... by creating a Public mail group on the mail server, and adding all the receipients into it! Never did find a 'proper' solution, but definitely got a workaround now ;) Thanks to those who tried to help :)

well, blow me down, how come I never spotted that, lol..... ty :)

can I PIVOT in Access??

I'm looking for some help here (obviously!) I have a database which tracks Sales Leads... in tblLeads (which is a download from another system, so I have no control over how it 'appears' in my database) I have LeadID (PK) ConsultantID (FK to tblConsultants) DateLeadPulled (Date ;) )...

On the form you are using to do the search.... are the boxes you are typing the search terms into bound, or unbound controls? If they are bound, then that could be why it keeps 'bringing them back' - it's opening the form and showing what's in the fields already. If you don't want it to...

You only need 1 field... Then base your report on a query. In the query, create a calculated field, something like DisplayThis: iif(somefield="Novice","",somefield) and use the calculated field on the report

Your report needs to be based upon a query that contains both tables, with the relationship between the two tables in place. You then just add your PCode from the PostalCode table into the query, instead of (or as well as, if you prefer!) the PostalCode field from your Customers table...

From now on in, you're on your own, lol.... ... at least until Tuesday ;) (Just noticed you've said you can have both apparel and trophies on the same order - this version allows for multiple lines but of the same type.... see if you can work the next bit out for yourself? ;) )

ok the multiple lines thing should be easy enough to do - just means changing the subform to be a continuous form, a bit like the Customers form with the list of orders at the bottom, showing a 'summary' of what's been ordered, with an 'Add Order Detail' option like the 'New Order' button'...

Ok, don't tell my boss, but I got bored today (a meeting was cancelled!) so I've had a play round with your db, did a bit more with it than I intended lol but have a look and see what you think of this?