Search results

Hi everyone I have a report that shows a list of runners that are going to be in a race. How can I create a count on the left hand side of the report that shows an incrementing number i.e if there are 8 runners the numbers will show 1 through to 8. I cannot attach these numbers to the runners...

Nice one! Thanks for the help doco

Hi, I have an unbound form with a list box on it and a subform How can I filter the data displayed in the subform by the value selected from the list box?? If there are no records in the subform with a matching value from the list, is it possible to have the list value selected appear in the...

Hi everyone I recently found a sample database on this site that was a continuous form with about 6 columns of data and at the top of each column was a drop combo box displaying each columns values. You could select a value from any column and it would filter the form and refresh everytime you...

Any help or ideas would be much appreciated... im really struggling with this! Thanks again James

Hi everyone I have a form that people can enter data into with a print button on it. The button prints a report displaying the data currently being displayed on the form. What I would like is, rather than the report being print previewed or immediately sent to the default printer, the button...

Thanks for the advice but this is sounding far too complicated for me!! I was hoping there was a simpler way of doing this maybe by using the expression builder or something. If not I will have to give it a miss im afraid... Thanks James

Hi everyone I have a table with the following fields: entry ID, surname, forename, date I have created a form based on the table where data can be entered but I don't want people to be able to enter a combination of surname, forename and date that already exists in the table. How can I create...

Sorry about not replying but only just got back to work this morning! I managed to find a simple sample of the character count that I have edited and this works fine. thanks anyways James

Thanks for the reply bob. I copied the code into the On Change event and edited the names to match my text box and memo field but keep getting an error message... "Microsoft can't find the macro Me." I also tried the code in the After Update event but no luck! any ideas??

Thanks for the reply, should I just enter this into the ControlSource of a text box dragged onto the same form as the memo field??

hello I have searched the forum for character and word count tools that can be added onto forms but have only found an example that is too complicated for me. Can anyone tell me of a simple way to, on a form, display next to a memo field how many characters (including spaces) have been...

Hi everyone I have a form based on a table The form includes a subform displaying data from a related table The subform has a record count in the footer =Count(*) I have limited the number of records that can be entered into the subform to 3 by looking at the =count(*) in the BeforeInsert...

I am using count if on a range of cells containing single letters eg. C I can use countif to look for 'greater than' or 'less than' another letter but how do i count letters between a range. ie. count cells containing a letter between C and H? Thanks

There is a practical application!! I am using the Array formula PDX Man posted and its working fine. Thanks for all the help

Your best solution is to resize the image in some software like photoshop to the size you want it. Save it as a seperate copy and then insert that image onto the report. It will look best doing it this way. James

What your wanting to do is pretty complex if you are a beginner. I am not a beginner to access but still find linking it to webpages hard. Like i mentioned in an earlier post, I would take a look at using Microsofts FREE Visual Web Developer Express software to link your website to a database...

Microsoft Visual Web Developer! Hi Loo I have just recently started a similar project and have no previous knowledge of web databases (data driven websites). I have found an amazing piece of FREE software you can download now off microsoft. Its called Microsoft Visual Web Developer Express...

I think this is really cool but im not very good with code. By 'DataItem' do you mean the field on the form that you want to number to appear in? I have a field called 'Score' and a box showing that data on a form. How can i make the slider value (all on the same form) input the 'Score'...

Hi everyone, I have a field in a table holding numbers with no more than 2 decimal places eg. 96.87 Field Size = 'Double' Decimal Places = 'Auto' The data appears fine in Access and when exported to Excel. However, when I merge the data into a Word document the numbers have loads of decimal...