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: *

  • Users: Apollo13a
  • Order by date
  1. Apollo13a

    How do I multiply a field result in a query?

    Hello, I have a query that returns labor hours from a table. I want to multiply the fields OT and DT by 1.5 and 2 respectively. Here's my sql SELECT tblContractor.Contractor, tblJobs.JobName, tblHours.ST, tblHours.OT, tblHours.DT, tblHours.Shift, tblHours.WorkDate, DatePart("q",[WorkDate]) AS...
  2. Apollo13a

    Combo box doesn't show data

    Hey JB, yes I set the column count property and the column widths property to 9 as you suggested. My subform combo still doesn't show a value. I also have a little vb code that refreshes everything after a selection is made in the combo on the main form. thanks Jim
  3. Apollo13a

    Combo box doesn't show data

    Hi, I have a subform linked to a combo box on my main form. I changed one of the text boxes in the subform(the name of the box is UnionNumber) to a combo box and now it doesn't show any data. The rest of the subform show all correct data. I set the record source in the combo on the subform and...
  4. Apollo13a

    Get week ending date

    Perfect. Thanks
  5. Apollo13a

    Get week ending date

    Hello, I have a query that daily labor hours and with dates for each day. I have this query to get quarter and week numbers. I now want to get the week ending date(always saturday). SELECT tblContractor.Contractor, tblJobs.JobName, tblHours.ST, tblHours.OT, tblHours.DT, tblHours.Shift...
  6. Apollo13a

    Workgroup not available-one answer

    Hello, In reference to thread thread779-1298830 . I have found one, of many, solutions. Scenario: Win XP pro, Norton Internet Security 2007. In "My Network places" I would receive an eror when I clicked on "View network Computers". I un-installed Norton for a number of reasons, used the Norton...
  7. Apollo13a

    Using linkMasterField

    Got it, I used With formname .LinkChildFields= link field .LinkMasterField= link field End With I guess I was doing something wrong but this works fine. jim
  8. Apollo13a

    Using linkMasterField

    hello, Is it possible to change the field that links the subform to the master form using LinkMasterField and LinkChildField? I'm trying to set the link field for a subform based on the response from a popup(vbyesNo). I have used some SQL in vba to change this field but if the user inputs more...
  9. Apollo13a

    Protect/isolate boxes on home network

    Well, I was thinking. The only way to join the network is to use the network wizard, right? My friend's son could connect to the router but not technically be on his network. That should isolate him and protect virus and trojans and al that stuff from spreading. Am I thinking clearly about this...
  10. Apollo13a

    Protect/isolate boxes on home network

    Hello, I am helping a friend add a 3rd computer to his home network. This computer is for his 14 yr. old son. It seems that his son likes to shut off virus protection on his computer and search the internet(not my issue :)). My question is, Is there a way to protect the other 2 boxes on the same...
  11. Apollo13a

    Getting part of a date

    Well, it seems I've found a solution but I'm wondering if it is the best way to go. I changed the data type of LaborYear to string and then using LaborYear = Format(!LaborDate, "yyyy") i get just the year jim
  12. Apollo13a

    Getting part of a date

    Hi, I'm trying to set a date variable equal to just the year of my returned date. some DAO to get the date info then LaborYear = !LaborDate LaborYear = DatePart("yyyy", !Labordate) My code gets the proper date but I'm having trouble extracting the year Can someone point me in the right...
  13. Apollo13a

    storing string data

    Hi, I've created a material pricing Db that holds material name, category and prices from different suppliers along with the price date. The user selects a category from a combo and I run some vba SQL code to fill a second combo that shows all material in that category, the user can then select...
  14. Apollo13a

    Getting latest date and ID

    PHV, I used the SQL in VBA (on Form Open) to set the row source for my listbox. Thanks again
  15. Apollo13a

    Getting latest date and ID

    Thanks PHV, that's exactly what I need. Although I have to open the query in order to get it to run. I would like to use this query as the record source for a listbox but I get an error. How do I set the record source of the listbox to this query and run it from my main form? Also, does this...
  16. Apollo13a

    Getting latest date and ID

    Well, I think I spoke to soon. I'm still trying to get the PriceEach of each product(tblMaterialID=21) from each supplier based on the latest date. Here's my current SQL SELECT Max(tblPrice.PriceDate) AS MaxOfPriceDate, tblPrice.tblMaterialID, tblPrice.tblSellerNameID, tblPrice.PriceEach FROM...
  17. Apollo13a

    OE6 missing emails

    Hello, HP laptop, XP home and OE6. I'm working on this issue for a friend. He has told me that he can send and receive email. He can read the email, but when closes Outlook express and re-opens it he has lost all of his previous email. He runs antivirus software. I was thinking maybe a corrupt...
  18. Apollo13a

    Getting latest date and ID

    I think I got it using this SQL SELECT qryGetLowestPrice.MaxOfPriceDate, qryGetLowestPrice.tblMaterialID, tblSellerName.SellerName, tblPrice.PriceEach FROM (qryGetLowestPrice INNER JOIN tblSellerName ON qryGetLowestPrice.tblSellerNameID = tblSellerName.tblSellerNameID) INNER JOIN tblPrice ON...
  19. Apollo13a

    Getting latest date and ID

    Thanks PHV, although I'm trying to get all Sellers that have a MaterialId=12 and show the latest prices(based on date) for each. Jim
  20. Apollo13a

    Getting latest date and ID

    Hello, I'm trying to retrieve the latest price date for a particular material ID. My db has 3 tables. tblMaterialDesc DescriptionID(PK) MaterialDesc tblSellerName tblSellerNameID SellerName tblPrice PriceDate PriceEach MarkUp SellingPrice tblSellerNameID tblMaterialID I'm using combo boxes...

Part and Inventory Search

Back
Top