Search results

So here is the image you requested. The left outer join is working as you can see below. Here is the issue. For example, let say someone finds a file with the closed number 00-0330 When they add it if it does not exist in the all_matters table it is placed in the notinms table. My issue...

The all_matters table has two fields called “ClosedFile1” and “ClosedFile2” unfortunately the data in these fields is not as standard as it should be so I do a regex pattern match and copy any number pattern “##-####” into a new table with the row ID called Closednumbers The date looks like...

Thank you

Thanks everyone I got it working not sure why but a left outer join works where the not in does not Private Sub all_mattersinsert() Dim db As Database Set db = CurrentDb db.Execute "INSERT INTO all_matters (RowID, Client, Matter, ClientName, MatterDescription, OpenedDate, ClosedDate...

So far it has not errored out. I let it run for 20 minutes. It just shows a spinning circle. I am going to kill it and try removing fields.

I am trying to run an insert into from one table to the second table. For some reason, I think it does not like the "not in". Here is the code. It does not give an error it just spins Currently there are about 40 records it is trying to insert. I also tested with just a select statement and...

So here is what I have so far db.Execute "UPDATE all_matters INNER JOIN all_matters1 ON all_matters.RowID = all_matters1.RowID" & _ " SET all_matters.ClientName = all_matters1.ClientName," & _ " all_matters.Matter = all_matters1.Matter, " & _ " all_matters.MatterDescription =...

Thank you I will test this also, I was searching about hashing this morning and saw some hashing on SQL but was not sure if it was possible in access.

Thank you I will test in the morning and let you know

Thank you so much unfortunately I don't think there is a way to get a field to see if it has changed. So how should I do the update? Should I use a recordset and do while not EOF with a bunch of if loops? Do you have an example to get started? Here is the partial code I had started. Not...

Currently, I have an Excel Sheet that Imports using the DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "all_matters", "R:\Close Files\accessimport.xls", True This excel sheet has 16 columns and about 52,000 Rows. It does have a unique id. There about 10-20 rows are added 5 days...

Sorry if I sounded Rude that was not my intent at all. I am grateful for the help you did provide.

I realized the issue was trying to use a split form. I am trying a continues form with a button to insert into the other table. Thanks for all your help.

Thank you I will try in the morning

I am using the db.TableDefs.Delete and a "DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12," in a button to import excel into the table. Yes it has a unique key RowID is unique. The second table I just created I can change it but right now it has ID, RowID, DestructionAprroval...

I have a table I am importing from an excel file. This table will be deleted and reimported probably weekly/daily. I have created a second table that will have some of the other information. The first table has closed file information such as: AllFiles_Table RowID, Company, Closefilenumber...

Thanks I am getting a runtime error 3075 Missing),], or Item in query expresion '[User] Like "ABC*" And ([ProposedDestructionD <Date()'. I changed your code to this and it started working Me.Filter = "[User] Like " & Chr(34) & Me.CMBUser & "*" & Chr(34) & " And [ProposedDestructionD] < Date()"...

The above code is giving me a Syntax error. Any other ideas? Thanks for your help. I have tried this and it also gives an compile syntax error today = ([ProposedDestructionD] <#" & Date() & "#")

Fist let me say that I am new to access database. I have been working on a project for the last several weeks. I do not have much experience with programing but do understand the basics of rational databases. I am trying to filter by a combo box then a textbox. If I filter by each of the...