Search results

Thank you to the both of you!

*"how do I"

I'm guessing the SQL is something like SELECT tbl WHERE "keyword", but how do is set the RecordSource property of the 3 forms appropriately?

Hello, I have a form with three subforms that display three separate tables. I know there's a way to do it, but I haven't figured it out... I'd like to have a unbound textbox and button where I can enter a keyword into the textbox and On Click, the three tables filter to only those...

Anybody else?

I have an excel that exports from another program. Unfortunately, the source includes leading spaces in some of the column headers. I have the following command to import to a specific table with similar headers: DoCmd.TransferSpreadsheet acimport, acspreadsheetTypeExcel12XML, "tblA"...

As always, thanks!

What goes in "KeyField ="? I think that's clogging it up...

How do you use the result of the DMax() in the criteria of others?

Thanks! But, I think my problem is a little bigger than I thought. Now, I'm trying to set some of the fields to copy by DLast. The DMax fld works just fine, but the remainder populate based on a row in the middle of my table (confirmed by a Me.Refresh test). I can't seem to figure out why. I...

I have a form that opens in new and includes a couple fields with DMAX code On Load. But, sometimes the rest of the form isn't filled out. Is there a way to set the form to save only when the other fields are populated? Otherwise, I end up with a table with a bunch of empty records.

Thank you Gents! Apologies it took me a bit to respond, but I finally got back to working the DB and your recommendations worked.

I have an On Open event for my form that says Me.fldX DMAX("[fldX]", "tblX") + 1. fldX appears fine (it adds one to the highest number in that column and places the result into fldX), but when I enter values in the remaining fields and close the form, fldX show a value of 0 in tblX. Any...

Simple question for a silly program. Is there a way to and have two fields on a form automatically populate with a random field when a button is pushed? I.e. txtfld1 populates from a random field in column 1, tbl1 txtfld2 populates from a random field in column 2, tbl1

Thanks for the info. I'm not very knowledgeable with SQL and VB so I just picked up a few things here and there. The 2 paragraphs after the code are confusing. I'm not sure what you mean. I know how to put code into a query to see if it works. But I'm not sure how to assign strings or...

I've edited the code, but it doesn't bring back anything when I enter a value I know is contained in one of the records fields: Code: If Not IsNull(Me.Text21.Value) Then stDocName = "rptReport" DoCmd.OpenReport stDocName, acPreview, , Chr(34) & Me.Text21 & Chr(34) & "In...

I tried doing a search on this, but apparently "contains" is too common of a word that the search automatically deletes it as a keyword.... I have an unbound textbox where I want the user to place keywords. Then when they click the report button, I want the report generated to show all records...

Thanks SOS!

Below is a code I'm trying to use to filter a report by the value in Combo14. The value in Combo 14 is determined by the value in Combo 8 (cascading) The code I'm using causes an "object required" error. On Error GoTo Err_cmdReport_Click Dim stDocName as String If Me.Combo8.Value =...

Easy question I can't find an answer to. I know how to cause frmB.fldA to match frmA.fldA using the onopen cmd. But how do I cause rptA.fldA to match frmA.fldA using the onopen cmd? There doesn't seem to be a "Me.fldA.Value =" option.