Recent content by RT

I'm constructing a label report that can print a certain number of labels (given by the user) for a certain client, or clients. I saw a way of doing this by appending the address for those clients into an emptied table however many times they were needed. After rereading your previous post, I...

I cannot do that because I want to run the query multiple times for the same input to append the same information repeatedly and I only want the user to enter how many times to run the query. Thanks Rich

I want to run an append query with parameters. I believe this can only be done from within VBA by explicitly writing the SQL (as I cannot pass a parameter into an access parameter query using VBA code). Is the best way to do this using the 'DoCmd.RunSQL' syntax, and if so, how do I refer to a...

because they need to be able to choose any number of options from the list.

I've actually just realised that its giving the error message 3 times, so it's nothing to do with nameing the text box.

Private Sub FrequencyCheck() Dim freq As String Dim length As Integer Dim ctrl As Control Dim strSame Set ctrl = Forms![Dispatches subform]!Frequency If Not (IsNull(Forms![Dispatches subform]!Frequency)) Then freq = Trim$(Forms![Dispatches...

To be more specific, I have written some VBA that validates a frequency field. The code is run before update of the field. However, if the user enters incorrect data, the error message pops up as many times aas there are records on the screen. I am only assuming this is due to the fact that...

How do you refer to a single field on a continuous form, as for example, if you have a 'client' text box, all records shown on the form will have a text box called client and any reference to client seems to be ambiguous. Cheers Rich

I am trying to display the current month name in the header of a report. I have managed to get the month number using the Now and Month functions, but I cannot find a way of converting this into the month name. Is this possible or is ther another way round it?

I have been having a bit of trouble trying to find the correct syntax for running an Access macro from within an Excel macro. Could anyone please help.