Search results for query: *

Can't seem to get my head around this one. I am upgrading a database that keeps track of employee attendance points. I have built a Macro that runs a series of queries to update records and such on an employees record. The problem I'm having is I have made a make table query to form the...

I am running Exchange 2003 on a Server 2003 machine. Recently have discovered that we had one customer that we could not send or receive emails from. I turned up SMTP logging and sent test to the customer and this is the error message that I got: Event Type: Error Event Source: SMTP Protocol...

I am fine tuning a database for our HR person. I have run into a problem that has me stumped. I need for the query to return employee records for a date of an attendance offense and all records for events 365 days back. Below is what I have now, however Access says that the expression is too...

I have a query field called TRDATE that is the date of an attendance offense. I need to retrieve all records based on the report date minus a year. Between Date()-365 And Date() doesn't work because my report date my be a week or more ago based on payroll periods. Please help. Thanks

I am writing a macro to SetValue in a field on my form. This will activate on the AfterUpdate event from the Verify checkbox. I believe this to be the expression I want but, for the life of me I can't get the syntax right. I've tried so many different combinations. I just keep getting the...

I have been working on this now for weeks and I am stuck. I hope that someone can help me with a solution. The following queries are working together to calculate hours worked and rate of pay for a worker at a particular client. Each worker may have different rates of pay at each individual...

I have a query to pull pay rates for workers. All workers have a base rate which pulls from WorkerPayrollQry. Works fine. Also, some workers have a custom rate for certain clients (could be higher or lower than base rate) this comes from WorkClientPayrollQry, Works fine. Problem: I joined...

OK I am in over my head again. I have developed a query to run my payroll reports from and generate an electronic file to send to payroll company. The following query works really good for our purposes except if there is overtime. Once a worker goes over 40 hours in [Time worked], needs to...

I have an unbound text box that the user will enter a date for service. That date must be between the AuthStart and AuthEnd dates. I have been playing with this for a while and just can't get it to work. What am I doing wrong? Private Sub Date_BeforeUpdate(Cancel As Integer) If Not (Me!Date...

I have the following code, but being new to VB, I need help so I don't mess it up. Now the code uses the system date to Insert into all records. But I need to have the code prompt the user for the FromDate instead or I could put an unbound text box called FromDate on the [Authorization Client...

I am calculating shift duration from [Starttime] and {Endtime]. Everthing is great until my endtime is Midnight. Then I get negative value hh:mm. If a person starts work during the midnight hour and ends at say 7AM, I get the wrong value. Here's the query I have so far but I need help...

This main screen is for authorizations for service with 9 subforms. Each subform holds times for a particular service completed on that day.It works great but every time I add a new record to one I have to advance all the other subforms manually to stay in sync with it. I want to out a command...

thread702-396121 I am wanting to send automatic emails from Access 2003 when I cancel a schedule. I have found the above thread to be very helpful in creation of the code. But, I am having an error and I am afraid that I my be off base with it. I have been working on this a long time and need...

I want to have the password masked as it is typed in only to show symbols such as black dots. I am working with Access 2003. Is that possible in this program?

I have done this before, but cannot remember for the life of me how I did it. I have the query below: SELECT [Worker table].WorkerID, [Worker table].WorkStatusID, [LastName] & ", " & [FirstName] & " " & [Middle] AS WorkerFullName, [Worker table].Phone1, [Job Description].JobDescID, [Job...

I have an unbound text box in a subform with the following IIf statement: =IIf([Day]=1,Forms![Master Schedule]!SchHCWeekHrsSbfrm.Form!Day1,IIf([Day]=2,Forms![Master Schedule]!SchHCWeekHrsSbfrm.Form!Day2,IIf([Day]=3,Forms![Master Schedule]!SchHCWeekHrsSbfrm.Form!Day3,IIf([Day]=4,Forms![Master...

I have a query that searches a worker's general availability as stated in the availability table. This is when worker's are available to work. then I link that to the schedule table. I want to see what workers are not already scheduled during a particular time frame that day. The first query...

I have a continous form of daily schedule records. It currently lists records by date just fine. But when I have multiple shifts on the same day, I need them to list in order of earliest to latest time. I've been bangin on this for a couple of days and cannot figure out how to get sorted by...

I have a Master schedule. When complete I have a command button to append to the [Schedule1] table. I want a query to run to check for existing records first (in case they already were appended. If no records found then I want my append query to run. I don't know how to write the code for...

I have a pretty large application that I am creating and in the process of developing this I started receiving a strange message when opening the table - [Scheduletbl] from the frontend database. It's an "Enter Parameter Value" message: Forms!SchedSearchList!ScheduleClientfrm.Form!ComboJob I...