Search results for query: *

Hi, This is a really simple one for you guys. I am trying to write a database to keep track of the documents sent and received on a particular project. My problem is when a document is sent to one person and copied to many. How do I store this data, i.e. one document entry in the "incoming...

Hi there, please bear with me if this is a stupid question, but I am still getting my head 'round Access. I am trying to produce a simple DB to record outgoing documents. The documents recipient is chosen from a combobox with a list of names. I also want to record who the document was copied...

Hi, Thanks for this. I don't seem to have a copy of the OCX file on my PC but have downloaded one from the internet. Unfortunately, though, when I try to use it, VB says that it is not properly licensed. Perhaps I need a more powerful version of VB ? Thanks anyway, Martin [penguin]

Hi, Apologies if I am being stupid, but I can't find the datagrid control in the additional controls listbox. I am using VB 6.3 as shipped with Office XP. I would be grateful if anyone could shed any light on this. Thanks, Martin.

Hi I have a problem with an XL spreadsheet which is coming up as locked by user even though the user was not using the file, excel or was logged on to the network. The computer won't let the file be deleted or moved, only opened as read only and then saved as a copy of the original file. Has...

Hi Is it possible to set up rule to bcc to another folder rather than cc. ? We have a mailbox called QA where all email traffic goes and we do this by using copy to alternate recipient on exchange and a rule locally on each PC. If there is a better way of doing this, I would be glad to hear...

XL

hi All I have the following line: ans = Messagebox('some text') This runs fine on XP but on office 2000, I get the error message: 'Can't find Project or Library' I'm a beginner with VB, so can anyone shed any light for me. Grateful of any help, lou [penguin]

Skip, Thanks a lot - that works great ! Martin

Herewith whole thing... Const iTitle = "Pick file" Const Filterlist = _ "Word(*.doc), *.doc, Excel(*.xls), *.xls" Dim Fname As Variant Dim i As Integer With Application Fname = .GetOpenFilename(Title:=iTitle, _ filefilter:=Filterlist, _ FilterIndex:=2, _...

hi Skip Tried to declare it as a variant (remember I'm a beginner here, so please be patient with me). This is the code as it stands and I get a Type mismatch on the IF statement. Could you give me the corrected version, please, as I'm confused with it? Dim Fname As Variant Dim i As Integer...

Thanks for the reply, I tried that this morning and when I put the if statement to catch the cancel error, it then fails on the OK button when I have selected files. Error is Type Mismatch. Thanks again. Martin

hi All Firstly, I'm a beginner with VB. Got the following out of a book and works when I select some files, however, when I choose Cancel in the Openfile Dlg, it returns msg 'Error 13: Type mismatch' on the FOR loop. How can I check if the array is empty(ie no files selected or cancel was...

I am writing a programme to aid quality assurance in our office. It serves as a database for all communications, incoming & outgoing and generates unique references for documents. At the moment I use getopenfile to allow the users to pick the file they refer to, e.g their letter, or their email...