Search results

how can a declare a variable as public on on form then on a other form use that variable in a select statement. ex (public phase as string ..... "select unit from table where ph = phase") ??????

I have a form, when a value is picked in the first listbox I want the second listbox to display only the records that go with the first listbox. I know how to write a select statement to retrieve the records. My problem is where would I put this code. If I put it on load form I get an error...

o.k. heres one.. i created 5 tables (create tabledef....) any way I need to append all table together later. the problem there may be some times that a table has no info so never gets created. How do i check if a table exsists?

I create a query like this: set qd=db.createquerydef("query..... docmd.openquery "query" ect... anyway next time i run this code I would like to check if this query exsists and delete it before creating it again.

I create a query like this: set qd=db.createquerydef("query..... docmd.openquery "query" ect... anyway next time i run this code I would like to check if this query exsists and delete it before creating it again.

How can I make my points on my chart different colors depending which group they are with? I'm using a scattered chart. And I have 5 different groups.

how do I make a control button highlight when mouse over?

I need help create a chart from a query. the query will have classno and total-weeks-to-train fields. I need a chart showing weeks and the difference in the classes. any help

I'm trying to use a recordset I get this message??? "RUNTIME 3709..THE APP. REQUESTED AN OPERATION ON AN OBJECT WITH A REFERENCE TO A CLOSED OR INVALID CONNECTION OBJECT. Dim holdstu As ADODB.Recordset Set holdstu = New ADODB.Recordset holdstu.open "SELECT personnel.lname,personnel.fname...