Search results

Namliam, My utmost appologies, you must have posted as i was replying to MrQ. I will have a play and failing that I will post a copy of the db for you guys to have a look at, Many thanks to both of you for your help, it really is appreciated

Thanks MrQ, That is sounding hopefull, can I ask how you would set it as a caption tho as I could not get the Caption entry to take anything other than basic text?

Sorry I should probably have been a bit clearer. Manually changing field names I can do, but for e.g. if we just look at Query1, If I select from my form the reporting month of May, then the data in this query will be that of March, however if I selected June then this query will hold April...

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

I'm afraid I have to play dumb here, creating an SQL statement is easy enough, but I'm never quite sure what i should be doing with record sets...

OK discovered my problem is that I really don't want to be using a listbox... so going back to the original code above, is it possible for me to pull a set of email addresses from a seperate query? e.g. all a query for the email addresses of all the participants of a particular training...

Thanks for the info, Unfortunately on making this change I get an error message "Invalid use of a null" I should also add the list bos has the mails listed like: email1@address.com email2@address.com email3@address.com and not as a string, is this the problem?

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

Thank you so much for the quick response. I had tried various versions of the save command to no effect but this has workd perfectly, and my print and export report fuctions work perfectly. Once again many thanks Paul

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've done this and as much as it updates the query it also moves the form on to the next record. I need to update the field while remaining within the same record, is this possible?

Hi guys just to let you know I finally managed to find a way round this, it was a combination of things I'd been trying individually. The code I ended up using on the Click control was as follows: Private Sub CmdFindCommandButton_Click() If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord End If...

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