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

    HOW TO DELETE DUPLICATE SERIALNO

    How do you wish to do the deletions - from within a form using code or with a query?? Or by opening the table and selecting rows to delete?
  2. BobAtHome

    SQL used in VBA syntax

    I don't know why you have so many "" but I do know that you don't need as many as you have. Try the following. Also since you are only selecting from 1 table, you don't need the table reference in front of the fields. The only time you need them is when you are using more than 1 table and there...
  3. BobAtHome

    SQL used in VBA syntax

    I don't know why you have so many "" but I do know that you don't need as many as you have. Try the following. Also since you are only selecting from 1 table, you don't need the table reference in front of the fields. The only time you need them is when you are using more than 1 table and there...
  4. BobAtHome

    Can anyone help me convert this SQL to Oracle 8i SQL?

    Easier to understand if you use an alias for each table (A,B) update MSP_TEST_MSP_SYNCHTABLE A set A.Chargeable_Flag = (select B.FLAG_VALUE from MSP_TEST_MSP_FLAG_FIELDS B where B.Proj_ID = A.Proj_ID and B.FLAG_FIELD_ID = 188743752 and B.FLAG_REF_UID = 0); The assumption here (since I don't...
  5. BobAtHome

    Sort by Month with a date

    Assume that the field that holds the birth date is called "BirthDate". In the query, in the last column, paste the line below in the "field" row. showmonth: Month([Birthdate]) Leave the "table" row empty. Select either ascending or descending in the "sort" row. Deselect the check box in the...
  6. BobAtHome

    strSQL type mismatch

    Instead of opening a recordset, try deleting using DoCmd and RunSql, as follows: Private Sub cmdDelete_Click() Dim strSql As String Dim intActivityId As Integer intActivityId = lstCurrentlyBooked strSql = "Delete from ActivitiesBooked where ActivityId = " & intActivityId & ";"...
  7. BobAtHome

    email to address in textbox control content

    I have never seen both the "if" and "else" sections of a "if...else...end if" get executed. I would suspect the the email is getting generated elsewhere. As a test, comment out everything in the "else" section. Add a simple msgbox command as shown below: msgbox "email will get sent" Run it...
  8. BobAtHome

    email to address in textbox control content

    I found that checking a control for null in that manner doesn't necessarily work so I wrote a little function that will check if a control is empty. ------------------------------------------------------- Function IsSomethingInControl(MyControl As Control) As Integer IsSomethingInControl =...
  9. BobAtHome

    Using "Like" In The Query Of Subform

    I assume the combo box the field that links the main form and the subform?
  10. BobAtHome

    Problem with stLinkCriteria between 2 forms

    If badge is a numeric field then you don't need the single quotes. stDocCondition = "BADGE = " & Me.cmbBadge.Value
  11. BobAtHome

    Search only filters exact matches.....

    ...the wildcard character, and a combination of single and double quotes. The stLinkCriteria would be as follows. stLinkCriteria = "[strCity] like '*" & Me![Text56] & "*'" When the stLinkCriteria is parsed it will be: [strCity] like '*ompa*' It doesn't matter if the partial search string is...
  12. BobAtHome

    Don't want forms to open in maximum mode

    Open the form in design view, open the form properties box, click on the event tab, double click in the "On Open" event so you see "[Event Procedure]" in the box. Click on the small box to the right of the "On Open" event to get to the code window. In the "Form_Open" sub procedure key in...
  13. BobAtHome

    update query question

    In the sql statement below, replace the table and field names with your table and field names. Create a new query, click on "View" and select "SQL View". Cut and paste the modified sql statement into the query "SQL View" box. Run the query. UPDATE CustomerTable INNER JOIN ProvinceLookUp ON...
  14. BobAtHome

    Alcohol 120% caused problems with CD-RW/DVD COMBO DRIVE

    Try reinstalling your original software - RecordNowDx
  15. BobAtHome

    File Growing From Query & Subforms

    Yes, unfortunately, that is normal. To get the size of your database down, you need to compact it ever so often. Use menu options "Tools/Database Utilities/Compact and Repair Database" and select your database to compact.
  16. BobAtHome

    Search by Character then number.

    Your query was as follows: SELECT Main.FirstNm, Main.M, Main.LastNm, Main.Address1, Main.Address2, Main.City, Main.State, Main.Zip, ID.IDNum, Main.SocSecID; FROM Main INNER JOIN ID ON Main.SocSecID = ID.SocSecID WHERE Left([ID.IDNum],2)="CA" AND CLng(Mid([Main.IDNum],3)) Between [Please enter...
  17. BobAtHome

    Search by Character then number.

    Paul I'll get back to you on a day or two with this. I have some suggestions but I'm a little busy right now. Bob
  18. BobAtHome

    Search by Character then number.

    Paul Not sure what you want as the stating of your needs is a little difficult to make out exactly what you want to do. However, I get the idea that you want a user to be able to enter a 2 character state designator and a from/to number range. To test a solution, I created a 1 field table -...
  19. BobAtHome

    Search form syntax problem

    Sorry bluegnu - I did this on the rush and forgot to have the search string append to itself when it finds a criteria that has a value. All you have to do is append the new part of the criteria to the current search string as shown below: SearchCriteria = SearchCriteria & " and in each of...
  20. BobAtHome

    Search form syntax problem

    What Golom mentions about formats for different data types in the search string is correct. I would approach building the search string differently. I would add to it as I tested each control for null - as follows. Private Sub Search_Click() Dim SearchCriteria As String 'set criteria to an...

Part and Inventory Search

Back
Top