Recent content by MacCaillean

Hi chaosguy - in the same OnClick event for the Generate button, after the code we've already discussed you can add something like... Me!txtDeposit=0 Me!txtWithdraw=0 Regards Mac

Hi Chaosguy Make your "Credit Card" table the RecordSource of your form. Make the "Card amount" field the Control Source for your txtTotal field. Stick some code behind the Generate button, in its OnClick event, something like Me!txtTotal=Me!txtTotal+Me!txtDeposit-Me!txtWithdraw Easy - but...

Hi TN If you change your Case statement to look for "Source " (where the last character is a space), does that achieve what you want? Regards Mac

Hi AT76 Instead of the whole table, you need to base your report on a query that includes only those RESPONSEs that are not null. Regards Mac

Hi Mike You are trying to calculate the number of records on a recordset that has already been closed and set to Nothing. If you still get problems when you move your Recordcount statement, you might like to check out the VBA Help for the DCount function. Regards Mac

Hi molly The likeliest thing I can think of is that your image in Photoshop has some transparent pixels. JPG does not support transparency so you end up with parts of the image that are white instead of transparent. Export your images as GIFs instead. Another possibility is that you need to...

Hi imarosel Unless I'm way off the mark, your Method=TestFiles looks to me like a simple parameter name-value pair, where the page "admin.asp" is called and requested to display only those records where a field called Method equals "TestFiles". So, you need to look at the query/table in the...

Hi ckroon Modify > Templates > Detach from Template Regards Mac

Hi sunmorgus Do you need to have "RMA Base Form" open before you can set its .Recordset? So, add DoCmd.OpenForm "RMA Base Form" before you try and set the recordset. Worth a try... Mac

Okay Scott So you don't need to store the value and you don't need to display it on the workorders form. You just need it set to show the current workorder assignment on an employee form. Okay, easiest way is probably to add a dropdown to your form. This dropdown will get its source data from...

Hi SierraBlind Are you happy to discard historical information about the workorders each employee has worked on? If yes, you can store the workorder number in tblEmployees as you suggest. When the employee completes that workorder and is assigned to a new one, however, the information linking...

Hi Jim I think I was on Office 97/Windows 2000 Pro SP6 when I was getting my problem, which incidentally was the subject of my very first post on Tek-Tips. Although I'm on XP now, as I said, I have taken to using menus instead and simply avoid the issue. What was happening to me was that on...

Hi Jim I have had similar problems in Word and have failed to resolve them. Instead of command buttons on the page I now usually implement a new menu instead. Regards Mac

Hi tekkyun Have you tried checking the options setup in each copy of Outlook. As an example, if one user's Outlook is set up so that he needs to supply a password before mail will be sent, that could interfere with your code. If there are any options set up differently from your PC, try...

Of course you don't - sorry, the word macro just didn't register with me. Okay, you'll have to convert your macro to VBA. Highlight your macro in the list and then choose Tools > Macro > Convert Macros to Visual Basic. The VBA window will open and you can find your converted macro by...