AW23
I assume when you mean a MEmo you mean a field of type Memo.
If so then this simply uses a normal text box which can be expanded out.
There is no special Memo box on the tool bar.
Regards
Peachmelba
I found this which might help
Public Function GetContact()
Dim olApp As Outlook.Application
Dim contacts As Outlook.MAPIFolder
Dim listContact As Outlook.Recipient
Dim distList As Outlook.DistListItem
Dim i As Integer
Set olApp = New Outlook.Application
Set contacts =...
Try modify this
Public Function GetContact()
Dim olApp As Outlook.Application
Dim contacts As Outlook.MAPIFolder
Dim listContact As Outlook.Recipient
Dim distList As Outlook.DistListItem
Dim i As Integer
Set olApp = New Outlook.Application
Set contacts =...
I have a customer who wanted a very similar thing.
One site in the south of the Uk and another in the north. Linked together with a 500k pipe.
Looked at replication and sycronization.
Very messy and a real pig to look after.
Solution I went for was to use Microsft Server 2000 Terminal...
Yeah tried cutting up the value into left(mydate,2) & "/" & mid(mydate,4,2) & "/" & right(mydate,2) which should give me 31/06/04.
But gives me 04/06/31.
So it obviously is changed as soon as it is entered!
Any other ideas?
Peachmelba
Can anyone help with this.
I have a field on a form which is a short date (dd/mm/yy) format. When I input 31/06/04 there is a check on the value to make sure it is a date using Isdate funstion. This returns true as it thinks that the date is actually 04/06/31.
I can't think of a way to sort...
Craig
Thanks but that is the problem. I need to read in one cell at a time hence why I am using 'Input' rather than 'Line Input'.
The problem is with the number of commas which is not consistent. Excel seems to drop commas after about 10 rows. This means that the first ten rows have 21 commas...
I have a file that I have created in Excel which has 21 columns. This is saved as a CSV file. I then import this file into Access using the following
Set rs = db.OpenRecordset(strTableName)
Do While Not EOF(1)
i = 0
rs.AddNew
Do Until i = intNoImportFields...
Try here for the files you want
http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp
Files contained in MDAC 2.8 are on
http://support.microsoft.com/?kbid=828396
Regs
Peachmelba
Jim
The best solution is using the Jetcomp.exe which is usually stored in the windows\system32 folder. If not download the latest from Microsoft.
This is a useful tool for repairing any database. Try on a copy first. Quite straight forward to use.
Good luck.
Peachmelba
Rookiedev
This is usually because one of the tables it is looking for to relink does not exist in the data database. When this happends I usually delete all the link tables and relink them all. Much quicker that way.
Peachmelba
Alan
Thanks for the response but that does not work.
I think it is something to do with the pvtTable.DataBodyRange but i have not yet looked into this.
Regs
Peachmelba
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.