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

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

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

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

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

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

Hi again I have used =MAX to find the largest number in a range. BUT... is there a similar way of finding the second or third or fourth (etc) largest number in a range? Thanks

Hi everyone, What formula should i type into a cell to make it display the biggest value present in a set of numbers across a cell range. Each cell in the cell range(a column) contains just one number. Thanks

Hi guys, I have basic knowledge of microsoft Access and do very little with script and coding. I also design websites and can code in HTML and have good skills in Dreamweaver etc. If I want to create a database driven website is Visual Web Developer 2005 a good software choice?? The way I...

Hi everyone, Is there a simple way of allowing users to press a button on a form that will print all the form data but in a report i have deisgned?? Thanks James

Hi guys, I have created a form based on a query that prompts the user to enter a persons name. Once entered, the persons data appears on the form and some other related data appears in a subform. However, I have found a problem that occurs when a name is entered that doesnt exist on the...

Hi everyone I have a database accessed by alot of people and have recently added user level security so that i can monitor who is logged on etc. Another thing i need is the ability to update the design of forms whilst people are on the database. To do this i planned on creating a replica and...

Hi everyone I have searched for help on this forum and all over for a while but cannot find the help i need. I have a database stored in my user area on a schools network. Other users around the school access the database by clicking on a shortcut to it found on their start menu. The database...

Hi everyone I would appreciate some help redesigning a database structure. Currently the database has a table holding students personal details. Linked to this table with a one-to-many link is a table holding subject reports. Also linked to the student table are two other tables holding prior...

Hi guys I need some help working out a way to archive records. All i really want is a button on a form that when clicked deletes the record currently displayed on the form from its table and moves it to another table that i will call 'archives'. I think it might have something to do with using...

Hi guys I need some help working out a way to archive records. All i really want is a button on a form that when clicked deletes the record currently displayed on the form from its table and moves it to another table that i will call 'archives'. I think it might have something to do with using...

Hi everyone Is there a way of setting a forms propertie's so that the form always stays 'on top' and visible, even if it isnt the focus. The only example i can think of to explain what i mean it the msn messanger window that you can choose to 'stay on top' even if you click on a window behind...