Search results for query: *

I am using Access 2010 and have experienced the above problem. I have googled this and found that it was a known problem in Access 2007 for which a hotfix was issued as here http://support.microsoft.com/kb/972558. Has anyone experienced this problem recurring in A2010? If so what was the...

I am experiencing issues with queries that open instantly in SQL view but when you go into design view it can take up to 5 minutes to load. The tables are linked to a SQL db and name auto correct etc. is switched off. This is something we've only recently experienced to any great extent. Has...

I have a transform query in one of our apps. TRANSFORM Sum(tblRateValues.RateValue) AS SumOfRateValue SELECT tblSchedules.Schedule, tblTrades.Trade FROM ((tblRateValues INNER JOIN tblSchedules ON tblRateValues.ScheduleID = tblSchedules.ScheduleID) INNER JOIN tblRateTypes ON...

Does anyone know how to write a bit of VBA code to set the default property for new queries to snapshot as opposed to dynaset? I am using Access 97. Don't ask me why I need to do this it's too complex to explain in a succinct way. Thanks

I have a continuous form on which additions are notallowed. As the user tabs through the form the records are updated as per normal, as they move the focus to the next record. Of course on the last record the control just goes back to the first control on the last record, as there is no new...

I have a piece of code in my Access app that looks something like this: if me.client = "PEV001" then ...... The client is actually "pev001". On my computer it works fine and does the compare in a case insensitive way, however when copied to one user's PC the compare fails as it acts in a case...

When trying to access a backend table on a very slow server connection I get the message Run-Time error 64512 Couldn't use <dbname>; File already in use. This is a bit odd because there is no ldb open. Has anyone experienced an error like this? thanks

I need to be able to read the registry and find the location of Access. I know this is possible in VBA but I don't know which key to read. If anyone out there has got a code fragment to do this I would be very grateful. Thanks Tony