Recent content by keusch

LOL - that was helpful!

Within the VB code I have built a SQL statement. I need to understand how to use a table field variable inside the VB code for the SQL statement Any where there the field name "carrier_description" appears below, I want to substitute the varible field name. Dim db As Database Dim rec As...

The task at hand is to compare the data in two tables and write the mismatches to a table. There are hundreds of fields and millions of records. The process is currently opening the the "master table" and capture each field names (SelectedField) when plug the SelectedField name into the SQL...

The issue: would like to populate specific data in Excel directly from Access. Currently, the process is data is transfered from Access to create a new worksheet "B" in the existing spreadsheet containing worksheet "A", run VB code that loops through all the data to match Name in worksheet "A"...

PH, Thank you so much. I'd just saw the amendment posted but had already worked through that process. I was amazed with the instr usage in the SQL but after much thought and many efforts trying figure out why I couldn't use the txtholditem (with many alterations) by itself in the query, I was...

PH, I'll give it a whirl - I see the obvious solution on the concatenation - Thanks - I will be back intouch

The user has several options for selection criteria so the where is a little lenghthy (uneditied version) WHERE (((DATA_WELL.WSN) Is Not Null) AND ((Year([Spud_Date_Proposed])) Is Not Null) AND ((DATA_RIG.Spud_Date_Proposed)>=[Forms]![frm_geo_spud_date_year]![txtStartDate] And...

Problem: I need to export data from Access that is created on the fly. This is to be written to a text file. I can create a file but I need to append successive data to the file as it runs through the loop. Current Code: The data set is generated with select criteria and creates a list...

PH, That did the trick! Thanks

I have code that creates a Relationship from VBA ; however, what I want is to Include ALL records from 'A' and only those records from 'B' where the joined fields are equal. Currently code creates an join where both tables are equal. Can anyone help me??? Dim db As Database, rel As Relation...

Thanks PHV that was far too easy! It proves that I have spent far to much time in the gooey interface and should spend some quality time with SQL. However, I would ask if there is a way to hard code a space at the end of a record? As originally stated (before I altered the shortnames), some of...

Remou, Thank you for your response. I should have been clearer. However, after reading your response, I came up with a couple quick solutions. So thanks! Here is the problem Table A -with a field "shortname" is used in a query with Table B to create a new table. I have Table A shortname...

This is probably very simple but I can'f figure it out. Problem Table A -with a field "shortname" is used as a pass through query with Table B to create a new table. I have shortname entries like Table A GV GVW To make the pass through work properly, I need a hard space at the end of GV and...

Thanks for both your help -- Zion7, could have done without your sarcasm. Anyway, [WELLNAME] was populated, and there were no null values. The problem was that display = true was not part of the criteria. Here is the final code. Private Sub Type_AfterUpdate() Me.Refresh If (DCount("[TYPE]"...

Thanks Pete - but still no luck - Here's an example of the form- When the user enters data for line 3 (if Type = RE or NP), message should generate and does not. WELLNAME Agency Type Status Display Submit AP 33-9-695 ST NP APP -1 7/13/2005 AP 33-9-695 ST SUN APP -1 7/15/2005 AP 33-9-695 ST RE...