Search results

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

Thank you that worked and did get me further. I'll continue to try to figure out the "Ivalid use of Null"...Greatly appeciated!

Greetings, I found an example of a search example on this forum a few months ago an have been trying to build something similar but have a few bugs. I have a search form at the start of the application, a txtSearch field to type the text to search, below is an unbound field attached to a query...

I have a report set up as a letter for mailing purposes. in the letter i have a subform listing names, amounts, ect. it is setup in datasheet view. the problem i have is the more records in the subform it causes the text to display over top of the main reports text boxes that display verbage on...

Will do, most likely will have more questions once I dig into it....Thanks again.

Thanks for all you posts/help. much to discuss and think about. I appeciate your help!