Search results

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

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

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

I would like to send an email notification "On Insert" when a new record is entered. In the Body of the email, I'd like to include an "Item Name" that is associated with the record. The table I'm using has an "ItemID" field, which is numeric. This is easy enough to include as it comes from...

I have a query that selects records based on certain flags in each record. I can view the record in datasheet view, but I need to be able to edit the records selected by the query using another form. Is there any way to automate this process? Thanks, John

I have two option groups on a form. When I make a choice on the first option group, I'd like the second option group to change automatically using a macro. This is primarily for the user to see, as I know that changing the value of the second option group in the record would be easy with code...

I would like to use concatenation of a form field with a string to be used as the Field and part of the Update To expressions of an update query. I can enter the Field name and the Update To manually, but I want them to be able to change when the drop-down selections in my form change. For...

Hi All, I have a material specifications database. I have a dropdown to select Manufacturer and a dropdown to select the Supplier. The one for the Supplier works fine and I can select a different Supplier when editing. However, the one for the Manufacturer will cause all entries for the...

Hi All, I posted earlier today and have found out more information. When I have one attachment field in my table, query, and form, I am able to add an attachment from the form without any problems. However, when I add a second attachment field, I lose the ability to add attachments to either...

Hi All, I have a product form on which I would like to show a picture of each product for each record. I have an attachment field in the table, and have placed an attachment type field on my form. The form draws from a query, and I've pointed the attachment field in my form to the attachment...

Hello Everyone, I have a database with a Supply Receipt Form. The first field in the form is a combobox for the user to select a material/supply. I'd like for the form to open to a new record every time. When I use: DoCmd.GoToRecord , , acNewRec in the Form On Open property, I lose the...

Hi Everyone, I'm constructing a database that will include a simple inventory management system. I have manufacturer and supplier tables with basic company information, and a packaging table that has units, quantites, etc. Next, I have a material specifications table that lists supplier...