Search results for query: *

You may want to try: =rept("0",4-len(B1))& B1 This will add the appropriate number of "0" to anything in cell B1. Mind you that the result will be text. Hope this helps!

I've been working for several months in 2003 openning 2000 databases and have not run into any problems/limitations. Since we are not all using 2003, I think it would be prudent to open in 2000 until everyone's has 2003!

Thanks LarryDeLaruelle! Because I have so much invested in previously built tables with text fields, I think I'll try splitting the table in two, then modify the fields in the two, then combine them back into one using "make table" queries. Oh, btw, I'm using 2003 and it looks like that limit...

Nope. Once you create the query, save it, then "export" it. When you export, it gives you an option of file type to save it to. Also, you can create a query, run it, then "send to" an email address (your own if you like!) That will also request for you to select a file type. Hope this helps!

Try this link... Office 2003 Editions Frequently Asked Questions

While trying to modify a table with 135 fields, mainly type text, some date, I get the "too many fields defined" error! I've compacted and repaired the database, modified the length of many of the text fields to low numbers, but still get the error message. Any ideas other than splitting up...

Check out this link: Hyperlink navigation to a Web site may cause an error dialog box to appear that says that a security problem occurred in Word 2002

Thanks RamziSaab, If you do that, you save the entire workbook, all sheets. I want to save a single sheet. On that sheet I have a command button. The person updating that sheet will click on the button to "publish" it to our intranet.

TIA Trying to publish a worksheet in a workbook to the intranet, this is not working: Private Sub CommandButton1_Click() ' ' Saves goals to intranet ' ' With ActiveWorkbook.PublishObjects("Current_Goals") .Filename = "\\Server\Goals\cgoals\cgoals_curr.htm" .Publish (False)...

Thanks PHV, I reviewed my sandbox setting in my registry (thanks to your link,) and it was set to 2. According to the link, you can set your sandbox to the following: Setting Description 0 Sandbox mode is disabled at all times. 1 Sandbox mode is used for Access applications, but not for...

I just upgraded to Office 2003 and now, whenever I open a table, I get the following: "Security Warning: Unsafe expressions are not blocked." I have to go through three screens to open the table! Any way to turn this off? Thanks,

Problem: Kept getting error "too many fields defined" while trying to change data types in table design view. Solution: compact & repair. background: I searched for "too many fields defined" and nothing pulled up. While trying to change multiple "data type" in table design view, I kept...

Thanks onpnt I did read that link prior to submitting the question. I really don't think it's in the SQL statement. I think it's in the ASP scripting. Thanks for pointing out the trim(). That will help in case someone wants to add a space! Before I actually try it, can you copy the MS SQL...

Here's something... IIS, MS Access 2k Searchit.asp User enters telephone number: <FORM action="telephn_results.asp" name="info" method=POST> telephn_results.asp And it's suppose to bring up the recordset based upon "info" [the phone number]: cmdTemp.CommandText = "SELECT * from...

Thanks! That was it.

Some assistance please. I'm forcing errors in my code to learn how they show in IE6, but they don't show! I only get "The page cannot be displayed" message. If I remove the error, the page performs as expected. Aren't I'm suppose to see an error of some type? Code: <%@ LANGUAGE="VBScript"...

Thanks Cassidy, I was able to get it to display VBscript time() when I ran it from "http://" From that, I'm pretty sure that option you mention is set for both Javascript and VBscript, since they both display. Thanks everyone for the replies! "I'll be back!!!" (I'm pretty sure of it!)

It seems that I could only get it to work if I run the page using "http://" as oppose to using "\\[servername]\" Please confirm if I'm figuring this out right. The reason it works using "http://" is because the server is running the page, where as using "\\[servername]\ , the page is not sent...

Thanks kaht. It worked using javascript! Does that point to the server not recognizing VBscript, even though everything is Microsoft?

Running of IIS, correct! I tried <%=(FormatDateTime(Now(),4))%> Still the same! Seems as if the server is not recognizing the server commands! (Observation only, not experience!) Thanks,