Recent content by bev

Our Division is being transferred from 1 department to another. That means all our file folders need to migrate. Currently our folders are on Windows 2000 servers with Active Directory. Is there a way to document the current User and Group Permissions so that we can recreate it on the new...

I think you need: "SELECT Name, loginid, field1, field2, FROM Data_Table1 where Field1 >= " & Forms!Reports_Switchboard.startreport Bev

Folks, I'm so very embarrassed! It turns out that when I updated the query to use tblUPS03 (it had previously used tblUPS02), I broke the query and didn't realize it! MEA CULPA! So the issue wasn't a coding error at all; it was a linking error in the above referenced query. Thanks so much...

That didn't seem to work. I've done more investigating and it seems the parameters have not been set at all. Specifically, though the SQL is as above, the value for: oQuery.Parameters!BeginFY displays <type mismatch in expression> when I highlight it and pause my cursor over it. When I view...

I'm working in Access 2000 on code that was developed years ago in Access 97. I'm getting a data type mismatch, but I'm having trouble working out what to do. My VBA code contains the following code: Set oQuery = CurrentDb.CreateQueryDef("", sSQL) oQuery.Parameters!BeginFY = BeginFY...

I'm sure this is a dumb question, so thanks in advance for answering! We have a SQL 7 Server running. We have purchased a new server and the Network Admin installed SQL 2000. I did a backup and restore of the databases from SQL 7 Server to SQL 2000 Server, but we're not going to shut down the...

I wanted to thank you all for your help. I am now looking into ADO and OLEDB, but for the future. It turns out that by removing the Service_Code index, the problem was eliminated. (Of course I do not know why.) What I can tell you though is the the field Service_Code only has 118 values...

Thanks John and CajunCenturion. CajunCenturion, in answer to your questions: The backend is SQL 7. I'm using Access 2000 on the front end. I've got a bit more info now about my problem. It seems that when I try to insert OR update a record which has the VALUE '114' on a VARIABLE called...

First, let me apologize in advance for posting a question which probably doesn't have enough information, but I'm hoping somebody can just help point me in the right direction. In VBA in Access, I dynamically build an &quot;INSERT INTO ...&quot; statement. My program runs through hundreds of...

I've had a chance to do quite a bit more research, so never mind. I DID find the info in the answers to questions that others had asked. Keep up the good work! Bev

We've bought a new server which will have SQL2000 (once it's installed). We're currently running SQL7. I'm sure these questions have been answered a hundred times, but when I looked for a concise answer I did not find it, so I'd appreciate any and all help. 1) What's the easiest way to...

It's possible that there's a jumper on the motherboard that would allow you to undo all BIOS settings (or removing the battery might do it). Clearly, though, once you do this, you'll need to know either how to set the system back to the settings it had before you did this or back to it's...

I'm totally new to ASP, but know a little SQL. I think you'll have a problem with: sql = &quot;SELECT [Drawing Detail File].StNo, [Drawing Detail File].*, ... because the variable &quot;StNo&quot; specified in: [Drawing Detail File].StNo is also included in: [Drawing Detail File].* Usually...

I think you need: 21% =iIF((x > 1 or x < .85),&quot;yes&quot;,&quot;now&quot;) Bev

A little more information would help. On what basis do you know that it is the &quot;999999&quot; that you want? Is it because it's before the last &quot;/&quot; and after the previous one? Or is it on some other basis, like that it's the longest numeric string? Bev