Search results

Hello everyone, With the advent of the accdb format in A2007, setting up user security has become the developer responsibility. Luckily, to provide basic, “lightweight” security is not a difficult task. It consists of managing a database user table and providing the application with a login...

Hi everyone, Every so often I see requests on Access boards inquiring about a way to streamline events for multiple controls of the same kind, so they are executed as a single function. Surprisingly, most answers are negative in the sense that VBA (unlike VB) doesn't know control arrays...

Hi everyone, In my experience as a freelance software developer, the biggest obstacle in running the business has been to get paid for my products, even from people who expressed satisfaction with what I delivered to them. In the eighties I eventually gave up and got a “regular job” in IT. At...

In the OP about the merit of global variables in Access programs, I mentioned Juan Soto's as a promising approach to take. This is because in my thinking, global variables (and constants of course) very often hold info about the application settings and session parameters. It is not as much that...

I have recently veered into a discussion about global variables and received a handful of opinions from respectable contributors to AWF ranging from the the standard caution not to overuse them to the view that there is always a better solution than a global variable. I certainly do not accept...

I am designing a custom generalized FindRecord form (see attached pic) to replace Access Find Record dialogue which I had many (justified) complaints about. Everything seems to work fine except: The DoCmd.FindRecord method does not (seem to) handle controls with searcheable combos. First...

Scoured the web, tried everything. The HKCU\Software\Microsoft\Office\15.0\Common\Security\DisableHyperlinkWarning set to 1 does not work nor do the other remedies. Strange that the annoying message appears 1) with files stored in trusted locations (local folders) 2) only...

Has anyone noticed that in A2007 if you disable the Navigation Buttons on the form the Me.RecordCount will be set to 1 when the form opens ? I replace the Nav buttons with my own set but my "Go Next" button will not work untill I hit "Go to Last". This apparently restores the recordset count to...

I have a setup where a selection from a Listbox fetches a record. I am using the well-known method of setting up a recordset clone and on finding the record goes to it via the clone's bookmark, something like... If Nz(DLookup("EEID", "tblPayPeriod", Criteria)) <> 0 Then ' record exists - get...

This is sort of a brain-teaser (if that is allowed here). I already have a work-around but thought it interesting to share it with the board to see if perhaps better solution might exist. I have created a fancy-schmancy form for a payroll program which can be used to enter time sheet data...

I have created a small string encryption DLL in VB Express 10 and tested it in 32-bit environment. Works fine. Could someone test it in a 64-bit version Office ? I would like to see if the "safeptr" gizmo will do the trick. Unfortunately I don't have access to a 64-bit version Office at the...

Thought I would share a little discovery I have made after some have-duty wall climbing. You will find dozens of Access forum entries dealing with the above Access message (Runtime Error 2448) and a good portion of those deal with the specific issue of it appearing when starting data entry in...

Hi all, like Michael, I have a homemade function which I would like folks to evaluate. Sometimes, when I finish my work I feel reasonably certain it is clean code. Sometimes I don't. This would be one instance when I have an inkling it could be done better. The need for this function seems...

I have been using a printer-selecting listbox without an incident for a number of months now. It is for Access printouts of Excel spreadsheets. So far no problems. The two routines below register local and network printers and select active printer among them: Public DefPrinter As String...

Hi, being still relative novice in Access I live with great daily surprises. Here is one that has left my head shaking. I have a relatively simple query which is to serve as Bank Deposit control sheet. The database manages condo data, and the payments come from two sources (owners paying their...

I need a general purpose VBA routine converting ordinals into Roman numerals. Did not want to spend much time on it. To my surprise my Google produced nothing much of value. Mind you, there are some smart blokes out there who propose to create value tables for the Roman letters and then go...

I am using a listbox which is populated at runtime with stats. I have a really strange problem with a string formatted for currency, like so: .AddItem "Budget for " & Str(Year(Date)) & " :" & stBudgetStr the stBudgetStr being previously assigned value in this manner : stBudgetStr =...

I don't know whether this has been discussed on this or the VBA forum (I have not found any reference) but my single-select listbox (i.e. Multiselect property set to 'None') in Access 2007 drives me to distraction. I have tried everything but can't find a simple solution to reading out the...

Hi everyone, a newbie here. I have introduced myself in another thread. It has become clear to me over the past few weeks that boards like this one are an enormous resource. They have already saved me tons of time on little piddly problems and bigger ones as well. So I thought I'd share one...

Hi I am getting back to programming after a twenty year pause.... more or less Windows killed me back in the nineties and I became an IT manager. Now I am retired and have appetite for some fun projects. So, there, I am starting again: 'Hello world !' :)