Search results

I have a textbox control that displays the number of workdays between two dates. I am using a custom format to suffix " days" after the number for clarity : #,##0" days";[Red]#,##0" days" I'd like to modify this so that when the value is 1, it displays "1 day" rather than "1 days" Tried using...

I'm getting really strange behaviour trying to apply a (relatively simple) query as a data source for a continuous subform. The query works when I run it directly, but when I use it as the data source for the subform, some of the values are not the same. Trying to figure it out before I try a...

I have two tables with a one-to-many relationship which I want to be able to query in order to "flatten" the data for reporting purposes. I have a table of "phases" and a table of "phase histories" which records the start and end dates for each parent project for any of the phases through which...

Hi guys, Hoping somebody can save me some heartache here... I've inherited a very old database (MDB) format. It references a tonne of Windows API's (rough count of between 70-100 declarations) and obviously 64-bit Office wasn't on the horizon back then as none of them use conditional compiling...

Hi there, I'm using the GetSelectNamesDialog from Outlook as a means for users to identify / select contacts : Dim appOutlook As Object Dim objNameSpace As Object Dim objSelectNamesDialog As Object Set appOutlook = CreateObject("Outlook.Application") Set objNameSpace =...

I'm trying to do something that seems very simple but can't quite get it to work as intended. I have a textbox (unbound) to which I want to apply an input mask. Basically, I want to restrict the user to only enter values of the form "ABC-099999" - in other words, it must be prefixed with the...

I have a form with a continuous subform. The subform uses a local staging table as its record source; that staging table is cleared and refilled when the main form is loaded such that the staging table only contains the records specific to the record for the main form. The idea being that I can...

I have a number of tables which include a SortOrder column (i.e. to allow the contents to be sorted in a query based on some attribute other than simple alphabetical or numerical order of a particular field or combination of fields) ID Value SortOrder 4 ABC 100 2 DEF 200 3 GHI 300 1...

Fallover from question on this thread (related but not the same problem...) I have a continuous subform which lists a set of data from a query. In the header section I have a hidden textbox which holds the ID of the currently selected record. I have a button which updates the value in this...

I'm embarrassed to even ask this question but for some reason I can't figure it out... Very, very simple problem - I have a ListBox that has Multi-Select set to None (i.e. only allow one item to be selected at any time) When I select an item, I can't seem to deselect it again? I can only...

Came across this thread in the Code Repository as a neat little workaround for displaying checkboxes a little larger and with a touch of colour but struggling with one tiny detail (and the thread is no longer open for replies) if anyone can point me in a direction? How does one "translate" the...

Hi all, Have a suspicion what I'm trying to do is simply not possible in Access (as opposed to SQL Server) but figured I'd ask before completely scrapping it. I have a table - consisting of two fields of ID's (basically a junction table) - but no formal relationships, so no foreign keys etc...

Hi there, I've run into some difficulties with a distributed Access DB (that is, a central ACCDB backend with distributed ACCDE frontends) The front end utilises some API's which obviously have to be declared differently in the two configurations (made pointer-safe in 64-bit) and I've...

Hi there, I've been making some modifications recently to an Access DB that's been in production for several years. Standard FE/BE split design, single BE ACCDB sitting on a network drive and distributed FE ACCDE's. I have a master copy of the FE locally and I make whatever updates are...

Hi there, I have a module which I use to pull the local system font information into a local table (literally just the available font names) which I've done via EnumFonts as follows : Declare Function EnumFonts Lib "gdi32" Alias "EnumFontsA" (ByVal hDC As Long, ByVal lpsz As String, ByVal...

Hi there, I have a continuous subform residing inside a parent form. I recently added two columns to the subform and now for some reason every time I load the parent form, the subform is always partly scrolled, horizontally, to the right, by a couple of centimetres. I thought it may have been...

Hi there, I have an Access DB which has been in production for several years. This morning, users reported issues loading it up and running any of the functionality. It appears that recordsets which were previously used for data manipulation, are no longer updatable (??) These recordsets abide...

Hi experts! I have an unbound multiline plain textbox in a form, into which users can enter text (or, paste text, usually from a column in an Excel spreadsheet, or from an email etc.) which is then taken as in input into a process I've just discovered that users can't enter, or paste, more...

Hi, Not sure if what I'm trying to do is simply outside the bounds of what Access 2013 can provide or if I'm just missing something stupid but hoping somebody can help... I have a user form which acts as a method for users to create saved templates for emails. The form has a textbox (unbound)...

Hi guys, I have a table of records, multiple fields but key fields here are a UserID (Text) and a Login timestamp (Date/Time). A UserID may appear across multiple records (different devices). I want to run a delete query that deletes all but the most recent record for each distinct UserID...