Search results

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...

Thanks for your suggestion. I tried to Write statement, however the only difference was that it inserted a quotation mark at the beginning and end, which is also not wanted. And the CR LF was still there that I'm trying to avoid. I would appreciate any further ideas. many thanks petko

Hi, I'm using a form to collect the actual bank transfer data from the user and at submit the code prepares the requested string that is converted to a text file, that will be imported into the bank terminal. After having prepared the string I write it into a text file: Open TxtFileName For...

Most of the time in Print view but from time to time Report View is also used.

This is a regular problem when opening report for which I could not find solution so far. I use DoCmd.MoveSize for sizing and positioning the report's window and ZoomControl for the needed scale. After opening the report this way manual scrolling is needed to scroll done from the header to...

Hi, I have a strange problem that I could not find a solution for so far. For some unknown reason I'm not able to use the local menus on form that was possible till 2 days ago by clicking the right mouse on the header of the form. The mouse works fine, even on reports I can use the local menu...

Thanks Minty, That makes sense. Is there an event that would do the same job on the line visibility in the headers but in report view? Thanks petko

I'm trying to make a kind of tree structure on a report for better visualization of the structure of the technology, my report describes. For making this possible, a procedure runs through the different levels and bottom units of the record set to set booleans, like last, or first in the group...

Thanks arnelgp, The ticking way I know but I would gladly avoid using one boolean just for that. Is there no any way to refer to records in a form, selected by the user? Peter

I'm in need of the following functionality: The user would select a bunch of records from a form and after a user trigger I should be able to run a procedure manipulating the set of records according to the user selection. How could I do this? Thanks for any input Peter

Hi sneuberg, thanks for the example, works nice! Peter

This is what I tried to do but then the form's fields are not editable anymore (as the rowsource's fields are not either...)

What I'm trying to do is probably an easy task but I need some help to do it. I have a form, for example a form of customers. One of the fields of a customer is a city postal code. As a result of an independent external querie I have a bunch of postal codes on which I'd like to filter my form...

Thanks jdraw, ACCDE format is nice, that solves my problem... As I don't have any experience with it, I'd like to know if it is possible achive that the user could not see, or at least not delete objects from the object list (opened by F11) Thanks Peter

Hi, I'd like to identify if the user switches a form to a design mode. The form where I want to do this is a password inquiry and I'd like to handle somehow this scenario from code. But I don't know how to catch it. Any idea would be appreciated Peter

Thanks for your feedback. I'm not really familier with these system stuff. You mean the directory Windows/system32? That is full of hundreds of files. How can I know which to check for existance on the virtual PC? Both the pcs and virtual pcs are 64 bit ones. Is that important? Thanks Peter

Hi, For making a database available from outside I copied it onto our server and want to reach it via remote desktop - the idea works perfectly. However a good part of my events don't work for some reason. Some do, some don't, and always the same don't work, unfortunately I can't find any rule...