Search results

Hi experts, I would be greatfull for some advice on my problem....... So, I have Data access page which have command butons for searching through recordset, one command button is searching column with text datatype, and other button should search through column with currency datatype. The...

thx for posting how you solved this problem krberube! :rolleyes: I had the same problem like U ,which is now resolved using solution you provided.:)

Is there a way to put command button on DAP which will onclick call form in which will I put parameter and when I press some button on that form I get DAP with results?:(

Hi all, I was thinking if some could suggest me how could I make DAP which will have only one text box and command button in which will the value written there be forwarded to some parameter SQL when that button is pressed... Do you know what VB code should I implement in onClick action for...

Thx Ttime, i was guessing I could do that using parameter querys. I think this is not the only way to do it but obviously it is not that easy to do it

Hi, I have a Data Access Page which is generated on behalf of a query. Query uses one parameter field ,so when is started it promts with the form named Enter Parameters in which I have to input parameter value. So before the DAP is opened, first is displayed parameter form. I would like to...

Well TTime, I would like to have Excel autofilter capabilities in my Data Access Page and not to use export from access to excel so users who are using DAP could have the same filtering capabilities like in Excel.... Is there some way to do implement this kind of filtering in DAP?

thx guys, I read those posts about how to create audit trail of record changes in form. I think it want apply on DAP. If I could somehow, by using Environ(), get any info on who modified some row,can you tell me how and where will I use Environ() function?

Hi, I have DAP which is generated on behalf of a query. When I designed DAP, I placed field names in the Caption section & removed default navigation toolbar so I could have table-like view of that data in the browser. I also use on one field group flter option. **Is it possible to somehow use...

Hi, I have DAP database through which users manipulate with data. There is about 15 different IP's accessing that database and they are all in local network, Intranet. Someone modified one row with wrong data and I would like to find out which computer made that change. How can I find out which...

Hi, I made data access page which is generated on behalf of a query. In the query desing i chose parameter input option as criteria for one field, so when I open try to open that DAP first I get form for that parameter input. All values in that parameter lookup column are text datatype and...

Hi I use Access 2003, Does anyone knows hot to make some button on data access page which will when pressed open MsWord or some Word document?

thx for You're advice but it didn't help.... I go on script editor on that DAP in witch command button resides and after I chose that object and action onClick I paste You're code but button remained unfunctional.

Hi, How can I make command button on my DAP to use update query that I wrote? :confused:

u R wright.....i was misslead by the fact that those tables where created in excel and used through excel.there is a VBA code in excel table A, which when button pressed copies data from in VBA code specified 6 columns from this file and paste this data in another excel file called table B...

Hi guys, can someone tell me please how to create ONE form which will be used for data insert in TWO tables(table A & table B). Table A has 19 columns & table B has 6 column whit the same name and purpose like some 6 columns in table A. So through that one form I want to insert data in table A &...