Search results

Hi I have upgraded to Windows 7 from XP, and as part of that I backed up a 'program' that I have that uses Access to run. When I put the folder back on my machine now, however, when I try to open the Access file it says Error 3027: Cannot update. Database or object is read only. If I try to...

Hi I have a list box where a user can double click a value in it, and based on the unique id of that row a form will come up where you can add information linked with what you've just opened from the list box. However, if a user double clicks the blank white space below the values where they...

Hi I have created a subform that I want to look like a list box. I have made it all a white background etc. Is there a way where I can make it that if a user clicks in any field, it will highlight the text in all of that field and the corresponding ones in that row?

On a form I have a list box that is populated from a query. Is there anyway that I can make it so you can right click one of the results in the list box and then delete it? I have a list box on a user profile that shows a list of future events that they are attending. If I want them to no...

Hi I have a junction table of fixtures (FixtureID, HomeTeamID, AwayTeamID, KickOffId, RefereeId, Date, VenueId, Mark) All of the fields are filled in except for RefereeId and Mark. I have a table of referees. I have a query that shows me which referees are available to referee on a...

Hi On my form, how am I able to do the following: Type a value into a text box a Lookup this value from a table Return what is found in column 2 into textbox b It sounds like it should be simple but I am only a novice and do not know how to do this. Any help would be appreciated Many thanks

I have searched the forums and the internet and the only replies that I find use VBA and terminology that goes right over my head, such that I don't even know if it's answering what I want it to!! Something I found was this, which the OP seems to want the same as me except that he uses longitude...

Hi All I have a search query where I want the person to enter in . It works how I want it to but currently only searches one field. How can I get it to search multiple pre-defined fields (six in total, which are Address1, Address2, Address3, Address4, Address5, Address6) Thanks in advance

Hey I have a form that has a combo box that displays referees from a query of whether they are registered or not, and then I have a list box of all available dates throughout the season so I can input when they are free to referee. 1. How can I do this by making it a multi select list box...

Hey I have a form that has a box for you to enter in a parameter, and then a search button. Currently, clicking the search button will open a form that finds what the user has asked for, and can view each selection with the record navigation buttons at the bottom. However, I added this form...

Hi I have an IF formula that will calculate if two cells equal each other, then to display the value that they show and if they don't, then to display "No Root Found". Is it possible that I can create a table and if the cell does not equal "No Root Found", then it will copy the content of...

Hi I have a table that consists of ID | Mornings | Afternoons | September 5th | September 12th | etc. (every Sunday through to April 24th) Every field is a Yes/No (except ID). How can I create a query so that the user can enter in which date that they want to view, and then it only returns...

Hi I have tblTeams (pkTeamID, TeamName, Ground) and then I also have a tblMatches, which consists of pkMatchID, fkTeamID, fkTeamID2, fkRefereeID I established a relationship between pkTeamID and fkTeamID. However, one match will consist of two teams. How can I make it so that the table will...

I have a form whereby you select a person from a drop down and then in a sub form you can enter in marks for that person. At the bottom, I have two list boxes. One shows that persons average number, and this updates when you select a different user (so then you go back to that user to find their...

I run a query and it returns a number. How can I make it so the number is only shown to 2 decimal places?

I have a form called frmEnterAvailableDates and I want it so you can select the referee from the drop down list and then you can tick which dates they are available, and it will update this in tblAvailableDates. The drop down list is derived from qryRegistered9v9 (referees who are registered...

Hello I'm very new to creating databases and working with Access, so please forgive me if this seems basic! I'm going to put it in context for you... I am creating a database for my role as a Referee Secretary (Football in England) and I have a table that has referee names and marks. So the...