Search results

When user wants to attach the file to a record he triggers this by double click on a certain field of a form. The form displays than a patch text to a field, it sets the focus on the field and user just presses Ctr-C. Text is on clip board.

The problem is that the required mp4 file's location is hard to find out for a normal user so copy file would be difficult because I don't have the location. Mp4 files, needed to store, will arrive mostly by mail or on a media. Best would be that the player application could offer a 'Save as'...

Hi, For our company database we attach files (mostly pdf and jpg) to records so that Access generates path as text, based on the record ID, target forder's name and file extension. User picks this generated path text up by Ctr-C to the clip board and while using 'save as' method from the pdf...

I would use vba codes for renaming the headers and footers. Mostly becase I found out that - where these characters are present - after having them replaced to a correct character, the RecordSource of the Form has to be deleted and re-given again, otherwise the error message comes up. Can you...

It took a while to find out the exact problem but I'm stocked with the solution. If any of you have suggestion, that'd be great. It turned out that I the described error message appears if there is character Ű, ű, Ő or ő used in any of my forms’ name or in any of the form’s object’s name. I...

I can't see any broken element in the reference list. The only strange thing is is that I can't uncheck Microsoft Access 16.0 Object Library as vby says 'can't remove control or reference: in use'. Please let me know if you have any input in mind. Thanks petko

Ok, I've just made an empty db with a form, having a single button on it. When I try to make a sub a message pops up: MS Access is not able to make a Visual Basic modul. It tells me it must be something very obvious general setting. I enabled Active-X control under File/Data protection center...

It is Win 10 Pro. Do you have something in mind? petko

Hi Pat, I'm not able to check the error itself. I set a stop point at the header of the sub but the popup message pops up before it starts running the sub. Is there a way I can check it somehow? Regarding the code I know it worked well before the change. Now mass of errors occure, only a...

I imported all objects into a new db. Unfortunately it makes the same error message.

Hi theDBguy, I can compile it without error.

Having replaced my notebook in these days I had to change to Office 365. Previously I used Office 2013, all my files are accdb. I started the database back in 2007. After changing to Office 365 I have problems with running codes. But not consequent. Some of the codes run with no problem, some...

Sorry, I forgot to mention that code is run from the form, the report is opened from. On clicking scenario of the opener button basically like this is that runs: DoCmd.OpenReport "Invoice", acViewPreview, "InvoiceID = " & Me.InvoiceID, acWindowNormal With...

Hi There, I have a report with a sub report for making invoice. Column header on sub report are label and their caption should be visible or invisible, bolded or not bolded, depending on what language is set for the invoice. I'd like to set these parameters - after opening the report - from...

The question still stands how I can create the XML file from my data. Please specify a bit more. Thanks!

Actually they provided one, I attached a shut of it. I can follow the logic but don't know how to creat such a file. petko

Hi, in my company we issue invoices from the central Access database, that has been working perfectly for 15 years. However now an XML format file is required after each invoice issue holding the issue details and sent to a central authority. I'd like fix this from vba but I have no any...

Hi, I have the following task: the code has to rename all available files according to a naming pattern in a given directory. How could I approach this? Appreciating any ideas petkó

@rpeare, Filesystemobject solved my problem entirely. Thanks a lot!

According to the bank's requirement strBankTransfer ends with Chr(26), the Substitution character. After using Print statement the text file is created. Checking the text file with a help of an editor Notepad++ I find the Sub character at the end and following it the unwanted CR LF character...