Search results

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

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

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

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

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

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

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