Recent content by peachmelba

Try something like With Me![SubformName].Form .Visible = (.RecordsetClone.RecordCount > 0) End With Regards Peachmelba

Phil The NOT() statement reverse what the value is. Simply remove that and it should work how you want. Regs Peachmelba

Fabby1 No I dont think it is possible. I would just use individual check boxes or a list box which allows multiple selection. Regs Peachmelba

AW23 Try using DBEngine.Workspaces(0).Users() This will then let you add, change or set the password. Regs Peachmelba

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

Phil I would do something like this Me.Combo0.Visible = Not (Me.Check2.Value) Regs 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...

Cheers guys Used both of the info you gave me and it worked!!!! Yeah I hate dates as well. Thanks Peachmelba

Tony I have put it in the BeforeUpdate event. Peachmelba

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...