Search results for query: *

Thanks merlinx That is heck of a link. Nice one Tom

Hi grnzbra I'm not sure that such a list exists anywhere. Here in the UK we have a structure that allows the following genuine zip codes (we call them Post Codes) NN17 9RS LS3 1DD W1X 3SE EC1R 5DX W2 4PH RG2 3AB If you ever find a list then I would like to know it too Best of luck Tom...

Hi Tadynn I suggest you look at thread702-174997. If that doesn't give what you need then try the search for "Conditional Formatting" in the Access forums. There are quite a lot of threads on this which should help you, failing that post some more detail on exactly what you are...

Hi RussDogg I have a similar structure in operation on a number of databases, and the general technique is build a dynamic sql string containing the search criteria. (I've assumed that you want to be able to select by any / all combinations of the fields you've mentioned) This dynamic sql...

Hi New9 I was just about to do the same myself, so the zip would be really useful. Thanks in advance Tom tommoranbtclick.com

Also look at thread181-84900 Tom

VBSlammer had a good point there, but remember that your data might not always be delimitted by spaces or any other fixed character for that matter. Tom

Hi Muzzy I'm not sure what you've got there but month(datefield) will give you the month number (1 - 12). You could try using this and then converting the number afterwards Tom

Instr will find one string within another (check access help for spec). As you won't have completely uniform types of address data, which is very unlikely, I suggest you separate your string into substrings using the space separator first but watch out for "," and "-" also...

A few more thoughts for you Is the form based on a query, and if so are there are conditonal elements in the query that relate to to the control source for the field? Is there any conditional formatting that effectively hides that field by making background and foreground the same colour? Is...

Hi ModeX Assuming your form is based on a query (if on a table then change it to a query), then try changing the control source of [label_1] to an iif in the query itslf. e.g. IIf([Date]>now(),“times up”,“Still in time”) Tom

Sorry, I've never used ActiveQuery so can't help you with that Tom

Hi It sounds as if you need something like Forms![Mainformname]![SubFormName]!TextBoxName.ControlSource = ChosenFieldName for each of the fields the user has chosen. You could set these at the same time as you are creating the SQL string. Tom

A couple of quick thoughts. 1) Have you tried Compact and Repair. 2) If you cannot do that, can you import selectively into two or more new databases, then compact and repair and, rejoin and continue from there? Haven't got a db that size to try myself, but let me know how you get on as I can...

Any control on any loaded form or subform is accessible givien the correct reference syntax. There are many ways to refer to a control on a form or subform. Try checking the VB help under subforms. This gives plenty of examples Tom

Hi Instead of trying to test for the colour, why don't you just test for the condition that is used to set the colour in the conditional formatting Tom

Sorry - can't type - should be tommoran@btclick.com

OK send me the mbd then and I'll take a look at it Tom tommoran@btlick.com

Whoops Big Typo - not concentrating properly I've only used two fields here, parkcode as numeric and weedname as text INSERT INTO Regestration ( parkcode, weedname ) SELECT IIf(IsNull([hhreg].[parkcode]),0,[hhreg].[parkcode]) AS Expr1, IIf(IsNull([hhreg].[weedname]),&quot...

Hi Wrecker You just need to use iif in a query e.g. iif([FieldA]="A",OldValue*Multiplier1,OldValue*Multiplier2) Regards Tom