Search results

In Access VBA when creating Excel spreadsheets, how do I extract the default font color? I have a routine where I cycle through a recordset and one particular field has one of three possible values, a positive number, zero or negative number, that are text fields, not numbers. (It's a...

I am successfully printing a report directly to pdf via the command, DoCmd.OutputTo acOutputReport, strReport, acFormatPDF, strFile, False Everytime I run the code there is a messagebox that appears and instantly disappears, though I can't read the contents of the messagebox. This happens...

I'm returning to some Access data manipulation and I've come across a situation I thought was possible, but can't figure it out. I have adopted a work-around (explained at the end), but I thought there is a less-convoluted way. I have a table that records running times of runners for each...

I've created a spreadsheet that records my club's weekly run data for each member. The data is extracted from Strava, bit of a process, screenshot taken, then converted to PDF, then OCR'd and then to Excel (temporary sheet to iron out any OCR hiccups) then copied to the final Excel data file...

Preamble: Users will be able to fill in a spreadsheet (that is downloaded from the Access application), and eventually import the data from the spreadsheet into a temporary table and then eventually into the live table on the network. I'm still in draft/development mode with this feature. I...

I'm working on an Excel sheet, have created many functions that return strings to the cell(s). After applying all the VBA functions to the cells (1,000's), if I make a slight change to a string within a VBA function that obviously changes the return string to the cell, how can I automatically...

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