Search results for query: *

Thanks Geoff, I have had to develop a different approach now to workaround other problems, but you helped me get a draft ready in time and avoid any hold ups. Regards, Phil.

Hi Geoff, Thanks for the suggestion, but alas it just counts all of the values for Rowfield2. I had tried using the Count property of Visibleitems previously too, this has the same results. Kind regards, Phil.

Been through everything that I can find but can't work this one out, probably means it's simple! I have a pivot table with 2 rowfields. I want to count the displayed items in rowfield2 when rowfield1 has a filter applied. I can count all of the items in the rowfield2 using...

Remou, Works like a treat. Knew there was a simple way around it but just wasn't thinking Access!!! I have assigned the recordsource in the GotFocus event of the combo as viewing continuous forms. Many thanks, Phil.

Hi Remou, I have tried doing this but always get prompted to enter the parameter on opening the form. I am guessing this is becuse I am having to populate the text box via a query which in turn is referencing the main form. Phil.

Hi All, I am putting together a Database to look after questionnaire responses from forms created in Excel which have been emailed back in text files. The questionnaires can change and therefore the database needs to know which questions are associated with which responses - all come back in...

Welshy, Take a look at this, I think it's what you're after : thread68-947139 Phil.

PH, Ignore my last post - I forgot to take an Exit statement out!! This works great. Thanks again, Phil.

PH, I still get asked the question, even though I have added 'Me.Saved = True' as the last statement in the BeforeClose event!! Thanks for the idea though, I'm sure this approach has got to be in the right direction. Phil.

And I have just found that DisplayAlerts doesn't affect this anyway, so my problem has just gone sideways!!! Phil.

Hi All, I'm sure someone will know how to do this and make me feel really stupid!! I have an Excel spreadsheet which is to be used as a questionnaire. I hide all toolbars, tabs etc; and turn off alerts. The thing is I don't want to get the save changes message up when the user closes the...

Hi, You're right in thinking that your data could be better organised. But, what you are trying to do is still possible. You need to create a field in your query which uses several nested IIf statements to get the correct data. Below is what you will need to type in the Field box of your...

Won't make any difference if they are on your desktop then!! If you use them a lot and are not shared, I would recommend making a copy on your local drive. Phil H.

DaMorf, Have you got a date field within the table?? If so, what you are looking for will be the Month function. Create a field within your query such as MonthNum:Month([YourDateField]) and use criteria such as Month(Now) Hope this points you in the right direction. Phil H.

Chris, Have you tried just doing a Find/Replace on the XXXXXX part, rather than including the href = ' If you are not replacing the single quote, surely it should be okay! Phil H.

Hi Simon, This sounds as if the template file which is being used has at one time contained or still does contain macros. Try creating a new template and see if that works. Phil.

Hi, Hopefully an easy one to answer. Fairly new to Outlook, have had to suffer the pains of Notes for some time. Does anyone know a way of viewing all Mails (ignoring folders etc) as was possible in Notes. I need to see in one view Sent and Received items no matter which folder they may be...

Mighty, How about making this your default printer? Phil.

When you open the task pane is there a link at the bottom of it to [COLOR=blue]Restrict permission...[/color blue]. If so what do you get when you click on this? Phil.

Hi poalaerds, How many columns are displayed in the Combo Box and how are you refering to it? Phil.