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

    Active Cell or Row

    Hello, What I am attempting to achieve may not be possible without code, but here goes anyway. I am trying to find a function that will tell me which row on a worksheet is currently selected. For example: If I am currently on worksheet "X" I would like to know the row number on worksheet...
  2. matethreat

    Excel 2003 Formula Display In Cell

    Hello Everyone, I am having a problem with Excel 2003. When I enter a formula into a cell, quite often the formula is displayed and not the result. Is there something I need to do to have it always diplay the result. I have never seen this before. Thank You, Aaron Destiny Is Not The Chances...
  3. matethreat

    Append Query Problem

    Hello, I don't know if there is a way to solve this problem but, it's worth asking. I have a table the holds procedures to complete jobs that our company produces over and over. I have a second table that allows me to schedule people to jobs. What I would like to be able to do is run a...
  4. matethreat

    Mouse Over

    Hello, I am sure the question has been covered in the past, but the search engine on the website is not allowing me to do a search right now, so I thought I would just ask the question again. I am using a box (rectangle) over my command buttons to allow me to use colors for my buttons. What I...
  5. matethreat

    Searching a combo box

    Could you not just start typing the name you are looking for in the combo box. It should take you directly to the name you are looking for. You should not have to set up a seperate search. Destiny Is Not The Chances We Take, But The Descisions We Make.
  6. matethreat

    Use Command Button to Post to Seperate Table

    This might be a litte longer a solution then some of the others, but you don't need to create a query. If you place this code in the OnClick event of your command button you will get the same result. Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Set cnn = CurrentProject.Connection Set...
  7. matethreat

    combo box afterupdate

    Hello, In the query for your combo box add an additional field with the following info. Expr1: [tblname].[fld1]&"_"&[tblname].[fld2] Then in the format tab of the properties box for the combo box change the Column Count to 3 and you Column widths to 0cm;0cm;5cm Your combo box display during...
  8. matethreat

    CreatIng A Table With Dates

    I have a form with 2 Active X Calenders. I use these calenders to view information about jobs between 2 dates in several reports. What I would like to be able to do now is create a temporary table that creates a unique record for each date between the 2 dates selected in the calender. I then...
  9. matethreat

    Unbound Controls for Calculation

    You cannot perform calculations on calculated items. But, if you put the following formula in it should work. = sum(quantity * price) Aaron Destiny Is Not The Chances We Take, But The Descisions We Make.
  10. matethreat

    User Conflicts

    I have actually solved my own problem by splitting the database. Keeping my tables on the network and the forms and reports on each users desktop. Thanks for your reply. Destiny Is Not The Chances We Take, But The Descisions We Make.
  11. matethreat

    User Conflicts

    Hello, I have a database that I have placed on our network and I would like the ability to have multiple users in the database at the same time. My problem is that once one user opens the program it locks out all other users. The following error is displayed when a second user attempts to...
  12. matethreat

    Using Like In A Query

    Thank you for your responses. I was able to get it to work by creating a seperate query and then using that query as the source for my subform. For some reason it works this way, instead of having my subform with it's own internal query. Aaron Destiny Is Not The Chances We Take, But The...
  13. matethreat

    Using "Like" In The Query Of Subform

    Ken, Thank you for your efforts. I created a query seperate to the subform and used that query for the data in my subform, rather then direct from the tables, and it works. Thank You Aaron Destiny Is Not The Chances We Take, But The Descisions We Make.
  14. matethreat

    Using "Like" In The Query Of Subform

    Yes It Is. Destiny Is Not The Chances We Take, But The Descisions We Make.
  15. matethreat

    Using Like In A Query

    PH, With " Like '*" & [Forms]![Scheduling]![Combo8] & "*'" I Get No Result If I Modify It To Look Like This Like "*" & [Forms]![Scheduling]![Combo8] & "*" I Get Only Exact Matches This is a tricky one. Destiny Is Not The Chances We Take, But The Descisions We Make.
  16. matethreat

    Using "Like" In The Query Of Subform

    That's correct. This is what I am looking to achieve. If I select in combo8 040511 I would like the result to show all of the following in the subform. John Doe 040511 Jane Doe 041286/040511 Jack Doe 040511/041388/042003 etc....... Thanks Destiny Is Not The Chances We Take...
  17. matethreat

    Using "Like" In The Query Of Subform

    Thanks Ken, I still get the same result, only exact matches to Combo8. Aaron Destiny Is Not The Chances We Take, But The Descisions We Make.
  18. matethreat

    Using "Like" In The Query Of Subform

    Hello, I am trying to filter a subform that is based on an item selected in a combo box. What I have is a Combo box that lists job numbers (with a text format) and a subform that lists all the people who worked on that job. My problem is that in the Job Number field of the subform an...
  19. matethreat

    Using Like In A Query

    Hello, I am trying to filter a subform that is based on an item selected in a combo box. What I have is a Combo box that lists job numbers (with a text format) and a subform that lists all the people who worked on that job. My problem is that in the Job Number field of the subform an...
  20. matethreat

    File Size With Background Picture

    You are right I do get an increase, but it's not in any way substantial. With the picture linked my database is back to 280Kb. Destiny Is Not The Chances We Take, But The Descisions We Make.

Part and Inventory Search

Back
Top