Search results

Dear Fellows, I haven’t visited the forum for a while as I’ve been enjoying the fruits of a 15 years long development. The system, worked out for our company, serves comprehensively from purchase to invoicing, or from labor date to car management. Tables are located on the server, front ends...

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

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

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

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ó

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

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

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

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

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

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

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

Hi, I run a database with table on the server and 7 users linked to the table. I've recognised that users frequently let their application running even if they are out of the office. Is there a simple way I could recognise this from the vba and shut off automatically like after and hour...

Hi, I'm in need of some input very much in the following matter. Given forms A and B, user works in form A and as a result of his process a field value fldCopyFrom in form A is copied into fldCopyTo in form B. Focus is set on form B so the user can go on here with his work with the copied...

Hi there, I observed something annoying when opening a form with a subform for which I cannot find any reason. The thing is that when the form opens, the first field of the subform flickers while the field description at the bottom left corner shows "calculating". If I open the form with...

Hi, I'm using CopyObject method for distributing the newly developed objects to all those accdb files that containt that object. However at each copy I need to provide a confirmation for overwriting the existing one. I can't find an option among CopyObject parameters to skip this confirmation...

Hi, I'd like to know if it is possible to copy an object (typically forms, reports and queries) by code from the acces file I'm woriking in to another one that is not opened. Appreciate any ideas petko

Hi, I have an accdb file, holding all the tables on my server. Clients are linked to this one from their workstations. Speed is a constant issue mostly when more users are linked and I'm trying to find ways to make things faster. Would it be possible to open a recordset when a form is loaded...