Search results

I have created an ADP front end connecting to a SQL 2000 Database. Due to the current Network Infrastructure I am using SQL authentication for the users to logon. The Front end will be deployed by Group Policy to Approx 60 Users. However the front end opens the authentication logon box with the...

I am creating a system that logs visits to site, using a sql backend, access front end. Now loading the front end I have a procedure which creates a local mdb file in the users my documents folder. The purpose of the local mdb file is that it gives the user an offline record of all their visits...

Thanks for your advice so far. As suggested by you and others I created a new instance and then opened the recordset assigning it to the form's recordset. This gives me all the records from the local table, what I want to do now is from the main form select criteria, which after updating...

I think a bit of background would be useful first, before discussing the coding issue. I have an Adp connecting to a Sql 2000 Server. The purpose of the front end is to record visits to premises. My users have laptops so therefore will not always have a connection to the Sql backend...

I will need to use code by the looks of it. Conditional formatting only allows for three possible answers, I have 10. So I still need help

I could use conditional formatting in this case, but I thought it would be maybe useful to know in the future.

All I want to do is a create function that checks the text in a form field, and then dependant on value assign a font color. So my code I was thinking would look something like this Dim txt As textBox set txt = txtBoxName FormatTxtBox(txtBoxName) Public Function FormatTxtBox(txt As TextBox)...

I am being very stupid here, but I can't figure it out, so maybe you can. I have an Access ADP form, the source is a SQL View. When you click a command button it runs a stored procedure which inserts the fields into the SQL view. A SQL 'instead of Insert' trigger then inserts the parameter...

Thanks for your help so far. Ok I've setup the Pass through query running my stored procedure, how do get the requested parameters from my form controls??

Runtime error 438 Object doesnt support Property or Method

Don't know why I typed it liked that! I did have them the other way. Anyway the variable takes the value from recordset field but then when I try to use the variable with the txtboxCtrl it produces an error saying it can't associate

OK, I'll tell you what i've got so far. On opening an Access Report I am running a Stored Procedure (a Select Query). Now my Recordset fields have values, but I cannot associate them to the controls I have placed on my Report. What am I doing wrong?? For example strFamilyName=rs.Fields(2)...