Search results for query: *

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

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

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?

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

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