Answer Questions

• Marius T. Can Microsoft Access be Hosted

  I have been seeking out hosting services to run Offices applications and a Access database i developed.  I have received some really lame answers like the following "MS Access is a file based database and is not designed for sharing, (i.e. If someone opens the database, no one else can open it).  In addition, MS Access file cannot be opened remotely (over the Internet).  We support MS Access for web applications.  It is not ...Show All

• C Joseph go to next line?

  I have a script that will automatically send an email. The problem is an outlook security warning window that pops up. It waits 5 secs and then asks you to click yes. I want to use sendkeys to get rid of the warning box, but the script will not go to the next step until item.send is finished. Below is the portion of the code. Is there anything I can add to the objMail.send line to get it to go to the next step even before the message ha ...Show All

• fstfwd74 work localy with database

  hello, i have a database on the network and when i run a function with many queries it works really slow. is there a way to copy the database to the local computer, make the queries and continue working on the database on the network other users also work on the network database so it's important that the file stays linked to that DB. please help... refael Here's a link to conversion tools from Access to SQL: http://www ...Show All

• mdev Copying range of cells to another worksheet without copying the drawing objects

  I want to copy a range of cells from one worksheet to another without copying the enclosed drawing objects (like arrows). I use the following code, but it copies everything including the arrows. Worksheets("Blank Item").Range("A1:AY190").Copy Destination:=Worksheets("Item Entry").Range("A1:AY190") How can I get the copy to only copy the cells themselves Use the c ...Show All

• Prokennedy Runtime err 1004 when attempting to set data range for existing charts

  All, Months ago I created a GUI within Excel to plot 2D scatterplots from various sorted datasheets based on constraints placed in the GUI. When I initially created the tool, the code worked properly without issues. All plots updated each time a constraint was changed, but I'm having issues now. More specifically, when I update the data to be plotted in each series (the length of the series changes) I run into a runtime error 1004 ( unable to ...Show All

• cirilo Setting Chart Title through VBA sometimes works sometimes doesn't.

  Hello folks, Wonder if anyone has the solution to the following problem. Got an Excel addin that the user can use to generate Charts. The users are very lazy and want the addin to set the titles for the chart as well as for the axis. When I tested the code everything works fine and the charts including it's titles are set. Everyone is happy. However in certain spreadsheets the code throws an error. Method 'HasTitle' of object '_Chart ...Show All

• nLella working with 2 workbooks

  hello, i have a master excel file with a command button which when pressed opens a SLAVE excel file, reads one of the cell entries, closes the excel file, comes back to the master file and writes the data into one of the cells in that. now the reading of the slave file should be done in the background and should not be visible to the user of the master file who clicks the command button. this is what i wrote ... have already done quite a lo ...Show All

• Bang Hai Huynh Form Requery

  I have a command button on a form to create new records for the data shown on the form. When the code finished I want the form to have the new record available. I have this code at the end of the button code: Forms("frmDocumentDetail").Requery It does not work. The records do not update unless I exit the form or do something like hit the sort records button. TimD At the end of the button code. My cu ...Show All

• Chris Gillotti Email from MS Excel

  With thanks to another poster I've managed to get the code below opening and sending an email from MS Excel. The only problem I'm having is I want the value from a particular cell in a worksheet to appear in the message body. This value is actually a formula and will change as the source worksheet changes hence it will differ each time an email is sent i.e. the value at time of sending will convey the message I require. My unsuccessful att ...Show All

• efratian Windows Vista beta

  I am hoping this is the right place to post this request... I own my own computer repair business and I have very many clients. Some of them happen to be extremely computer-illiterate, so I write simple programs to change settings that may be harder to find. for example, instead or clicking start, clicking run, typing in msconfig, clicking startup programs, and unchecking and checking programs, I created a list of very commonly used programs ...Show All

• arongpan Bound Object frame manipulation in VBA

  I am having some trouble with boundobject frames in Access. I have a record in which 1 of the fields is a embedded object that is a excel ss. Now I would like to execute a script on it to extract some information. I have gotten help from the "Buddies" on how to do this inside a form ------------------------------------------------------------------------------------------------- Private Sub pin_ ...Show All

• Greg Hoover NEW

  I WAN THE NEW MESSENGER BUT IT'S HARD TO DO this post is a little off-topic for this forum, but try this Messenger FAQ: http://support.microsoft.com/kb/316660/en-us -brenda (ISV Buddy Team) ...Show All

• Nigel Lin Collating Data from Multiple Excel Sheets

  Hello, My manager has given me a project of collecting skills of all the employees. I have made and sent out a Excel sheet for employees to fill and send it back to me. It asks the Empployee to enter the following details Employee Name: Employee ID: Date of updattion: There is whole list of skills against which they have to Self Rating (Scale of 1 to 3) Mention the Level of experience (A,B,C,D) Training Undergone (Interna ...Show All

• willlawhk paper tray and assigned paper form

  Hello, what I need to do is find out what paper forms are assigned to the paper trays of a given printer. I 'd like to do that either via VBA or VBScript, either is fine. Any ideas/suggestions would be appreciated! Herbert Per our support engineer... Can you let me know what you mean by "what paper form assigned to paper tray" Does it mean "A4 is assigned to tray 2", "A3 ...Show All

• AggieNut Browsing Selection.InlineShapes forces Word to crash

  In Visual Basic Editor/Debugger: If I Trap when a Selection is made of an Inline Shape, and then try to browse the selection, Word crashes when I try to open the selected InlineShape: Sel.InlineShapes.Item(1) Anybody have an idea why that happens and what I can do to avoid this Thanks :-)an Little clarification I am not talking about browsing throught code, I am talking about browsing ...Show All