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

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

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

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