Search results

@nirmal: I agree with Pat that using unbound forms is usually unnecessary. And I believe yours is not unbound otherwise your Docmd.OpenForm statement in your very first post would not work (you cannot open a form filtered using the Where clause of the OpenForm method unless the form is bound)...

Cross-posted with solution here: https://www.accessforums.net/showthread.php?t=88151 Cheers,

I do 😁!

Maybe try ActiveExplorer (I tried it just before .Display): OutApp.ActiveExplorer.WindowState = 0 'olMaximized OutMail.Display 'Send | Display The original function uses late binding so no reference to Outlook is necessary, but you need to use the actual value (0) of the olMaximized...

Missing AND in the criteria clause of the dCount between the two fields).

Use a dCount or dLookup in the source table to check if you already have an entry. Cheers,

I'd use RecordsetClone as suggested and also add .Form after Me.Parent. Another option would be to use Docmd.FindRecord: Me.Parent.Form.Controls("ID").SetFocus DoCmd.FindRecord Me.ID Cheers,

I assume you do not save the files as attachments inside your database (in an attachment type field), but actually store the name and path as text in a short text field. If this is true then it should be a very easy job to do what you mention, look at the Name statement to rename the file and...

You can use the row index to loop through the columns: Dim i as Integer For i = 0 To Combo1793.ListCount - 1 CurrentDb.Execute "INSERT INTO tblYourTable (Qty,Type,Name) VALUES ("'" & Me.[Combo1793].Column(0,i) & _ "','" & Me.[Combo1793].Column(1,i) & "','" &...

@mhorner: what ebs17 suggested is what is in the my final paragraph, the tricky part comes if multiple users are trying to create new certificates as the DMax (for the newly created certificate) could belong to a different certificate creates by somebody else. You could use a CreatedBy field in...

You can use "placeholders" in your default body (I usually use pipe-delimited ones as it is a fairly uncommon character) then use nested Replace() functions to insert the actual values from your form...

Many ways to do this, but I would simply have a field in tblModels to use as a flag, could be a yes\no, a date field with a timestamp, a numeric (long) to hold the original ID. You populate it when you add the batch of records attached to the original certificate, then you run a update query...

The comment at the end is not accurate, as it simply displays the newly created PDF in the default application set to open PDFs (which seems to be Edge; Docmd.OutputTo method has nothing to do with emailing, the email is being displayed by the .Display line): DoCmd.OutputTo acOutputReport...

To add to the great ideas and support from the previous posts here is a link to a free utility that would allow you to build a custom Access-based chat system into your application. http://forestbyte.com/ms-access-utilities/fba-ms-access-custom-chat/ Cheers,

If you requery before the Delete happens you will always delete whatever is the first record, not the current one you actually want to delete.... So maybe it is better that it didn't work for you yet. In post #4 Larry asked you if you can delete directly from the form's record source? Is it a...

It should, give it a try :)!

As already suggested by the_Doc_Man using the Name statement would probably be the easiest as it does all actions in one step(create new\copy\remove old): https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/name-statement Cheers,

Try to replace Me.Refresh with Me.Dirty=False to force a save of the record. Cheers,

Having the listbox filtered in some way might help with that, either by a date range and\or complaint category, etc. The textbox method would probably involve the user to manually compile a list of numbers either on paper or another app then maybe paste it in. But the logic would be the same...

Replace the textbox with a multiselect listbox to select the multiple complaints (allows you to show additional data such as complaint date or category) then loop through the selected items and run a Update statement for each selected item. If you want to keep your textbox use Split() to get the...