Search results

Hello I have a calculation tool that displays some life cycling figures... I need to return the block 'value' for which both the upper and lower figures are the same ie. dont contain FAIL So in the picture attached - I want to return the value representing the highest pair of values ie...

I store Sterling / currency exchange rates in my DB which apply between a date range (given as Start / End dates in the currency table : ie. an exchange rate 'period') So for any one currency type (Euro/Swiss Franc etc.) - there can be many records in the EXCHANGE RATE table, each record...

I wish to use a recordset call with SQL to return all records for the current month/year... can you advise on the parameters to Format to achieve this please..?

I need to generate an Excel report but NOT using the shortcut menu and Wizard in access... From report preview... I want to be able to use vba to run the access report and automatically save the excel report to a designated folder on disk. (I have another routine i can use to then email the...

I have a Switchboard panel/form , set as 'Popup' this is the primary panel for my DB application. ....this has been fine for many years, however I am implementing a new panel for time bookings for our workshop where operators of machine tools will likely have oily hands and I want to mimise...

Hi I have a report that runs from a dialog where the user has the option to print out or preview. This has worked fine for many months. Yesterday i had reason to change a label on the report , to a text box whose control source is a text box on the parent dialog from where the report is...

I have a report that is initiated from a dialog box. From commandbuttons on the dialog - I can preview or print (my own print function). When the user prints the form I need to run some additional code.... However, if the user previews the form and then runs the Print option from the context...

I have a query that uses the following LIKE condition... Like [Search for OD?] & "*" This returns all items where the OD(Outer diameter of components) broadly matches the search criteria. However, my stock of components has sizes : 16mm and also 160mm... If my query search string is '16'...

I have a form with a collection of bound controls. By default, the form loads empty for new record entry but using the navigation buttons can browse historical records. I have a text control bound to the primary key / ID for this form and if this is NOT NULL ie. an existing record, I wish to run...

Is there a way to determine across the entire database what entities (tables/reports/ forms etc.) have changed since a specific date..? I am not talking about records at table level... I mean VBA code and database design/structure changes I am not using source code control or anything...

I am constructing an SQL string in code and am using the following to detect where a String contract reference is NULL / not stated - in which case I use empty string parentheses .. Nz(txtContract, " '' ") .. However, when the string is constructed the parentheses are being removed and I am...

I have a STOCK table which holds unique stock records for materials held in our system- I also have a form on which I can select items from the STOCK table that I wish to 'pick'. Any picked items are added to a temporary table STOCK_TEMP. Initially the picking form is populated with a query...

I have found code on an excel forum for creating Tooltips in a Listbox control.. but cant get it to compile in Access ... Are there any Access/VBA 'gurus' out there that can use this baseline and modify it to work with Access 365 please..? The code in question is here.. ListBox Row Tooltips...

I don't suppose the ROWS in a listbox control can be adjusted i have multiline text i need to display. If not i suspect the only way around this is to use continuous form display config with a multiline text box ..

I have successfully used a list box in a form inrcorporating a right mouse click event in the list box itself, to toggle the selection of all list items.. The list box is 'Extended' type. Using a similar setup on another form I am writing - when I right click, although the code to Toggle the...

I am having re-occuring issues with a database that I have been working on for many years. I make changes to the GUI of a form, save and run.. but the form doesnt load... I decompile/recompile without issue. Run again, form wont display... I have had to resort to having a seperate database file...

Hope can help - a simple way to illustrate my problem... 1.Create a simple database with a table and a 'short text' field, call it ReqNo 2. Add the following records to the table for ReqNo : 2a334,999,1231,34595 3. Run the following query against this table.. : SELECT Max(ReqNo) AS Expr1 FROM...

I wish to create a form for the user to hide customers from a panel. On load, The dialog to do this will populate with checkbox rows according to the number of customers returned from an sql query. Any helpful code snippets to dynamically add the checkbox controls would be appreciated. Thank...

I have a report that is showing hashes in fields where the content is truncated. I modify the report and change the text box width. I can re-open in Design mode if I chose to after Save. But when i attempt to open the report in Form view, the report wont open.. cursor briefly suggests something...

I have installed a copy of the Front End for my 'split' database on a brand new Windows 10 laptop connected to our LAN. After I have run it for the first time, I note a record locking file remains and the operating system will not let me physically delete it : saying that Access is still using...