Search results

Thanks Minty. Yes, that pic attached was the query put into the query builder. It was editable before migrating to sql server. What I've done for now just in testing is inserted into a local temp table in the front end access app, and it now does not produce an error. I have a lot of work ahead...

Hello AWF, I have just migrated a back end access db to sql server, and have been altering code to include the dbOpenDynaset & dbSeeChanges as I was getting error messages about needing dbSeeChanges when interacting with IDENTITY columns in sql server. The below function is called in a...

Do you just click in the product/productID field and then scan, or do you click a button and then scan? I use: bcode = InputBox("Please scan product") You could then have your if bcode = x then this else that.

Solved this by inserting the group & sum operation into a temp table, and then joining back to the email group (long text field) with the ID when opening the recordset. So I do believe it was the SQL functions mentioned in post #2 & #4. Thanks! I didn't find too much on the VBA truncating but...

That is very helpful! thanks. I will see if I can use a subquery to eliminate the group by, because I do have a sum operation requiring the group by.

I have a table with 2 columns - email_group_id(integer) and email_group(long text), where email is a string of emails. I have a saved query that selects from the table, and I open a recordset in VBA with the saved query, and assign a variable "Em" (dim as string) with the email field. When...

Looks like I did have null values in [dt_str] that I missed.. I modified the query to include where [dt_str] is not null and now it works as intended. Thanks!

I have 2 subforms that both have a date between query, but one of them throws the "expression is typed incorrectly, or it is too complex to be evaluated" error. If i remove the where clause, then the query runs fine. I've tried adding the parameters statement as I see that solves it for some...

Understood. Thanks for the help! (y)

so would you use "if not rs.eof then"? Thanks!

Would a "If rs.RecordCount > 0 Then" after the set rs take care of this?

Never mind... I see what was happening. the .recipients.Add strEmail was adding them to the .to and then outMail.BCC is being set with bccEmails

Hello, I hope this post is in the right place. The code below is populating the bcc and to fields in my outlook message. Is it possible to only populate the bcc and leave the to field blank? Or am I approaching this wrong and should loop through and send an individual email to each email from...

Hello, Thanks for the welcome! I am using a continuous form. Yes some monitors are set up at different resolutions than others. I tried resizing the fields to fix the issue, as the form only takes up 1/2 of the screen width, but the field still resized to display "######". I'll do some more...

Hello, I'm trying to find how to set a width to a field on a form. On some computers the field shrinks so much that "#####" is all that displays instead of the value. Is there a way to set a fixed width that won't resize, or a way to autosize so that all characters are visible? Thanks