Recent content by ruaridhmac

Right, I've dropped DAO for ADO - which someone told me to do a while ago but i ignored them thinking it would be hard work - and everything seems to be working. Thanks to those who helped! R.

Now i think i've discovered the problem as when i type it returns the same error as before: error 91 which leads me to believe there is a problem with the database but i'm not sure where to start fixing it?

Just tried that but when i type 'New DAO.', 'recordset' does not appear on the drop down list. I typed it in anyway and back came an error. Anyway this is what i now have: which is really begining to make me think i have a problem with referencing because it looks right to me.

I'm having trouble using a recordset in VBA that i have previously used without touble - the only difference is that i'm now using linked tables in SQL Server. Code as follows: All the function is supposed to do so far is set the recordset to the query - this doesn't work and just comes up...

I have been messing with the screen resolution - i swap between using the laptop monitor and the desktop flatscreen. Will this affect it?

I have a bit of a problem which i really can't figure out. I'm only in the testing stages of building a form to edit data so i'm using visual basic editor to open the form using code to populate the fields. Sometimes when i open the form it appears very small so only half the close button is...

I think you could probably make the switchboard a popup form and auto centre it from there - if this fails make your own form to cover the duties of the switchboard. The switchboard is pretty restrictive anyway. Of course, some people don't like the look of, or like working with popup forms. R.

thanks gemma-the-husky, still can't actually work out what was wrong but you're suggestions probed me to do a few things to try and fix it. Ended up copying 'haulage prices' table and modifying it to work for 'Product Prices'. This has worked and now the query returns the prices that i need...

I'm new to this as you can probably tell Here's the SQL of the two queries. Haulage Price: SELECT Loads.[Advice Note No], Loads.AL, Loads.Project, Loads.Contract, Loads.Customer, Loads.[Haulage Contractor], [Haulage Prices].[Haulage Price] FROM [Haulage Prices] RIGHT JOIN Loads ON ([Haulage...

I have an access 2003 database which holds data for lorry loads of timber delivered to different places at different prices and by different hauliers who get paid different ammounts. I have tables that hold the prices for both haulage (sorted by the delivery location and haulier) and product...