Search results for query: *

I have a worksheet that has 122 ranges named. I need to delete all of them and rename them. I know how to delete one but i was wondering since there so many is there a faster way to delete it rather than "Name" highlight it and then delete one at a time

I have a excel spreadsheet that when a user selects a command button a wav file plays. Question -=- aside from compiling what do I need to consider to be sure all users are able to hear it? do i need to save a dll file in the folder or anything? thanks

I have an on close event for a form that runs a make table query and then an update query. Does anyone know how to alter the code so that it does not require the user to click yes 6 times? Thank you in advance for advice or suggestions.

I am trying to in Excel 2000 using vb 6 on event for a command button play a wav file. I have tried two different codes that were on the net. My problem is this....they use declaration statments and i keep getting a debug error message saying that you cannot use declaration statements. Below...

Hello I have a folder which contains an excel application and .wav files. I have user forms where end users can view a product. I would LOVE to somehow make it so that they can 0n event hear a small .wav file to hear about the product. Anyone have an idea? Thanks in advance!

I have been working with this and I have an idea about it but I am unsure about the correct vb code. I have two sheets Triggered by a macro button, I need to compare the cells of A1 (all rows)on sheet 1 to the cells A1 (all rows) on sheet 2 If the values are equal i would like it to copy and...

I have two fields on my form which i would like to concatenate in a separate field. Ex: Store Number Product Code Concatenate 102 AAAA 102AAAA The Product code automatically populates in the concatenate field. How can i make the field insert the store...

Working in FrontPage, I have a drop down box "D1" and an excel spreadseet "Spreadsheet 1". I am trying to get the value from D1 to populate the spreadsheet in A1. I am using this. Am I close?? <select size="1" name="D1"> <option value="1">Mustang</option> <option value="2">Escort</option>...

I have an excel spreadsheet with functionality on a webpage. How can I add a combo box so that the selection autopopulates the first two columns of the spreadsheet then upon next selection finds the first empty row? Thank you in advance for any information you might have.

Hello I have an excel spreadsheet that I am saving as a web page. Is there a way to add a listbox that dynamically populates the first two columns of the spreadsheet as it would in excel? If anyone knows about something I could read more about excel and the web that would be great or I would...

I am trying to create an excel spreadsheet for a web page with functionality. What I need is a two column list box that would through event autopopulate the first two columns of the spreadsheet. Is it possible to do this? I also tried creating a cell specific listbox which I would have...

Hello I am trying to import an excel spreadsheet into a table in access 2000. I get 121 import errors all saying "Type Conversion Failure". Can someome please tell me why this happens and what I can do about this? Thank you in advance.

I have a select query based on one table and one query. The table tells me what products have been forcasted for the month of January and the query tells me what of those forecasted products have actually been ordered. I would like to see the entire list of the products, the number forecasted...

I'm sorry I dont know how to better describe the question in HTML so I used excel terminology lol.... I have 100 text boxes in rows for a user to possibly fill from two different dynamic list boxes to autopopulate the item and the cost.....I am wondering how to make the list box find the first...

Is it difficult to have a list box (item and price) on a form that would automatically populate a two side by side text boxes on blur? And if not, is it possible to have the onblur find the first available blank text boxes if i have a bunch of rows similar to excel? Im sort of trying to...

Happy New Year! I have a report in which I have a field that calculates a January Forecasted Number minus the January Actual number. In the group footer then it totals the January Forecasted and the January Actual. How do I go about totaling the Forecasted-Actual calucated field? Thank you...

Hello, I have a problem with my database project. If I have the program open, other users get a message box saying that they can't open the program because the file is already in use. If others are in the database, I can open it but no exclusively which makes sense but it DOES still allow me...

I have a table which stores products, a table which stores the number of each product a territory office has projected it will need, and a table which stores actual orders. On a report I am trying to show the number projects by month, the actual number ordered by month, and then the unused...

I realize that to answer this question totally is beyond the scope of this site. I am just hoping someone could point me in a direction to research or provide suggestions. I have a list of several "kit" products that are comprised of possible componenets. The kit definitions list all the...

I am certain this is probably simple but I have researched the help for access and can't seem to find the answer. How can I make a date field autopopulate with the current date at time of entry? I have tried =Today() but it won't accept that. =Now() works to put in the time....is there...