Search results

Thank you very much for your help everyone. The Article about security is very interesting and i will definitely implement some of it in the future.

Ok i tested it out, you can delete queries in an accde file, but you can neither delete or edit forms. So where does the "continous form" problem come from?

Hello everyone, i am currently developing an access application for a small company. We are close to finishing the project and the database has quite the size. I am the only developer so i have full control over the whole application. We split our database into a frontend and a backend, and i am...

The problem is not the right name of the window. When i run the code it puts access in the foreground. So the code works, and the window name is correct. The problem is the timing. I press the button in outlook Access opens the Form Access runs the function -> gets the focus...

AH yeah, when i test the function in access vba, without using the outlook button, my access gets the focus and i can write. So the code is working, i got the caption right. Now it is just about when to execute the function so that outlook does not take the focus back...

Hey, i would just add a if condition before your loop. You are already getting the count, so you can just check if the count is 0. Set rstAdd = CurrentDb.OpenRecordset("Select * From tblContractorJob Where JobID = " & OldId & "") Set rst = rstAdd.Clone If rstAdd.RecordCount > 0...

Hey, thank you very much for your help everyone. My problem is a bit more complicated though. First, the following function is much more reliable, thank you @Gasman. Private Declare PtrSafe Function FindWindow Lib "user32" _ Alias "FindWindowA" _...

Hello everyone, i am currently creating a vba solution for outlook to communicate with my access application. I created a custom Button in the Outlook Header Bar, that calls access to open a form. So far so good. Now i want vba to set the focus from outlook to access, so that i can immediately...

Thank you, i tried that out. The problem is, the rich text is not storing the line breaks as <br>. The Text is surrounded by <div>'s. Whenever i print the content of my text field i get this: <div>Line1</div> <div>Line2</div> <div>Line3</div> So i came up with this solution. Feel free to...

Hello everyone, I have a rich text field. Now whenever a user copy pasts text from the internet into the text field, the formatting might be off, due to other fonts, text sizes etc... That is why i added a button to reset the formatting of the text. Using the PlainText function you can convert...

I literally googled "Outlook does not recognize one or more names" and took the first stackoverflow page that came up ^^ Most of the time people do not post error codes in their posts, so it is always better to find a solution via the "error message" :)

https://stackoverflow.com/questions/24638124/outlook-does-not-recognize-one-or-more-names Maybe this will help. There are quite lot of good suggestions. The problem might occur when you have multiple contacts with the same email adress, if you are using outlook shared folders, or incorrect...

Sadly no, but it is very hard to debug without any source code. Can you maybe send in your database project? Or at least a code snippen where this occured?

For what it looks like you do have 2 spaces in your SQL string after the Semicolon. So if you try to replace "; WHERE" with one Space it won't find the string. Try: Replace (sSource, "; WHERE", " AND")

Hello everyone, i have a Popup with a continous form inside. This popup form has a predefined size. Is it possible to make the form smaller, when there are less records? Like scale down the height of the form based on how many records you have? I know there is a "Move" function which you can...

Hey everyone, thank you for these informations, you helped me very much! CJ_London, this trick is awesome! Thank you! I will use this. I will mark the issue as solved!

Hey everyone, So first i gotta say i am using a backend on a server, so i am trying to reduce network traffic right now. The where condition in DoCmd.OpenForm is very optimized. It will only pull the records matching the criteria. In my case i am using an ID field so it will only pull one...

I will take a look at this now, Thank you very much EDIT: Yeah that is my current approach. What i am asking is if there is a pure SQL way to handle this. If not that is not a problem, then i will stick to vba. I just want to optimize my queries as much as possible, and using vba is slowing...

Thats a simple recordset looping through the fields and adding them to a String. See here Public Function getWorkersByTask(TaskID As String) As String With CurrentDb.OpenRecordset("SELECT * FROM tbl_Workers WHERE TaskID_F = " & TaskID) If Not (.EOF And .BOF) Then Do Until .EOF =...

Hello everyone, i have 2 tables, tbl_Task and tbl_Worker. They are connected using a 1-n relationship over the "TaskID" and "TaskID_F", so one Task can have multiple workers. What i want to do now is, i want to show the names of all the workers, seperated by a comma for each task. So i need to...