Search results for query: *

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

Hi All, I want to trim all in a text field except the last letter / value. So if I trimmed 'DaveShmaveX' (without the quotes), I'd only be left with X. I've looked at the online help and have messed around with this for a while with no success. Can someone clue me into how you'd trim all but...

Hi Jon, Try reading over this first: http://support.microsoft.com/support/kb/articles/Q207/7/93.ASP?LN=EN-US&SD=gn&FR=0&qry=Security%20FAQ&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000 It is an Access Security FAQ covering Access 2.0 through Access 2000. HTH Dave

Hi Roy, This is new in Access 2000. You can't make design changes to the back-end (tables) of an Access 2000 database without opening the database exclusively. Also, if the front-end is shared on a network server rather than each user having a copy on their computers you can't make design...

Hi Jon, Try this: http://odyssey.apana.org.au/~abrowne/AppAudit.html It's a little involved but it definitely works. HTH Dave

Glipuma, In Access2000, open a module and then go to Tools-References from the Menubar. For Access2000 DAO these should be your references: Visual Basic for Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft DAO 3.6 Object Library Microsoft Visual Basic for Applications...