Search results

Worked it out myself.... I needed to create variables for everything when using this method ie. Dim emailTo As String Dim sCc As String Dim SBcc As String Dim sForm As String Dim sSubj As String Dim sMsg As String emailTo = InsOwner & "; Charles.davenport@.co.uk " sCc = "" SBcc = "" sForm =...

Thanks for pointing that out.... still not the route of my issue but im sure it was one of (possibly many) reasons

OK I have the below VBA to send a report but Im getting a syntax error on the DoCmd.Send.Object and trying to work out where ive gone wrong! Ive had to list out all of the variables so that I can take the email address from a table of employee names based on the name on a form and ive gone...

Thanks Moke 123, Ill look at this! I cant find away to not have duplicates, basically a search is undertaken for a new client against an existing client list which returns a list of clients. These need to be saved and so are appended to a table and then vba code ads in the primary key for the...

That would then delete all rows with that ClientName including the non duplicates for other FormNumbers would it not? ie it would delete data which whilst a duplicate is not considered a duplicate for this purpose? What I have to work out is a way of deleting duplicates only if the FormNumber...

Unfortunately I do not have one column with duplicated data. The table could look like this ID FormNumber JobReference ClientName 1 2 E003 This Company 2 2 T001 That Company 3 5 E003 This Company 4 5 V006 Various Companies 5 5 R001 Random Company 6 6 V006 Various Companies 7 6...

As information about a job is found out then further checks against third parties is required and therefore the user will have to go back in update and re-run.... haven't started to figure out the delete duplicates yet as it appears to be a minefield!

Your right instead of the loop I could have used the FindNext function

Now because this whole thing can be run a second time by the user with updated information and I don't want the original information to be kept I need to somehow include a delete duplicates into this as well!

Sorry if im not clear.... this database has just grown and grown in size! I have a table with two columns for client names and client references. I have a table with a form which a user inputs a new client and a query is undertaken from multiple fields on that form against the client list and...

@ Isaac The .MoveNext did the trick..... didn't think i needed it as i was looping! Newbie mistake I think there!

Yes it just hangs as it infinitely goes through the loop

Gasman The reason I have created this as above is because there is no link between the tables whatsoever but I need to create a link between the results with the primary key of the data in the table/form used for the search to save the results. The search and append query also produces...

OK.... Im sure that everyone will tell me I should do this in a different way than what i have come up with. I have a query which is appending a table and fills out two columns with the data from the query being a result of a search (which I have already had help with in the query forum)...

Perfect!!!!! thankyou for all of your assistance on this it has been amazing!

OK... First of all I would like to appologise for being a pain and thankyou for the assistance with this. arnelgp, your latest code and sql code has helped however, when there are blank (null) fields this is now (from what I can fathom) searching for blank spaces and returning all clients...

Works a treat thankyou! And thankyou to everyone else's posts..... Now I have run into a problem, I have used your search module in a number of instances in the sql query as detailed below, this works if all of the field have something in but, in many instances these will be blank ie null...

Thankyou everyone for your responses! One day Ill get this VBA down! Arnelgp, once again your code works perfectly for my requirements however, I have run into a slight problem. I have used the module to undertake multiple searches ie multiple locations on one form with company names and...

basically it produces a list of companies which we have acted for in the query (and report) which is the result of the search to inform the user there may be a conflict which then needs investigating...

Thanks for the reply, The purpose for this is for the user to input new client and project data. This information is then searched against a current and historic list of people the company has acted against and to check of there is a conflict to work for them. One problem is that I need the...