Search results for 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...

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

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

Perfect. Thanks

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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