Recent content by JBRTaylor

I have now removed the link between tblRateCard and tblkitSubCat and directly joined tblRateCard to tblEquipment which has had quite an improvement and we are now down to about 20 seconds which is a huge improvement from about 55 we were at before. I have also checked all the foreign keys are...

tblCollection - this holds information relating to a production who are collecting equipment. In this table you need to select the tarriff that the production will be charged. tblCollectionItemized - These records are a reference to the equipment table, so each record is an item of kit that is...

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...

Thanks, that is really helpful. I have already created a junction table between my main table that contains all the camera information and another table that holds information about which type of user the camera is suited to which could be many. I have the same set up for the recording format...

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, Yes that was the problem i hadn't declared the variables and set the database as you said. I have got it working in a test database, now to set it up in the main one. Fingers crossed i'll manage that one on my own, lol. Thanks for your help with this, it is going to be so useful. Jon

Hi, I have found this post really useful as i am trying to do a similar thing however i have very little knowledge of VBA. I have tried to follow your example as closely as possible and have created two tables with the filed headings as in the sql statements however in the second part i keep...

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, Thanks for the speedy reply. Yes at the moment it is just the price that is in the Tariff table which looks somthing like this: Equipment key Tariff Price 1 TariffA 10 2 TariffA 5 1 TariffB 6 So to find...

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...