Search results for query: *

oh my duh i didnt define the variable thanks that really saved me a day of monotony

I tried both suggestions and when i run the module it highlights the n and says variable not defined. i should add that i am using 2000 if that matters. any suggestion?

thanks a lot i am sure glad i asked cuz that was gonna be crappy. thanks!

yes

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

Phantazmo thanks a lot!!!!!!!!!!!!! My end users HATE clicking 6 times lol dont blame them

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.

Man you guys are the greatest! That is exactly what I needed. Thanks for your time and patience.

is there a way to do it in a form/report module?

maybe i need to clarify that i am trying to do this with a command button on a user form?

thanks i tried that exact code but changed the .dll I get the error message that says this upon opening the applic ation: Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules any ideas?

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

that is all she gave me

im sorry i dont know what you mean i re-read it. you had said the syntax would get the correct results so i typed it as it was posted

FROM (tblProducts LEFT JOIN tblConsolidatedForecast ON tblProducts.PK = tblConsolidatedForecast.FK) LEFT JOIN tblOrders ON tblProducts.PK = tblOrders.FK Thanks for looking at this again

I have typed in the sql syntax that PHV has provided however I am getting an error saying "Invalid SQL statement expetced Delete, INsert, Procedure, Select, Update" Any thoughts? I am in MSAccess 2000. thanks again

Thank you!