Search results for query: *

Never mind I figured it out. Instead of vbProperCase, I just used the value '3', and it seems to work.

I do not do much in Access and find it cumbersome at times. I have a query and all I want to do is change a field called "LastName" to propercase. In the expressions builder on the query I have typed in: Expr 1: StrConv(LastName, vbProperCase) ... but just get error messages!! Please help...

Appreciate the knowledge you bring to this forum. Microsoft help didn't list this anywhere! I would be interested to read the debate on proper case. I'll do a search in that forum Thanks.

Microsoft Word has a function to change the case of a field to capitalize the first letter of the word ... for example: JONES to Jones. Is there any thing in ACCESS that will do that function? I can only find upper case or lower case functions.

Thank you so much for your suggestions. I am going to try and do the update query, as I am sure I will have need to update my links in the future. I did do a work around ... I just made a copy of the text file giving it a different name, and linked that to my database. Once I related these...

I have a text file that is created by another program. I have linked this table to Access so I run statments with the report writer. I just added another field to this text file. However, I can not view that new field in Access. I have updated my links and just can't get it to show up. If...

Thankyou. Several days ago I was finally able to convert the AR module. I found one customer was giving me problems so I got rid of the history transactions and was then able to finish the process. Thanks. Rita

I am trying to convert my data to 5.1A and am having problems with the AR module. I keep getting a message that the AROBL table cannot be converted. I've done a data integrity check before the conversion and it all checks out fine. Any ideas what to look at?? I have also done one other thing...

I have two computers using ACCPAC and I have the workgroup version of Pervasive SQL on both. My computer has the data and the other computer reads the data on my computer. I just installed ACCPAC upgrade on my computer and put a clean copy of ACCPAC and pervasive on the other computer. I have...

I posted this on the Win 2000 Forum and have not found an answer. I am not very familiar yet with w2k .. since I am using 98. My involvement with this problem computer is through my friend. They received the Klez virus on their computer that is running w2k and it is also the computer that...

I have not checked the event log. I am not very familiar yet with w2k .. since I am using 98. My involvement with this computer is through my friend. They got the Klez virus on their computer that is on w2k and is the computer that runs their network of 3 other computers (that are on 98). I...

I have not checked the event log. I am not very familiar yet with w2k .. since I am using 98. My involvement with this computer is through my friend. They got the Klez virus on their computer that is on w2k and is the computer that runs their network of 3 other computers (that are on 98). I...

I disabled the "auto reboot", tried installing Office 2000 and did get the death screen. Before the machine rebooted, the error read: "STOP Unexpected-kernel-mode-trap Beginning dump of physical memory Dumping physical memory to disk" I was able to install Office 95 with...

Thankyou. I have spent hours on the internet trying to find a solution ... and finally found this web site. I finally have some place to start. The CD's I am using are backup copies of my originals. I recently got a CD burner so figured it best to keep originals in a safe place. Not being...

I take the CD out it just boots up to windows as normal. If I don't take the CD out it reads it again and reboots. Rritz

I have a computer using Win 2000 Professional, that I am trying to install Office 2000 Prof. As soon as I put the CD in the drive it automatically starts the 'setup' program then immediately reboots the computer. It also reboots when I try through 'start' 'run' 'setup' or when I am able to...