Search results

Hi Scott, Thank you. I took your approach and i was able to do it by using only two statements sheet1.Copy and sheet2.PasteSpecial Thanks again.

Hello! I have created a worksheet using : Dim wkSheet As Worksheet Set newWkSheet = ActiveWorkbook.Sheets.Add Now i want to copy data from another exiting sheet to this new blank sheet. How can i do that? Any help would be greatly appreciated. Thank You.

hello! I have req to add a combobox and populate it programmatically when the sheet loads. I find the combobox control in the Forms control toolbar and able to add it in the sheet. But i dont know how i can change the Id of the control and i'm not able to access it in the code. Please can...

Hi Bob, I figurred the problem. I had anothr sheet in the same workbook that was running some automatic formulas. I changed their calculation to Manual and it resolved my problem. But i have another issue. The button and a dropdown that i added into my sheet, i'm not able to access in the code...

Hello! I'm a new VBA prgrammer so please bear with me. I added a button on one of the worksheets assigned a macro on its click event. Inside the method when i try to do "Me." the intellisense shows up for a second and then vanishes and Me turns to red. I dont know why its happening. Any help...

Awesome! Thank You for your help Banana :) Access programming making lot of sense now. I have downgraded myself from ASP.NET 2.0 to Access. Can you believe that :(

Thanks. I got it to work.

Okay, Pls excuse me as i am fairly new to Access. The query i am binding to is a plain select like select BookTitle from Books. Books has a FK as ID which relates to the PK ID in Client table. When you say "If you right-click on the criteria row" i'm not very sure what you mean or how i do that...

Thanks. But how can i have it as a pop-up so i can still see my main menu form(from where this was opened) in the background?

Yeah but how will i link the ID to the ID of the form so i see the books only relevant to the record on the main form?

Thank you for your response. Well its just meant to be displayed, nothing much.

Hello guys, I was able to bind my subform but i am still wondering if i can rather use some control that would allow me to show a numbered list of items? eg. List of Books: 1. Book 1 2. Book2 3, Book3 Thank You.

Hi, I am opening a form like on a button click using "DoCmd.OpenForm" method but i would like to open the same form as a popup and set the width,height,location co-ordiantes of the form. Is it doable? Thank You.

Hi, I already had a form with one subform but now i want to show some other info on the main form so i am trying to add a subform( dont know if there is a control to just listing items). I assigned my query to the Data of the subform but when i am trying to add a Child Link it says "Can't build...

Hi, I have a command button and a label control on a form and when i hover the button i want to change the border color for the button and change the forecolor of the label text. Similarly, on hover out i should undo the changes to bring in the original state. for on hover i was trying On Got...

Hi, I have a created a Main Menu page with the menu items on the left hand side in a vertical fashion and want to display the forms corresponding to each Menu item in the same form on the empty right hand side. How do i go about doing it? Is there some Panel kind of control that can be used as a...

Thanks a lot George. I had no idea there was this database on this site. Kudos to everyone who posted their stuff, simply awesome! More questions to follow :) Thank You.

Hi, I am trying to build a menu driven MS Access officee xp App and would like to use styles on the page and control level. More importantly i would like to know if there's a free resource available to create customized buttons (eg oval shaped gifs button lookalike like in web pages) for Access...

Thank You guys.

Hi, How can i write the following string concatenation in a short form: strValue = strValue & "Hello" Tried strValue &= "Hello" but it doesn't work. Please excuse me for my basic question but i am new to VB. Thank You for your help.