Search results

Hi Missinglinglinq, Yes, it was a typo. I had solved the problems several days before posting and in the meantime I was working on an Excel spreadsheet with Vlookup formulas so that was what was on my mind. Thanks for the info on the hotfixes I will have to do that.

Here is the solution to my problem. I realized that my computer has service pack3 for Access2003 and the computers that were not showing any result for the VLookup did not have the service pack. I installed the service pack on those computers and the vlookup worked properly. I had another...

I have an Access2003 database that is split with a backend on one logical drive on the server and the frontend on another logical drive. I am connecting to a sql database on another server. I created an ODBC datasource on each computer for the sql database. I have a textbox on a subform that...

As stated before the query is working by itself but when I try to use it inside vba I get an error. Are you able to use a field out of a table that you query as a parameter to the query? This is what I am doing with the [tblEquipOpReq].[intFreq].

I have a query that works on its own but I am now trying to set a recordset equal to the query. Here is the vba code that I am using: Dim db As Database, rs As DAO.Recordset, qdf As QueryDef, prm As Parameter On Error GoTo Error_Handler Set db = CurrentDb Set qdf =...

Thanks all for the help. I found that if the data entry property is set to yes on the data tab then anyone that has only read permissions will see a blank form when it loads. I set the property to no and the bound controls appear. Is there a general rule of thumb when you set this property to...

Thanks missingling for replying. The form is set to open/run and the tables read data, read design. I have the same permissions on other forms and they show everything. The problem with this form is that it is not showing the text boxes, combo boxes, labels etc. Anything that is a bound...

I have a front-end database linked to tables in a back-end database. I have security permissions set for a group to have read permissions on the form and read permissions on the linked table in the front-end and also read permissions on the underlying table in the back-end. When I sign on with...