Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vanleurth
  • Order by date
  1. vanleurth

    Intro. to class modules

    Hello, So, I'm back with a finished progress bar. It works great !!
  2. vanleurth

    Intro. to class modules

    Hello fellas, I was wondering where can I find an online tutorials about how to create a progress bar class or any other class in Access. Thanks, V.
  3. vanleurth

    Converting Access db into exe?

    Bokazoit, It is possible to convert your database to an executable file but it won't have the exe extension. Access has a tool, under its tools menu, that allows you to compile and package your db but it will have the mde extension. This means that you will still need to have installed Access...
  4. vanleurth

    How do I bypass AllowBypassKey?

    Thanks for the fast response Edski, I read about the property in the help file but I still can't get it to work. I have an AutoExec macro that launches a function called StartUp that disable the AllowBypassKey. One thing I have notice is that my database is not secure. Do you think this might...
  5. vanleurth

    How do I bypass AllowBypassKey?

    Alright, I have an AutoExec macro that runs a function that disable the AllowBypassKey but it doesn't work. Am I placing the function in the right place. V.
  6. vanleurth

    Having trouble converting to MDE

    Hi happy programmers, I have been trying to convert my database to a MDE. The problem is that if I go into the option to disable menus and toolbar and then change my mind, I can't go back to change the menu options because I already disable the menus. So, my question is; How can I just make my...
  7. vanleurth

    Can't requery an object inside a subform

    Hi happy programmers !! I have a very intriguing problem with access. I think I have tried any possible variation but perhaps you might have an additional one. Here is the problem. I have a subform inside a parent form. On the parent form I have a button that opens a form in which you can add...
  8. vanleurth

    Where can I upload my database ?

    Hi everybody, I have worked very hard to finish a database and now is time to show it to the world. I was wondering how can I protect my work and where should I upload it to make it accesible (download.com, etc. Any other examples) Thanks in advance, V.
  9. vanleurth

    Combining Multiple Queries into a single Query

    Thanks for your prompt response. I figured out a way to do it with multiple unions (onions, like that french soup !). Here is the solution; SELECT '(All)' as phgroup FROM [tbl phones] UNION SELECT '(Personal)' as phgroup FROM [tbl phones] UNION SELECT PhGroup as phgroup FROM [tbl phones]...
  10. vanleurth

    Combining Multiple Queries into a single Query

    Hey SQL eXperts Hello and good Monday, I mean morning. Here is my proble. I'm trying to add to values to a sql query by using UNION. For example SELECT '(All)', '(Personal)' as bogus from [tbl phones] UNION SELECT * FROM [tbl phones] It doesn't work. I know how to do this with just one...
  11. vanleurth

    How to beta test my database

    Hi happy programmers, After long hours of programming and form creation. I'm almost done with the debugging of my database. Now, I would like to get some feedback from potential users. Is there any book or guidelines online about how to call, what to do, do I submit my software to download.com...
  12. vanleurth

    DAP doesn't want to reconnect

    Hi happy programmers, I have just updated to Access 2003 and tried to relink my DAP to the replicated database. first, I thought it might have been something easy. I just browse through my files and find the replicated database. Then, just reflesh the connection and voila !! Unfortunately, when...
  13. vanleurth

    Why hiperlink doesn't work

    Hi happy programmers, I have a combo box which is hyperlink. On ewith a website the other one with an email. If I click on any of them a toolbar (hyperlink toolbar) pops up and nothing happens. How can I disable this feature and have my email program or web browser launch instead? Thanks in...
  14. vanleurth

    Avoiding redundancy by using a common mdb keeper of forms

    Did you just MACGYVERed that ? Thanks, it works !! V.
  15. vanleurth

    Avoiding redundancy by using a common mdb keeper of forms

    Rick, Thanks for your prompt answer. Here is what I'm trying, DoCmd.OpenForm "frm about", acNormal frm about is a form inside my reference mdb file. I still get; The form named "frm about" is mispelled or refers to a form that doesn't exist. Am I missing something? V.
  16. vanleurth

    Avoiding redundancy by using a common mdb keeper of forms

    Hi happy programmers, I have found myself reusing the same forms; splash, menu, etc for different databases. I have been sucessful at placing all my modules in a mdd file and using that one as a library for all my functions. I wonder how can I use the same mdb file to store common forms. I...
  17. vanleurth

    updating a combo box after updating its table source

    Hi Marina, Sorry for the week later reply. I have been ery busy. Thank you for your interest in helping out. Here is the code for the button. Private Sub btn_type_Click() ' Open the training type form DoCmd.OpenForm "frm training type", acNormal End Sub This calls the form...
  18. vanleurth

    updating a combo box after updating its table source

    Hi happy programmers, I have a combo box and a button right next to each other. The button opens a table (form) that is the rowsource of the combo box. I would like to update the combo box once I have added another record to the table source. Here is an example; Let's say I want to define or...
  19. vanleurth

    How to programatically determine a field type?

    Hi happy programmer, I trying to write a filter for my tables that will use string comparisons. For exmaple, If field1 > number then ' Perform an aritmatic calc. and greater than or smaller than comparisons if else field1 = text then ' String comparison and do not perform a greater or...
  20. vanleurth

    Inlcuding graphics in records of datasheets

    Hi happy programmers, Probably many of you agree that datasheets are very boring. Nowadays, as a software developer, we need to catch up with the fancy way things are looking, specially UI's. So, I was wondering how can I add a graphic to a field in my datasheet. This is, instead of open/close...

Part and Inventory Search

Back
Top