Search results

you can edit the record set by using : "Ex name for record set = rst" rst.edit rst![fieldname]="what you want to put in field" rst.update

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?

did you try an if statement... if item_skey = subform.item_skey then docmd.open acform,("nameofform") docmd.close acform,("nameofforme") endif

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 FOUND A WAY..... Dim varX As Variant varX = DLookup("[ssn]", "personnel", "[ssn] =[Forms]![pickstud]![Text18] ") If IsNull(varX) Then MsgBox "SSN Not Found" & (Chr(13)) & "Student Not in Database" GoTo lastline End If

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

did you set it up with the wizard to store value...