Search results

  1. A

    Copy data from one sheet to another

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

    Adding combobox to the worksheet

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

    Intellisense problem in VBA

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

    Open form as a popup

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

    Bind a new Subform on the MainForm

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

    On Hover change style of button and label

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

    Open a separate form in the same form

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

    Styling for controls

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

    Basic String manipulation question

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

    Querying tables from the code

    Hi, I have a button click event and i should be able to run a query command on multiple tables using an id( read from the form) and get the returned data and use it for certain purpose. How do i do it from the code. Thank You.
  11. A

    Access combobox from Sub form

    Hi, I have a form and a subform in it. Have comboxoes in the sub-form whose value i need to access on a Button(on main form) click. How can i do that? Thank You.
  12. A

    Calling a sub(in a module) from an Acess Form

    Hi guys, I have a very basic question. I placed a sub in the module and want to call it from one of my forms on button click event. So for eg Module1 has this code Sub SendEmail() Form1 has this: Private Sub Command23_Click() ' how do i call SendEmail from here... End Sub Thank You for...
  13. A

    Hyperlink fails to open

    Hi, I have a textbox bound to a Hyperlink column of the table. Let me explain what i'm doing through the code. My textbox name is txtFileName. txtFileName = "C:\temp.txt" On the form i could see "C:\temp.txt" inside the textbox in blue underlined but when i click it, it just doesn't open the...
  14. A

    Attachment files to a form

    Hi, I want to attach a file to a form in such a way that if the user clicks on a clip image it opens up a windows folder dialog and user can select a file and attach to the record. I know Access 2007 provides an inbuilt Attachment data type but i'm using Access 2002. Is there a way to achieve...
  15. A

    Binding the Text box value

    Hi, I have created a form that has a textbox field bound to some interger ID of a field in the table but there is another table that has the corresponding Name field for the ID and thats what i want to display in the textbox not the ID. It seems obvious i would have to use join and somehow...
  16. A

    Calendar view showing meetings

    Hi All, I am failry new to Access and building my first app. I have some meetings that i would like to show in a big calendar (like how outlook shows) and i should be able to click it and see the details of it. I am using Access 2002. I tried to do some research but couldn't find anything. Is it...
Back
Top Bottom