Search results

Right, I've managed to (almost) sort everything out. There is just ione problem getting in the way now and that is that the code wont send to multiple email address. Instead it produces the following run-time error: Run-time error ‘-2147024891 (80070005)’: IMessage::ModifyRecipients returned...

cheers for the tip Sergeant, Have put in a bit of extra code but i'm still getting the security warning (although 'yes' only needs clicking once now) and my emails are now ending up in the drafts folder, whereas they were in put in the outbox before. Any help would be greatly appreciated here...

Hi all, i've just downloaded redemption and set a reference to it, but am unsure how to adapt my code so that it makes use of it and by-passes the access/outlook email warning. If any one could have a pop at modifying my code so that it makes use of redemption that would be greatly appreciated...

Hi all, My goal is to update my product table to show the new stock levels after an item or items have been ordered. Currently I have an order form, which includes a sub form where the user can select the products that he/she wants to order. The subform is in datasheet view. Back to the...

Heres some of the code I have been using, that creates a single letter, based on a pre-made template. Private Sub MergeButton_Click() 'Variables for holding strings (text) Dim AddressLine, Dear As String 'Start building address line by dealing with blank last name and company fields If...

Hi all, As the title suggestes I would like to write some code, that on a click of a button on a form, a mail merge letter is created in Word that includes all of the customers currently held in the db. I've searched the forum already but haven't really found anything that appears...

Nice one raskew, thanks very much for your help, you've sorted me ouit a treat. Cheers

Ok, so retrieving the dates for the last 7 days and 30 days is easy enough, but how would you retrive all orders made within the last calendar month?

Cheers chaps, thats really appreciated

Hi, I wonder if any one could help me with what I think is a simple query. I would just like to show all the orders thats have been made within the last 7 days. So far I can retrieve all the orders made today, by using 'Date()' as my criteria, but cant figure out what criteria to use for the...

Hi all, In some of my forms i would like things such as combo boxes to retrieve their values using VBA code rather than them just being based upon an access query. My aim is replace all my access queries with just VBA. So far I am able to retrive values from the DB and put them into text...

Hi guys, thanks for your help, but things still arn't working. I think the problem is to do with the Null in my, If clause. The code works fine where there is an orderId (in the deliveryTBL) that is equal to the orderId on my form. But it crashes when there isn't an orderID (in the...

Hi yeah, have just tried that, the code now errors (at the highlighted line), saying :Run time error, the value you entered isn't valid for this field. If IsNull(myRecordSet.Fields.Item("DeliveryID")) Then Reports![OrderInvoiceRPT]!DeliveryRefText.Value = "N/A"...

Hi all, if any one could help with this problem it would be much appreciated. My Problem: I would like to be able to display "N/A" in the delivery text fields on my report where no delivery info actually exists. Displaying the necessary info where delivery info does exsist is fine, my code...

Hi all, I have an order form (orderFRM) which displays info such as who the order belongs to, the invoice number, payment method etc. This form inturn includes a subform (orderProductsFRM) which displays information about the products that are included within the order. This subform is...

cheers the stoat, you have come up trumps again.

yeah, the customer table does have only one record per customer. what i want to do on my form, which already displays a customers id, is also display their first and last name in seperate text fields. Hence pulling the id, first name and last name back in a sql statement where the id in the...

Cheers Stoat, it was the single quotes, not needed at all. Now all I need to do is figure out how to make the value of a text field contain the first name that wa pulled back from my sql statement. cheers again

Hi, I have the following Select statement where basically i want to retrieve a customer's first and last name depending on the customer id that is already shown on my form (the customer id on the form is being displayed in a text box, CustomerIDText): Dim cnn1 As ADODB.Connection Set cnn1 =...

supplierProductID isnt shown on the form, this is the auto-number field that is created in the first table (supplierProductsID), when a supplierID and productID is added. This auto-number then needs to be added in the supplierProductID field in the stockRecievedTBL in order to link the two tables.