Search results for query: *

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

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.

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

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.

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

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

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

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.

When I run a SQL from my code and try to set the value retrieved back to a recordset. I keep getting the Type Mismatch error. Can someone enlighten me abou this? I've already checked to make sure that the field type are not conflicting or anything. But I can't tell what I'm missing. Thanks...

I want to declare a Database object so that I can run couple of SQL to get some recordset back. But when it's saying that it doesn't recognize the type, the Databse type is not present in the little combo box that pops up either. Can anyone help me out with this? Thanks in advance.

Hi, does anyone know if I can create command buttons using VB Code instead of drawing the buttons in design view? Thanks in advance.

I want to create an Org. Chart from the data I have in Access. I would prefer to create the Org. Chart in a form. Can anyone tell me what i can do? Thanks so much.

Hi, I want to create a Ladder Chart (i.e. Org. Chart) base on the data that I have in an Access DB. I have two questions: 1) How can I do this? Can I do it just using VB and create the chart in the application? 2) Or do I have to do it with other apps like Powerpoint's Microsoft org. chart...

I have an application that would require the number and locaiton of command buttons to vary based on the information I have in the database. Can anyone tell me if this is possible? If so, how can I do it? Thanks.

I'm new at creating databases in Lotus Notes environment. I have two questions: 1)I'm trying to tweak one of our existing database to have it become an issue database. But the design from the original database lacks a function that auto generates an issue number each time we have an issue, so...