Search results

I'm working with a guy here that is doing something similar to both of your suggestions actually. He is going to have the db add a time stamp column and when running the append query he will be referencing multiple columns to avoid duplicate data. Thanks again.

What would happen in the event that I run an append query, but forget to replace the csv with a newer one? Will I end up with duplicate data or is there a way to prevent that?

Thank you all for the input. I've built a working database, but do find there are areas where some sort of scripting would significantly lessen the amount of manual work. For example, every time I get a new .csv I am going through the import wizard to append to the existing table. I'm sure that...

Hello, I'm hoping someone can help with the most efficient way to do this. Every month I download a billing report listing costs for several telephone numbers. Each cost is broken down separately by description, so each .csv file equates to about 12,000 rows in Excel. I've attached a shortened...

Worked like a charm! Thanks!!

Thanks a ton! I'll try it shortly.

Different occasions. For this particular spreadsheet, I only need it to delete all rows that don't have data in Column C, then add a column with "Date" as the header. What's weird is that when I run the macro to delete rows, everything works perfectly up to the last row. For some reason, it...

Funny you mention that. I just happened to notice that the macro checking for cell data in the columns will negate the need for my first macro. I would still need to add a column at the beginning for date though, but I guess I could do that manually.

Thanks to you both. Followup if you don't mind... I have a different macro that deletes Rows 1-13, then adds a Date column. Is there a way to have these run consecutively, or should I just run them individually? I'm not too familiar with macros.

Thanks!! I thought it would be pretty easy, but I'm an idiot :D

I copied an Excel macro from a previous post to check cells in column A for data, and if no data is found there to delete the row. The code is below, but how can I modify this to check cells in column B or C instead: ----------------------------------- Sub DeleteBlankARows() Dim r As Long...

I think what I used would be close to the callback function, but either way the second link you provided gets the results I needed. It doesn't work when "all" is selected, but it does when the top blank row is. So I'll just put a note to leave blank if wanting unfiltered results. Thanks!

Hello, hopefully there is an easy answer to this. I have a form with a combo box linked to a query containing department names. I used code I found named AddAllToList to create an "all" option in the combo box. Everything shows up fine, but the problem is I have another query that uses the...

Thanks. I eventually came to realize this as well. The problem was that I needed to average several groups, and then do a conditional count on them. I ended up just making two reports - one to do the average, one to do the count.

Hello, hopefully a simple question here. I have a report with 6 months of usage for many lines. Each line is separate and I have created a text box that averages their usage for the 6 months in the group header. What I'm trying to do is make a front page listing the number of lines with averages...

To start, I use Access 2007, but it shouldn't really matter which version you're using. I created a blank form, double-clicked at the very top left in Design view to set its properties, and set the "Record Source" field under the Data tab to my query. Then I created a text box on my form for the...

Which part do you need explained?

If I'm understanding you correctly, they are relatively easy to make. I created a blank form, set the data source to a query I have, then created an unbound text box on the form with a command button. Then all I had to do was set the criteria for the field in my query I wanted searchable to the...

Thanks. I'll give it a go.

Hello all, Please bear with me as I'm not very knowledgeable when it comes to code. My hopeful result is to select multiple Departments from a list on a form, then run a report based on an existing query with the selections in my list as a criteria. I already have the report completed and...