Search results

Yes, DT is date. It is a general date (including time)

I have a table FCData with the following fields FCData ------------ ID ----> auto assigned primary key Emp_ID DT ------------ On any given day an employee, represented by Emp_ID, can be recorded multiple times. I want to know if I can query to show how many times per month an employee is...

Hi, yes, the rsSession! did fix the problem. I think the code is fine now, but I have other problems. The machine I created this on is a thin client and it can't perform the code. It crashes every time. I have a desktop with Access 2007, but it does not seem to recognize the recordset. I am...

I got past the runtime error 3061. It happened to be a punctuation mark that I accidentally put into my code in Access. I am however, having issues with this segment of the codeDim outobj As Outlook.Application Dim outappt As Outlook.AppointmentItem Set outobj =...

I took a stab at this. Here is what I've got. There are a couple extra fields than the initial table. Private Sub SchedOutlook() Dim rsSesssion As Recordset Set rsSession = CurrentDb.OpenRecordset("SELECT * FROM Session_lst WHERE HR_Apprvd = True AND Appt_booked = False", dbOpenDynaset)...

I have a table (Session_lst) which is a list of appointments. It has the following fields Session_lst --------------------- Session_ID Session_date Session_time Session_duration Agent Agent_mgr Appt_booked --------------------- I want the table to book the appointments with myself and the...

Many thanks!

Hi, I am having issues with the following code: Private Sub AddAppt_Click() On Error GoTo AddAppt_Err ' Save record first to be sure required fields are filled. DoCmd.RunCommand acCmdSaveRecord ' Exit the procedure if appointment has been added to...

I should also say that this would be much easier if I had access to an employee database where there was a relation with the EmpID as primary key, but that is not the case. So I guess my problem is finding a way to loop the SQL for many instances of that EmpID. Since it is not a unique...

by nearest date I mean the most recent date (dmax?) for that EmpId where City <> 'unknown' Basically there is a possibility that employees move cities, though small. So I want to find the most recent date to have the 'unknowns' replaced with the most accurate records possible. It's a case of...

Two months ago something happened to a server that caused a bunch of data collected by an application to corrupt a field. The database is a collection of information about employees, some served from another database (where the problem originated) and some collected in a form. To simplify...

I have a table of accounts with the following fields Account_ID First_Name Last_Name Institution Account_type I have created a form that allows me to enter in new records via text fields (list box in the case of Institution). What I want to do is to have a query search an existing record as...