Recent content by johndohnal

Hi All, Does anyone have any code for the "Forgot Password?" button on a login screen? I want an email notification sent to me if someone has forgotten their password, and/or automatically reset their password to a default value based on their user name. Any help will be greatly appreciated...

Hi All, Can someone please tell me how to find the version number in Access 2013? Thank you! John

Worked like a charm! Thank you so much! John

How do you set the focus on the first field in a modal form when it opens?

Currently, column 0 is set to Material ID number and a width of 0. Column 1 is set to Material Name with a length >0. The ID number is the key field and the Material name is what appears in the field after selection. I tried setting column 0 width to >0, but then a number appears in the field...

Hi All, I have a form with a combobox to select a combination of material, manufacturer, supplier, and packaging method. Each combination has its own material ID number. The combobox displays the name of the material, and there are several other boxes which display the manufacturer, supplier...

I have a query which selects a material ID and material name from one table and the associated manufacturer, supplier, and packaging type from three other tables. Some of the manufacturer, supplier, and packaging data were imported from an Excel spreadsheet and did not have data for those...

Subject = DLookUp("MaterialSupply","tblMaterialSpecifications","MaterialSupplyID=" & [tblReceipt].[MaterialSupplyID]) & " is ready for QA" It looks the same to me, but it only grabs the first MaterialSupplyID. Since this is a Data Macro, it has to run from a table. I tried creating a named...

Yes, I have a table and a form for releases. When material is received, the receipt table and form are used. When the material is inspected, the release table and form are used. The release table is linked to the receipt table by the receiptID field. I wanted to run a query which would find...

Sorry David, I spoke too soon. This only sends the MaterialSupply from the first record, not the record which was just updated. Any suggestions?

Hi David, This worked perfectly! Thanks for your help! John D

Hi David, Please forgive my ignorance, but it may be a little more complicated than that. I have a Receipt table and the query is based on that table. However, I need the Release form to find the records in the Receipt table, but save the linking field (ReceiptID) along with other information...

Sorry David R, I spoke too soon. I entered the code you provided, but now I get asked for the parameters for Reconciled, ReceiptConditionSat, and QSUNotified. If I enter the parameters, the Release form opens, but is blank. I tried changing the true/false conditions to -1 and 0, but it still...

Thanks David R! I'll give it a try. Best, John D

Thanks David R! I'll try it, but it intuitively looks like just what I needed. Best, John D