Search results

Hello RuralGuy There are times when one's brain should go for an overhaul. And this is the time for mine. The error I made is in the first line of the VBA code: Private Sub Command5_Click() Dim stDocument As String Dim strWhere As String strWhere = "1 = 1 " If Not IsNull(Me.txtSTARTWEEK) Then...

Hello RuralGuy Would you be able to download a PDF from the YouSendIt website? I can create a series of screenshots and put them together in Corel Ventura and then create the PDF with Adobe. As I can't find a method for sending screenshots in this forum, I would upload the PDF to YouSendIt with...

Hello RuralGuy Yes, I have tried every conceivable event. My problem is that it was working fine. I left the program for a couple of months, then returned to it last week and the problems began. Regards Terence

Hello RuralGuy Many thanks for getting back to me. Access 2002 on Windows XP Media Regards Terence

Printing two selected week numbers Hello RuralGuy I don't think the query is the problem. I have a form with two text boxes. First text box is called txtSTARTWEEK. The second text box is called txtENDWEEK. There is a command button on the form that opens a report called rptPRINT TWO SELECTED...

Hello All Made a small error on the "Between" statement. Should have read Between 01 and 13 The weeknumber is of course a number. Regards Terence

Hello All I have written an accounts database for a friend. At the moment I have four reports showing: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter These are based on Select queries where the criteria widow has the following code for the 1sr Quarter: between "01" and "13" This works fine...

Many thanks Rsmonkey, I will do just that. Regards Terence

Hello all At the moment I am able to create menus on a form driven by macros. They work very well. But after looking at a number of professional databases with drop-down menus that look the same as a Windows program with the toolbar and drop-down menus, my own efforts look feeble indeed. I...

Help a thickie Hello Guss2005 When the user loads the query, the "Enter Parameter Vaue" dialog box opens and the user will be expected to enter the required week numbers. Where do I enter the code?

Hello Guus2005 Many thanks for your reply, but please help a thickie out here. When I run the query, the "Enter Parameter Value" dialog box will appear and the user then has to enter the two weeks number. So where would I have entered the code?

Hello All I have a number of Select queries that select 1st quarter up to 4th quarter of the year for accounting purposes. These are quite simple queries such as: between "10" and "24" entered in the Criteria window. 10 and 24 being week numbers. However if I wish to randomly select the week...

Hello All I have a number of Select queries that select 1st quarter up to 4th quarter of the year for accounting purposes. These are quite simple queries such as: between "10" and "24" entered in the Criteria window. 10 and 24 being week numbers. However if I wish to randomly select the week...

Many thanks for your two replies I have already tried both of these options and didn't like the results. Does this mean that it is not possible to index the query in it's present format. Regards Terence

Hello All I have a field called MEMBERID I wish to index the following so that all members in 2005 can be idexed A to Z and all members in 2006 can be indexed A to Z: 00125/05 At the moment, the last two digits that indicate the year of joining are ignored when sorted in a query, and they...

ListBox to load a Form Hello John Many, many thanks for your reply. It works beautifully. Can't thank you enough for taking the trouble to reply. Regards Terence London 15 April 2007

Hello All I have a list box that displays the names of customers who are allowed to hire DVDs. I would like to highlight a customer and show all the relevant customer data on a separate form, not have the list box on the same form that displays the customer's data. Regards Terence London

Hello All The Microsoft web page on password protecting a form is very clear and concise. However, the example password used is the word PASSWORD. I have tried substituting where ever necessary but have no no luck when trying to create a different password. How would I creates a password such...

Months in chronological ordert Hello Ken I'm very sorry I didn't acknowledge you efforts on my behalf. Many thanks Regards Terence

Months in chronological order Hello Wayne & Pat SUCCESS!!! The mistake I made was to assign a 1 to January ending up with a 12 for December. I assumed that I could enter a 01 for sorting but of course you can't. I simply changed the numbers from 10 to 21 and can now sort correctly. I...