Recent content by crug

Thanks i'll give that ta try

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...

Dont i have to open the report first ? As it is i print the form that the data is input,

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...

That all i think i`ve sorted it

Any ideas ? pointers ? i can export to excel and i can open outlook from access but i wanna combine those functions

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 ?

How about Between DateAdd("m",-3,Now()) And DateAdd("d",0,Now())

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 -...

Thanks for your tolerance of my ineptitude I`ve attached a pic of the form and table layout The code is Option Compare Database Option Explicit Dim db As Long Private Sub cboWeight_AfterUpdate() Me![GCResult] = DLookup("GC", "TblAll", "[Weight] = '" & cboWeight & "'") End Sub Private Sub...

I dont think i explained too well What i want is the user to quickly pick a letter. input a weight (different for each letter) by typing and produce a number via a lookup. The number is unique for each letter/number combination and stored in two fields

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...