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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: Hinfer
  • Content: Threads
  • Order by date
  1. Hinfer

    Export crosstab with no row indent to Excel (no empty columns)

    This thread is related to thread149-1402780. I had a problem of exporting an Cross-tab report to excel and did not want the export to excel data only option (since I had some cells highlighted in different colors and wanted to retain the cell formatting). I found that if you right-click on the...
  2. Hinfer

    Union Query syntax problem (alias issue?)

    The code below (see code that doesn't work) gives me a error "syntax error in union". Once I click ok it highlight the bracket in ") as Q1". The strange thing is if I break this query apart then it works. There must be something wrong with my syntax surrounding the aliasing. I would like...
  3. Hinfer

    Query a column based on date ranges in another table (cross-tab?)

    I need a query to populate a column based on criteria in table. The criteria is based on 2 dates. I have 2 tables: employee position table and an assignment table(where the employee is scheduled to work). I need to add another column to the assignment table that displays the person's positon...
  4. Hinfer

    Finding records that do not exist

    I am using crystal 8.5 and need to find persons where a record does not exist. I have two tables, person table and a certificates table. I need to find persons where a certificate does not exist for that person. The certificates table creates records when the person has acquired a...
  5. Hinfer

    Finding records that DO NOT exist

    I am using crystal 8.5 and need to find persons where a record does not exist. I have two tables, person table and a certificates table. I need to find persons where a certificate does not exist for that person. The certificates table creates records when the person has acquired a...
  6. Hinfer

    multiple value parameter to pass into formula

    I have a parameter called Choose a competency and I have allowed multiple values. I have entered the default values in for this parameter. My record selection formula will look at the string selected and then select the records belong to the right group number. If user selects multiple...
  7. Hinfer

    Saving Attachments in Access Forms

    Hi everyone, I am a new Access user, and don't really know how to move about the application. Is there any way to save attachments (documents, e-mail, business approvals) in an Access form? They would need to be retrieved for later use. If yes, how would I go about doing that? Thanks...
  8. Hinfer

    Creating a copy of a access record

    I have an access database with an enforced primary key on all records. Users of this database wish to copy fields from one form/record to a new form. How can can I create a duplicate form without causing issues with the primary key?? Each form has a unique primary key and by replicating the...
  9. Hinfer

    Printing on A4 or Letter and accomodate landscape

    I am searching for a way to set up reports to run in the US and in London. If the printer specifications are hard coded in the report, then we need two sets, we don't want that. If we let the report use the default printer settings it switches to the correct size of paper but the orientation...
  10. Hinfer

    Printing on A4 and Letter accomodate landscape

    I am searching for a way to set up reports to run in the US and in London. If the printer specifications are hard coded in the report, then we need two sets, we don't want that. If we let the report use the default printer settings it switches to the correct size of paper but the orientation...
  11. Hinfer

    Printing on A4 or Letter and accomodate portrait

    I am searching for a way to set up reports to run in the US and in London. If the printer specifications are hard coded in the report, then we need two sets, we don't want that. If we let the report use the default printer settings it switches to the correct size of paper but the orientation...
  12. Hinfer

    Query using Multiple Combo Boxes

    Hi, How do I build a form that queries using multiple combo boxes? I am trying to create a form that functions like MS Excel Advanced Filter function. That is, I have a table with the fields: Country, State/Province, City, Location. I want the user to pick the Country in the first combo box...
  13. Hinfer

    Query using Multiple Combo boxes

    Hi, How do I build a form that queries using multiple combo boxes? I am trying to create a form that functions like MS Excel Advanced Filter function. That is, I have a table with the fields: Country, State/Province, City, Location. I want the user to pick the Country in the first combo box...
  14. Hinfer

    Query Using Multiple Combo Boxes

    Hi, How do I build a form that queries using multiple combo boxes? I am trying to create a form that functions like MS Excel Advanced Filter function. That is, I have a table with the fields: Country, State/Province, City, Location. I want the user to pick the Country in the first combo box...
  15. Hinfer

    Before Date Query

    I am trying to do a simple query to count records before the year 1995 and with no education ID. I am having problem with the date expression. Cna some one help? The date format that appears in the table is yyyy-mmm-dd (2001-Jan-01) SELECT Count(dbo_patient.patid) AS COUNT...
  16. Hinfer

    Undo changes in each record upon exit

    I have a form that displays all the current 5 employees. How do I create a button so that I can exit the form and not save the changes. The problem is that each row is a record. DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_UNDOFIELD, , A_MENU_VER20 DoCmd.Close A_FORM...
  17. Hinfer

    Cancel function code

    I created a cancel button on a form with a subform. My main form (client info) and subform allows for edits, additions and deletions. My subform allows many entries (aliases). If the user decides to cancel the changes he made to a record than he/she can press cancel to undo. I want it to undo...
  18. Hinfer

    Cancel function

    I created a cancel button on a form with a subform. My main form (client info) and subform allows for edits, additions and deletions. My subform allows many entries (aliases). If the user decides to cancel the changes he made to a record than he/she can press cancel to undo. I want it to undo...
  19. Hinfer

    Cancel button not working in subform

    I created a cancel button on a form with a subform. My main form (client info) and subform allows for edits, additions and deletions. My subform allows many entries (aliases). If the user decides to cancel the changes he made to a record than he/she can press cancel to undo. I want it to undo...
  20. Hinfer

    Cancel Button won't undo changes in form AND subform

    I have a form to enter client information. There is also a subform in the client information form. I have created an edit button to take me to the client I want to edit. I have a cancel button to get out of the form without changing the information. I used this code...

Part and Inventory Search

Back
Top