Results 1 to 16 of 16

Thread: [RESOLVED] Creating text box

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    135

    Resolved [RESOLVED] Creating text box

    how do i alter the already created macro.
    and can anybody help me, i need to a text box and i need to import related field from the table.

  2. #2
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: Creating text box

    Is this in Access? If so, a moderator should move the thread to the Office Development forum.

    Editing the macro manually is as simple as Macros/click on the one you want to edit/click Design.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    135

    Re: Creating text box

    its in VB

  4. #4
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: Creating text box

    There's no such thing as a "macro" in VB, so either it's not in VB or it's not a macro, but I can't help you unless I know which one is true. VB? Or macro?
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    135

    Re: Creating text box

    actually i want to get a text box in a form and a reports, same field and get the data from a field from table.
    ITS in VBA..
    a little help

  6. #6
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: Creating text box

    We'll have to wait until some moderator spots this and moves it to the Office Development forum, which is where it belongs. This forum is for VB6 and earlier.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  7. #7
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Creating text box

    Moved to Office Development forum

  8. #8
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Re: Creating text box

    actually i want to get a text box in a form and a reports, same field and get the data from a field from table.
    ITS in VBA..
    a little help
    1) Are you using Access or Excel?
    2) Do you want to populate the textbox from an existing database?
    3) You said something about the existing macro... what do you exactly have?
    Last edited by Siddharth Rout; Mar 29th, 2007 at 03:40 PM. Reason: Spelling Error
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved


    MyGear:
    ★ CPU ★ Ryzen 5 5800X
    ★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
    ★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
    ★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
    ★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
    ★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
    ★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
    ★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
    ★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
    ★ Keyboard ★ TVS Electronics Gold Keyboard
    ★ Mouse ★ Logitech G502 Hero

  9. #9
    Hyperactive Member pgag45's Avatar
    Join Date
    Mar 2007
    Location
    Colorado
    Posts
    262

    Re: Creating text box

    Are you trying to get the field name (I assume for Access) as an input to import that field from a DB into Excel?

  10. #10

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    135

    Re: Creating text box

    my database is in SQL server, yes i am trying to get field name as an input to import that field from DB, in a form and a report.

  11. #11

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    135

    Re: Creating text box

    So guys help me out here!!!! i need to add label and a box in a already created form. and i want data on that box to be displayed from the related field from a related column of a table. ITs in VBA, and database is in SQl server.

    also in reports i want to add same field to be displayed.

  12. #12

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    135

    Re: Creating text box

    let me put this way. i added a field in a table, and my database is in sql server, and in a form which is VBA, i wan t to create a text box which will display the related value from that new field in to that form.

  13. #13

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    135

    Re: Creating text box

    Anybody

  14. #14
    Junior Member
    Join Date
    Apr 2007
    Posts
    16

    Re: [RESOLVED] Creating text box

    how is this resolved?

  15. #15
    Hyperactive Member pgag45's Avatar
    Join Date
    Mar 2007
    Location
    Colorado
    Posts
    262

    Re: [RESOLVED] Creating text box

    We need to know if you are importing this into Excel or Access...

  16. #16
    Junior Member
    Join Date
    Apr 2007
    Posts
    16

    Re: [RESOLVED] Creating text box

    haha. yes. makes sense after reading the previous posts.
    i was just scanning for the vb code box.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width