Search results

The SCHDQTY field / text box is just a result from the query, a regular field with no calculations on it. Is that what you are asking?

I have a report created where the page uses a query as the back end, all works well. I need to add a text box with the summed up values; however, I keep getting the #error for the result of my sum function. I am trying to Sum up one field called SCHDQTY. On the textbox I am trying to put the...

Awesome, thanks :) I generally just put a msgbox("test") and move it around my code to see where it breaks :) Everything is up and runnign smoothly. Thanks for your help!

Ok, I ahve everything working perfectly so far. I'll start to play around with how to grab the order number variable, I'll have to look at the application a bit more. But, in the code posted I have a couple lines commented out. One quick question. Can I make the email HTML based anyhow? I...

Ok, i got past the error, and initial testing returns no error, but no email either. I will see if the data I am using is bad and get back. To fix my error, I had to add this to the end of the query code: , dbOpenSnapshot, dbSeeChanges)

The same error messages happen when I changed the code to what you suggested.

Ok, having a few issues so far. Here is the entire code for the button: Private Sub CreateOrderFromTK850EditTable_OrderDetail_Click() On Error GoTo Err_CreateOrderFromTK850EditTable_OrderDetail_Click Dim stDocName As String 'stDocName = "CreateOrderFromTK850EditTable-OrderDetail"...

Thanks a ton Trevor! From a quick scan of what you posted, that looks to be identical to what I need. I will work on this today and post back with any questions I may have.

I know how to do it, I know the pseudocode, I do not know the vba syntax. That is what I need help with.

I explained one portion incorrectly. For every line that is tagged as high alert, an email will need to go out containting informaiton about that line. A seperate email for each line. So, I think I need a programatic approach to run the results in a loop, and then send an email for each line...

I need to send an email based upon query results via vba or macro. Here is the steps taken: 1) user clicks a button 2) I need a query ran with the following syntax: select HighAlert from Orders where (order = 123456) 3) I need to cycle through those results (seperate order lines) and if...

Its easy stuff, just running into an error using my .fmt file for the bulk insert...I'll get it figured out :)

Thanks for your help...the truncate helped. now, its time to tackle the import into sql with a fixed width .txt file

I definately think the truncate will help immensly...so, I have to make it a stored procedure in sql to run it in access then, correct? Access doesnt' recognzie that function, correct? If so, then i create the stored procedure, and then call it in my query using the info you just recently gave...

I will try the truncate in my stored procedure; however, I still haven't had my question answered on how to run as stored procedure from Access...be it in VB, macro itself, or a query. Big deal if I didn't know what truncate was, i probably did, I just never use it. Creating queries in and...

I'm not sure what a truncate is? I do know, however, that running the delete in query analyzer is extremely fast compared to the access query, so I am thinking the stored procedure would be fast also. I know it can be done as I have done it before, but I have absolutely no idea on what...

How do I run an sql stored procedure in a microsoft access query? I am looking to do this because I have a macro that deletes a table and then appends it; however, since I moved the table to sql, the delete takes a very, very long time, and I think running a stored procedure on the server side...

That works great, thanks!

I have a form that when a button is pressed, I wish to call a query, and, if there are any results in the query, then display the results either via pop-up or just open the query results itself (which may be easier). So, here is sort of what I need done: if this query has results: SELECT...

that seems to have fixed my issue, thanks!