Search results for query: *

Hello, I am performing a find and replace in a sheet and after the find, when I select replace I am confronted with a open file request. I can't seem to find any mention of this issue in this forum. Google brings up nothing similar. Thanks in advance for anyone who may have experienced this.

Scenario of data: 12345 6/01/04 ... ... 12345 7/02/04 ... ... 23456 7/15/04 ... ... 32345 6/01/04 ... ... 32345 7/02/04 ... ... 66456 5/12/04 ... ... Is it possible to have vlookup get a 'HIT' and then use a second value to return the correct entry? 12345 is the first value, however I want to...

I have a form based on a query where a date is being requested. It populates the form nicely. Currently the requery pops up the request from the query to enter a new date. Not very elegant. I am trying to have a field on the form accept a new date and on the update event requery based on...

I am attempting to remove links in a spreadsheet. The help files only speak about hyperlinks. Can anyone give me some insight into how to accomplish this? Many thanks

I want to switch a form view from Form to DataSheet with a command button. I figured it was as simple as changing the default view to datasheet (Me.defaultview = datasheet) but error 2136 occurs. Can anyone help with this? Thanks

I am attempting to exit a field (text box) on form1 with a value and use it to open another form - form2. I am using DoCmd.Close to close form1. I get: Run-time Error 2585 This action can't be carried out while processing a form or report event. I have tried to put the close command in...

I can eliminate the question "Are you sure you want to run this type of query?" in Access, but I am struggling to understand how to eliminate it when the .mde is used with only the RUNTIME on the computer. I have tried to change security and only caused problems. Any thoughts as to...