Search results

Hope someone can help. I've been given an Excel spreadsheet and asked to clean it up as it's not doing what it's supposed to. It's a Leave Roster spreadsheet. What has happened is that 67 checkboxes have been added to individual cells, in the same column. Each checkbox is named...

I always find double quoting very difficult on the eyes and so easy to stuff it up, missing quotes or too many quotes. To make life easier, why not write a little function where your string to be quoted is passed in and the output is a correctly quoted string. I use the following, hope you find...

How do I find the FaceId for buttons on the Right Click Menu. What I would like to do is cycle through the complete listing, find a relevant image, and use that image for some of my Right Click Menu items. I'm using Access 2010 and 2016.

I've taken the plunge, now trialling SQLExpress along with VB. I'm following an online tutorial but have got to a point where I can't connect to an MSSQL database. I've installed SQLExpress 2017 and the SSMS tools program. They were both installed to their default locations on my C: drive...

My regional setting for Dates is set to "dd/mm/yyyy". Below are some results from my Immediate Window. ? Day(#30/11/2018#) 30 ? Month(#30/11/2018#) 11 ? Year(#30/11/2018#) 2018 The above shows that the Day, Month & Year are correctly extracted from the inputted date. ? #30/11/2018#...

For a Label control, I want to only display the left border and the other borders to be transparent. Is this achievable? I note there are properties of the Label control, referred to as Gridline Styles, and one of them is 'Gridline Style Left' and setting that to 'solid' has no effect...

I'm returning to Access as I had to modify a Car Booking database I wrote many years ago (it's not my primary role). The main form is based on a Listbox, the first column represents the time in 15 min intervals, from 00:00 to 23:45 (a full day), therefore 96 rows. The following columns...

(Access 2010 - 32 bit) Is it possible to edit and save a button item within a user-defined shortcut menu (right-click popup menu)? I'm suspecting at this juncture that it's not and the only option is to Delete the shortcut menu and recreate. An item on a right-click menu is "User Form (show...

Continuous Form - show last record at bottom of list - Access 2010 How do I go to the last record and show that last record at the bottom of a continuous form list (without having to click the vertical scroll bar to force all the records above to appear)? In the process, the last record is to...

Hope someone can shed some light on this. Using a Continuous Form, every time I change the Recordsource of the Form via VBA, only one record is displayed and is positioned at the top of the window. White space is below the record, even though all the required records have been returned...

I've been researching how to implement the Right-Click menu in Access 2010. I came across an example from StackOverflow that partially works. I'm getting a Type Mismatch error on the following line: Set combo = .Controls.Add(Type:=msoControlButton) When checking the debug session the value...

Just over a year ago I started out designing a schema for a personal finance/accounts system. I received a lot of help at that time, here's the thread. I wanted it to replace my reliance on Quicken. Since then, other things got in the way so I didn't progress it much further. Anyway, now...

For an application I've written, and is extensively used, I'm now in the process of adding a Document Management feature. Up until now, there were no links to external documents, whether they be images, video, documents, etc. I've not implemented this; it's still in design and development...

This problem has me stumped and now seeking assistance, I'm hoping someone may have come across this previously. Microsoft Access 2010, 32 bit, Windows 7. All office computers are configured the same way. Users reported errors of my main application, and they all originated from the same...

I don't think the Multi-Quote is working as it should. It seems to be hit'n'miss as I have been able to get at least two quotes gathered into the one reply box. Clicking the 'double quotes +' button, is only highlighted for the first click, when clicking the same button for other messages...

I'm stoked, my kids got me a Samsung Gear Watch for xmas. What can I say, I love gadgets.

Okay, first up, I know how to resolve the following but what a pain in the ....... In one of my applications I keep track of the user logins (session_id, version, dates, times, username, machine name) along with which backend data files (full paths) they are opening/closing. The session...

On a form I have a Multi-Select listbox and other listboxes (on the same form) which are updated according to the value in the Multi-Select listbox. I detected that the AfterUpdate event was not firing when using the keyboard such as Shift and the up or down arrow keys. So I created the...

Personal Accounts - Handle share trading (revamped) Okay, after much research scouring the Internet for examples on how to incorporate share trading within a personal accounts model, I've decided on the following. I think it's almost there. I've not included miscellaneous attributes or...

I've now come to a mental block as to how to design and map out the buying and selling of shares and recording the associated broker's commission. It's in relation to a personal accounts package. For non share trading transactions I've got the design nutted out but for the life of me I can...