Search results

I am trying to display a txtbox if data is null and Display the combobox with the data if it has data. I am getting an run-time error '3021' No current record on If rs!Closed_Numbers Like "" Then Thanks for all the help. Here is my code Private Sub cmbMatter_AfterUpdate() Dim strSQL As...

Good Morning! I am trying to add sequential numbers to a table. If it does not exceed a number another table. I am having trouble with the insert portion. this code works in a normal query in the access query gui. SELECT Format(Date(),"yy") & "-" & Format([Closed_File],"0000") AS test; I...

Any idea why this won't work? SELECT Max(Val(Right([ClosedNumbers]![ClosedNumbers],4))) AS Expr2 FROM Closednumbers WHERE (((Left([ClosedNumbers]![ClosedNumbers],2)) Like "Str(Right(DatePart("yyyy",Now()),2))")); It says the expression you entered contains invalid syntax. You may have entered...

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...

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...

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...

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...

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...