Search results for query: *

Thanks for your help Missinglinq! Just what I needed. Sorry I didn't respond earlier I had to leave to deal with a family member's health issue.

Thanks trevil620. You were right on. After entering the password hold down the SHIFT key while hitting enter.

How can I open a password protected database where the Navigation Pane was disabled. If I hold down the Shift key while opening the database the enter password box comes up. I enter the password and the database opens but the Navigation Pane remains disabled. Any help would be appreciated.

Thanks for taking the time to read my post. A user asked me to provide her with spell check on a specific field in a form. The name of the control is StatusNotes. So on the AfterUpdate event of that control I used the following code: Private Sub StatusNotes_AfterUpdate() On Error Resume Next...

Thanks for reading my post. I was looking for a good way to automate downloading files from the web and I came accross thread705-1670052 with a link to the Vbnet website http://vbnet.mvps.org/index.html?code/internet/dofiledownloadcustom.htm Even though I don't really understand most of...

Thanks Zameer, geat idea. I'm implementing it and I thing that solves my problem.

Thanks for reading my post. I need to generate daily time sheets for 3 groups (departments) of employees. I’ve created a form, frmTimeSheets the record source is qryTimeSheets that selects all active employees by department using cboDepartment on the form. There is also a calendar control on...

Thanks very much for your help Lameid!! Worked great. I'll take to heart your advice about minimizing the use of "D" functions, but in my particular situation I can't think of another work around. Thanks again, have a great weekend.

Thanks for reading my post. I've been working on a Payroll Db. In one of the queries the pay record information for all active employees for a two week period are returned. The criteria for this query is: [Forms]![frmReportDates3].[PayPeriodID] There are two other controls on this same form...

Thanks to all; SkipVoughtm, Lameid, TheAceMan1, jsteph and JoeAtWork for your contributions to my education. Your generosity in sharing your knowledge and experience always amazes me. TheAceMan1 and jsteph's comments about "typecasting" were very helpful. This was something I knew nothing...

Hi lameid, thanks for taking the time to responding to my post. I'm not using VBA. I included the "$" in the examples only to indicate that the pay rates used come from the pay rate tables with the format set "currency", decimal places set "auto" The field [PayCommOTRate] from qryCommOTRate is...

Thanks for your help with this Skip. Example of specific values use in the OT calc IIf([RateType]=1,([240]/60)*([$15.25]*1.5) Actual calculated value $91.48 Expected calculated value $91.50 IIf([RateType]=2,(([240]/60)*[13.39]) Actual calculated value $53.57 Expected calculated value...

Thanks for reading my post. I'm working on a payroll db and stumped on understanding why I'm getting rounding errors in a totals querry that calculates total pay. I start with a query that calculates hours worked (in minutes) from tblLaborHours. TimeStart, LunchStart, LuchEnd, TimeEnd - all...

Thanks PWise! Worked great. Appreciate your help.

Thanks for reading my post. I'm working on a Payroll Db. I need to capture on an entry form "frmLaborHrs" the "PayPerID" from "tblPayPeriods" where the "frmLaborHrs.LaborDate" (Date/Time field) is between "tblPayPeriods.PayPerStart" (Date/Time field) and "tblPayPeriods.PayPerEnd" (Date/Time...

Thanks PWise for taking the time to read my post. I guess this must have been an ID ten T error. I tried doing this several time yesterday, and although I was getting no error messages, none of the detailed records were showing up in the subreport as expected. In frustration I dumped what I...

I have been asked by our Payroll Clerk if it would be possible to combine two reports she uses each pay periord (2 wks.) into a main report and subreport. I can't see a way to do this but I thought I would try some greater minds than mine. The first report pulls labor hours from a JobCost Db...

Thanks Lameid and Randy700 for responding to my post. Sorry to be so long getting back but I've was fighting a flue bug. The bug won. Lameid, I had dubble checked that the "?_" did not have a trailing spaces and that each of the forms did in fact have the code in the BeforeUpdate event...

Thank you for reading my post. I am using code provided by TheAceMan1 to perform required field entry validation. It works as expected for the main form and the 1st nested sub form, but does not seem to work on either the 2nd or subsequent nested sub forms. I am tracking Customers, their...

Thanks again Duane, that's just what I needed. I'm very thankful for your willingness to share your wealth of knowledge.