General

VBA Help in Access 2007
When looking through the Help engine, either local or online, I get blank pages when I look at many detail pages in the Help file. For example, when looking at most all web pages in ADO (Section I: ActiveX Data Objects (ADO), there's one title line and no detail. Is that planned behavior (no data) or is there s... 27 Apr 2010 21:20

Setting up an Email to automatically be sent based off a date
I have a list of Birthdays were I would like an email sent automatically to my boss when it gets close to or on that day. I am not sure how to approach this. Any Suggestions? ... 28 Apr 2010 16:20

Using the DateDiff function based on 5 days
I am using the DateDiff function in a report. I am using it based on 16 hours to caluclate process time of work. I need to include a 5 day work week. if a worker gets something on Friday at 4:00pm and does not complete until Monday morning. How do I calculate that time? ... 17 May 2010 19:08

how do I strip spaces and replace with dashes
I have several item numbers that have various spaces 1234 5678 A and I want to strip the spaces and replace with dashes 1234-5678-A ... 29 Apr 2010 01:20

Run-time error 3061; Too few parameters. Expected 2
Private Sub Sect_BeforeUpdate(Cancel As Integer) Dim db As dao.Database Dim rst As dao.Recordset Set rst = CurrentDb.OpenRecordset("Select * From qryData Where [sect] = '" & Me.Sect _ & "' And [TimeIn] >= #" & [Forms]![MainMenu].[From] & _ "# And [TimeOut] <= #" & [Forms]![MainMenu].[To] + 1 &... 28 Apr 2010 09:29

Has anyone seen this?
I have data changing in a table. It is an individual BE table, FE linked and data just changes in it. I set a certain project ID# to Farmington School District and come back in 5 minutes and it has changed it back to Gentry School District by itself. This is an idividual table not in any relationship with an au... 27 Apr 2010 17:57

Refresh unbound textbox
Refresh unbound textbox Hello, Using Access ’03… I have quite a bit of VBA code that runs a variety of queries. Between all of the SQL code, I display information to the user in an unbound textbox on the form. Something like this: ‘’’’’’’’’’’’’’’’’’’’’’’’’ Sub RunQueries() Me.unboundTextBox = “About to ... 27 Apr 2010 16:48

Expression with a cell reference
Table 1 has Month and total forecasted sales by month. Table 2 has historical sales broken down by a certain criteria. I'm looking to create a query where I can add the following calculations: 1. Table 2 line 1 divided by grand total table 2 to give me a % (same calculation for each criteria in this table... 27 Apr 2010 14:30

Access 2007 Excel Import Error
I'm trying to import an Excel spreadsheet into Access 2007 and keep getting "The search key was not found in any record." error message. I have deleted all blank rows, columns, tabs, formatted all the data to match Access, etc. What is this "search key"? -- Thanks! ... 27 Apr 2010 16:48

previous record not showing
i split access 2007 into FE and BE. When I fill the form ,it accesses the tables for information. When i now try to access the previous patients record, i am able to get a blank record instead of the last record of an inputed patient. However when i look at the table, the information is there. Why is the previ... 28 Apr 2010 07:15