Search results for query: *

I want my form to look up a columns value and if the column is empty insert a character(example: "n"). I've tried to alter the table with a sql statement but that doesn't seem to be working. I know this should be fairly simple but I'm not having any luck. Thanks so much

I have the following code that sorts the table in ascending order by MakeName, ModelName, and VIN rst.Open "Select * From " & tnm & " Order By MakeName, ModelName, VIN", CurrentProject.Connection, adOpenStatic, adCmdText 'tnm is my table name I want to now add two more...

I've added the following code to one of my access forms: Dim tnm As String 'Get the table name tnm = [Forms]![Form1]!Text0.Value If Not CurrentDb(tnm) Then MsgBox "This table already exists in the Database." DoCmd.RunSQL "DELETE * FROM " &...

I have a form that is creating a table and I want to check and make sure the table name that is entered into [Form]![Form1]![Text0] is in the database. If the table already exists I want to delete it because otherwise the new data that I am importing gets added to the current table. So basically...

When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...

When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...

When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...

When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...

OK, here's the code that I am trying to use: Dim strSQL as String Dim tnm as String 'Get the table name that I am creating in a form tnm = Text0.Value 'I am adding another column to my trm table that is generated from my Makes table. strSQL = "UPDATE " & tnm & " INNER JOIN...

Does anyone know if there is a function that can List all the Tables you have in one Database?

Does anyone know how to use the DLookup in a Macro? according to the help it can be done, but I'm not sure where you can enter it.

I am trying to merge two table together. The first one [Forms]![Form1]![Text0] is being created in a form by importing a text file and converting it to the table format I've already designed. However in one of the columns contain abbreviated values, so I created another table manually that...

I have been trying to get two tables to be able to link and replace information. One of my tables just consists of two columns - one with an abbreviation and the second with the abbreviation all spelled out. I have another table that has several records and one column in the table contains these...

I am doing a lot with an imported text file so I will start by explaining what I will be doing. I am having a user start by creating a table by entering information into a form. In my form they enter the name of the table and the name of the file to import. Click a button that converts the text...

I'm getting a unique character when I import my text file. Here it is:  If I want to create a SQL statement to automatically remove these records that contain  in one of the fields, how would I do that? I would be putting the SQL statement in a form that gets executed when the button is...

I want to automate the process for someone to convert text file to an access file where the table is automatically created with the proper headings and widths. I've created a macro that used import text, fixed widths, if the file and table name are entered in the macro it works fine. However, I...

I am new to Access and I would like it if someone could tell me how to create a macro, so that my table will build the columns based on the position. Thanks so much. Chris

My question is almost identical to one posted earlier. Here is the message posted in December the only change is that i wanting to import my text file in ACCESS not excel. Can someone tell me an easy way to do this. Thank you StephDN (MIS) Dec 31, 2002 Hi! I'm trying to import a rather...