Recent content by DaveShmave

Found it! On pages 719-721 of &quot;Microsoft Access 2000 Power Programming&quot; by F. Scott Barker: '...and reserved characters-- &quot;/\[]:|<>+=;,?* --can't be used.' Hope this helps anyone else. Dave [afro2]

It's been my experience that this error message occurs when a database becomes partially corrupted (or at least temporarily unusable) due to one of the following: 1. Power loss or loss of network connection at a terminal that's currently logged into the database. 2. Someone terminates their...

Thanks for the response. However, I thought certain characters, like question marks, commas, forward slashes, backward slashes, etc were not allowed. And I'm certain I read that somewhere but when I looked at the Security FAQ I didn't find anything there either. I'm a little concerned about...

I used to have a list of the wildcard characters that one could NOT use in passwords for MS-Access security, however, I can't seem to find it and I've done searching on this forum and on the web. Can someone please provide me with the list or a link where I can get the list? TIA Dave [thumbsup2]

Okay I think I finally have it figured out. I used the OutputTo Method to overwrite the older spreadsheet. Here's how: DoCmd.OutputTo acQuery, &quot;Sheet1&quot;, &quot;MicrosoftExcel(*.xls)&quot;, &quot;C:\MyDocuments\MySpreadsheet.xls&quot;, False, &quot;&quot; DoCmd.TransferSpreadsheet...

Thanks again for the help, Lightning and GeekGirlau. I have one other question that I'm struggling with. Because I will run these queries over and over again, I want to be able to start with a fresh spreadsheet (the TransferSpreadsheet Method doesn't replace the existing spreadsheet) and then...

Oops! I re-tried your suggestion Lightning and it works great. Thanks for the help. Dave :-0

Actually I had looked that up, but since I'm using Office 2000 (sorry I didn't mention it before), I didn't think that would work. Well, I played around with it for a bit but didn't get the desired results. Any other ideas? Thanks, Dave X-)

I did a couple of searches but was unable to get my question answered. Maybe someone can help me with this. I want to export 3 tables to Excel but have the first table as &quot;Sheet1&quot;, the second table as &quot;Sheet2&quot; and the third as &quot;Sheet3&quot; within the same spreadsheet...

Thanks Maq, Joe and Craig! I'll look into all of your suggestions. Dave ;-)

I just did a search for what I'm trying to do but haven't had any luck. I have a text field in a report (Access 2000 SR-2) that contains numeric and alpha information. Let's call the field &quot;Code&quot;. Any valid &quot;Code&quot; starts with a numeric value, however, invalid codes start...

Thanks I just might do that. Microsoft suggested going through CompUSA, Office Depot and the like. By the way, someone found this site in case any of you are interested: http://www.microsoft.com/business/licensing/overview.asp Thanks again, Dave :-)

Hi All, Does anyone know how to obtain an &quot;Open License Agreement&quot; for Office 2000 (SR1a)? And if so, what's the process involved? I have many users that need to upgrade to Office 2K from 97, however none have a CD so we need to purchase licenses if possible. TIA Dave X-)

Nativ, Have you tried the decompile start up command? If not, try it by creating a shortcut on the desktop with the following: &quot;C:\Program Files\Microsoft Office\Office\msaccess.exe&quot; &quot;C:\DatabaseDirectory\DatabaseFile.mdb&quot; /decompile If it's Access 97, just follow the...

Cool Thanks! Dave