Search results for query: *

I'm trying to write a report in an access database, but someone has it locked! Is there any way to determine any info about who has it locked so I can go and talk to them? I know the info is out there somewhere, because every now and then I see a pop-up that says "The database has been...

I have a query (access2000) that prompts users for a date range. I used the following code in the criteria section of the date field in my query: Between [Please enter the start date - mm/dd/yy] And [Please enter the end date - mm/dd/yy] Is there any way to trap this data and store it in a...

I have a query that calls some vb module functions to do a lot of string manipulation. The problem is, my query calls the functions several times for each record to get back the exact same data. Is there a way that I can call the function once, then store the result in a temp variable for each...

Does Access provide any regular expression support? I know that the '*' wildcard is supported, but are there any other wildcards that I can use? I'm trying to pull out fields where the date is in the format xx.xx.xx in my query, but I cannot figure out how. I need a wildcard that specifies...

I'm trying to pull some information out of a huge memo field. I can find the start of the data I need by using Instr(...) and searching for a specific word that is always there. I'm having trouble finding the end of the data that I want, though. The data that I'm trying to pull out varies in...

Does anyone know which geforce3 card is the best buy? Or a web site that compares the cards? I don't need to know about the chip itself, but I'd like a comparason of the different cards offered. Thanks. Kevin

I'm having a problem with Crystal Reports. I'm using version 7. I'm trying to make a report from a ms access 2000 database. Specifically, I'm having trouble making a formula. I can insert any field I want in the report, but when I try to build my formula, CR won't let me use any fields from the...

I need to strip the first couple of letters (it varies) off of the beginning of a field. I have the following code, which should do it. This code is in a module in my database. My problem is, I don't know how to utilize the module in my query. I'm pretty sure that this is easy to do, but I'm...

I'm working on an application to be distributed on cd that uses msde. We're in the process of testing msde on a win98 machine, and I can't seem to get it installed. I can get the 1.0 version installed, but we need to use 2000. The installation hangs when it gets to the very end. No errors...

I'm very new to vb (and sql, too) and I need to play around with the MSDE engine I just installed. Is anyone familiar with this? I need to register the active-x dmo control to use the MSDE engine, but I don't know how. I found the file 'sqldmo.dll' and registered it using regsvr, but the dmo...

Does anyone know where I can get a list of all the keyboard codes? I want to use the keybd_event function to simulate key pressing. Also, could someone *briefly* explain what the code is? I mean, is it a decimal number or hex, etc? I'm very new to vb, and I just downloaded a little piece of...

Anyone familiar with Microsoft's 'Personal' and 'Desktop' editions for SQL Server 2000? My company is looking into getting one of these for our catalog on cd, and I need some advice. Any help would be greatly appreciated. (btw, I've been looking through Microsoft's documentation about these...

Anyone know a good book for vb 6? I'm looking for a semi-advanced book that I can use for looking up syntax, etc. Any suggestions? Thanks. Kevin Tighe

Does anyone know of a good website that has crystal formula syntax? I'm getting frustrated, and I really need a good resource. I know that you can use vb syntax, but I'm just learning vb, too, sooooooo..... Any help would be greatly appreciated. Kevin