Search results

Here's a simple code to insert today's date in a cell in Column "E" when double clicking any cell in that column. It works fine, however, I can't figure out how to make it start at Row 3 of that column. Any ideas? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...

The main table in my database is imported from an excel table. All fields are TEXT fields. My continuous form has a column called RevDate and I'd like to have a button to sort the form by this field. Most of the time, the date is in a format yyyy-mm-dd. So using this simple code requires no...

I have a simple text box in a report which can contain several sentences. It could look confusing bunched up altogether. Is there a way to parse the sentences with a line breaks at end each period?

There are a lot of examples of resizing the Main Access window using the Application object, Application.hWndAccessApp But I can not find a way to use this property without repositioning it. It would be great if it could be made to work like DoCmd.MoveSize for a form. Basically, I'm trying...

I've been using isladogs IMEX form found here to import my data into my database quickly. https://www.access-programmers.co.uk/forums/threads/view-edit-imex-data-task-specifications.307897/ All was working till I created another import spec and tried running it or changing the file path using...

I'm trying to filter a combo box using a three way checkbox in a similar to the way of doing the cascading combo box by using something like this in the combo row source [Forms]![FormName]![CheckBoxName] This works when the checkbox is True or False, but not if it's Null. Anyway to show all...

I'm using the View & Edit IMEX Data Task Specifications version 2.2 found here Is it possible to edit the import to allow two imports with one click of the "Execute Action" button? It would be essentially the exact same task but importing another spreadsheet from the same folder.

I'm trying to use conditional formatting to highlight duplicate cells but only when a corresponding cell in the same record is different than the 1st one. Here's a picture of what I'm trying to do. Notice that the SN field gets highlighted for duplicate SNs, but ONLY when the corresponding...

I'm trying to import an excel spreadsheet that has one field with more than 255 characters sometimes. So far, I've tried linking to the spreadsheet and using this ACImport VBA and both have continued to truncate this field to 255 characters. DoCmd.TransferSpreadsheet acImport...

Trying to create a recordset via a query where all records shown with the lowest item number record. I've tried this, but it's not working. DMin("ItemNo","Findings",[Findings].[ItemNo]) So for example, I have this in the table Any ideas how to fix it?

Trying to use the query criteria to show only a single row in a batch of records with the lowest item. Something like this Batch Item 001 001 001 01 02 03 002 002 002 02 03 04 003 003 003 02 04 05 So I'd like the results to show this Batch Item 001 01 002 02 003 02 Tried...

I have a table that has multiple duplicates. I'd like to run a "Group by" Totals query and then use an update query to update a temporary table with those results. But I get an error message, "Operation must use an updateable query". Is there a workaround for this or another way to do what...

I'm trying to highlight a field with duplicate values in a continuous form but only when that field and another field are different. I've tried various combinations of the following code, but can't get it work DCount("*","TableName","[SN]='" & [txtSN] & "' AND [ID]<>" & [ID])>0 This is what...

I've used the Linked Table manager to Link an Excel Table as the data source in Access. But the table needs a small change to one of the field titles. Very simple to just open the file in Excel and edit the field and then launch Access. But I'm trying to add a button in an Access form that...

I'm using a text field in a continuous form to show Y or N or just leave blank if nothing is filed in yet. To filter out the records, I'm using a combobox with a filter like this If Not IsNull(Me.cboYN) Then strWhere = strWhere & "([Tested] = """ & Me.cboYN & """) AND " End If This...

Trying to find a way to sort a continuous form from a column in one of the combo boxes. I can add an unbound field in the continuous form and call it TeamSortOrder and make the control source the second column of one of the combo boxes. For example, =[TeamFunction].[Column](2) This unbound...

I have a report that sorts the data based on a linked sort table. But there are records that are not linked to the sort table. Is there a way to sort those entries that are not in the sort table list to the bottom?

I have two tables. tblContacts and tblTeams. Each record in tblTeam has 3 contacts. And I use a drop down to populate the ContactID from the tblContacts table in each of those 3 team contacts. So the tblTeams table looks like this: TeamID, Team1, Team2, Team3 01, 02, 03, 04 (These are the...

My company recently moved to Office 365 and now I'm having issues using DoCmd.TransferSpreadsheet This VBA used to transfer a query to a Worksheet and then open the Workbook DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, WbSheet, CurrentProject.Path & "\" & WbName, True Now...

I have several buttons on a ribbon like switchboard form that will open forms below. The forms open one on top of another just below the switchboard form. When a user selects a form to open, it is in focus and the corresponding button on the switchboard form changes color to the form that is...