Search results

I have a form named "frmOpenOrders". On this form is a field named "txtOrder_Qty". I am trying to write code for an afterupdate event of this field to do one of two thing: Scenario 1: If values DO NOT exist in ANY of 5 fields in a totally separate table named "tblPartsMasters", then I want a...

This is going to get complicated I'm sure. But here goes. I have a table named tblPrices. I have another table named tblPartsMasters. Both of these tables have a field named "Part_No" which is the index field in both tables. Then I also have a form named frmPartsMasters which is bound to...

I'd like to add a command button to my form which contains a listbox. When clicked I'd like all records to be selected. How can I do this?

Didn't work... I get an error that says "Enter parameter value : Type". Here's my code... Private Sub Command27_Click() On Error GoTo Err_Command27_Click strSQL = "Type = '" For Each varItem In List34.ItemsSelected strSQL = strSQL & List34.ItemData(varItem) & "' OR Type = '" Next...

I have a form which contains a listbox. It is a multi-select listbox. And I have a button on the form which runs a report. But I want the report to only show the selected records from the listbox. The report gets its records from an underlying query. But how do I make the selected records...

I have a report which has a calculated field on it and want to sort the records in descending order based on this calculated field. How can I do this? --Steve

I have one more question... once the image have appeared on the form, how do I make them print on a report? I can't seem to make it work. --Steve

Sorry I missed that. Excellent. Thank you so much for the help!

Incredible! Now, one more thing... what if I want select an image that has been loaded and when I click on it, have it enlarge on the screen? Can this be done?

The way the form is to work is this... 1) The user selects a record from the combo box. 2) Depending on the record selected, thefield to the right of the combo box fills with data from the table, tblLots. This information is for the user's reference only. 3) Then also the field right under...

It is single form. Sample d/b attached.

Just checking.. nobody has responded to my question... is there anyone can can offer any suggestions as to how I can go about this project? --Steve

I have a form in Access (2003) which has a combox box. When the user selects a record from the combo box I have another field which populates with a path to a folder on the computer which contains several folders. Each folder is named the same as the record selected in the combo box. But I...

I've built a label in Access 2003 which is bound to a query which may end up with multiple records. For each record in the query I have a calculated field, "LabelQty", to tell me how many labels to print. But I can't figure out how to make the application actually print that many labels. For...

I have a table with user names in it. Also, have a form for a user to enter a "login" name. If the name they enter in the form exists in the user name table, then I want a second particular form to open. How do I do this? --Steve

To ghudson, (or anyone), The SendObject "thing" is working fine now. But a new issue has developed. The attachment I'm sending with the mail message has to be able to be opened on a pc and on a Mac. Snapshot format of course works great if opened on a pc. Any cosmetic horizontal lines...

To ghudson... THANK YOU! Its perfect. I really appreciate all your help. --Steve

New Line - How? I have been able to convert the macro to VBA code. But now I want to be able to make a "new line" happen at a specific point in the text message. But what is happening is this... Dear, recipientsname, vbNewLine & Message here. Its just sticking the "vbNewLine" in the message...

ghudson... Thanks for the reply. I have copy and pasted the name of the form into the on click event and tried what you suggest. But I get the following error... "There was a problem opening the macro 'macroname'. Do you want to continue?" Thoughts? --Steve

But my problem is I really don't know how to code it to make it work.