Search results

Hello I need help,I have a table in which one field is populated with numbers , I want to truncate this filed to 5 digits( some numbers are less than 5 and some are more). for this field, I want to put a condition if it is greater than 5 digits, delete the rest of the characters( I mean if it is...

Thank you, I added error handling but still doesn't delete the table !!! I have 3 tables to be deleted ..with a specific name .. If (Not IsNull(DLookup("Name", "MSysObjects", "Name=JIC Global"))) Then DoCmd.DeleteObject acTable, "JIC Global" On Error GoTo ErrorHandler ErrorHandler...

Hello I have the below code to delete a table if it exists, but it doesn't work could you help me where is the issue? If Not IsNull(DLookup("Name", "MSysObjects", "Name='JIC Global'")) Then DoCmd.DeleteObject acTable, "JIC Global" Thank you

Hello I really need a help I have a table in access in which two fields are date/time datatype .when I change it to shortime to append to a oracle table( two fields type are VARCHAR2(5byte) ,it doesn't let them in . ex: from Access ( 4:30:20) Am doesn't get in ...because should be...

I have linked Oracle table to my Access database .I found that there is a field in Oracle which is primary key and autonumber ( unique) and Not to be null. the key violation error refers to his field .how can add my records through Access to this oracle table without error .? can you give me a...

Hello I really need help I have a table in Access and a table in Oracle, I want to append the Access table to the oracle table. I face the Key violation .... error message and doesn't work. I have checked all fields data types in each field .but doesn't work. both tables have the same...

Hello, I want to change the data type of a field from double to decimal . This SQL code ALTER TABLE **tablename** ALTER COLUMN [**myfield**] DECIMAL(6,2) says syntax error and doesn't let me save it. Does anyone have a suggestion about how to change it?

Thanks ,If the same procedure is for another table, can I add the second one to the form as well?

Hello I have a table with two fields,I want to put two ted boxes to be filled and a button to add them to my table? Could someone help me with how to do that? Thank you

Yes it worked. Thanks a lot

How do I assign the textbox to each table?I am not sure I got your idea .could you show me with a sample ?

Hello I have a Database with 4 tables . How can I show the number of the records on the Main form? When I create put "=Count([table1]! [primayKey1]) " for one table works .but when I add other tables it shows #Error for all even the first one ? How can I show all tables total records on...

Thanks but how do you copy data from the first database to the second one? with your code seems we can open the second one and create a table and add fields, and now how copy data? and change the second table with the current date on it????

I did but it doesn't accept ?? Now I am getting a "Type Mismatch "error code. Actually , I want to create a table and change its name with the current date. Function CopyTable() Dim objAccess As Access.Application Set objAccess = New Access.Application 'open the destination access database...

the problem is in the name of the destination table in the second table.I need to add the year and month in the name of the new table.

Hello I am Looking for Access VBA code to create a table from one database X to another database Y which includes the date in name of the new table,.thank you Function TransferTable() Dim objAccess As Access.Application Set objAccess = New Access.Application 'open the destination access...

Hello, I have this code which imports a *.txt file into a table.how can I say change the table to the name of the text file not a fixed name? Private Sub ImportData_Click() ImportCompleted = Empty Dim path As String path = FilePathText.Value & "" Dim tblName As String...

Hi I am trying to import an Excel sheet to access table and i find the comments section being truncated.I changed the data type in table to long text ( Rich text) .but it truncates less than 255 char. can you help me a vba cod to update this field in the table from linked excel. or a query to...