Recent content by sbornstein1

Hello all. Is anyone familiar with ADP? How can I make a form always fetch the most recent data like Access 97? Do I have to do a requery on every record on current to handle this? This seems so bad. Thanks

Hello all. I have a form that is in a ADP file that is not updating properly so I need to fire off the Current event and requery the form with a bookmark. Everytime I do the bookmark the record goes to the top and the scroll bars move etc. Is there anyway for the bookmark to appear but the...

Hello all. I need some real good info on this. I have a large scale ADP application that the biggest issue I have been trying to resolve for a month now is capturing a lock coming from the SQL Server backend. I have an Access Form in my project that links through ADP(SQL Server). The only...

Your question makes no sense. Can you explain in more detail what your trying to do.

Hello all. I am using the DoCmd.SendObject to send email. It is a little confusing because I am using Exchange Server as the mail agent but outlook on all the clients. I know there is a couple of articles in MSDN about using automation for Microsoft Exchange or Microsoft Outlook but I am not...

Hello all. I am using the DoCmd.SendObject to send email. It is a little confusing because I am using Exchange Server as the mail agent but outlook on all the clients. I know there is a couple of articles in MSDN about using automation for Microsoft Exchange or Microsoft Outlook but I am not...

Does anyone know how I can clear the clipboard in Access in code. I am trapping a multi user conflict and when I try to close after the undo it prompts that I have copied a large amount of data to the clipboard. Any ideas?

I have a form that I changed from a recordsource to a recordset On_Open. The code line is: Set Me.Recordset = rs When I call a function to complete a find for a bookmark I set the recordset to recordsetclone. It used to work when I was using a recordsource as the bound query. Now ont he...

I create a new stored procedure through code but it does not recognize it unless I literally go to the Stored Procedure tab and click refresh. Any ideas? Application.refreshdatabasewindow does not work.

Hello all I need your help tonight because I am in crunch time with a deadline on this project. Here is the question I am wondering if anyone has any options. Ok I have an ADP database which when I setup the recordsource I have a query that uses a * in it for example tblOrders.*. Well what is...

Hello I know there are some lines of code such as: DoCmd.Echo True DoCmd.Echo False Application.Echo True Application.Echo False Can someone please explain when and how I use these on a after_Update that is calling a requery or a insert procedure from causing the screen to jitter alot. I guess...

Jenn if you need to close another form then you will need: DoCmd.Close acForm, "frmScheduler" and not just DoCmd.Close

Hello all. I have an ADP database and when a user is editing a record from one instance with the pencil icon meaning its in edit more, when I open up another instance and I go to the same record I get a Write Conflict and get trapped in an infinite loop for some reason. I can trap the error on...

Does anyone know how I can undo changes based on after I trap a error and then allow the user to move on. Currently I have a Select Case in my Form_Error and I am able to trap the Error and then I END. But I need to somehow UNDO the changes and then allow the user to move out of the text box...

Hello all. I am running a Access 2000 DB with Office 2000 quite. I need to from a form click a button which I will query for a fax number and then I want it to auto fax a report to that number. Does anyone have any suggestions for doing this? Is there anything in Office 2000 I can use...