Search results

Hello When I click on a hyperlink that I have added on a form, it will not open. I have added a sample of what im doing if anyone can help. Thank you

Hi all, I have uploaded a copy of my access database as .sql to my website and created a table in the mysql database. Also done a html form of the database and a prosses.php. Evey time I run it I get the following error : Parse error: syntax error, unexpected ':', expecting ',' or ')' in...

Hi all, I have an external program that I export a csv file. In access there is a link to the csv file to a table & query, so that I get use the data , (like the graph in the sample db). Every day the csv file is created, but access will not update unless I use the Link Manager. Is there a way...

Hi, I would like to show my appreciation for all the help I am getting and given on my project. I just cant pop round and buy a beer, so is there any other way ? thank you John

Hi all, I have attached a sample db that I need help with. What I need is when you have selected a page from the combobox, How can you get it to return to [SampleName] automatically ? Thanks

Hi all , I need to have the pound sterling symbol ( £ ) in a field, but only have two options 1- Dollars ( $ ) and 2 - Euros . I have done a search but cant seem to find out. How can I get pounds or change one of the others. Thank you

Hi all, Im using the below code to open a from depending on what option is selected on a combobox. Private Sub DirectPCombo_Click() Dim cboVal As String Dim stDocName As String cboVal = Me.DirectPCombo.Value Select Case cboVal Case "One" stDocName = "TestOneFrm" Case "OneRpt"...

Hi all, I have made a navigation form that prints the current record out as a PDF and also the option to send the current record by email as a PDF. Both work perfect when you open the form outside the navigation form. But when you open it inside the navigation form, it does not print any of the...

Hi all, I have a form that has 2 subforms. When I try to print the current file there are a few problems, 1) When you use the print option in File menu, and select "Selected Records" , it will always print the second record, no the one selected. 2) No matter how often I change the...

Hi all, I have a from setup with my hospital/ doctor / health care appointments (a lot of them), Is there any way to have a alarm / message box pop up 1 week before the appointment date ? 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 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...

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

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

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