Search results

Hi SueBK, Try this for starters..http://support.microsoft.com/kb/209871. Bob

Hi again, As long as your tab in excel is called Loans then there should be no more changes needed. You don't need the autonumber access fixes that all on its own. Bob

Nice!! I like the way it drills down..very nice! Bob

Hum, Yeah I have noticed that too..tested below and it works H:\My Documents\Excel Files\ ....or something like that Bob

You're welcome! I have fixed the problems, misspelled the field :eek::o...fixed it. Also fixed the date filter, tested it and it works. Cheers Bob I cannot upload the database - seems to be a problem just now. post your email address and I'll mail it to you instead.

Ok final version with a delete record button and an excel import button. Note for the delete record button the record needs to be marked to be deleted i.e. choose record and press button. For the Excel Import button I have done the following: A macro that checks in a specific folder and imports...

A newer version with an add record functionality. BOB

SFDemon, Check this out as a start perhaps. Cheers Bob

Ah thx I'll do that! Cheers BOb;)

And also I forgot to mention the accountnumber in the is joined to an account number table that contains all the information. Ah this is messy. I have two tables one called accountnumber that contains static information about the accountnumber, account name, last changed. The second table shows...

Hi All, I have a query that gets accountnumbers the account numbers are renamed and consequently they get a date stamp when the account number is changed. I only want the most recent accountnumber. I have tried using a max on the total row in an aggregate query and it is not working - it still...

Hi all, I am working on a form that would hopefully be able to check if a a query has a certain result then it would produce a nice little picture (exclamtion mark) Is there a way to pass the result from a query to a picture in a form? :confused: Bob

Never mind solved it, the query and field that is linked to the textbox on the form must be non-visible. Bob

Hi all, I have a form with a text box which is linked to a query and a specific field. Now I want to have some of the query's fields to be visible in the form when I enter a value in the text field. But I cannot get the form to update the query so that the results are visible in the form. Does...

Doh! He he yeah I mean of course tried..Will check it out Thx

Right tired that, and it works except for amount that is for example 0,233 then it returns 000? Any clues? bob

Hi all, I am trying to format my union query with a thousand separator but it is not working all that well. This is what I have so far. Does anyone have a clue?:confused: Bob SELECT [DATE],[CATEGORY], [X],FORMAT([SumOfAmount],"# ## 0.00") AS FROM [a] UNION SELECT [DATE],[CATEGORY]...

Hi use this piece of code and this works fine, only thing that is needed is to save the attachement in a predetermined place: Bob Sub MailToGroup() Call SendNotesMail("Test", "C:\Test.txt", "myaddress@mailaddress.com", "Hi testing", True) End Sub Public Sub SendNotesMail(Subject As...

Found it, Me.refresh;) Bob

Hi all, Does anyone know how to update subforms that are in a main form?:confused: Bob