Search results

Thank you - that Solved. :)

Thank you - that helped.

Hello people. Can someone tell me how I show the source of the data in a query without adding another field in the table.? I want to pick up expiry dates from a number of tables in a series of expiry queries. E.G from plant register - expiry of registrations etc from training register -...

I think I know what I've done....Doh! Thank you MarkK

My database is installed in a server environment. Back end and Front end. When I log into the server and open my front end, I have full control. Yet, one of the users, on his server profile, all he can do is read. He cannot enter data. I have installed and reinstalled the front end, yet...

Hello I have a front end and back end on a terminal server. The front end was opened the other day by an administrator (direct from its location on the terminal server). He found he couldn't log in. The issue was that all the VB coding was gone. This has happened twice now. There was a...

I have a list box returning values from a query. The query is based on my table called: tblinductionexpiry. The table captures induction dates of Contractor Employees. The PK is; Induction_ID. Contname_ID ...fk and ContEmplName_ID fk. Obviously contname_ID shows up evertime one of their...

Like this...? Sub CreateStatusReportToBoss() Dim myItem As Outlook.MailItem Dim myRecipient As Outlook.Recipient Set myItem = Application.CreateItem(olMailItem) Set myRecipient = myItem.Recipients.Add("Dan Wilson") myItem.Subject = "Status Report" myItem.Display End...

Hi I have researched the internet and am able to send an appointment to Outlook for re-scheduling expired training. I have used the following code. Private Sub Reminder_Click() Dim Outlookapp As Outlook.Application Dim OutlookAppointment As Outlook.AppointmentItem Set Outlookapp =...

I have a data base to manage members of a boat club. I have a fees table - just used for String. The fees table only has FeesID, Fee. $72.50, $36.25 $145.00 Members pay fees depending on their category. So, my members table: MemberID - Autonumber Name - Shorttext CardCode# - number...

Please can you tell me. Is it possible to calculate part years using the DateAdd function I have set up my Expiry_Period feild in decimals in the hope that entering .5 would give me half a year. eg: DateAdd("yyyy",[Expiry_Period],[Date_Completed]) Alas, no result. I perhaps could use...

Galaxiom. I have now gone through my application and removed any stored dates for expiry. Expiry dates now appear on all my sub forms (based on queries) with calculated dates. I had to go into the tables and remove the expiry fields and replace with an expiry period. The user can select this...

I understand I think. So, expiry period is a value i would enter instead of storing the actual expiry date. And, the query would actually calculate the expiry date (not store it). Say: Date_Completed is a stored value Expiry_Period - is a user...

Training date is the date that the training occurred on. Expiry is not a calculated field however. So, not quite sure what you mean. I.E; a first aid cert lasts for 2 years. The expiry date is mandatory. Some Unit Standards have expiry dates as well such as Powered Lift Trucks, or Elevated...

Sorry. Been away. Have just read your reply (Glaxiom). Thank you for taking the time. I didn't know that you could return data in a query from unrelated tables. I will let you know how I get on. Again, thank you.

You are trying to justify your ill-considered decision to denormalize the data. My advice is, don't do it. do you have to use such damning rhetoric? the energy you've used to slam my idea could have been put into giving a bit more detail. seriously mate. I asked a genuine question. If you...

Hi Am hoping you can help. I have a database that is a health and safety application. In it I can record training (with expiry), plant maint (with expiry) and a variety of other things for which expiry date is important. I have a table called.....tblexpiry. My plan is to run append queries...

how do I make this a solved thread.....?