Recent content by cc5305

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...

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

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.

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...

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.

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...

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...

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.

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.

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...

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...

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.

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.

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...

Thanks so much. That was an easy solution.