Search results

Hi all I have a table "tblEmployee" which has "name, employee_no, manager, etc" I recieve from HR a updated spreadsheet which can have new employees or just updates. ie new manager name. I can run an update query to update changes based on the employee_no which is constant. How can i add new...

Hi all I have a database that collects data to a table. If there are items missing a checkbox is ticked and then the record saved. When the record is viewed later, i want the user to be able to dlookup a value in the table and if this matches then update the checkbox value to unchecked Anyone...

I am using strMail to send an email with an attachment The email address is stored in a table (tblMail) I can populate the To, CC and BCC Anyone know how to add a third To and CC field in the code ? Thanks Private Sub CommMail1_Click() Dim Response As Integer Response = MsgBox("Do you want...

Hi all I have a data input form (Form1) In has various lookups based on input data, then the values are saved to a table. It has a print button to print data on form. It also has a return button (which runs a append and delete qry via a macro ) When the return button is pressed i need to...

Hi all this is doing my head in. I can transfer my query to Excel ok and i can send a report to Email. But what i want is to be able to attach my query in Excel format and attach it to an Email and send it without any warnings. Any ideas ?

Anyone know if i can use DateAdd or something like in a query to show current month I want the user to be able to see records for the month we`re in Thanks all

I`m using a calender to pick a start date and end date shown in two combo boxes. I can store this value in a table with fields StartDate and EndDate I want the user to be able to pick the dates and show query records between these dates I thought i could use something like -...

Hi all Its my first time on this forum so please be gentle with me ! I have a list of numbers stored in a field (wieght). I have another field that is the product field. I also have a list of letters (A-D) Now, the weight can be 1kg (through to 20kg) A-D hence four different values in my...