Search results

Now I've changed it to Access 2003, with no SP's installed, I have an issue but a different one. With regards to the date?

As an update, I installed Access 2003 separately and can now open the MDE file. However, an error 3075 comes up (see attachment) Any ideas from here??

I'm using Access 2010.

I tried opening it from within the documents folder, after downloading it. Yes I have extracted it beforehand; that's one thing I can do! :p I'm confused as to why it would work on another machine? On my XP laptop, it opens fine but not on Windows 7.

I have tried opening it from program files and also my documents. I have attached an image of what I get when I try to open it. So the file successfully opened for you, with a list of upcoming games in the body and options across the top to add extra games etc. ? How come it won't work for me...

Yep, if I don't hold the shift key then I get the above error. As I said earlier, this was a program that I installed, but it is an Access file so I don't know if it has lots of security on it. Have you tried downloading the link to the files I posted?

The references bit under 'Tools' is greyed out. :confused:

It hasn't been made read only in properties. It was written in Access 2003 and I am using Access 2010 on Windows 7.

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

I'm a novice when it comes to Access. If there is no value and so the error message box shows, then I want it to finish and not then run the if statement.

Hasn't worked. Using what you said, my code is now. If I change the code to Me.FixtureID (the name of the primary key) then the debug comes up with Compile error: Method or data member not found. If Me.ID = Null Then MsgBox "No record" Exit Sub Else If...

It's in the on double click event properties. When I click 'Debut' what is highlighted is this code, that is in the form that is opening's on load event,

Ok I've added it, but it doesn't seem to have changed anything. The same error is displayed.

Hi Trevor The row source is currently already filled in, as the list box returns the results of a query based on a previous select. There is a combo box where the user selects a team, and then the list box will requery with all of the games that the selected team is involved in. I then want...

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

Hi I have a table of post codes and corresponding lat / long distances. It is only rough (using the above example the post code may be NN3 4GL but I just have NN3. This is perfectly ok for my use though). Something perhaps a bit more simpler to start with... I want to have a form that will...