Replies

A little persnickity, are we? LOL! . True though.

LOL, you’re absolutely right. That’s what I get for writing code in the lounge, I skipped a step, and didn’t debug it! Oh Well, no one is perfect!

LOL, you’re absolutely right. That’s what I get for writing code in the lounge, I skipped a step, and didn’t debug it! Oh Well, no one is perfect!

Just an extra FYI, there is a product by Microsoft called Virtual PC. It allows you to create ‘virtual’ hard drives and operating systems on your existing PC. The virtual hard drives are literally files on your computer. Want to make a backup, just copy the file somewhere else. Install whatever you want within the ‘virtual’ operating system, and if things go wrong, just delete the file/harddrive. Very handy for creating ‘test’ environments.

Just an extra FYI, there is a product by Microsoft called Virtual PC. It allows you to create ‘virtual’ hard drives and operating systems on your existing PC. The virtual hard drives are literally files on your computer. Want to make a backup, just copy the file somewhere else. Install whatever you want within the ‘virtual’ operating system, and if things go wrong, just delete the file/harddrive. Very handy for creating ‘test’ environments.

This will do what you want, without Notepad, and is a little shorter then Mark’s code.

Dim f As Long
Dim strPath as String
Dim strTemp as String
strPath=”C:Temp.txt”
f=freefile
Open strPath for Binary Access Read as f
strTemp=space(lof(f))
close f
kill strPath
strTemp=Replace(strTemp,”_”,””)
f=freefile
Open strPath for Binary Access Write as f
put f,,strTemp
close f

And that would do it.

This will do what you want, without Notepad, and is a little shorter then Mark’s code.

Dim f As Long
Dim strPath as String
Dim strTemp as String
strPath=”C:Temp.txt”
f=freefile
Open strPath for Binary Access Read as f
strTemp=space(lof(f))
close f
kill strPath
strTemp=Replace(strTemp,”_”,””)
f=freefile
Open strPath for Binary Access Write as f
put f,,strTemp
close f

And that would do it.

The title of the browser is determined by the title tag within your header. If you look at the HTML for your home page, you will see this as the fourth line:

The title used in navigation bars and banners is actually stored within Front Pages navigation file. (structure.cnf). It can be viewed from the Navigation panel of Front Page. When you create a page, and you give it a ‘title’, Front Page uses that title as the ‘default’ name within the navigation structure. However, if you change the page’s title, that does not change the navigations ‘title’.

I hope this is what you were asking about.

Just to make sure, are you really dealing with a textbox, or is this a listbox? Listboxes and comboboxes, when you set a string to their ValueList, are limited to 2048 characters. You can program around this by using a callback function, instead of a value list.

Just to make sure, are you really dealing with a textbox, or is this a listbox? Listboxes and comboboxes, when you set a string to their ValueList, are limited to 2048 characters. You can program around this by using a callback function, instead of a value list.

There is a bug in Access 2000 (which I think the latest service pack fixes), which goofs the Autonumber, during a compact. It will let the system try to ‘reuse’ an existing number. Just an FYI.

There is a bug in Access 2000 (which I think the latest service pack fixes), which goofs the Autonumber, during a compact. It will let the system try to ‘reuse’ an existing number. Just an FYI.

That only a limit when entering through the datasheet of a table, or a form view. If you interact with a memo field using ADO or DAO (with code), a memo field can hold up to the size limit of the database itself. The ’64k’ imposed limit is actually a limitation in the viewing capabilities within the datasheet view.

That only a limit when entering through the datasheet of a table, or a form view. If you interact with a memo field using ADO or DAO (with code), a memo field can hold up to the size limit of the database itself. The ’64k’ imposed limit is actually a limitation in the viewing capabilities within the datasheet view.

Just so we don’t leave everyone in the dark, I am posting a ‘flashy’ method of closing a form, and even closing Access. This is what LadyGnome is going to use instead of ‘floating’ the controls. There are three forms. The ‘twist out’ form doesn’t really twist, I would have to use transformations to do that, and just don’t have time to mess around with that right now.

The modules in this db are completely standalone, so you can import them into any project you want. Use the code behind the buttons on the sample forms to see how it works. (The functions only require the forms hWnd value).

Enjoy!