Search results

The attached code was written to enable a database form with multiple attached pdfs to be emailed from the command-click button on the form. Since some machines have been upgraded to the latest versions of Windows 10 and Office 16, I get different errors, such as "User-defined Type not defined"...

I have a form with checkboxes, indicating fields which can be selected for a query. The strSQL variable works fine, and I can use QUERYDEF to create a query from the variable. I wonder if it is possible to generate a form to display only the fields chosen - i.e. I don't want a general form...

I have an SQL statement which is dynamically built on a form. It can be truncated to read [Colour] = 'Blue' or it can be left as a complete statement - SELECT * from tblOrders WHERE [Colour] = 'Blue' The statements work when I open a form. Is there a simple way to open a report (or query) with...

Hi I have a subroutine that successfully builds a SQL statement "strSQL", which is a public variable. Using msgbox, I can read that the value is correct - SELECT * from tblIncidents WHERE [Nature] = 'Hover'; (The select statement may be complex, e.g. [Nature] = 'hover' AND [COLOUR]=...

I would like to have 5 combo boxes from which users can choose fields to search, e.g. cbo1 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE cbo2 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE cbo3 - choose YEAR, TYPE, LOCATION, COST, COLOUR, SIZE cbo4 - choose YEAR, TYPE, LOCATION, COST...

I would like to be able to add more than one scanned document and link them to one record. If it is possible, I would like to have a command something like "Attach file" on the form displaying the record. The user could browse to find the scanned document and it becomes a link. The user could...

I have a form linked to table tblINCIDENTS When I create a new incident, I select DATE_LOGGED in a text box. This updates the field in tblINCIDENTS. I would like to show on the form (and store in the table), e.g. "Record 5 in Year 2013" I already had the new record number as an...

Hi - I have a form which accepts a start and end date in 2 unbound textboxes. A 3rd textbox allows the user to select the status of te incident. On clicking a command button, I can open a subform which displays each matching record: Dim strWhere As String Dim ststatus As String ststatus =...

Re: send email from access Thanks for getting me started on emailing from a form. My problem is, I have a form called frmINCIDENTS, with a text box (txtemail) which holds the email address to be sent. It sends the information correctly to outlook, but when I click SEND, on returning to Access I...

Hi - this sounds like it should be simple but I can't make it work: I have 2 tables, joined in a query to populate a form. TblPOI has Userid, POINAME, EMAIL (e.g. JMS, John, myemailaddress) tblINCIDENTS has among other fields POI, IC (POI links to UserID). I want IC to update to POINAME when I...

Hi - excited at finding forum help.