Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. h3lm3t

    Table testing with loop

    Hi there, i want tto ask your opioion to see if something is possible. I would like to test the limits of my tables within the database. Is it possible to use code that started with a single character "a", insert that into a table, then loop through until the valid limit is reached ...
  2. h3lm3t

    INSERT into with variable ??

    Hi there I need help with an insert into statement, i have a variable that i want to put into a table. The variable has value, i checked in debug, i cant see the error, it passes the vb syntax error handler, but gets stopped at runtime. manuID is the variable tblStock has 5 attributes...
  3. h3lm3t

    Read Listbox Contents to string

    Hi Bill that worked a treat Sir, thank you!! Wonder what other problems await me 8-) cheers for the help h3lm3t
  4. h3lm3t

    Change a text box to a combo box, acCmdChangeToComboBox

    Hi Bill, thanx for the reply, i had been to that site, i ended up doing a workaround. I messed around and got this close form open form in design Me.txtManuName.ControlType = acComboBox close form ( over-ride the save) open form that worked, just incase anyone wants to know. Again ta for the...
  5. h3lm3t

    Read Listbox Contents to string

    Hi there, i need help in putting a listbox selection into a string. Ive tryed it may ways, and keep getting, "invalid use of null" i have 4 global variables 2 listboxes with 2 columns each, each listbox is bound to column 1, and only lists column 2, using the 0",1" trick...
  6. h3lm3t

    Change a text box to a combo box, acCmdChangeToComboBox

    Hi there, i having trouble changing a text box control to a combo box, i looked at MSDN but could not find the correct sysntax, or even any refernece to the function. Its part of doCmd.RunCommand Any ideas n how to change it ? Thanx in advance for any and all help cheers h3lm3t 8-)
  7. h3lm3t

    Passing a form as a parameter to a module

    Hi Tony, again you have helped me, thank you very much sir!!!! o doubt i will be asking of your knowledge again. kind regards h3lm3t 8-)
  8. h3lm3t

    Passing a form as a parameter to a module

    Hey Paulo, i think ive made the questsion too hard, and because of that no-one gets wgat i mean, (not even me) ;-) I'll start again. Simply, how can you use a module in all forms. I mean actualy use a specific form in the module, when you dont know the form name beforehand. Can you use a...
  9. h3lm3t

    Passing a form as a parameter to a module

    Hit there thanx for looking, i need help in passing a form to a module. Ive made a module that deals with navigation and 2 buttons that are common across 10 forms. What im trying to do is pass the form that currently has focus, so i can use the underlying module code. in the form control...
  10. h3lm3t

    Working with a copy of a form

    Hi there thanx for looking, i need help understanding and using a copy of a form. I want the user to view some records via a form, but when the want to edit a specific record, i want a popup of the currently selected record to appear as a new form. Originally i made 2 forms, with an edit...
  11. h3lm3t

    SQL select from....using variable question

    Thanx for the help, Tony i really didnt want to go down the recordset route, coz i thought it would be a major can of worms, but you forced me, and now using recordsets i have the info i needed from the tables. Thank you very much !!!!
  12. h3lm3t

    SQL select from....using variable question

    Hi ther thanx for looking, i need help with a SQL syntax question. I'm not very good with SQL and have never used in within VBA. I have 2 list boxes that provide the criteria for the SQL They work correctly and return the correct values, they are both string data types: manufactName as string...
  13. h3lm3t

    Passing values between forms

    Hi Rolliee, thanx for the help. helmet@blueyonder.co.uk cheers h3lm3t
  14. h3lm3t

    Passing values between forms

    Hey there thanx for looking, i need some basic help. I built a form based on one table, i only want the user to navigate through this form. I bult another form in design view so that when the user clicks ADD new record, the second from comes up and allows them to enter values for a single...
  15. h3lm3t

    Recordset Question

    Thanx very much for the help, i see what you mean now 8-) I also mucked around with some recordsets, and seen their value when i looked in the local and immediate windows. Thanx again h3lm3t 8-)
  16. h3lm3t

    Recordset Question

    Hi there, thanx for looking, (my first post) I'm a bit new to using VBA inside of access, i did the proper thing and bought a book, and thats got me through BUT some things are missing: Why should you use a recordset ? - i mean if you can get data out of the tables by referencing them through...

Part and Inventory Search

Back
Top