Search results

Hi, I guess you have been really bussy, if you get some time over I would appreciate a reply on my last post regarding our thread about pausing execution of macro

Here is the code for the form: '------------------------------------------------------------ ' cmdSendReport_Click ' '------------------------------------------------------------ Private Sub cmdSendReport_Click() Dim varName As String Dim intNumOfRecs As Integer Dim intResponse As Integer...

After iniating the report from the form DoCmd.OpenReport "PurchaseByPerson", , , , , acDialog is printing the report but neither the messagebox or the SendObject ever gets fired

This is the code for the report on activate: '------------------------------------------------------------ ' Report_Activate ' '------------------------------------------------------------ Private Sub Report_Activate() On Error GoTo Report_Activate_Err DoCmd.OpenReport "PurchaseByPerson"...

But I want to show the user the result of the search, I want the user to view the result of the search, halt execution of the SendObject, if the user approves of the resultset, then unpaus, so the SendObject can be executed. Thats why I had the second messagebox, I thought I could show the user...

I am not asking for a blank report, after supplying the searchstring to the textbox, if there is a valid result I want to the report to be displayed before sending it to outlook, or if no record is found to prompt for a new search.

I tried it out, it works.. I am using a textbox in a form to provide for the serachstring. My problems is that I need to see my report before firing the SendObject command. In my case I see the report behind the form but its not accessable becuase I have a messagebox waiting for a prompt. If...

I have a form with a macro that has the action "SendObject" that sends a report by email. In the report itself I have macro that displays a messagebox if no records were found. What I want o achieve is to halt the "SendObject" macro if no records were found and stop loading Outlook, instead...

Hi PNGBill, You were quite right :), didnt at all think about the autonumber would be the issue, but quite logical ofcourse. But it will be a valueable lesson for the future, this is acutally my frist foray into access and sql. -Sohail

For the fields regarding the append query, the local table has all the fields set as Text, except the PK whick is a "AutoNumber" and one field which is set to "Yes/No" The same fields for the remote table are set to" nvarchar" instead of text and "int" for the PK instead of "AutoNumber" and...

This was actually a first test run, with no other users online, all other queries, for example INSERT INTO from the SQL Server to local tables or update queries both ways dont have this issue. Is there any way to paus the execution of the child table in my macro. The sequence that I am using...

Thanks for your reply, the issues you mentioned, wouldnt they also be valid when saving the record locally, so,how come that tre records locally a saved with any problems?

I am creating a query to find unmatched rows between a local access table and an online MS SQL Server table based on the PK field ID. This is working without any flaws. My problems start when I run a append query with INSERT INTO based on the result of the former. I get the following error...

Thanks a lot

By the way, can I empty the searchstring in the text searchBox when I click for "show all records". This is my current code for showing all records when I set the filter to false: Private Sub cmdShowAll_Click() With Forms![Copy of Contact List] .FilterOn = False End With End Sub First I want to...

Thanks a lot, I really wouldnt have imagined the soloution you suggested with Calculated field name for the search filter. Thanks again Sohail

Hi JR, I made a copy of the form and edited the query behind the form with the calculated field as you suggested. I tried that out, but when I submit a search string in the textbox with the name of SearchBox in that form, Access wants me to supply a value in a parameter dialog for...

So, this would work? With Forms![Contacts List] .Filter = "[LastName] Like '*' & Me![searchbox] & '*' OR [FirstName ] Like '*' & Me![searchbox] & '*' OR [EmailAddress] Like '*' & Me![searchbox] & '*'" .FilterOn = True End With and for the reset button to dispaly all records again: With...

So if I have form named Contacts List and a textbox named SearchBox and the three fieldnames of the table being LastName, FirstName and EmailAddress, would the command click code for the button be in VBA be the following? With Forms!Contacts List .Filter = "[LastName] Like '*' & Me![searchbox]...

I am sorry if I wasnt clear enough. What I meant it, regardless if I submitt a string of firstname, lastname or email. The string I provide with a like clause could be in one of those fieldnames of a table, and resulting rs could display more then one single record corresponding to that search...