Search results

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

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

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

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

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