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

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

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

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

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