Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smelly

    Get my fireworks file back from the HTML. file

    Hi I am very new to this and need some assistance please. I was working in Fireworks with my website when I accidentally erased the file. I still have the HTML file in Dreamweaver. Is there a way I can convert this HTML file back to a png file so I can open it in Fireworks again. THANK YOU!
  2. smelly

    Datasheet view of linked tables doesn't display values.

    Yes! I figured it out. THere was a problem with my linking fields. Thank you!
  3. smelly

    Datasheet view of linked tables doesn't display values.

    I am trying to set up this database very similar to the Northwind database where the Suppliers table is linked to the products table which is linked to the order details table. But I have a Clients table linked to a Projects table which is linked to a Tests table. Everything seems to be set up...
  4. smelly

    Datasheet view of linked tables doesn't display values.

    I have two tables which are linked together. When I go to view them in the datasheet view and click on the plus next to the parent table, the child table opens up but it does not display data in the fields, but if I open the child table individually on the tables screen it displays the data...
  5. smelly

    open a report with this sample #, print then close!!

    Sorry, I am just learning. Thank you for your help. I put it in the criteria below sample ID but it wants me to input the number instead of it being passed in when I click.
  6. smelly

    open a report with this sample #, print then close!!

    Thanks, I am now getting a compile error, it doesn't like the first line with the asterisk. Private Sub checkbox1_Click() DoCmd.OpenReport "InternalLab1b", acViewPreview SELECT * FROM Query1b WHERE [Sample ID] = Forms!ChainOfCustody!BBCID End Sub
  7. smelly

    open a report with this sample #, print then close!!

    I have a form where I am trying to open a report from a check box. The form has a sample ID and I am trying to run the report from the query for this sample ID. How can I pass this to the report so the report opens for this sample ID then prints, then closes. Thanks!
  8. smelly

    passing project number from one form to next!!!

    I have fixed my problem here is my code..... a helpful chap by the name of pono1 suggested this bit of code and it works for me....... Test the following by putting a command button on the practice1 form and assigning this code to its click event. Private Sub Button_Click() Dim PNum As Long...
  9. smelly

    passing project number from one form to next!!!

    Thanks, I fixed that but the error still reads.... Object does not support this object or method. Private Sub Send_Number_Click() stLinkCriteria = "[ProjectNumber]=" & Me![ProjectNumber] DoCmd.OpenForm "Practice2", , , stLinkCriteria End Sub Thanks for any help!
  10. smelly

    passing project number from one form to next!!!

    I am trying to pass a project number from form A to form B, but I am getting an error. I am using the code I found on an old thread for an on click procedure to go to the form B.... (I have a command button to open form and the code behind it is...) stLinkCriteria = "[ProjectNumber]=&quot...
  11. smelly

    passing variables from access to other programs

    I am trying to put a database together for a lab that would like to be able to use Microsoft Access to organize everything but also use additional forms in other applications to record data and print up reports. I would like to have the client name and the experiment number passed over to a...

Part and Inventory Search

Back
Top