Recent content by ChrisSedgwick

Hi there! I hope that what I'm about to write makes sense and I don't cause too much confusion... We have quite an extensive database (or at least it's extensive for us), around 250mb. It's a split database with the back-end being held on our server. It holds around 6 years worth of...

Hi, I'm trying to send a report using the EmailObject macro. I've completed all the relevant fields i.e. To, Subject, Message Edit etc. However, I want the macro to use an email template that has already been created and is held on our server. I've tried using the path for the file and also...

Did this ever get resolved as I have the same issue?

Hi guys, I've hit a bit of a brick wall when completing a form build. Basically I have created a form that allows the user to raise an installation order. The form works perfectly and takes all of the information from the form (which is stored in tables) and places it into a nice Report that...

Hi, Thanks for the response. Apologies, I've not explained it well. I have the text box as you've described that is se to Sum - how do I then get the result of this Sum to update in a table? Thanks,

Hi, I have a form that we use for adding orders. The order will contain product lines, so I use a continuous form to do this. At the bottom of the form is a text box that calculates the total cost of the order by taking all the unit amounts. This box is just used for displaying a figure on a...

Hi both, The link that moke sent did help, I did a quick Compact and Repair and it seems to have worked. It is a split database with multiple users with access. The BE is held on our server and multiple FE copies on the users' desktops. Not quite sure how it occurred but the Compact & Repair...

Hi, I'm not sure how this is happening, however I'm hoping that someone can help. I have a table containing a list of customers and their contact details. The table includes an AutoNumber field which is set as the Primary Key and Indexed with No Duplicates. We have over 650 records on this...

Hi, Is there a reason why a PasteAppend command will work on one machine but not on another? I've tried issuing a different front end copy, tried to diagnose the issue, however I'm not getting much luck. When I click the 'Copy Line' command button on my machine it does what it's supposed to...

Perfecto! Worked a treat! I'm new to VBA so haven't come across referencing a parent subform this way. I always assumed you had to use the forms index and go in that way. Anyway, lesson learnt. Thanks again!

Hi arnelgp, Thanks for your reply. I'm still receiving the referencing error. See images attached. Thanks, Chris

Yes, this is the case. I've left the Level_3_Product form open in the background and opened the main form. Run the same test and I get the preferred results. As soon as I close the form in the background. It stops working. This is where I'm now stuck... :(

Just to update you. I've managed to do what I was originally looking to do, by creating a Macro Event After Update. I created the macro by opening the LEVEL_3_PRODUCT form and tested it and it worked. However, when I closed the form and opened the main form which contains all of the sub-forms...

Hi, I'm trying to create and AfterUpdate event that will display a MsgBox if a Quantity entered into Box A, is greater than the Quantity shown in Box B. I've managed to find a piece of code on this forum that sort of looked like it was what I needed. However, in my circumstances, it isn't just...

Hi jdraw, Apologies, I didn't think to add the relationship structure (how did I assume members were going to be able to help without this?). I have now attached a screen shot of my relationship structure. Hopefully this will help. Please let me know if you require any more information...