Search results

Hey guys, Im trying to change the registry with VBA but it doesnt want to. The code works without errors, however it doesnt write a value to the registry key. Here is the code: Dim myRegKey As String myRegKey = "SOFTWARE\WOW6432Node\Microsoft\Office\12.0\Outlook\Security" RegKeySave...

Seems like I forgot to answer what fixed the problem for me. Actually the antivirus was outdated and outlook stated that its not valid or similar, cant really remember now. However, updating the antivirus fixed it. But now I have the same problem but on a Windows server 2008 r2 which doesnt...

Thanks! I went to the form and changed the textbox text format from plain text to rich text and now it shows in one line without changing the query. If i keep the textbox text format as rich are the some down sides? I also changed it on my report because I use the same on that report.

Yeah seems like this code in expression builder is making the new lines because I can see then in the query datasheet view too: KompletanNaz: IIf(Left([Konto].[KontoNr];2)<>"20" Or Len([Konto].[KontoNr])=4 Or Left([Konto].[KontoNr];4)="2013" Or...

I have a textbox on a form which shows data from a combobox column(1) and column(2). The textbox is wide enuff for the value to fit in one line but it brakes in one or more, not for every combobox choice but for many. Is there a way to force the texbox to show the text just in one line without...

If I comment out the next code in my code it works fine: Set Wrks = DBEngine.Workspaces(0) 'Wrks.BeginTrans 'Wrks.CommitTrans So, BeginTrans and CommitTrans.

I didnt see your last post up until the morning. Yes I add a record with just populating that one field, all other are not required except the autonumber which populates itself, but I do populate some other fields too, I just didnt include them in this copy of the code.

There is a with, I didnt post the whole code, sorry for the confusion. Its actually a recordset inside a recordset too much to post everything. Anyway the code works fine, after the .Update it keeps going fine I just can run the query in query design after that moment. Set MyQry =...

Ok, I went line by line and it stops when I open the same table in another recordset variable and add a record to it, immediately after the .Update executes the query doesnt work anymore. Set MyRs1 = MyDb.OpenRecordset("Table1", dbOpenDynaset, dbSeeChanges) .AddNew...

Yup, its the field has the same name as the table. You are right, it was set to allow zeroes and I changed it, but still same happening. When I make a query in access with the query design tool (same as the one in code) it runs fine, however when I stop the code with a brake point on the...

Data type: bit, size 1 and 0 as default like everywhere else where I have true/false and the other work in other code. Actually by setting one of my other recordset variable to nothing just a line before the problematic line executes the code runs but then it gets stuck later at...

Alright, I linked just the Table1 back and yeah the code works, thats the table I use in that recordset Variable, "NewVariable". Does that mean something is wrong with the SQL table? But then again, why does it work when I remove the True/False part :confused:

Hey DB, I made the DNS manually through ODBC data source administrator. I wouldnt say anything is wrong with it because all the linked tables open fine and all the other reports/forms work correctly. Edit: I go quickly link back some tables which are used in that code to the old .mdb database...

Im trying to move my database to Ms SQL Server 2008. I did that upsizing and checked the tables and everything seems to be fine. However, when I run a piece of my code I get the error from the title. This is the line where is appears: Set NewVariable = MyDb.OpenRecordset("SELECT * FROM Table1...

If I dont put the .Display before, the logo doesnt want to show up. I tried inserting the .gif in the .html file but same, it doesnt want to show up on the email, it does show up when I open the .hmtl file.

Here is the code, I translated the commented parts and some msgbox-es. Hopefully you can understand it :D And the code needs improvement, Im still a newbie at this. Private Sub cmdEmail_Click() '20190410 Dim FileName As String Dim emailText As String Dim SaDatumom As String...

Thanks pbaldy, it does state that the antivirus status isnt valid, so it might be the case. Unfortunately im not in the position to test it now but I assume thats the problem. However, I had another problem next to this one. Today a worker sent the emails as usually and that warning poped up, I...

Im sending about 50+ emails through Access VBA with Outlook but for every email this warning pops up and I have to click on allow. Anyone else had this problem and whats the best way to avoid it? I did research a bit but didnt find any optimal solution. Interesting is that on the first PC it...

No, i moved code from page footer OnFormat to Id (the group by i added) footer OnFormat. I actually did copy the whole code from OnFormat from Id footer to Print event on Id footer, same error. Edit: Direct printing works, printing without entering the print preview

You misunderstood me, it works for me too but the problem is when the text box of the subreport which Im referring to is a blank field/control, then I get the above report and I cant avoid it with Nz or IsNull. My idea was to avoid any of the 4 subreport textboxes which have a blank...