Search results for query: *

There are only about a dozen records (at most) in the combo boxes). To be honest Duane I'm coming to the conclusion it may be some issue with network processes such as the virus checker/offline file caching/office installation. Thanks for your thoughts, always useful to hear someone else's...

They do need to select from the combo box. The datasheet is displaying a maximum of c60 records. The combo box fields are "relation" indexed.

Yes it does, there is a definite pause when you tab thru a combo box.

Thanks for your interest Duane. I mean that the form is wider than the screen and the users have to tab or use the horizontal scroll bar to view some of the controls. The right hand column is also frozen. Tony

Sub FindMaster() Dim wbResults As Workbook With Application.FileSearch .NewSearch .LookIn = "C:\" .FileType = msoFileTypeExcelWorkbooks .Filename = "Master.xls" If .Execute > 0 Then 'Workbooks in folder Set wbResults =...

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

We currently have an Access 2003 MDB which is linked to a SQL 2000 database as the back end. We are about to upgrade to SQL 2005. Has anyone found any problems doing this? Will everything work as before? Huge questions I know but a few pointers would be greatly appreaciated. Thanks

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

Yes I'd deleted the option compare statement. It is so familiar that it easy to forget how important it is! Thanks everyone.

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