Recent content by vbJupiter

Thank you Gemma. I'm glad I have this figured out now. I can't believeI've been able to get along without this knowledge so far Woe is me for all the time I've wasted troubleshooting in the dark! It's cool how you can view the locals window in addition to the immediate window as well. I...

How do you do an Access/VBE split screen? I want to be able to watch the code execute as I enter data into the form. I have redesigned a database, essentially building a new one from scratch. I have all of the forms created and they are working beautifully. :) Now, I'm error-handling to...

I would think that it has something to do with the date because both the parameter query and the orderby form property both involve the date. As to why user is asked twice...I think what's happening is the Orderby property of the form load event causes the parameter to be reevaluated. So...

I would think that it has something to do with the date because both the parameter query and the orderby form property both involve the date. As to why user is asked twice...I think what's happening is the Orderby property of the form load event causes the parameter to be reevaluated. So...

Is "SQL_table" the same as Data_Scrub_SQL??? If so, I would suggest the following modification: (the text box that user types the error message into is referred to as txtErrorNumber) Private Sub YourCommandButton_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As...

I think this link might help you: http://www.tek-tips.com/faqs.cfm?fid=1964

My apologies, Bodi. I am in such a hurry today, I'm embarrassed I didn't catch that... Would you mind showing me the sql syntax using the In command when comparing to a string? You said to remove the quotes surrounding the In clause, but I can't seem to get it to work.

Hi Buddha, I tested this to see if it would work and it just pulls up an empty recordset. I think that for the In command to work, I would need to have the array include the "" for each batch number in addition to the commas I am already adding. Let's say the Query is evaluating record...

I'm editing this post. At first I thought this query wouldn't work for me because the MAX would return just one record. Now that I'm looking at it again, the insert into query would give each batch number the same LastAdd value, so the MAX function should pull up all the records in the batch...

Thanks pdx man. I really appreciate your response. I was able to get the query working to display the recently added records. I think my problem was that I was working too quickly and wasn't being thorough enough. I simply moved the docmd.openquery line to the main form code module and it...

My apologies. I should have added more notes. :( Yes, my end goal is to retrieve the records newly entered to the AssignedBatches table. Yes, this is correct. Yes, this is correct. bad idea i'm assuming. i originally had it in the assignbatch subroutine, but moved it to the function when...

Yes I am actually looking for an exact match... Public Function GetBatchNumbers() As String Dim rs As DAO.Recordset Dim qdf As DAO.QueryDef Dim strBatchNumbers() As String Dim strSQL As String Dim strCriteria As String Dim strBatchNoList As String Dim intCount As Integer Dim intCounter As...

I have a public function in a standard module that adds records to a table. The function returns a comma-delimited list of the batch numbers that it added to the table including leading and trailing commas. I am trying to run a query using the list to select just those records that are in...

This makes sense. I've got the function in a module and it is working. The public function getbatchnumbers is what gives me the batch number array. They aren't two seperate procedures. So, I can't do the following suggestion: See, if I convert it to a boolean function, I lose the actual...

The MasterBatch table contains thousands of different batch numbers. There are 16 criteria rules as to what batch number gets assigned depending upon what type of functionality is needed. I use case statements within the function to return the correct batch number(s) associated with the type...