Search results

I've got an interesting problem. I've developed an access database to log all sales requests. Each request has to be authorized by the site manager. I have the entry form in access setup so that when a new entry is made an email is sent to the manager with an attachement (access report)...

Hi Guys, This things been driving me nuts. What i'm trying to do is copy certain fields from one table into another. Heres part of the code I'm using... Dim rst as dao.recordset Dim rst1 as dao.recordset Set rst = CurrentDb.OpenRecordset("Entry_Log") Set rst1 =...

Hi All, My question is with regards to the error handler that I have. The code below is only a partial extract from the code on the form. Essential the code attaches a report to an outlook message. If the user doesn't send the email, it runs through the error handler and asks the user to...

Hi Guys, I have a query that runs fine but takes a while to run. As a consequence all queries and reports built on this query slow down resulting in poor peformance. Let me first off try to explain what I'm trying to do and point out what is slowing down the query. I have a table with about...

Hi Guys, I was wondering if there is any way to solve this problem. I have two tables in my db. tbl1 has fields name, qty, date tbl2 has fields start date, end date, classification eg tbl1 xxx 2 12/03/03 yyy 4 01/04/04 tbl2 11/29/03 12/31/03 j11 01/01/04 02/02/04 f01 What I need to do is...