Search results for query: *

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]

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 "Sheet1", the second table as "Sheet2" and the third as "Sheet3" within the same spreadsheet...

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 "Code". Any valid "Code" starts with a numeric value, however, invalid codes start...

Hi All, Does anyone know how to obtain an "Open License Agreement" 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-)

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, Is there a good place to go and research information on trying to incorporate (synchronizing data) an Access database and say a Palm Pilot, Pocket PC, etc.? What are the limitations, storage capacities, pitfalls, etc.? Is the technology advanced enough to use a PDA and a large networked...

When converting an Access 97 database to Access 2K (with the intent of using DAO), I was wondering what the reference order should be. This is what I have and I want to make sure it's correct: Visual Basic for Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft DAO 3.6...

When converting an Access 97 database to Access 2K (with the intent of using DAO), I was wondering what the reference order should be. This is what I have and I want to make sure it's correct: Visual Basic for Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft DAO 3.6...

I'm in the middle of converting a few databases from Access 97 to 2K. Two if the three converted flawlessly, however, when I try and open the third (after converting) I get the following error message: "Cannot find the file 'C:\Database\Database3.mdb'(or one of it's components). Make sure...

I have just started looking at a 97 database that has been converted to 2K. I noticed one of the References said 'Microsoft DAO 3.6 Object Library'. This may seem like a stupid question, but why if I remove the DAO object library listed above does my code no longer work, specifically 'Dim db As...

I was wondering if there's a way to use the Val function in a query. I have been messing around for a while and was wondering if it's even possible. I want to return an ID number from a field that's a combo box. The ID number is hidden in the combo box (Column Width = 0), but two other fields...

Hi, I have a text box on a subform (Access 97) with this as the control source: =[Forms]![frmOrdersSubform].[cboSubParts].[Column](1) Now when I open the main form (with the embedded Subform) the text box has '#Name?' displayed. However, if I leave the form open, go to the database window and...

Hi, Periodically people here get the error message "Not a Valid Bookmark" (Error #3159). What exactly causes this? Is there something I can do to trap this error and deal with the problem? I have done some checking in the online help but haven't found anything that clears up the...