Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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