Recent content by ddikeht

Hunted around, but cannot seem to figure this out. What I am trying to do is take a dynamically named file and save it as a standard filename. for instance in a folder we have the following C:\ elements_201106.txt elements_201107.txt elements_201108.txt These correspond to monthly data...

VBA - You hit a home run. It runs without an error on my button. I imagine I need to put this in one of the form events? Which do you recommend so it runs for each individual record? THANK YOU SO MUCH

VBA- No love, still the same "missing semicolon error" semicolon is there, GRRRR

VBA - Thanks for all of the time you are putting into this. You are really nice. I put in the code SQL_Text = "Insert Into Metrics (State) Values ('" & Me.State & "') " & "Where ([Checkbox] = '" & True & "');" And it gives me the same error, which is missing semicolon at end of SQL...

Ok, so back to the original question. How would I write the insert statement to only insert when there is a checkbox checked on the form? I have a continuous form that has editable fields. I am only wanting to perform an insert on the records that have a checkbox next to them. How would you...

VBA - Thanks again. Read the link and I am pretty good at SQL, but really suck at formatting it in Access. Is there are easy way to write this? I tried in Access, but I think I am worse off than before. Any help you could give (or anyone else) would be greatly appreciated.

VbaInet - Thanks for the response. I tried it both ways, and I am still getting an error. Really cannot figure out why as it is so simple. Here is the modified code. Dim SQL_Text As String SQL_Text = "Insert Into Metrics (State) Values ('" & Me.State & "')" SQL_Text = SQL_Text & " Where...

I am just trying something easy, but running into an issue here is the code Dim SQL_Text as String SQL_Text = "Insert Into Metrics (State) Values ('"& me.State & "')" SQL_Text = SQL_Text & "Where (Me.Checkbox ='" & True & "');" Basically, I am just trying to insert a...

Paul, Another great suggestion. I think I will have to have a couple of tables, one with project, another with frequency. I can then loop through them and set a flag for due. Due would then be the criteria for creating the record. Am I on the right track?

pbaldy - Thanks for the tip. I just need to make sure this opens everyday, which I know how to do. This is getting really complicated, which I love. In looking over the data, I would have to insert a record, on say, (best case) once per day, (harder) every Wed, and (way hard!) 15th of month...

First, thanks for all the help over the years, everyone here is invaluable! Issue - I have a database that tracks projects. These consist of both new and recurring projects. For the recurring (which can be daily, weekly or monthly) I would like to automatically add these to the database, so...

Rural, Yes DB is split. Finally figured it out, and thanks for your help. It should have been CurrentDb.Execute "Update Customer_Notes set Customer_Notes.Customer_Number = '" & Me.CustomerNumber.Value & "' WHERE Customer_Notes.Customer_Number = " & Me.CustomerNumber & ";" CurrentDb.Execute...

I tried this CurrentDb.Execute "Update Customer_Notes set Customer_Notes.Customer_Number = '" & Me.CustomerNumber.Value & "' WHERE Customer_Notes.Customer_Number = '" & Me.CustomerNumber & "';" But it keeps giving me a data mismatch error. Grrr

I tried using a bound form, but the database will be accessed over the network and because of its size, the performance was unacceptable.

I am trying to update a table with values from a Form. Here is the code that I am using on the command button; CurrentDb.Execute "Update Customer_Notes set Customer_Notes.Customer_Number = '" & Me.CustomerNumber.Value & "'" CurrentDb.Execute "Update Customer_Notes set Customer_Notes.Comments=...