Ok here's the code: 1) Go to Modules Tab and create a new module and paste the code below. Save and name the module as you like 2) Create a new button on your...
Is there a way I can change the background colour of a button on a form? Thank you in advance. Ilona Adelaide, Australia [Non-text portions of this message...
I don't know if this is strange or Im just missing something only. Couple times I encountered these but just now got a chance to pay attention: 1) While...
Hi Ilona, Check this http://www.lebans.com/cmdbutton.htm hth, George ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com]On Behalf Of Ilona...
Sorry: Out Of Topic The innocent victims of Internet child abuse cannot speak for themselves. But you can. With your help, we can eradicate this evil trade. We...
Thank you very much George. This is quite complicated for my very limited knowledge of Access Basic, but I will give it a go. Thanks again Ilona Adelaide,...
All, I am using a barcode scanner to input book data into Access. Using the barcode, I compute the ISBN including the check digit. But, when the barcode is...
Not sure if this will work in VBA.net but most probably. Paste this code to a new module, basically this is the replacement of the Replace built-in function: ...
George, Thanks for the reply. Your solution is very good. It is somewhat more general purpose than mine. I wasn't very clear in my question. What I really...
Cindy try this in the OnLoad event docmd.maximize Jim nycsmiles08 <nycsmiles08@...> wrote: Is there a command I can put in a form Code that makes the...
I need a form that will filter by category (and also be able to by Keyword, but that may be for a later post). I'm well comfortable enough doing basic table...
Hi George, I don't mean to be argumentative, but I have a question: I am using Microsoft Office Access 2003 on Windows XP Professional 5.1.2600 Service Pack 2....
Hi Ilona, I believe in all version it says like that. Changing the background color is almost applicable to all controls but not in the command buttons. ...
I'm in a bit of a quandry here. I built this form containing 250 or so fields all from one data source. The person I'm working for wanted to add another 100...
Try using a sub-form. Guy Harley www.youramigo.com _____ From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf Of rlee_at_channing Sent:...
Ryan, You can gain maximum flexibility by not binding the form to any data source. Then via VBA you can issue any SQL commands you want. Alterantively you...
I know what the person you works for wants carries a lot of weight, but 350 fields on one form seems really busy to me. I would think the user would get lost...
The number of fields on the form is an issue. Evem though you are "only" using Access proper database design is still necessary. The table that the form is...
Hi. I have a form that us used for data entry to a table. How do I get the form to show the next blank record every time it is opened? I beleive it is...
Jeff, I assumed you're using bound forms. Put this code on Open or On Load property/event DoCmd.GoToRecord , , acNewRec '// If you want to focus to specific...
Jeff, I assumed you're using bound forms. Put this code on Open or On Load property/event DoCmd.GoToRecord , , acNewRec '// If you want to focus to specific...
Hello All, I am working on a process that will append records to one of two tables. I believe I will need to have update and append queries to do this....
I need to output (DEBUG.PRINT) the {name} and {row source} of every combo box on every form in my Access97 DB (around 30 forms). Any ideas would be much...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
