Recent content by frankbutcher

Hi Is it possible to add a set number of records to a table, based on a field in another table? I have a table, tblGeneralDetails, with one of the fields being Size. If the value of Size was 5, can I add 5 records to another table (tblIDDetails) Also, then to lock the number of records so no...

Thats great, thanks very much to all replies... :-) Frank.

Many thanks for the quick reply. frmCalendar was taken from a db from a thread a while back:- Private Sub AXCalendar1_DblClick() On Error Resume Next Dim datRet As Date datRet = Me.txtDate DoCmd.Close acForm, Me.Name Screen.ActiveControl = datRet End Sub Thanks. Frank.

Hi I have a form linked to a table (via a query) with a "diarydate" field. When I double clickon the field on the form, it opens a calendar, I double click on a date and it adds it into the field. This works fine, but it will only add the date into the table once I go to the next record and...

Hi I have a button on a form, which updates the numnbers of records in 4 tables. When the button is clicked, it deletes all records in the tables, and then adds the records back in from another table that is linked. Part of the code is below:- ---- Dim stDocName1 As String stDocName1 =...

I get the error message in the message box saying "The Email has not been sent, errors have occured" ( I think I should have written this info before..!!) I uninstalled 2010 and reinstalled 2007 and it worked. I then uninstalled 2007 and put 2010 back on and the same error message appeared...

No, there doesn't seem to be anything checked. It doesn't work with another Database as well, so I am thinking it may be a setting on Outlook 2010?

Hi I have recently upgraded to Outlook 2010 from 2007, but my Access is still at 2003. I used to send emails from Access with Outlook 2007 with the following code:- --------------------------------- Private Sub Command67_Click() On Error GoTo Err_Command67_Click Dim strMailto As String ' email...

I have another DB which uses the same sort of code, and it is doing the same. When I stripped down the code, it was high lighting this line:- DoCmd.SendObject , , "RichTextFormat(*.rtf)", strMailto, strMailcc, "", strSubject, strMessage, True, ""

Hi I have a button on a form which sends an email out automatically. I recently had to re-install Vista on my laptop, and after I did that, the button does not work. It was working perfectly fine before, but not after. All others aspects of the DB seem to work fine. The code is below. and...

Thanks for your replies, much appreciated. I did try adding the line:- rs!Buy= ctl.ItemData(varItem) But it added the SKU number into the Buy field....which sort of makes sense. Not sure how I get it to copy across the Buy field from the material list... Will see if I get any luck with the...

Hi I have a form, from where I choose the material I require, from the material list table. The form has 5 combo boxes on it, each combo box is a catagory. There is also a list box on the form. When all combo boxes are blank, the list box lists all the materials. When I choose from the list...

All I have a form with a sub form on it. Through a few combo boxes on the form (f_MaterialList), the user picks an item they need, clicks the "add" button and it adds it to the sub form ( f_MOF_S ub) On the sub form, they are 4 fields (amongst others), "ProjectNo", "MOF", "Sku and "Submitted"...

Any ideas anyone? Many thanks.... Frank.

Hi all. I have a form with a sub form. I have a button on my form which takes the info within the sub form (a list of materials) and then puts them into a report. Within the sub form (datasheet view), there is a field for Quantity, which I change for each item. What I would like is to check...