Search results

I wanted to thank you all for your contributions and sorry for the delay in my thanks.

thank you Gasman, I have already implemented the suggestions in that article, however, as he suggests the TLS aspect of the CDO appears more experimental than working. Also Isladogs, When I used your email form, I did not get any errors. It did not send the email, I clicked send, and...

I had a look thanks, I entered the same data and I couldnt get it to work with tls smtp servers. Have you tried it? maybe im doing something wrong or this particular server is difficult. For the record its an nhs.net email.

just for clarity, this is the error i get :

Hi Ranman, the problem with SendObject is that it sends with a 3rd party email program like outlook. I was hoping to not to rely on such a situation.

I hope everyone is safe and well. I currently use cdo to send emails within my front end. Works well, but some smtp servers / accounts require a tls secured connection I have experimented with config.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendtls").Value = True However...

I tried this in the onload from main, and it didnt work, the report is still empty. Im guessing its because the query is trying to pull data from the textbox which hasnt been loaded yet, as the main form will load last?

Hi Arnelgp, I hope your well. Should i try this from the main form onload event do you think?

Ok, so here is the situation. we have a mainform, then the navigationsubform. On the navigationsubform is a subform which has sourceobject of a report. This report is based on a query which references a textbox on the mainform. The issue is that the report is always empty unless you requery...

I have an access FE, SQL BE. Everything is working well, however as the system is getting bigger and busier we are now getting more and more write conflict issues. This is where a warning pops up saying there is a write conflict, do you want to save, copy or drop changes. This is obvious...

To correct myself and add more info, the issues are purely down to using some of Access "inbuilt" functions, like the "find". So for example, I have written a simple query and search system, and its lightning fast, much faster than the access find with an access BE. This is where the indexing...

I wanted to join in on this thread and add my experiences. I have a access Fe, sql 2019 be. In some instances, especially searches , sql seems to be much slower that just a split database. Im sure this is just because I havent designed the forms/queries with sql in mind, however its important...

yes thanks, I got it working now. Heres the code I used in the end, the syntax is really different to standard access/vba , so becareful DoCmd.BrowseTo ObjectType:=acBrowseToForm, _ ObjectName:="Form_Name", _ PathToSubformControl:="Main Menu.NavigationSubform", _ DataMode:=acFormEdit

Hi guys, Im just trying to open a form in the navigationsubform space, just like a navigation button would do. I was hoping there would be a simple parameter like target=, but i cant seem to find any such thing. Any ideas? thanks,

i had to download and use the sql odbc version 17 driver to work with sql express 2019. can you connect to the server using ssms? when you installed sql, did you do it as an instance or default? if default, then there is no instance needed.

Is there a way to have a control on a form which is like ms Paint? I am trying to see if it's possible to draw in a form, and save the image.

thanks, I will check. I really feel Microsoft have let us down in this respect. This is basically what Im trying to solve, I was trying to be vague and not give out to many details for obvious reasons. I will wait for your new version and continue to research and try and figure something out.

I will look into that, but it doesnt seem a good solution. Adding another login for the users. Also, just a quick glance, and Im not even sure its possible from ms access, it seems to be set up for a web based environment, eg using asp or visual studio. I am hoping just to find a way of...

I don't think thats an option, im using azure sql.

One thing I have learned from transitioning to sql be, is that you realise access is very quick and easy to work with. It will make you consider going back to access.... If you want to change or modify your back end when its in sql, prepare for pain. Things that access just does automatically...