Search results

Hi Db7, Thanks for you help, I'll play around with it and see how it goes, anyway appreciate yr help. Regards Mark Any other ideas are welcomed ;)

Please help I really need one here! Thanx in advance

Time calculation/conversion problem Hi all, I have a problem with time conversion, I'm using this function, it works fine, the only problem is, I'm getting a result as a string (that was the only way I could write this - limited skills :rolleyes: ). What I want to do is to have a result as...

Can anybody help me with this, please?

I found out that the problem is with the loop, it sends email only to first user from a query list, end shows the error after. Still trying to solve that puzzle, thus help would be great!

What I'm trying to do is to sent an email to group of users (getting addresses from the query) without using Outlook (sending directly through SMTP server) I use the following code and I get the following error: Runtime error "91", Object Variable or With block variable not set, CDO Library is...

I came up with something like that: Dim StrSearch As String Dim rsEmail As DAO.Recordset Dim strEmail As String Dim iMsg Dim iConf Dim Flds Dim strHTML Set rsEmail = CurrentDb.OpenRecordset("INQ_EMail") ' Send by connecting to port 25 of the SMTP server. Const cdoSendUsingPort = 2 Set iMsg...

hi all, I know it has been here few times already, but all the bids and pieces I found were not particulary usufull in my case. What I want to do, is after user fills all the fields in the form, he/she has a message "do you want to save it" Y/N, After clicking on yes, obviously the form is...

just refreshing the thread

Thnks again for that, the first sample suits me better, though I've put the code and it works, however I still get this annoying warning from Access: the value that you enter doesn't match to the one on the list. No idea why

thnks for fast replies guys, Doran that should do me fine, Cheers, mate Mark

Hi, I'm certain that this is a simple one, but I can't crack it I have a combo box, and in the not on a list event I'm using: DoCmd.SetWarnings False MsgBox ("This value doesn't exist. Do you want to add it?"), vbOKCancel, "Warning!" and somehow I'm still getting the warning: the entered...

Hi there, Sorry, if the answer for my problem is on the forum but somehow I could'nt find it. I have a form to create a new material, the user has to provide index number, name, group, vendor, etc. I have a Index number in following format: xxx-xx-xx-x eg. 140-11-10-0 140-11-11-0 etc...

Ken, I'll try to prepare a better sample, vand - Van Dake

Any other way? BTW. Am I clear enough on that? Regards

Here it goes again, Cracked one thing, stuck with another, :confused: The search form works fine, what I am doing now it's implementing it in another form. In my database Product contains of particular Material, thus the search subform has (MaterialID, MaterialName, Group, Vendor). Main...

Being wrong is a human thing, they say, in this case - everybody is satisfied ;) Regards Mark

Well, I've cracked it, thank you guys for your help. Cheers Mark P.S. Ken you're right again, Cheers.

Hi Ken, You mean some sort of cascading boxes? I've tried but I wasn't succesfull, I could play around with this little more, do you think this might be the best way? Regards Mark

hi all, My problem is similar to few posted here, yet different. What I have is a search form, with 3 combo fields, 2 of them are unbound one (Producers, Group) another one shows results (Material Name). At the moment I can pick a vendor and see all the products from it, I can limit the...