Recent content by AmyLynnHill

Sorry, I dont understand what you are saying. Do i put that in the query QBE or in VB code somewhere?

Greetings! I have a form with one unbound text box and an unbound list box. The listbox has a query as the row source. the query has a field (SSN) that is a number field. it drops leading zeros. (I cant change it to a text field, it is linked to an oracle database.) The text field is used as...

Got it. Thanks a bunch! greatly appeciated. good day!

Thank you so much.....It works like a charm. I want to be sure i understand what the select stmt is doing. Is it inserting a date into the table?

Why is the syntax "Insert into" vs Select?

I put a MsgBox to display what value is being stored in the variable UPDATE. The value is the select statement in text????? most likely from the quotes?? no wonder the if statement is not working. What am I doing wrong with the select statement?

Ok I'm stuck I tried the format syntax, it didnt work. the form opens but the query doesnt run which leads me to believe the IF stmt is FALSE so it ends. But in actuality it is TRUE. I looked up the OpenRecordSet Method....not sure where/how I would use this.

Greetings, I have a query I want to run on the ON OPEN event of a form. I want it to run only once a day. I have the following code on the ON OPEN event Private Sub Form_Open(Cancel As Integer) Dim update As String update = "Select GDCSearch.LastUpdate from GDCSearch " If update < Date() Then...

Thank you for your expertise! greatly appeciated!

Bob, I'm not sure what you mean by manually? The purpose is to display records in datasheet view with a "Few" fields to let the user make decisions. Then if the user wants to see more of the information, they can click on the record and "all" of the fields display in a formview below, one record...

Sorry, I didnt explain very well. The main form in Participant Subform1 ParticipantRequest - datasheetview attached to a qry Subform2 frmWithRequest - formview attached to a table I want the datasheet view to display the record in the form view its linked by a ReqID to the subform1. Each...

Greetings, I've been messing around with this for a few weeks and need some help. I have a listbox and on the dblclick event it opens another form and displays a form(participant) that has three subforms. One displays information in a datasheet view (RequestSubform), another displays the...

I'm making progress, i have the subform linked to the main form. The subform displays the first record in the main form. I've been trying to figure out the syntax to requery the subform Here is what I have on the ON CURRENT event of the main form...its not working...

Great thanks! I'll give it a whirl and post by questions and results!

Greetings, I have a DB witha subform listing REQUESTS attached to a PERSON. Person is master record, Request is child record. There are many records to the child, one master. The subform is displayed in datasheet view. I want to be able to click on one of the child records in the subform and...