Search results for query: *

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

Okay - set up a variable and then supply that instead. Dim MyFilename as String MyFilename="ExportIPs_" & Date() & "_" & Time() & ".txt" Then in the TransferText command, set the filename parameter to be MyFilename. Rgds Mac

Hi elvanace1 One of the parameters of the TransferText action is the filename you want to output to. So instead of just supplying a string as a name (e.g. "filename.txt"), you can add variables (e.g. "filename_" & Date() & "_" & Time() & ".txt"). Hope this helps Mac

Hi Orangearium You need to base your report on a query which contains both of your tables. The query should contain totals - to do this, click the Totals button (sigma symbol) on the query design toolbar. From your primary table, add the appropriate unique field, e.g. the serial number or...

Hi strublepeter Have a look at thread705-79802. Hope this helps Mac

Hi xEzekielx Okay - just to clarify - a single report needs copies to be printed to different printers, and you want to change the settings on the fly. The code you run just now appears to successfully change the default printer, but the report still prints to the old one. Things to consider...