Search results

pbaldy, Thank you SO very much. Your code was very similar to codes I was trying to get to work but your plain English description that was included had me up and running (and UNDERSTANDING) within literal MINUTES! Thank you so very much! Mike

Hi All, So I've been reading these forums about this issue of mine and I find very similar problems to the one I am having but I can't quite get the posted solutions to work. Maybe my mediocre knowledge of VBA is the issue, who knows :) Anyway, I have a form that opens in datasheet view. It...

Thank you BigHappyDaddy, that's exactly the starting point I needed and can modify as needed. Thanks so much! Mike

Thank you, I am doing so. Not sure why the snarky was needed here though as I already mentioned I was still looking and thanked you for your direction/guidance. Thanks! Mike

Thanks for your reply! I know that the current script is just a transfer, I've been trying to find example code that will do both of the two formatting items after export that can be combined with the above script on click (i.e. transfer, then format the exported document). I'll keep looking...

Hi All! Just a quick question. I have VBA code exporting multiple queries to multiple tabs in a single Excel Workbook (Access 2007 user). I have posted the code below. I need to modify this code to do 2 formatting things: 1) Bold the headers on each sheet. 2) Autofit (or...

Thank you so much John! I had the group by query already created but was having issues getting it to link back and delete the bad records from the original table. This article helped me complete the circle I had started! You rock! Bremen

Hi gang! So I need a little help on a query. I have a table called duplicates. There are say 10 columns but one colomn is "Internal ID" and another is "Created". The internal ID column has records with the same value but other columns may be different. What I need to do is run a query to...

Hi Gang! So here's the issue I have and have spent 6 hours trying to find how to resolve. Today we went into an existing form (frmOrders) and deleted a few options and added a few new options. We called the new version (frm_Orders_New_Test). We changed no queries that the original form used...

Hi Gang! I have an Access 2010 database with only one table at the moment. I created a main form with some basic controls for users to view and make changes to the table through the interface rather than the tables themselves. I inserted a subform into this form (called Table1 Subform) that...

Lagbolt, Thank you so much this worked perfectly! :) Bremen217

Hi Guys and Gals! In an Access 2007 database I have a table with about 1000 total records in it. 2 Columns for these records are telephone and fax numbers that have "()" and "-" in them. I need to remove these and have the columns be integers only. I have tried changing the properties of...

Hi! I made a macro for Access 07 to grab all .csv files in a specific folder on a shared drive (the Access database is also located in this same folder). There's about 20-40 .csv files generated each month and once a month I want to be able to grab all of them and dump them into the same...

Thank you very much John! I did the reading you suggested (I had played around with the Total Query prior to your post and have that concept). I started playing around in an access query with the datepart as well. I am the first to admit that I am by far no SQL master, so please bear with me if...

Sum of Records by Month Query Help Hi Gang! I have raw data that (in part) looks like this in an access database: Contract release date Update Resource 01/26/10 Lisa 12/22/10 Lisa 12/07/10 Lisa 03/09/10 Linda 09/24/10 Linda 04/06/10 Linda 03/18/10 Linda 10/07/10 Linda 07/17/09 Julie...

Perfect! Thank you very much! I wasn't quite sure how this got nested. Thanks Bob!

Hey Gang! I just need a little help cleaning this up I know it isn't hard but I since I am not an SQL expert I know enough to realize I am missing something. Lets say I have 2 values (ValueA and ValueB) both numerical. If both values are not null then I want the query to give me the sum of...

Mr Larson you are in fact my hero of the day! Thank you so much! Happy Thanksgiving everyone!

Ok so I've strained my eyes and looked elsewhere before bothering people on the forums but I cant get this to work in Access 07 VB: Private Sub Command3_Click() If [Forms]![NORAM Subform]![previousDate] = "" Then MsgBox "No previous date entered.", vbExclamation Exit Sub Else Dim newDate As...