Search results

I am trying to UPDATE a table based on the result/value for the corresponding record in a separate query. This is the basic syntax of the query : PARAMETERS SpecifiedRecordID Long; UPDATE tblRecords R LEFT JOIN qryOutstanding AS Q ON R.RecordID = Q.RecordID SET R.LockID =...

Does anybody know if, when calling the Windows Colour Dialog (to provide an option for a user to select a colour for something) : Open the Windows Color Dialog from VBA ...is it possible to define, set or change, the Basic Colours that are loaded into that dialog (as opposed to the Custom...

I have a form with a number of "cascading" comboboxes, each with simple Table/Query RowSources. When the user selects an option from the dropdown of the first combobox, the second combobox is requeried and revealed, with options relevant to the first selection. And so on down the list; each...

I'm trying to build a query that will insert new records into a table, which is effectively two columns of ID's (essentially foreign keys to/from two other tables) where the combination doesn't already exist. Basically, I have a source file/table, to which I join on respective fields to...

I have a query which takes a parameter (a User ID) and then appends a record to a table using that parameter, along with a couple of other fields from a staging table, assuming a similar record doesn't already exist (tested using an outer join). Not a complicated query and I have dozens of...

I have a textbox into which I want to insert (programmatically) some text along with some unicode characters. The textbox is purely informational, it's locked to users and only populated by code. Have formatted the textbox with the Segoe UI Emoji font and want to insert some of its characters...

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