You were correct, you want to Insert, Object, Create from File, Select the file, click Display as Icon, just don't check the box for Link to File. Unfortunately, it seems to embed the whole path as part of the file name, I don't think there is an easy way to fix that. But that may have been...
What type of data is the field. What access does is base its descision on the data type of the field on the first 24 records of that field. If its picking up a number data type and record 26 has text, it won't be able to import the text value. In excel, text values align left and numeric...
I have a user in E2k that gets an error "Invalid Web Query" when running a web query. It seems to run fine until he makes another application the active app, and then switches back to excel. I can't find any documentation on this error and was hoping that someone had experienced...
Show the field codes for the merge field and add '\@ "h:mm am/pm" ' before the last brace } (without the single quotes) that should give you the correct format.
Here's some code you can modify to your needs, just change the range "a1" to your first cell in the list and "a2" to the second, should work fine.
Sub InsertRows()
Dim x As Integer
Do While Not Range("A2").Offset(x) = ""
If...
Thanks, yeah that didn't work. Unfortunately I can't uninstall/reinstall ccMail right now. I wish I could just get rid of it, our clients don't use it, we don't use, but hey, thats corperate politics for you. Thanks for your help
This is kind of a complicated one, basically because of my setup. First of all, on my PC I have Office 97, Office 2000, ccMail 6 and ccMail 8 installed (I think one of these is the culprate, however I could fill this message with all the apps and versions on this PC) running on a Win98 platform...
Well, sorry to say, there is no suggestions other than get everybody upgraded as quickly as possible. The ldb (locking database file) that access creates is exactly compatible between the versions. Your only other option would be to create a 2000 version of the database and have those users work...
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.