Recent content by JAy3k1

I am having the same issue Gizzy and I too cannot use the Print Preview option due to control buttons on the report. My DB was designed in access 2007 on win xp and we have just upgraded all our systems to win7 with access 2010 and now the report is not displaying correctly. It is almost a...

Good evening all, I'm looking for a little guidance if possible. I have a database in Access 2007 that uses a split form and am looking to create a search button that will filter the bottom of the form to display only the item searched for. Now I am very new to Access and found a bit of code...

Thanks for the reply John. I shall have a look, unfortunately I am having to post via my smart phone and it is cutting off some of your quoted code.

Morning all, I have been trying to setup a List Box that will filter a form, but am not having much luck. My database is setup as a split screen with data entry at the top and form at the bottom. http://i54.tinypic.com/ms2685.jpg And what I would like is a drop down list for the Company Field...

Got it fixed. I just split the database, made a backup and then with the networked version I locked the Shortcuts from within the access settings which stopped all right clicking. :)

VbaInet, I've got to the point all the development is done on my database and have read through the.links you supplied and attempted the splitting of my database, which went fine. I then created a ACCDE file from the original file and that too seemed to work. But when I test the ACCDE file it...

Your a star stopher, I changed all the buttons to tab no. Except the Save Entry button so if the user does press enter twice all it does is save the entry. :) Thank you. :)

Thanks for the reply vbaInet, but I cannot use that feature as it effects other databases running on the system. The solution has to be specific to my form as opposed to general settings. :)

Ahhh, got you. Thanks for the links vbaInet. :)

Sorry missinglinq. I have to cater for people that are very bad with computers. The field allows you to enter the date manually or pick from the pop-up date box and I know that people will.use the enter key when moving through the fields and noticed the issue if the enter key was pressed. :(...

The file extension I'm using is: accdb and the other one is: mdb. ttp://i53.tinypic.com/25uh1z8.jpg Add the H to that link vbaInet.

I'm having issues with the enter key on my form. On the last field, which is a date field if the user hits the enter key to confirm the date it automatically move the selection to my delete entry button on the top of the screen. And if the enter key is hit again the new entry gets deleted...

Thank you for the reply vbaInet. I have managed to solve the issue by adding another command to maximize the window. But for some reason I can now right click and gain access to the Design view, which is something I don't want on a multiuser environment. Is there a way to turn this off? I would...

Good evening all, I'm looking for a little assistance with a database I am making if possible? It must be 10 years since I last used a DB program so I have been teaching myself access 2007 over the last few weeks. And there is one problem I cannot seem to get over. The DB I am making is setup...