Search results

Is the following correct?

Thank you for the prompt response...:) My combo box is called: St_Status My text box is called: archive - which is unbound. Do I use the 'Expression builder' to write that code. :o This is all new to me :( Thanks again.

Hi, Is it possible to make a text box field active based on content from another box? Basically I have a drop dwon combo box that shows a list, such as 'active, withheld, archived, etc'. If the used selects archived, then I'd like the the textbox to be active so the user can input a date that...

Something I read; If you're refering to the number of rows visible in the drop down list it's 1000. AutoFilter will operate on lists greater than 1000 rows in length, but you must select "Custom" and enter the value(s) of interest. :(

I don't see Alphingate Cloase at all, even though it's all alpahetically listed. The last record I see is York Road, in the filtering list. :confused:

I have noticed that it displays records (in the scrolling list) up to row number 1060. Nothing beyond that. :mad:

Here we go...do your magic :D Using autofilter I cannot see Bower Cup Fold in the list.

:D I know... But whilst scrolling the list...not all records (data in the row) show. Anything else :confused:

Thanks for the resposne... I have data that makes up 1300 (approxs) rows. When I perform the AutoFilter option and scroll the list within the drop down filter list, not all records show. :confused: Hope that helps...:o

Hi, Does anyone know if there is a limit in a filter list (using auto filter), as many of my records do'nt seem to show, unless there is a glitch of some kind :( I have approx 1300 rows. :o Thank you.

Hi, I have a chart that has figures/data and in one of the cells I need to put in N/A - this is treated like 0 (zero) and messes up the chart. Any way of getting round this? Thank you :)

Excellent...Thank you! :)

Hi, I am trying to display all records that are 30 days old from date of registration (& not paid). I have: 30 Days: [SrDate]+30 SrPaid = No But I don't want to see those that have registered in the (say) last few days, but only those that have not paid and 30 days are up. How would I achieve...

Hello anyone home:confused: I can see the Primary key (autonumber) field, but cannot see the the other content (this is in the table structure). A drop drown arrow displays both content (ie primary Key & data), but then leaves the primary data number rather than data i'd like to display...

Thank you for the reply. How can I see in table view contents from another table, what's the best way round this? TIA.

Is that in the Title table? or would that be in the Parents table, which are both linked? :confused:

Hi, Trying to get back into Access after a long time, just need some refreshing :) tips. I have 2 tables, one of the tables stores titles (mr, mrs, etc). I tried using the 'lookup' data type to link the data from the other table. This however stores the field as a number and causes problems on...

lol...I just remembered and came back to reply, but you beat me - thanks for the reply :D . Didn't know what I was looking for...:)

Hi, Could some one please jog my memory, what I'm trying to achieve is formatting of text. Basically I'd like to have text on 2 lines but in one cell (not merged)...I used to use a short cut but unable to recall. Any help appreciated. :o

Hi, I'm testing out some VBA coding and have created a simple userform. How do I get this to oped/display in my spreadsheet? Thanks! :confused: