Search results

Got most if it solved, Just keep getting error Index or primary key cannot contain a Null value How can i fix this ? Thank you

Hi all, On the attached sample db , I have a few problems. 1) How do you get the main form ( RequestForm ) to save the data in the subforms. 2) When adding a new record , it keeps the data from the first record, also when changing the data on the second record, it changes the information on...

Hi all, Im would like to generate prescription order form, so that I can order 10 line items at a time. But have no idea where to start. I have the following tables, Suppliers --------- SupplierID SupplierName SupplierContact SupplierAccount No SupplierPhone No Order Form Header...

Hi , I have add a sample off the database, if you load a pdf file, select it and press the preview button, it will come up in the box. Now if you press new record it will still show that pdf. i dont want that John

Hi all, I'm having a problem with a form that when you want to add a new record, It takes the previous records PDF files. Is there anyway to stop that. thank you John

Hi all, I have a Adobe PDF Reader , active x control loaded on a form. And would like it to show the PDF a file when a button is clicked. The following code works, if you want to view outside access, but I don't. Can anyone have a look and tell me how I can link the button to the active x...

thank you, with a little try and error I got it working. I have updated the sample db with the code Private Sub AcroPDF5_GotFocus() Me.AcroPDF5.LoadFile ("D:\ResMed Reports\12 to 19May 2014.pdf") End SubThis works if you only want that pdf file to be shown, I have different 2 pdf's for each...

Hi all, Is there anyway to preview a pdf file within a form ? the sample db is what im looking for , but in the preview window have it show what file to show, pending on what is selected. Thank you

Hi all, Is there any way to reset a database to have no records (start again) ? thank you

i have got a little bit forward. 1) in the image box it shows the image name ? 2) and in the queries for ( QRY_SearchAll ) for in the Pic column it will not allow me to save the criteria -- Like "*" & [Forms]![FRM_SearchMulti]![SrchText] & "*" is there any reason for these ? see the updated...

Hi all, I have attached a sample database that is for searching products with images. The search works ok, but cant get the product image on form-- FRM_Carns Can anyone help with this problem. thank you

got most of the problems fixed, just need to get the pictures now

anyone got any ideas ?

Hi all, Im trying to make a find page that looks up 7 fields and after reading about the Dynamically search multiple fields i downloaded the sample and changed a few things. But I have a few problems . 1) If you open the FRM_SearchAll from the navigation pane , it will not show the detail form...

hi sorry thats my typo, correct code

hi both reports are open , the error is that the value does not change when you select from the drop list

Hi all, I have a drop down list with the following : Week And Weekend :. I want to change the Average field depending what is selected. But having a problem. I'm using the below code, but does not work =IIf([Days select]="Weekend", [Reports]![Weekend Settings]![Average),([Reports]![Week...

Hi all Im trying to get the value of the following code .. The result of the below fourmula is 54 (that is as long as the program has been running), but I need the answer to be 7 (that is the value from today and the last 14 days) =[Reports]![Results <4 and >14]![Result<4Total] I have used...

thank you sorted

=IIf ([Result1]>[Reports]![Pump Settings]![Target High], [Result1]-[Reports]![Pump Settings]![Target]/[Reports]![Pump Settings]![Sensitivity Factor (SF)] ,0) I need a little help with this formula, If you use a calculator it works out the correct answer, eg. result 1 = 12.4 target...