Search results

Is there any way to have a query result set be a pop up? I have a button that opens a calendar on the "Event" Form...from the "Calendar" form you can select a date and click "check availability" which closes the "Calendar Form"...the result set is under the "Event" form...I would like the...

"Find" Code I have a "Find" button on my form (code is below)... I would like to write some code after the record is found that displays a label on when the record was last updated. My problem is I don't know where the code runs to after the "Find First" button is pressed. Please...

It just hit me as well....we had a power outage yesterday late afternoon....I wonder if some files got corrupted...the repair database utility won't work either...I get the same error. Any suggestions Thanks ________ Vaporite solo

Thanks for the prompt reply Doc-Man... I'm waiting for all users to get out of the program, but I noticed when I click Tools --> Startup I get an "Operation Invalid without a current index" error Does this help you with any other suggestions? Thanks again! Kacy ________ KID AVANDIA

When I click a tab (table,queries,reports or module) I receive an error that says (" isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names). Please help. Thanks, Kacy ________ P

Any way you could save the sample database in Access 97 format? I'm having trouble opening it. Thanks. ________ Anal Hardcore

I'm not for sure how to write that code up...what is the ( 'last_name = lastname_TB and first_name = Firstname_TB') TB stand for? Thanks again ________ Galleria Ferrari

I have a combo box that displays LastName FirstName. If I have two people with the same lastname it finds the first one in the table w/ that last name. Please help with my code so it searches by firstname and last name. Thanks in advance. Kacy ' Find the record that matches the...

Thanks Pat....worked great! ________ Lovely Wendie99

Is there a way to have multiple detail sections in a report? The reason I ask is because users want to include every facility name in the report even the though the datasource of the query include a date range. If there are no records within the date range it will not show the facility name on...

I still get the "Microsoft Jet database engine could not execute the SQL statement because it contains a field that has an invalid data type" error....any other ways around this? They want to see "N/A" in the report rather than leaving it blank or putting it at zero. Thanks in advance, Kacy...

thanks for the response...unfortunately I'm still getting an error message....any other suggestions? ________ St. catharines components plant

I have a report that has sums in the "report footer" In the control source of my sum text box I have "=Sum([initial_verf])"....and it works fine with all numerics being in the initial_verf. However some of my data contains "N/A" and it throws an error b/c the "N/A" is not a number. How can I...

"Send To" using "HTML" My users are needing to email their report....I had them do "File -> Send ->" choose "HTML". On my system it sends it as a link, that can not be modified, however on their system when they choose HTML it pastes it in the email like text. Is there a...

that did it....Thanks! ________ Concept X1

I am having trouble using the Like statement. It won't retreive any results. However if I change the "Like" to "=" and take out the '* this query works fine. SELECT * FROM [DUI Speakers] WHERE Event Like '*[Forms]![frmSchoolInfo]![txtEvent]*'; Anybody have any ideas why this wouldn't return...

returns the records with null SANCTION because a null is not like DELETE.... thats the problem...it does NOT return records with a null SANCTION. Why is this? ________ Asian Webcam

returns the records with null SANCTION because a null is not like DELETE ________ Free Streaming Amateur Por

Yes..I know this will work, but I am more curious than anything on when using this criteria it doesn't pick up the nulls? ________ Mary Jane

The following query is not returning records that are NULL in the Sanction field. If I take out the (NOT LIKE 'DELETE*') it returns all records even the the ones that are NULL in the Sanction field. Why is this query not returning records that are NULL in the sanction field? I want to...