Search results

Thank you both, gasman and arnelgp, for your answers. As gasman hinted, I also think it has to do with the spaces in the name. As I said before, if I rename the file to MyFile.txt, there is no problem. The below code works without errors. Sub LoopThroughFiles() 'to import all MyFiles*.txt...

Doesn't work, it returns the same error 3011.

Hello! I would appreciate it if someone could explain why I'm getting Run time error '3011' The Microsoft Access database engine could not find the object "C:\MyPath\MyFile 01.txt" when running the below code: Sub LoopThroughFiles() 'to import all MyFiles*.txt data to table MyTable Dim...

I tried also with a plain text template (created in outlook and saved as a .txt file). Unfortunately, it does not work either.

Thank you for your answer. With this approach, I guess I would have to export the report as pdf file first, save it to the disk, and then add it as an attachment. With DoCmd.SendObject I don't have to do this, I can send a report as pdf directly, without saving it to the disk. I would rather...

After quite a few attempts, I came up with this code: Sub CreateMail() Dim myItem As Object Dim olApp As New Outlook.Application strAppdata = Environ("Appdata") strTemplatePath = strAppdata & "\Microsoft\Templates" Set myItem = olApp.CreateItemFromTemplate(strTemplatePath &...

Well, Microsoft says you can, like this https://docs.microsoft.com/en-us/office/vba/api/access.docmd.sendobject I took my pice of code from there. Obviously, it doesn't work.... I'm afraid my knowledge of Access and VBA is too weak. As I understand it, this code sets the appropriate template...

Hi! I know this has been asked many times, but I couldn't find an answer that would work, at least not for me. I'd like to send a report as pdf by email, using a Microsoft Outlook Template file (.oft). I have tried to use the OnClick event of a command button using DoCmd.SendObject and...

Thanx theDBguy. That works....

Hello! I have a problem using DCOUNT to prevent duplicate entries by date. I have a table named tAverage(with the ItemName, Quantity, AverageQuantity and Date_average fields) into which I add new records using the qAverage_Add query. This query also calculates the average quantity. I run this...

Thank you, Doc_Man, you made some good suggestions. The last one seems the best one to me. So I'll try with that.

Well, I need an empty database, to import new data on an annual basis, to process data and prepare reports. New data should not be added to the existing data. Although I could delete the data from an existing file and save it with a new name, I do not want to do this because there could be some...

Micron thanks for your reply. With the simple "Save as Template" you can save only the front-end or only the back-end. So when you open the front-end template, you get a new database front-end that is linked to the "old" back-end. If you open the back-end template, you get a new database...

No, I know how to do that. I wold like to make a template from an existing split database.

I don't have much experience in building databases with Access (or any other software ☹). I would appreciate it if someone could provide me with the info or step by step guidance on how to save an existing split database as a template. I have the latest version of Access 365. Frank

It's easy. Go to "More Options" at the beginning of the thread (simply find the three "..." and click on them). Then click on "Edit thread", edit the thread title and then save it.

Thanx namliam, your improvement also works.

Thanks Adam, this is working.

Thank you for your answer. Unfortunately, it does not provide the solution I wanted, because for each item it returns a total occurrence in a table greater than 1. I agree that the sample data provided was small, so I added some more. All items that appear only once are not highlighted. All...

Hello! I need help building a query that will count and filter my records. I have a table like this, with several thousend records: I would like to build a query that will count and filter out all records with same Item and more than one Group and will give result like this: How should I do...