Search results for query: *

I think the "countme" variable should be declared as a Static variable in the form's module level, as opposed to the procedure level. That way, the variable will retain its previous value from the last time you called the procedure to check the logon ID/password. That way, you can...

Try this on for size: Dim dbs as database set dbs = currentdb MyJobCode = me.cboJobCode dbs.execute "UPDATE tblYourTable SET tblYourTable.JobCode = " & MyJobCode & " WHERE (((tblYourTable.Name)="whatever"));

Need clarification. Will the user be indicating more than one ethnicity? Or, only one? If user is allowed to select more than one, you might try the following: SELECT * FROM tblEthnicity WHERE (((tblEthnicity.Ethnicity_1)=-1)) OR (((tblEthnicity.Ethnicity_2)=-1)) OR...

Here is the syntax for an update-type SQL statement that will update a table with the values. I have used my table names, but I think you might get the idea on how to substitute your tables for mine. My sample below uses two tables (tblManagers and tblUsers). I have asked that for all values...

If your report is based on a query, you can set a filter for the query at runtime. I have included a sample of my code where I have asked the user for a value to my variable by means of an input box. Then set the field in the query to equal your input box response variable. intBANum =...

Thanks, dvannoy! Just a few questions... In your rs.open method, is strCn your data environment connection? I can see that you're a much more advanced VB programmer than me. I have been using bound forms, rather than binding late. I think that's what your code is doing here, anyway. If my...

I need to create a form that contains a data grid linked to a table or view of a SQL database. What this form should do is present a list of all available records, allowing a user to double-click on one record. This double-click event should bring up another form showing that record's detail...

You can always delete all of your linked tables from your front-end application, and then import all of the original linked tables from your back-end file into your front-end file. That should work.

I have a form based upon a table. This table holds records for all departments. For security purposes, I need the form to only allow the user to see records related to his/her department only (usually, there is more than one record). Also, if the user needs to add a new record, I need the bound...