Recent content by ds0203

Thanks, that worked great!

Hi all, I'm trying to perform a query in which if the pump_type begins with the word "none" then I want it to populate exactly what is in the pump_type field. If that field contains anything else, I want it to say "dedicated-" and then what is in the pump_type field. What do I have wrong...

I already had the linking fields populated, so adding the code in the after update event worked great. Thanks!!:)

Greetings, I have a form that has text boxes to enter in a permit number and description. There is then a subform that we list individial permit conditions. I would like to be able to type in the permit number on the main form and then have that number automatically entered into the permit...

Greetings - I have this code that I pulled from another project and just changed the table/field names to match my current project, but when I try to run the code I keep getting an error that too few parameters are expected or a problem with the from clause. Can someone identify my error...

Thank you, by stripping the code and recreating a couple of the forms it works. Thanks!:)

Greetings, I have a database with several tables, queries, forms, etc. We use "form Alaska" to enter all of our data. I then have some code that I run to perform some append queries, etc to manipulate the data into a different format and into a new table. This all works just fine. The...

Re: Run Several sub functions - Another Problem Thank you so much for your help. Now I'm experiencing a new problem. I run the code and everything appends/updates exactly as it is supposed to. But then I go into one of my forms (to add in additional data) and the entire database closes. All...

This is what I have for running the action queries: Private Sub cmdCreateTemplate_Click() Dim SQL As String SQL = "INSERT INTO tblTasks_Group ( TaskID, CountofCitations, TaskTitle ) " & _ "SELECT TblTaskCitations.TaskID, Count(TblTaskCitations.TaskID) AS CountOfTaskID...

Greetings - I'm hoping someone can help me with this. I have a form with a button that on the click I want to run a couple of action queries followed by 6 sub functions that I already have written. I have the click event set up and the code needed to run the SQL for the action queries, but I...

Wayne, Thank you so much!!! I have been trying to figure this out all day. I knew it had to be something I was missing with the coding, I just couldn't find it. You're awesome, thanks again :)

I have data in an excel spreadsheet that I'm importing to Access using the transferspreadsheet code. I'm importing the data into table "tempIn" and then it will go into my final table "tempIn2" (I only want to append the rows where the units field is not blank). I can get the data into temp1...

I realize that, and since I didn't initially set up this database it's not how I would have done it, but it is what I have to work with. How do I set the code (I'm semi-familiar with VB) to save the values selected into that field? Or do I need to have a different field to save the values to?

I have a list box in a form that I have set to allow multiple selections but I can't get the code right to save the selections that are made, not quite sure what I need to do here. Every time I close the form and reopen it or open up the table housing the data for the form the selections are...