Search results

Hi I bet slow queries are quite a common problem but i am not too sure what is causing mine to be so slow. It takes at least 55 seconds to run at the moment. I have narrowed the problem down to the from clause by simplifying the select part of the sql statement. Although the example pasted...

I have a query within some vba code which updates a record with information from a form but it is taking about 6 seconds to run. Is there anything i could do to speed this up because it is getting slower as more and more records are being added to the database. The query i believe is slowing it...

After uploading my access database to ms sql i have found what i think to be a better option for me which is to use ODBC to connect to the access 2003 database file from a php web page. I have run into a problem with a sql string which uses OUTPUT to assign the record ID to a variable. The code...

After months of work I have a database which, I am really proud of and is working really well until one day a colleague asked about access to the database. At the moment the database is used by about 5 people and the database file lives on a shared folder and everything is great but I would...

I am trying to use a query to search 2 many to many relationships but i keep getting duplicate results because each record is slightly different. I have a table with cameras, another users and another formats. I have a table linking cameras to users and another linking cameras to formats so it...

Hi All I was hoping someone may be able to help me with a better way of displaying a field from a table, than using two DLookups. I have three tables: tblLocation – tblAssets – tblFaults The form is based on the tblFaults table. One of the fields is AssetID ( key from tblAssets) which I am...

Hi I am quite new to VBA and half my problem is not knowing what i should be googling to get the right answers. I have successfully created a subroutine which creates a record set, in this case a set of items someone is booking out under a hire id number and then emails that list to the person...

Hi, I was hoping someone here may be able to offer me some advice on how best to approach a rate card i am building. At the moment i have one table which lists all of the equipment that is available for hire. In a second table "tblRateCard" i use the key from the equipment table, the tariff and...