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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. cc5305

    Excel Font error message

    Everytime I try to change the source data of my charts in my spreadsheet, I get an error from the Office assistant saying that 'No more new fonts can be applied to this workbook'. But I'm not doing anything with fonts nor do I want to. It doesn't seem to be a problem when I change the source...
  2. cc5305

    Use Access to Start Other Office Apps

    I probably sound pretty stupid, but what is a .cmd file and how do I create it?
  3. cc5305

    Use Access to Start Other Office Apps

    Hi, I would like to have my Access database to be able to start a new Word document base on a Word Template. I would like to find out if it is possible for me to do that. Thanks.
  4. cc5305

    Affect of connection to SQL Server

    I have a question hoping someone can answer. I want to use Access as a front end tool to my users to connect with my SQL Server through ODBC. I think the general idea is to have create link tables to the SQL Server DB. But I have some VB codes that runs in the Access DB to do the...
  5. cc5305

    javascript code?

    Hi, I'm pretty new working with Javascripts. I have two buttons on my site. And what I want to do is to have the code behind one of the buttons executed when the user press the Enter key on their keyboard. How can I do that? Thanks for your help.
  6. cc5305

    List rowsource at runtime

    I think there are couple ways to do this. One way is to store the row source into a variable. Depending if your rowsource type, but I'm pretty sure you can always use a string or variant variable to store the list box's row source like so: variant = listBox.RowSource. Then when you're ready to...
  7. cc5305

    refreshing a list box

    Hi, I have a list box that is using a select query as the row source data. And when the user click on a button after selecting any of the items on the list box, it should delete the item, which is fine. But the problem is, the list of items in the list box doesn't change even i use the requery...
  8. cc5305

    Filling listbox with field from query??

    Yes you can. And use the Selected method of the listbox to figure out which item is selected. Then use the itemdata method to get the value of the item selected. Hope it helps.
  9. cc5305

    Print a Form to fit to one page

    I would like to print this FORM. However, it's bigger than one page on when printed. Is there anyway I can print the form to fit to one page? Thanks in advance.
  10. cc5305

    Saving a Form

    Hi, I've create a Form object while running the codes in VB. But I've found that the object will not be in existence if I simply by the statement (the form name is the name of the Form object that was created, usually Form1, Form2, etc.): Docmd.closeobject acform,form_name, acSaveYes So I...
  11. cc5305

    Limit to Create Form Control

    Hi, does anyone know if there is a limit on the number of controls I can create on a form? What I mean is that... in my database, I'm using various methods to create and delete controls. So as time goes on, the number of controls created and deleted would reach pretty high. And for some...
  12. cc5305

    Restart control names in Access

    Is there anyway to restart how Access names the controls on a form? I know this is not really an issue, but how can I start the naming from commandbutton1 again instead of commandbutton253? Thanks.
  13. cc5305

    I want to delete a form in VBA code

    well, I thought the macro worked, which it did a few times. But the same error came back up and not let me delete the form. I don't know why, can't figure out. But I did find a run around solution to what I wanted to do. Thanks.
  14. cc5305

    cleaning up a form

    I want to delete all the objects (buttons, lines, txt box.. etc.) on my form in access. so i use the deletecontrol method to delete them off the form, without having to delete the form. however, when i use the for loop explained in the help section, it somehow selects only a few of the object...
  15. cc5305

    I want to delete a form in VBA code

    Thanks so much. That was an easy solution.
  16. cc5305

    I want to delete a form in VBA code

    No, I made sure that the code is being called from another Form. Actually, I moved the code from one form to another. And I get the same results for both times.
  17. cc5305

    I want to delete a form in VBA code

    Hi, I want to delete one of the forms by using VB code so the form will be deleted and recreated as the user selects different options in the access database to present different set of data. However, for some reason, very strange too, that I keep getting the message that Access cannot do the...
  18. cc5305

    Why the For... Next doesn't take value from 100 to 299?

    Also you really don't need the part of 'Step q.text' part if your increment for each loop is 1. VB defaults the step to 1 even if you don't declare it at the for loop statement.
  19. cc5305

    Declaring & Redeclaring Module level variables

    Hi, I want to create a module level array in my program. However, I'm not certain of the number of elements in the array and I'll have to find out about the array size during the run of the program. So I think Redim the array size. But here is my question. If I do a Redim, does that...
  20. cc5305

    My Save As option is disabled, how can I turn it back on?

    My Save As option in Excel is disabled. Can't click on it or anything. I tried Reset Usage Data, that didn't work. Can anyone help me? Thanks.

Part and Inventory Search

Back
Top