Search results

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

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

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

Does anyone know how within a certain form I have use the F4 key or one of the F keys to fire a DoCmd.OpenForm event? Also when this occurs it will open a form. I need to somehow in that form know that this was hit, because the same form opens up as non-editable on the same form. Anyway I can...

I have a form that based on coming from a specific form I want to make the form editable and change the Me.Recordsource instead of maing a new form. Any idea how I can check first if the form is opened, because it will give me an error I think if the form is not opened and I do an IF statement...

Hello all. Here is my issue. I have a form that I recreated in another Access 2000 database. On the original form when I do a ME.REFRESH command the form goes to the FORM_AFTERUPDATE and then refreshes and keeps the record place in the detail section. On my new form anytime I do a...

I am getting a write conflict on some parts of my subforms going back to my main form. I get a Write Conflict box and it says the record has been changed by another user. I am the only user on it at that point. Any idea what I should look for what could cause this? Thanks

I have a query which is this followed by this. I cannot make updates to the tblOrders fields. I have set the Updatabale Snapshot and Unique Table properties. What am I doing wrong. I can't update anything in this? Any ideas. Here is the wuery. SELECT DISTINCT tblOrders.*...

Hello all. I need your help I need to change the backcolor of text boxes based on a date. Now I have this code but it needs to somehow know to change in the DETAIL section of the form which loops of course through the recordsource. Dim bg as Long Dim dt as Date ' this is so there is only...