Search:

Thank you!

I have been trying to hide the navigation pane in my FE. I have unchecked the "Display Navigation Pane" in the Access Options but Alas, it is still there..... It is an annoyance to my users who don't...

Ok sorry, yes thank you!

Hello all, I am having problems with dates again.... They trip me up eveytime :) Anyway, I have a query that I need to show all records that are 10 years or older from their effective date. I know...

Thank you!!! I knew it was something easy... I really appreciate your response!

Have a great day.
Rachel

Ok, so I have an Access 2007 database and it is used to record account transactions. I have two tables one called TBL_Categories and a second called TBL_SubCategories. There are a list of categories...

Hey Hans I am not finding any unqualified references, however, now I am experiencing a second button on the same form throwing up errors. I have a second merge identical to the first button but for a...

Thank you I will look it through.

I was just looking into this and noticed that for some reason after I close Word, an instance of it stay on locking the template... If I ctrl, alt, delete, then I see WINWORD and can end process.......

Hi Hans, I did look at this before hand and all is set up correctly....

I used Helen Feddema's DocPropery Code.... Worked great....


Private Sub CreateCensus_Click()

'Written by Helen Feddema 4-22-98
'Last modified 7-Aug-2007

On Error GoTo ErrorHandler

The database is 2003. The version has not changed. That is the weird thing! It was working correctly two days ago...

Hello, I have used this for years and for some reason all of the sudden the silly things wants to throw errors up. I have a set up that uses DocProperty to merge to word to create letters. When I...

How is this?

Fee: iif([Perfilling] =true, iif([multiplans]=true, iif([sizeofplan]="small",1400, 4000),iif([sizeofplan]="small",700, 2000), [numberofdays]*feeperday))

iif is the Immediate if. It...

Generally if you perform the calculation in the query, then the form just displays the result generated by the query. Is that what you are doing?
But sometimes all the calculation is done on the...

Can you post a version of the database with just enough data to see the overall structure?
Where do you want to perform the calculation? In a query or on a form or on a report?
This thing is a...

Hi I am struggling with totaling a calculation and need some "Expert" help!

I have a Fee Schedule with multiple parameters and would like to have it automatically give me a total. The Paramaters...

Thank you! You are always a great help!

Ok, I have a table that is called Census Letter Details, the users create a new record for each year that they do a census letter. I am trying to create a query that shows only the last two years of...

Ah, thank you so much Francois! I knew it was easy!

Have a great day!

Thank you I have found the answer for the date/time. I should have just kept looking! I believe that it is this:

In your form's BeforeUpdate Event, just put in code like this:

txtLastUpdated =...

Ok, I know my brain just is not working. I have two fields in a table that records request for changes in our database. I want it to automatically record the date and time the person created the...

Thank you! I will do that... I have one of her books, Access Inside Out and it is a great help as well. I am going to sign up for that newsletter as well... Thanks again!!

Thank you Hans, I will persue this and go from there. Your help is alway appriciated!

Well, that would have worked however the problem is that I keep loosing my link to the query. I don't want to have to re-establish the link everytime... Here is what the Error was this time: This...