Search results

Hello Rasheed. attached in the zip folder you will find two databases sample, one is on Access 2010 and the Other One I saved as Older Version can be opened on Access 2000 or 2003 You will find a table for exaple tblProducts, and a Form also frmProducts, I made a short example for you to see how...

Why don't you try and reset the form themes Go to design menu and in the second right button click it and try choose a themes in there that would change your labels and text colors Maybe by resetting the themes you would solve it

Guys, we are not only dealing with access when we open the database, there is so many other staff working to view the output on our screen, when you run your database on a computer standalone sometimes because of low memory and the access are requesting a code to run and cannot get it on time...

No you don't need to start again from scratch I know it could be hard but escaping from the problem doesn't solve it what would you do if you face it again, you can maybe rebuild the form again, save as your current form and try and rebuild the form again link the data properly, data must be...

Hello Guys, I opened the database and Checked, actually I don't like the way the relationship is made, I tried to convert the database to an older version but I couldn't because it is using features which will not run on earlier versions of Accesss, but what I did I attached a snapshot of the...

Guys, Access will not generate an error without a reasons, sometimes reasons of errors could be irritating and it will drive us nervous to solve it, check your autoexec procedure sometimes you could have a problem in sorting the executable commands which might lead for an error, in all cases...

Thanks Pr2 for the Professional Interaction, I strongly recommand who tries to use the sample databases on their project to understand every code they are trying to use from other users else we will never learn to do it ourselves, thanks again

Lets go step by step Press shift key while opening your database and open the main form manually and feedback if you still have the same problem, In the file menu under options under current database in the application icon combo box did you selected any icon symbol for your database?

Autoexec macro is a Macro you create to setup your database startup behaviour, if you are the database creator and you don't know it that means you don't have it because we create the autoexec macro inside the databases, a) are you trying to open your database via a network? if So, check your...

Hello Sean66, in this Forum it is not only people who gives answers helps, it is also the people who ask questions, they help others who is searching for answers, in my opinion every user in this Forum is a useful user even he is asking or answering. your are always welcome to ask,

do you have autoexec macro in your database? Check the onLoad event, did you try to compile your database? check the on Open event, compiling will reveal any problem could be with the code. check those and revert. hope you will solve it.

You can use RecordSet or Append query linked to your controls on the Custom Message Box and on the Yes button or OK button you can put the Code which will run the RecordSet or the Append query and update your previous Form data on its table or any other table or controls you might select in your...

Compact and Repair database, it should work :)

Well as for my experiene it is a fun of Access sometimes, normally data being entered by users will never affect the tables unless there was some un-expected closuer to the database, sometimes the database hangs, and the users tries to force quit, and it will show some messages that send report...

Don't forget to backup your database

Maybe you can refer to this link they have easier code: http://www.accessibledatasolutions.com/articles11/AccessexportExcel.htm

Sometimes I get this kind of stupid behavior for the forms, I don't remember if it was the same error but I got once an error on form loading and I couldn't get rid of it, what I did is I re-created the form freshly from scratch, I saved the old form and re-build a new one. Before also you can...

here you go, this is an older version Access format, you have to be able to open it now with your Access version 2003

well what you need to do is, on your command button on click event which loads the next form you need to add this line. Me.Visible = False

just in case you can check the attached database if it is more applicable to you