Search results

Thanks Chris I'm not great with using Modules. I'm guessing that I need to create this as a class module? Having done that, how do I then call it? Thanks Nick

This isn't a VBA question, but if you go into the field properties and find the Input Mask section, type in PASSWORD into that property and it will do it for you. Nick

Not sure about the formatting itself, but I know it won't work unless you include this: .BodyFormat = olFormatRichText somewhere between With MailOutlook and End With (before the sending part, obviously!)

Thanks for your responses, guys. I got it to work like this: Dim stAppName As String Dim docType As Integer Dim ext As String Dim app As String docType = DLookup("documentType", "tblDocuments", "documentID = '" & Me.documentID.Value & "'") ext = DLookup("extension"...

I'll make an assumption that you have a field called "OrderNumber" on both forms. Add in stLinkCriteria = "OrderNumber = '" & Me.OrderNumber.Value & "'" right before the DoCmd line. Obviously you'll have to butcher it to get the field names right. The first OrderNumber in my code is the...

You are quite right. I've just performed your test and found that it only worked when using both. The reason I have not come across this problem before is that I mainly use it in message boxes, where it is not an issue. I would swear blind I've done it on forms, but perhaps I haven't since I...

Hi, can anyone tell me why the following doesn't work? Private Sub cmdOpenFile_Click() On Error GoTo Err_cmdOpenFile_Click Dim stAppName Dim docType As Integer Dim ext As String docType = DLookup("documentType", "tblDocuments", "documentID = '" & Me.documentID.Value &...

I always just use & chr(13) & It's always worked absolutely fine for me, both in forms and in message boxes. What is the difference of which you speak? Nick

Subject:="Company Work Order " & Me.ID.Value

OK. Had a look at your dB. Point one throws an instant problem. You have not related the data in any way, so short of hard coding (very bad practise) ther is no way for the system to know which File Locations are part of which File Cabinets. The quickest way to get round this is to add a...

oh, and by the way, this http://support.microsoft.com/default.aspx?scid=kb;en-us;209948 has been extremely useful to me in the 'sending emails from access' scheme of things If you're mailing a lot of reports, this www.express-soft.com/mailmate/clickyes.html is a neat way of overcoming the...

I don't knwo what version you're using, but on my Access 2000, the object name is the second argument of the SendObject method, which means you are trying to use acReport as the name of the report, which of course it is not. The reason it is looking for '3' is because three is the equivalent...

I've already written this post once and it got lost... How about something like: For Each ctl in Me.Controls If ctl.ControlType = acSubForm Then ctl.BorderColor = lngHighlightColor End If Change the control type to whatever it is If you want to exclude some, give them a name such...

Not sure why you would want to do this, but the reason it doesn't work is because in your code it runs through all the sequence faster than you can perceive, then shows the last colour indefinitely. No guarantees, but you could try something like: dim startTime as Time dim endTime as Time dim...

No! LOL. I did a search on this forum before posting, and someone else asked the question before. That post was dated December 2001. I've been working on this project about three weeks. Nick

Hiya, Working in Access 2000 to an MS-SQL 2000 server, and having created the ADE file and put it on the fileserver, it opens as read only, so it is impossible to add or modify data (somewhat defeating the object of a database, you might say) I have tried copying the ADE down to local machines...

have got round this now. I had an If without an End If, so it wouldn't compile.

Hi, This was asked once three years ago, and no-one replied...... Having got my database somewhere near where I want it, I decided to test the client / server setup. So, I went to create an ADE file. But the dialog threw back an error that simply said "Access was unable to create a .ade...

Many thanks to all for the help here. I am very grateful. The solution was the deafult value on the field, and why I didn't think of that I don't know! Since I am running an adp to SQL2000, the default was in fact CURRENT_TIMESTAMP, which dumps in both date and time, which is probably more...

Nope. Thanks though. Tried this myDate = Day(Now) & "/" & Month(Now) & "/" & Year(Now) and then ...cAction & "', " & myDate & ");" This returns 01/01/1900. If I do the same but with - signs it returns 12th July 1894, bizarrely. If I wrap it in '' it just errors out as described above...