Recent content by olympus

Duane and PH, Thank you so much! Your suggestions solved the problem. John

Here's the SQL. I did not write this directly, I used the criteria fileds on the query design and this is the SQL result. Many Thanks. John SELECT [Drug Info Database].Drug, [Drug Info Database].RPh, [Drug Info Database].Requester, [Drug Info Database].[Question...

Duane, I tried adding this expression fron of my existing query and now the search yields zero records. I'm just guessing here but could an IIF statement work? I know that some of my fields are indeed "null", but have not been able to work around this. I thought that the "nz" function would...

My queries are not showing any records that contain one or more blank fields. I have a table (named DrugInfo) with 35 fields. I want to find records based upon user input for up to five of these fields. These fields are: drug, rph, requester, question summary, question response. I created a...

When the user is in print preview and then selects "close" from the print preview menu bar I woul like Excel to not only go to sheet1 (which it does) but to also set cells F4 and F14 on sheet1 to a value of zero. I haven't been able to find out how to trigger the running of code when the user...

Sometimes my networked Excel application generates an Error #55: "Samplefile.xls is already open. Reopening will cause any changes to be discarded. Do you want to re-open?" The app runs fine regardless if I answer yes or no to this question. I would like to write some visual basic code to...

I'm trying to require that the user imput a value into cells B3, B4, and B5. I have the following code to run "on open". The problem is this code allows the user to click on OK in each dialogue box then continue without entering any data into cells B3,B4, or B5. How can I require that data be...

to pbrodsky: The selection of units does determinine the final calulation. The final result is a flow sheet sheet which shows the dose and its appropriate flow rate in ml/hr to set the pump at. The print area and the multiples of how the display is calulated (by 1, 10, or 100 increments) is...

To pbrodsky: In my Excel app the user selects one of six possible radio buttons for mg, mcg ,units, grams, etc. In the second section one picks one of two radio buttons for volume( ml or Liters) and in the third section the user selects one of 7 posible final doses (mcg/min, mg/min, units/hr...

I am trying to write a series of IF then statements in VB for Excel. I have tried to use the: IF [condition] Then Statement Else End If format without any success. I have three cells (F4, F10, and F14). Each of these cell values are controlled by radio buttons. F4 can have a value...

jm314 & Boggg1, Thank you. My application will be placed on the network today, so I will be able to try your solutions. I appreciate you taking the time to helping out a beginner. John

Boggg1, The lag time is due to our network being slow. How would I go about saving the value on sheet1 cell g27 to a text file daily at midnight? I would also like to reset cell g27 to zero after its value is copied to a text file. That way I would know how many times the file was opened each...

I have an Excel file that is networked as a read-only application. The users utilize the worksheet to perform some calculations, then on close the workbook is coded not to save any changes. However, I would like to have a counterthat tells me how many times this Excel app is opened. It would...

I would like to either: 1) Close the print preview screen from a VB code module or 2) Print the worksheet from the print preview screen using VB. I have tried the suggestions given to be17 (thread 707-104728) without any success. I have also tried using the sendkeys command to send a "c" or...

Skip, How do you specify a function so that it will not appear in the Macros Menu? Thanks. John