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

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

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

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

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

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

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

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

Hello, I'm using this code to parse a query and return the record count using strCriteria. TN is a string and SignInDate is a date. RecordCount should be 3 but it is returning the total number of records in the query. It appears findfirst is not using the strCriteria. Public Sub DupSignIn(TN As...

Hi, I'm using VBA to autofill records in my subform. However as soon as I click in the subform the record is updated. I want to be able to edit this record before I update. Autofill won't be used all the time and I need to be able to edit one of the fields if it is used. Any ideas on how I could...

Hello, I been trying to convert this sql to VBA but I keep getting an error "Syntax error in date query expression." Set rsDays = CurDB.OpenRecordset( _ "SELECT tblhours.LaborDate, tblhours.tblEmployeeID, DatePart(#yyyy#,[labordate]) AS Expr1, tblhours.LaborHoursST" & _ " FROM tblHours" & _ "...

Hi, I've checked the forums and have seen this answered but I can't seem to get it working. I'm trying return the Max Date. Here's my SQL SELECT Max(tblSalary.ChangeDate) AS MaxOfChangeDate, tblSalary.tblSalaryID, tblRates.Rate FROM tblRates INNER JOIN tblSalary ON tblRates.tblRateID =...

Hello, When I try to install ITunes the installer package takes me to the Itunes Setup Maintenance program. The only two choices are Repair an existing installation or Remove Itunes. Neither of these work for me because I don't have Itunes installed. Originally I did have Itunes installed on my...

My query contains dates for entered labor hours. How do I show just the records for the current week? My payroll period runs Mon to Sun. Thanks, Jim

Hello, When I run this function I get an error that says "Can't not find Table or query". The error is on the line Set rsDelete = CurDB.OpenRecordset(strSQL) Public Function DeleteRoutine(ID As Integer) As Boolean Debug.Print Dim IDToDelete As Integer IDToDelete = ID Dim strSQL As String...

Hello, How can I get the primary key of the row selected in a subform? I have a subform linked to my main form using a field called TicketNumber(not the primary key). My subform has fields as follows: tblReferralID(Primary Key), StartDate, Contractor, TermDate...

hello, When I try to use my immediate window it doesn't work. I created a public function Public Function Test() Dim x As Integer x = 4 Test = x End Function I called it from the immediate window using ? Test and my cursor moves down one line but that's it, no 4. I also tried with a space...

Hello, my report has sorting and grouping by in this order: EmpLastName, Quarter, Weekly, LaborDate. I have footers after weekly and quarter to show some calculations and totals. My problem is that week 10 shows up first on the report ahead of week 6, 7, 8 and 9. I suppose Access is using the 1...