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 bkrike 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: luccas
  • Content: Threads
  • Order by date
  1. luccas

    Show the total value of records being entered on a fform.

    I am entering daily sales into a table named tblSales with fields SalesCounter, Date, Shift, FoodSales, Tax and PayType. I am loading this table from a form, frmDailySales, with two sub forms, frmDailySalesLunch and frmDailySalesDinner. Forms frmDailySalesLunch and frmDailySalesDinner - both...
  2. luccas

    And Or statement, is there a limit to the number of "Or" in a query?

    I am attempting to make a query for 10 text boxes. I have tried to enter it in the Zoom Box and I,ve entered it row by row in the query. Every time it gets cut short after being saved. How do I accomplish this? Example of saved version (Incomplete) Like "*" &...
  3. luccas

    Access 2000 Converting to Access 97

    Is there an easy way to convert an Access 2000 Application to an Access 97 Application?
  4. luccas

    Alignment test on Labels

    I want to be able to run a printer alignment test by clicking a button. I need to limit the number of labels printed in order to test printer alignment. How can this be accomplished?
  5. luccas

    Open A Dialog Form from a Report

    I am trying to open a Dialog Form that populates a Report. I open the Report to start the Dialog Form. The problem I have is the Dialog Form opens then the report comes up before the dialog form can be can be filled out. I have the code in the report “open event”. This is the Code I am...
  6. luccas

    Add a value to null text boxes on a form

    I have a form that I am using to run a query. The query name “qryUCQuery” the form name is “frmSelection” it has 2 text boxes on it ,Text0 and Text2. I am using “frmSelection” to specify the values for “qryUCQuery”. The criteria for the query is “Like "*" &...
  7. luccas

    Using a form to specify a query

    I have a query with a field called Category with text records, one record example: "3 4 SW SRV CCR GR FAF FCO FCR SCR FGR". This example shows 11 categories. I want to use a form to specify up to 10 criteria for this Query. The output will be used to make mailing labels. any help much...
  8. luccas

    Hilite a 0 value record in a report.

    I have a report where I want to activate a textboxes color when the value of another text box = 0. Example: I have a parts list when the value of [parts ordered]-[Parts recieved] = 0. I want a textbox that I have placed over the that record to hilite a color.
  9. luccas

    Activate a textbox backcolor from another textboxes value

    I want to activate a textboxes color when the value of another text box = 0. Example: I have a parts list when the value of [parts ordered]-[Parts recieved] = 0. I want a textbox that I have placed over the that record to hilite a color.
  10. luccas

    Will Not Boot

    In Win95 I uninstalled Com2 Com3 Com4 and LPT1 in the device manager. I left Com1. I was having a problem with Com2, I thouhght I would uninstall these then reinstall them. After closing down the computer I tried to reboot but I can't even get to the CMOS. When I turn the power on the fan goes...
  11. luccas

    Symbols for degree and diameter

    How is the symbol for degree. ex. 100 "degree symbol" , or the symbol for diameter ex, 1" "diameter symbol" displayed in a text box in Access?
  12. luccas

    Entire Access 2000 Application on a web site.

    Is it possible to build an Access 2000 Application, where the entire application is kept on a web site. Ex. A Bookkeeping application located at a web site, where the different people doing different tasks, can go to the Web site and do their task.
  13. luccas

    How are time fields (Am PM) calculated?

    I need to calculate times on a form (Employees clocking in and out). The purpose is to record daily employee hours. The fields are [In], [LunchOut], [LunchIn], [Out], [OtherIn], [OtherOut]. These are Date/Time fields. Using the AM/PM format I am unable to calculate the employees daily hours. How...
  14. luccas

    Access 2000 How to install in a Server Client Network.

    I would like to find the correct way to install Microsoft Access 2000 in a Server - Client Network. Currently I have the data Database on the NT 4.0 Server. The Application (Microsoft Access 2000) is installed on the Cleint. The Forms and Reports Database is installed on the Client. This loads...

Part and Inventory Search

Back
Top