Search results

Thanks, but I've already read a lot about late binding and can't seem to find the correct way to reference an opened email like the Inspector and CurrentItem do. Help specific to my code would be appreciated.

Hello, I have a database that allows the user to click a button and append text to an open email. The code below is used to add the text and it worked great until something with the references changed for the people who are using it. I'm trying to update the code to use late binding but after...

Sorry, still not working. Getting this error: Cannot find file 'C:\Users\%USERPROFILE%\Desktop\Action_Log.accdb'. Verify the path or Internet address is correct.

Forgive my HTML ignorance but I'm still getting the code in the email. Did I put it in the wrong place? With obMsg .subject = "New action request for " & team .To = people .Body = "A new action request has been submitted to " & team & vbNewLine & "Priority: "...

Thank you both for the suggestions, but nothing happens when I click the link. No errors, but no file either. Solo712, this is how the link shows up in the email (it shows all the hyperlink code but only the stuff inside the quotes is blue). Please click <A...

I see. You're right, that is the typical file path that should be used but that won't work for me because I need one email to be sent to several people that will open a file on their own desktops. So what I need is a way to reference the desktop without a specific user name in the path.

I'm not sure about the file permissions, but it's definitely an error about not finding the file, not about having permission. I've tried many different versions of the file path but none of them have worked. I guess that's the part I'm looking for help on.

No, I am using Outlook.

Hello, I have created an action log database that sends an email when a new action is entered. I would like to launch the database using a hyperlink in the email, but can't seem to get it to work. All users have a copy of the front end on their desktop, so whatever I add to the email needs to...

Right, I manually refresh the frontend links when I add fields, and it's worked fine before now. The way I update other people's copy of the front end is with code that checks the version and if it's different, their copy will be deleted and replaced with the latest version. So I don't need an...

Hi there, I have a split database where the backend is on a company server and about 15 people have their own copy of the frontend. I've made several field additions to the backend table over the last two weeks but yesterday I added two more fields and now the front end gives me the error...

This worked perfectly, thank you! I haven't seen querydef before, but will definitely add that to my list of things to study. Thanks again!

Oh my fault, I edited what the variables were called for posting purposes and forgot to change the code. It's edited now.

Hello, I am trying to update a record value in a table with a user supplied value. Here's what I'm trying to do: A user logs a test against a serial number (there are multiple tests per serial so the tests are numbered) and logs how many repetitions will be performed in that test. If a...

Finally figured it out. In the query design I wrote the following in one Field: Expr1: IIf(IsNull([Forms]![InspectionEntry]![IRN]),0,[Forms]![InspectionEntry]![IRN]) and in Criteria: =[IRN] Then created a second filed for all IRN data. So basically the query expression returns nothing if...

Hello, (I'm very new to Access so please forgive and correct me if I use the wrong terminology) Background: I created a form for data entry only where records could be continually added until you were done and closed the form. Into that form I dropped a query that kept a running list in...