Search results for query: *

Worked perfect thanks.

I am planning on using the "before update" event to validate a field. Can someone help fill in the english with some code!!! The form is used to enter different types of work. If WorkType.value = "Payroll" then [PAYROLL END DATE] is required. else do nothing End If Thanks Rob

Paul, Here is some more information about the setup. I am using a Between.. And statment for the date_in. In the date_out I had the iif statement. Here is the between .. And statement (applyed to date_in column) Between [Forms]![frmTeam3_Clientreport]![startdate] And...

I have a form that asks for the following input values. date_in, date_out, and a check box for outstanding records. When query is run if the outstanding check box is true I need all null values in date_out column. If false then all records should show. Any ideas on the iif statement for...

Is there a way to have a report automaticlly verify the database when opening. Sometimes when we update a database we forget to verify the cyrstal to the database. Thanks Rob

Using GroupWise 5.5. Every time I receive an email from one client there is no attachment. The client is sending an attachment. If I select File->Attachment->View in GW. The attachment is imbedded in a text message. If I forward the email to my hotmail account from GW the attachment...

Geoff, Thanks for the response. I'm new to VB. Could you help me on where to add the code. (Access or Excel (where in Excel)) Thanks again. Rob

I am using VB code in Access to open an Excel spread sheet that contains a Pivot Table: Dim xlApp As Object Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set xlWB = xlApp.Workbooks.Open("v:\syb\tradesheet.xls", True) The pivot Table...

How can I hide the Maximize process from the end user. "On open" I have all my forms maximize. Is there a way to hide the visual process. I would just like to have the form open maximized. Thanks

How can I create a link to open a file on the network. I want the file to associate with the application. For example if I hyperlink to a MDB file I want it to open in Access not IE. Same goes for crystal report files. I am trying to create a web page that works like a desktop.

I would like to have users turn on their computers, login and have a specific web page open automatically.(sort of like their desktop) Right now I have place a shortcut to the web page in Startup. But the browser does not always maximize its window. It there a better way to accomplish this?

Jim, I guess the Information I am looking is in the trillions position. Thanks Rob

Can anyone suggest a formula for the following? I have a field that has the following information “1,704,000,000,000,000.00”. This field is combing multiple values. I am interested in only the second position where the 704 is located. How do I only show the second data position? Thanks

Is there any way to have a report not open in design mode. I would like to have the reports to run when they are open. Thanks

Thanks. Worked perfect.

I have a link that opens up another window. I want to add a button to close the new window. How do I make this happen? Thanks