Search results for query: *

Thanks bud! I wish I had seen this earlier.... I ended up putting this in a module, so far it seems to be doing ok. Dim db As DAO.Database Dim recIn As DAO.Recordset Dim recIn2 As DAO.Recordset Dim recIn3 As DAO.Recordset Dim v_filepath As String Dim strLastField1 As String Dim...

Hi.. does anyone see anything obvious here? I am trying to write a unique random number that ends with the date, so it just goes down the item code column of a table . The one problem, it writes just one code for the first record in the table and then stops. INSERT INTO [tablename] (...

Sorry.. I shouldn't of said filter, I am trying to sort each column in true descending order.

Gentlemen, Good afternoon. I just upgraded to 2010 Access although this is more of a question for access in general. I am trying to filter columns in a table in descending order independent of each other. For example: Column A Column B 100 95 90 80 80...

Hey guys.. I am trying to create item codes for products. These products will be uploaded to a website and since their are so many products I need a way to create random item codes that will never be duplicated. What better way than to use Replication ID for the product code field. Problem is...

PH, this is why I came here to ask.. great idea. A simple search and I found CREATE TABLE "table_name" ("column 1" "data_type_for_column_1", "column 2" "data_type_for_column_2", ... ) I could simply copy and paste the table into a table and use a SQL statement to write the SQL! Ha! Looks...

Maj basically I have a list in an excel sheet that looks like TableA TableB TableC and so on.. what I would like to do is take a new db and somehow import so that a table is made for each name in the list (TableA, TableB, etc) As for the table structure, I could manually set that up later...

Hi.. just wondering if there is a way to do this.. I have a list of 100 tables that need to be made, I have a list of each table name in a excel file.. can I have access create a table for each name on this list? or am I trying to automate things a bit to much by trying to do this.

Guys, I am wondering if an easy way to exists this. I need to sort a list of records from a table that we will call Table A based on the the unique sku of the item in that is in the column labled SKU. I have a list of the unique ID's that I need to show and all the other records to be filtered...

I may of posted this in the wrong forum,sorry. What I am trying to do is create an SQL query to replace the [brand] into the product-table from model-table. Feel free to move this if I posted in the wrong section. Sorry for the inconvenience. Chris

I have a table that looks like this... Shall we call this table Product-Table Description Template Show-back-one-section-name Date Added yst-my-parent See the [Brand] [model no] Leather Case page2 1 4/22/2010 [Brand]-[model no] See the [Brand] [model no] Headset and enjoy your music page2...

Maj, Wow!! You are awesome! Thank you.. that worked perfectly and will come in very useful!!!

MajP, Thank you!! You have been way to kind and way to cool... thank you, I totally appreciate it. This is going to sound kind of funny, for the last oh I dont know maybe 7, 8 years I have been using Access to store information and I use SQL somewhat frequently but never VBA. I assume the...

MajP.. Thanks... if I use: UPDATE TableData SET TableData.Contents = Null WHERE (((TableData.Item) In (SELECT TableData.Item FROM Table1 WHERE TableData.Contents Like '*' & [table1].[A] & '*'))); It is still wiping out the entire contents column. What I am trying to do is say lets say I...

I totally appreciate you doing the SQL for that! I noticed that it deletes the entire record though.. is there a way to just have it delete the IDs (which are listed in table1, column A) from the TableData, Contents column. Sort of like a search and delete? I ask this question in general and...

Or to better explain... Table1, Column A contains a list of words that need to be deleted from the contents column in TableData ... I attached a sample copy of the Database...http://www.mediafire.com/?wbztgnmglmm

Guys, I was just looking over how to use the delete and I couldnt figure it out. Lets say all the IDs that need to be deleted are in lets say Table1 , column A and I wish to delete every instance of this ID from TableA, column "contents". What would the SQL look like? Keep in mind more than...

Thanks guys.. I ended up just breaking down the list to smaller ones and it worked. I guess it was just to many keywords (354) which produced the error. This is something I encounter frequently so I will print out this thread and mess around with the different ways. I especially like where...

Thanks for the suggestion. I gave it a shot replacing the like with a = but it still comes back with a error message of the query being to complex.

Hey Guys... I have a bunch of IDs to delete from a table that contains about 5,000 records. These ID's are in a column called contents and I am trying to filter the table to show just the records that have one of these ids in the contents column so that I can delete the ids from the column. I...