Search results

Hi All, I have what I'm hoping is a simple update query...just can't get my head round it (might need some coding) Table 1 ID..........Description A...........Tools B........... C........... D........... Table 2 Description Requests Tools Accessories Kits This is an exercise to assign new...

Hi All, I'm sure there is a simple solution to this problem but I just can't find it, and looking on this forum i can find several ways to refresh the subform but not the main I have a Form and a subform (frmMaster and sub_Paid) on the subform, sub_Paid I have a field called dblPaidValue this...

Hi All, Have searched the forums for an answer to this (hopefully simple) question. I have a query out of access that displays the completed actions for a previous month. I take this and paste it into an excel file that contains the monthly scorecards. Now in an ideal world I would link this...

Hi folks I have a database that arranges training sessions. It sends out the meeting requests automatically. What I'm trying to do is add ann attachment to the mail...now I know how to do this by manually adding the file location, problem is the attachement is a different file for every...

Hi Folks I have searched and searched on this forum and the web for a solution, so far to no avail. I basically need to send on the click of a button a mail independently to several people (1 email per person) Now I have a way to do this using a loop function using recordsets and the...

hi folks I've had a search on the forum to no avail... I have the following code that sends an email... Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sccname As String Dim sSubject As String Dim sMessageBody As String Set MyDb = CurrentDb() Me.Refresh Set...

High folks, Essentially I have a database thatsends out meeting requests as an AppointmentItem. The replys are automatically sent to a certain folder in my inbox. I also found a second bit of code that pulls mail details from a chosen folder through to access. My problem is as follows, the...

Hi Folks, Have dug around in the forum for an answer to this question but to no avail. i have a training database that is used to book training courses. On booking a course it sends out a meeting request in Outlook using the code below... My question is that for each training course I have a...

Hi Folks, I have a bit of an odd question that I'd like to pick your brains about... I have a report that runs from a date selection on a form...for e.g. If you select you reporting month as June, it will provide the data for April May and June. at the moment I have 3 queries, query1, query2...

Hi Folks, I'm sure this is a very quick question, with an obvious answer but looking on the forum I can't find it. I have a button that on click sends out meeting requests, I also have an update query that ticks a box to say the email has been sent "UPD_WaitingList_Added" what I've tried to do...

:DHi Guys, I'm hoping I can pick someones brains to solve what I think is probably a simple problem. I am building a system that arranges training for people, and when we assign them to a course they are automatically sent a meeting request through outlook. Now I've got all the tricky stuff...

Hi Guys, I'm wondering if anyone can help me with the following, I'm not sure if it is even possible... I'm creating a databaase to log training requests and courses. The principal is as follows 1) Manager requests their employee is put forward for training 2) Trainer adds employee to waiting...

Hi Guys, I've tried searching the forums for an answer with no joy. I'm trying to create a very simple DELETE query, which I've never had an issue with before. Basically I have two tables Dbo_PDRPerson (PersonID, RoleID, PDRID) tbl_InfoByPDR (PDRID) Basically I want to delete all records in...

Hi Folks, Have what I think will be a fairly simple problem but I just can't get the sql statement correct. I have a query; qryTopTen With the following fields; Material Planner Quantity Basically what I'm trying to do is return the top ten results (by Quantity) for each planner number for...

Hi Guys, Need a little bit of help, I have a report I pull out of an inhouse system with sales, shortages etc. I want to use a query to alter the formatting slightly and append it in to a different table. Most of this i can do fine, except for one thing. Two of the sales fields in my report...

Hi All, Having a problem with a report, I have a form that i use to enter a new record to my database, what I want to do is put a button at the bottom of the form to print the record (via a report) If I base this on a record that already exists, it works fine. However, If I have just entered...

I have a form linked to two talbles: tblData MaterialID (Autonumber) MateialCode (Manually entered catalogue number) tblBarcodes Barcode ID Barcode The barcode ID is basically a list 1,2,3,4,5 etc against a list of usable barcodes and the idea is in my form frmEntry I will add a new Mateial...

Hi All, I have a form from with a button that exports data in to excel using the following on click code DoCmd.OutputTo acOutputQuery, "qrySoftPDR2", acFormatXLS, "FOBPDR.xls", True 'open in Excel The problem is that if I go in to an existing record it works fine. However if I have just input...

Hi All, This is such a newbie question I realise, but I have a form (frmFOBEntry) with a combobox (cboMarketCode) which returns a list from tblMarketCode. New records are added to tblMarketCode using a form frmMarketCode When I look through the combobox on the first form if the MarketCode I...

Hello Again I've searched the forum but can't quite find what I'm looking for. I have one main table (tblFOBData) with the fields Material, MarketCode, Vendor and Cost. I also have a form that uses the Material and MarketCode fields in cascading combo boxes and this works fine, However, If you...