Search results

If anyone has issues with this ever, please review the following code. Set rs1 = New ADODB.Recordset rs1.Open _ "Select GROUP_NBR, AOR_SYS_ASSGN_NBR, WA_SYS_ASSGN_NBR " _ & "FROM tblInput;", _ ActiveConnection:=CurrentProject.Connection If rs1.EOF = False...

Hey guys, I have create a recordset based upon a table. The table holds group numbers of where the SQL statement is basing its criteria on. However, when I put multiple groups in, it will cycle through to match the number of records but it will not move to the next group number. Any...

@pbadly I would have utilized the basic query design but the criteria is based upon a subfrm table. This will allow a user to enter multiple numbers.

Hey Everyone, I am just stumped with this SQL statement that I wrote :banghead:. I'm getting the basic syntax error on the FROM portion of the SQL statement. Run-time error of 3135, Syntax error in JOIN operation. I thought I had joined everything properly but guess not. What I'm trying to...

@mdlueck Thanks for the quick reply, I will have to test this out.

Hey Everyone, :eek: Looking for some guidance on an issue I'm having in regards to a Linked ODBC table. I have linked the ODBC table and am looking to refresh the connection upon open of the database. I'm hoping to have this pop up as soon as it opens so the user will not have to log in at a...

@jzwp22, @Galaxiom Thanks for the quick reply. I looked into it a little more thoroughly and did each section at a time and was able to get the code to work. The code is below: strSQL = "INSERT INTO tblGroupRenewal ( PLATFORM_CD, BLK_BUS_CD, GRP_NBR, MSTR_RPT_NBR, GRP_RESET_DT, GRP_TERM_DT ) "...

Hello Everyone, I am having an issue with getting a parameter query to work in VBA code. I have the Between (Date) And (Date) to work but cannot get the >= (Date) to work. The date is based on table fields they enter in at night. I do not use a form since a form does not save dates entered...

You are the man jdraw haha. Thanks that worked really well.

I'm trying to open various databases up based upon current year for a link table process. So If Current Date equals 2012 Then open database for 2012. My process works if I'm not specifying a year but I need to automate it so I'm not updating the code every year. I just had a thought, am I...

Hello, I'm stuck on I would think a fairly simple compare. I'm trying to create an If Then statement that will compare a date. I was hoping that this would work... Dim strFileDate as string Dim strFileDate2 as string strFileDate = Format(Date, "YYYYMMDD") strFileDate2 = Format(Date...

If anyone ever runs into this issue, here is my thought process of how I solved my issue. I created a set of If Then Else statements. Below is an example set of code. 'Creates the current date placed on table that is being transferred strTableDate = Format(Date, "YYYYMMDD") 'This command...

Hi Everyone, I'm working on a automation process that will be pulling a csv file, placing the data into a table with the current date. I want to export the table into another database, but how do I do that since the date will always be changing? The coding below shows the import csv file and...

Thanks for all the input!

@GregRun I had originally created a sql statement with the Select * From MASS_TEMP_INPUT but I didnt think you could create a Where when you do a Select *. Also I don't want to just pull one record for viewing, I hope to pull one record through a upload process than movenext to second record.

@pbaldy Do I place that in the original Select statement?

Thanks for all the suggestions, I tried this set of SQL statement and it looks like it works. It looked like it was getting confused with my original "FROM MASS_TEMP_INPUT;", _ . So I just placed the FROM MASS_TEMP_INPUT into my original SELECT statement and it appears to work. If...

Yes, I have the characters in there, but I guess the VB environment doesn't like the characters within the SQL statement. I'm getting a Compile Error Expected: end of statement. So my question is really whether or not there are any other ways I could do a continuation.

I am trying to write a query with a large amount of fields and need it to write on multiple lines. Any suggestions? rsRecordset.Open _ Source:="Select MASS_TEMP_INPUT.LIC_ACTION_CD, MASS_TEMP_INPUT.[LIC-ID], MASS_TEMP_INPUT.[LIC-SYS-ASSGN-NBR], MASS_TEMP_INPUT.[LIC-ST-CS]...

Hello, I have currently taken over a large upload process developed by the previous DB developer and am still learning the ADVANCED aspects of coding. I am trying to pull data from a Mass Input table and cycle each record one at a time through a set of coding to string the fields together...