Search results

Actually after adding in all the columns I want, I have a problem. When I put it in a query its fine, but when I: 1. Run it from code with a DoCmd.RunSQL 2. Change the order of the first select statements in the Query SQL view 3. Move it all onto one line in the Query SQL view It says...

But how can I search a field to see if it contains the keyword somewhere (ie not an exact match) without using LIKE?

I have a QUOTES table that has a LOT of fields I have a search engine that compares the input keyword using LIKE to each field and returns any matches Is this the fastest method? (I am using an SQL Server 2005 backend) I am wondering if making a query that concatenates multiple fields and then...

Thank you very much for your replies. Yes I want the Item with the lowest [Items ID] and the second example works great! I probably should have mentioned I am using an SQL Server (2005) for the backend and am definitely interested in the fastest way of doing it.

I have a QUOTES table and an ITEMS table There are multiple rows in the ITEMS table for each quote linked by the QuoteDBID field. Can I write a query that will return one row for each QUOTE with a column containing only the first value for that quote. I have this, but it returns a row for each...

I have a form which is basically just a progress bar. I have the code set to run on Form_Current But my DoCmd.Close command at the end causes an error saying "this action cant be carried out while processing a form event" I can't figure out what event to put my code in so it executes as...

In another test, I got a recordset cycled through it with .movenext looking for 5 matches. Also with one version using .findfirst Then 5 seperate dlookups Once again the dlookups were faster: 200 loops of 1 recordset, looked through with .movenext for 5 values = 2.5 seconds 200 loops of 1...

Oh and by the way, to answer my own original question: After running hundreds of the short version, it would appear that it doesn't leave the recordset open or at least hasn't caused any slowdown or crashes on my computer.

I had read that Dcount was very slow, and since I am moving to SQL Server and having more users I thought I had better change all my Dcount's and Dlookup's to more efficient methods. However having taken your advice, while using the SQL Server (with linked tables via ODBC), it seems Dcount is...

Looks good, thanks! :)

I have some code that counts the number of records an SQL statement returns. It works fine, I am just wondering, is the recordset being left open and eating up resources? Will it be closed when the VBA Sub ends? Or when the form is closed? [CODE]SQL = "SELECT COUNT(*) FROM QuotesQueryLimited WHERE

Hi, I have a database where a lot of the table fields contain spaces. I would like to rename them but if I do I will need to edit all the Queries, Forms, VBA and Reports that use them right? (Thats a LOT) Is there any way I can do it automatically? I heard there was a utility by Chas Dillon...

Is it feasible to use a MS Access frontend with an MS SQL Server backend over the Internet? Or would it be too slow? Thanks, Trevor.

Hi, I have a MDB (Access 2003) database frontend and backend and I want to move the backend onto our new SQL 2005 server. I know I can use the wizard in Access 2003 to do this, but would it be a better idea to use the wizard in Access 2007? Im just thinking maybe they fixed a few bugs since...

Hi, Is there any way to find out an MP3 files bitrate using vba? I am making a music database that scans my mp3 cds, and this is one bit of information I would REALLY like to be able to capture! Thanks, Trevor.

I was looking for a way to do this for a long time, and the solutions I found were not very good. Then I finally realised you could just select a folder, and return all the files in it! Hopefully someone will find this useful. Just put both these functions in a module: Public Function...

Yea disabling the buttons works great. It is still possible to crash it if you click really fast on the same button, but I can't be expected to make it TOTALLY retard proof! So here is the final version. Thanks again for your help :)

Although...despite the fact it waits until the Shell is finished, if you do keep clicking on a button before its ready, it still crashes the whole database... Any ideas? Can I disable the left mouse button? Or is there a cache I can clear that is holding the mouseclicks?

AWESOME thanks petehilljnr! Both solutions worked like a charm :)

I have created an image manipulation form, so that users can very simply rotate, crop and resize photos without leaving the database. It uses the excellent free image software Irfanview, with a Shell call and command line arguments. (You put the path to the Irfanview folder at the start of the...