Search results for query: *

Hello, I'm trying to make a VB form that has a compass display on it. I want to display the reading from a digital compass sensor on a form and I am using Visual Basic 6.0. I can't find any built-in compass gauges, except for expensive downloads in Aviation packs, and wondered how I could do...

Hi, I'm having problems with Access 2000 on an XP Pro computer. The MSACCESS.EXE process hangs-up, when I exit Access. (I’ve looked everywhere for an answer. The standard answer is that some recordset in my VB code is not closed or the ‘Set RecSet = Nothing’ is missing. This is not the...

Hi, I'm using Windows XP and I just started using the "Desktop Manager" powertoy toolbar function. The one Microsoft recommends (and publishes) but does not support. (I can't find out who supports it.) If I have the ‘Shared Desktops’ setting turned on, then this problem does not occur. I only...

I have an Access2000 database where the user can choose to run multiple reports at once. When the user clicks "Run", I use a "For Each" statement to print a report for each record selected in a multiselect listbox on the users form. One problem I had was that the same report...

Hello, How can I create a recordset that will search every table in my database for a specific value? Not all the tables contain the field [Customer]. E.g. Dim sSQL As String sSQL = "SELECT *.[Customer], *.[User] FROM * " & _ "WHERE (*.[Customer] =...

Hello, I have created a database and I want to deal with any problems that may occur once it's up and running. I want to add Error handling code to my database that creates a new record in the 'Error' table, each time there is an error, and stores information about the type of eror that occured...

Hello, Ok, here is the situation. I have a database, which loads contracts, and payments, then produces a report for each contract. I have a multi-select listbox that lists each contract in the main table. The user clicks to select the desired contracts, in the listbox, then clicks a button to...

Hello, I have a form that is based on one table and a subform based on a second table. The main form displays one record from the 'Customer' table, and the subform displays all the related records from the 'Payment' table. The 'Link Master Fields' is [Contract Number] and the 'Link Child Fields'...

Hello, I have a form that is based on one table and a subform based on a second table. The main form displays one record from the first table, and the subform displays all the related records from the second table. I want to pass a value from the main form, to each record on the subform. I can’t...

Hello, I have created a variable that records the names of all the tables in my database. (i.e. TBLNMLST) I also have a Variable that is unique to each user. (i.e. USRID) I want to check the USRID variable against the TBLNMLST variable to see if there is an existing table in the database, with...

How do I base a continuous forms' recordset on the miltiselect column(0) values of a (.rowsource query) listbox? I Have a list box that fills in with contract numbers in the first column, and details about each contract in the following columns. I want the user to be able to "Multi...