Search results for query: *

Thank You all for your help and assistance. The last code worked fine, I do need the last name field as I have hundred of customers with names like Adams and Smith etc. I hope I can figure out how to do that myself. Thanks Remou and Thanks Aceman1 for the link. ThunderGeek

The select statement works well as far as pulling out the records. "SELECT [Customers Alphabetized].[Last Name], " & "[Customers Alphabetized].[First Name], [Customers Alphabetized].[State/Province], " & "[Customers Alphabetized].[Customer ID] FROM [Customers Alphabetized] [Customers...

I am not very good with code, my lookup uses a select statement to select data for the combo box and a macro to find the record on the form, the select statement is as such: SELECT [Customers Alphabetized].[Last Name], [Customers Alphabetized].[First Name], [Customers...

I have a question about a combobox in Access 2002. My customer database is over 70,000 records, I have a combo/lookup box that looks up customers by last name on a form. My lookup is now not working properly and will not scroll past the alphabet letter W, nor will it look any customer up that...

Thanks - I totally missed that simple solution. ThunderGeek

I modified the code just a bit, added the FileName = line. Public Sub XferToFile(FileName As String) Dim FileSpec As String FileName = Forms!supplier!SupplierBox & ".txt" FileSpec = "C:\SHOPSITE\products\New Folder\" & FileName DoCmd.TransferText acExportDelim, _...

I have a form with command button to export a text file with this code attached to the onclick, the code blelow works well: DoCmd.TransferText acExportDelim, "ProductsNewExportSpecification", "ProductsNew", "C:\SHOPSITE\products\New Folder\newproducts.txt", True, "" However I would like to...

TheAceMan1 That fixed the problem Thank You Very Much! ThunderG

I have a subform (access 2000), XP SP2 computer with two fields one named [Qty] and another named [Onhand]. A macro runs to prevent a uses from entering a quantity [qty] larger than the [Onhand] value. The macro is fired on the beforeupdate event, the conditions column is [QTY]>[ONHAND] and if...

InstrRev function - that works! Here is the solution- (string is a field from my table) My query fields are: String: string Count: Len([string] Comma: InStr([string],",") ToComma: InStrRev([string],",",-1) remove to comma: Left([string],[tocomma]) "Remove to comma" gives me the result I need...

I think I wrote the question wrong. If the string is - "This is my string, it has two commas, and a number 1234." I need the result to include this fragment from the left side of the string - "This is my string, it has two commas," The last comma - ", and a number 1234" will always exist as...

I am writing an Access 2003 query and having trouble parsing a string. Example of the string - This is my string, it has two commas, and a number 1234. - I need to remove the string section from the left side, up to but not including the comma. Here is what I am using in my query, string is the...

Works great! Thank you for the quick response. TG

Greetings I am having a problem putting this HTML code fragment as a default in an Access 2000 form text field; "><meta name="robots" content="index,follow"><meta http-equiv="content-type" content="text/html;charset=iso-8859-1 Access keeps popping a message box stating "The expression you...

PHV I just looked at your post again and realized that you were pointing out where my mistake was, not actually posting how to correct it. I had just copied and pasted the lines over my original lines. Sorry for not seeing the obvious. How do I change that portion of the code to un-mix the DAO...

Greetings Thanks for the fast response but its still poppping an error. It locks up at this point: rs![Order ID] = ParsedRecord(x + 1) Thanks again for the respose TG

Greetings, I am trying to create a loop that fills a table ([orders detailkpi]) from a text file(C:\shopsite\ORDERS\1OrderDetails.txt). The loop section isn’t working very well. I keep getting a runtime error 3421. I probably have wrote something incorrectly and can not see the forest for the...

Golom Works Great! Many Thanks TG

Greetings Here is the problem: I am using an update query to update a UPS shipping table,from my shipping database I have a field called [Ship CSV] within this field is combines 1.the customers Name, 2. State, and 3. Zip code. The format is as such: OAK LAWN, IL 60453 The City is seperated...

Great :) Thank you for the help TG