Search results for query: *

I wrote a crosstab query and run it as pivot chart and it works fine. But I need to add a line to the chart that represent a constant value, is it feasible? and another thing, how can i add a legend? TIA

I need the PageHeader to show only if there are detail lines in the page. On the ReportFooter there is a sub report and if the sub report is on the last page without detail lines, the PageHeader is still shown. TIA

Hi I have a sub form on a tab control. Double Click on this form calls a detail form. when exit the detail form - it requery the sub form to update it. I would like to get back to the record i stood on before . TIA

I have a form that browses picturs like an album and can resize them. Need to be able to rotate a pic. Is it possible? TIA

My user needs to see the details (size) of a file. I know how to show the file using GetOpenFileName, but not with details. Is it possible ? YIA

I need to add the content of a text file to another text file. like in Basic : copy c:\a.bkp+c:\b.txt c:\a.bkp Is there a way to do it in one command? TIA

Hi I want to give the users to choose an e-mail address from Outlook AssressBook. This table can be linked localy only "C:\Documents and Settings\MyUserName\Local Settings\Temp" Is there another way? TIA

Hi I need to run an Oracle procedure. Get this error "cannot execute a select query" Can someone See the problem here?? Thanks for any help Set qryOracleProc = CurrentDb.CreateQueryDef("") qryOracleProc.Connect= "ODBC;DSN=ORAxx;PWD=xxxx;DBA=W sql = "begin OracleProc(1);end;"...

Is it possible to change the mouse pointer to an icon i choose? TIA

Hi I send to a report the name of the calling form in "OpenArgs" and hide the form. When close the report i want to show the form again. forms!xxx.Visibl = True instead of "forms!xxx" to use me.OpenArgs I can't get the right way to write it. TIA [cat2]

Hi I created a custom toolbar. One of the options is 'Print' but I need it to bring the Print Window to choose printer, Print range.... and instead it prints to the default printer. How do I do it? Thanks

I'd like to change the property "Use Access Special key" within the code and be able to use F11 without reopen the application. Set db = CurrentDb On Error Resume Next Set prp = db.CreateProperty("AllowByPassKey", dbBoolean, bool_) db.Properties.Append prp If Err.Number <> 0 Then...

Hi I'm transfering a record from Access to Word with this code: Set objword = New Word.Application Do Until rst.EOF With objword .Visible = True .Documents.Add Template:=("\\Server\a.dot") .Selection.GoTo Name:=("CustName") .Selection.TypeText...

Hi I have an Excel file that has a link to an Access query. The parameters for that query are fields in access form. I'd like to transfer those fields to Excel as well as the query results. In what way ? TIA

Hi A query criteria is dinamic. It looks like: In ("122005","012006") I tried to insert a function that returns the whole sentence or only what inside the brackets, and both ways are not working. If i take the results of the function and place it in the criteria, the query work ok. Is there a...

How is it possible to determine in which directory MsAccess installed?

If you enter an illegal date in a form (like: 29/02/06) Access turn it to what looks reasonable to him. (06/02/29) The date format is "dd/mm/yy" Where (Event) can i catch and check the date. TIA

I need the form to stay in normal size (not maximized) and show a MenuBar. Is it possible??????? TIA [cat2]

Hi We have about 20 Access applications in the company, and till now we have Access installed on every station. (~200 stations) Now we need to remove the Access and switch to Run-time. I know the process but have problem with some Functions. For instance, the MS Calendar close the application...

Hi I'm using TransferText to import from text file to Access, the problem starts when it happens the moment the text file is opened for writing by another system, in this case the Access closed down with error. How can i determine if the text file is open? TIA [cat2]