Recent content by jco23

thanks for your replies, @RonPaii !!! I appreciate it, you gave me some ideas on how to eventually get to my desired results. I think I got it using this: Assignee_Num: (((1+DCount("*","[mytable]","[field1]< " & [mytable].[field1])+DCount("*","[mytable]","[field1] = " & [mytable].[field1] & "...

i see that working in the immediate window, but when I add it as a field to a query, I just get all zeros. when I add this line, "CountUpRepeating (DMax("[order]", "[qry_assignees]")) and then add the command to open the query with the countuprepeating(null) as a field, I get all ones.

yes, I'm good pushing the results to a temp table. I've tried the random number, but I want to ensure that they there are evenly distributed as possible.

How can I add a field to an existing query to include a sequential list of numbers (e.g. 1, 2, 3, 4) repeating? for example, I want to add an "Assignment" column. This column corresponds with another query where we have four people assigned one of these four numbers (some days the list may be...

sorry about that, i'll do that next time.

I got it to work by using delete and append queries to a local table, and then bringing in that table: Private Sub Command57_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim sHTML As String Dim strQuery As String Dim msgbody As String DoCmd.SetWarnings...

i also tried using the results from a table, and when the table gets created, it looks fine. however, when i attempt to embed the table into an e-mail, I get the same problem. thus, I suspect something is awry with one of these two lines: Set f = fs.OpenTextFile("QueryResults.html", ForReading)...

sorry, I thought the output would be the same as opening the HTML as a text.... how do I that then?

when add this line: DoCmd.OutputTo acOutputQuery, "MyQuery", acFormatRTF, "C:\Users\" & Adent & "\Desktop\QueryResults.rtf", the file saved looks fine. basically, the same as above but without the file path

i appear to be a roadblock here, where my VBA code is producing some weird results. essentially, everything works perfectly fine except that the first field in the row of the query results in the e-mail contains additional text. that text has the ending string of the path where the app resides...

this appears to have worked for me. I'm going to have others test it today. thanks again for the suggestion!

i appreciate the effort, but my company prohibits us from uploading any content.

i'll see if that is feasible. thanks for the quick responses and extended effort!

it's possible, but I don't recall. still doesn't make sense why it would apply to one form and not another.

the only "save" codes pertain to the records, not the forms. but just closing the form does not contain any events.