Search results

Hi RuralGuy, Thanks for the list, I found what I was looking for. Peter

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

Quite simple and easy..:) but seems to be working. Thanks!

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 JHB That works perfectly! Thanks!

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

Dear CJ_London, Thanks a lot for your feedback. Speed is a big issue (I guess) but what I would like to know particularly if it is generally possible to set a recordset as a data source for a form? Appreciate your help Peter

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

Hi MarkK, Thanks for your help, it works. However I can't find the way how to make a form on the tWorkerGroup table that would provide the data for the user in a matrix-look sheet. Something that looks like an Excel sheet where line heads are WorkerID, column heads are GroupID. Do you have any...

Hi In my DB there is a set of company-running rules that are addressed to different groups within the company, like drivers, bookkeeping, warehouse, electricians etc. Both groups and workers scope and number might change from time to time. I need to make a table that holds which worker belongs...

Exactly that I looked for... Thanks JHB!

Hi, I'd like to do the following: when the user does something on Form A, Form B has to be open and the Forms should be located on the sides (Form A to the left side, Form B to the right side) of the display so the user can see them at a time. However both Form A and Form B has an automatic...

Hi, I would like to put a message on the screen for informing the user - mostly during some procedures that might take time or when, after a warning, I want to go on with the program but without action from the user. Msgbox is obviously not the one I'm looking for as it needs customer...

Thanks a lot CJ-London!

Hi, We have at our company a shared database system; tables on the server, end users linked to the tables. The system is quite complex with a lot of VBA codes, all developed under 2010, runs fine. We need to have new users but Access 2010 is not available anymore but only 2013. So some of the...

Thanks CJ_London, that works fine!

Hi, I'm trying to send an Outlook e-mail from Access. Everything works fine except for one thing: When generating the HTMLBody I use vbNewLine for starting a new line in the string that works fine as long as being in Access. However after displaying it in Outlook there are no any new lines in...

Dear Galaxiom, Your explonation on index helped a lot! Actually the speed of the system became brilliant by using indexes. Obviusly it needs some experience where to use and where not but it is obviously a key thing in improving performance. Thanks a lot!