I have only dabbled in Javascript. I cobbled this code together from articles I have read on line and got it working with the exception of the "document.write()" enclosed below. All other document.writes in this web page work fine, but I do not understand why this one misbehaves. It fires, so...
I am running WinXP Home SP2 on a Dell 4700.
I have no idea at what point this happened. One day I accessed the Add or Remove Programs List to find the alphabetical order had shifted. The list now starts with Power Options and ends with Portable Media Devices. Everything is still there, it's...
I am trying to let the user toggle a boolean field (Yes/No) by double-clicking on the record line in a datagrid. This is the sub that I have, and I am getting a 6160 Data Access Error on the ...Text = ... lines. I have the datagrid set to AllowUpdate, and Enabled and such. I am using an...
Just when I thought I knew what I was doing...[blush]
I am recieving the error "Customer's event handler called a non-reentrant method in the provider." on the red line below when I change a QTY field in the DataGrid:
===========================================================
Private Sub...
I have been using MS Access for years, but just recently I'm trying to migrate to VB6 with a bit of a strugle! I get a Type Mismatch error on the line indicated below. What am I missing?
==================================================
Private Sub Form_Load()
Dim dbs As dao.Database...
I've searched through countless threads about populating a text field with selections from a multiselect listbox. And now that I understand that I can't do it with a combobox, how does one go about doing it with elegance?
It appears to me that the only way to accomplish it is to display the...
I have a continuous form (not a subform) with a table as the record source. The record selector buttons are turned on. And even though the Access Help file says "The SelHeight property. A Long Integer value between 0 and the number of records in the datasheet or continuous form."...
I have a Continuous Form with a table as it's data source. I need to set the yes/no field for each record in the table when a user selects one or more of the records using the Record Selector buttons.
I have not been able to find any property that can be tested for "true" indicating...
I have a Continuous Form with a table as its data source. I need to set a yes/no field for each record in the table when a user selects a range of records using the Record Selector buttons.
The "range of records" that I refer to is when the user clicks on the record selector button...
I am trying to recreate an application in Access 97 that was originally written in Xbase. In particular, a report that summorizes fields that may or may not contain data.
Each year the user creates a new table that will contain that year's data. At report time the user is allowed to select...
I have a table displayed with a continuous form that has header and footer sections. In the header section, instead of Labels as column headers I have Command Buttons that, when pressed, sort the table on that field (column). The following is an example of the code I have for OnClick...
I am hoping someone can tell me how I would go about changing the background color of records that a user selects using the record selectors down the left side of a continuous form.
I am hoping there is a better way than keeping track of the SelTop/Left/Height/Width properties. Although I...
I've got a Purchase Order table that contains the Vendor Number and the Total Dollars for that particular purchase. Then I have a Vendor table, related to the Purchase Order table by Vendor Number, which contains three yes/no check boxes indicating whether or not that particular vendor is WBE...
I've got a text file that the following code reads behind the splash screen to verify/update the linked table connections. For example, this line:
CC Numbers = C:\Files\Db\Lists.mdb
is read and parsed into the sTable (left side) and sFile (right side) variables to be used to set/verify the...
I have modified the following code in the Switchboard form created by the Switchboard Manager add-in that comes with Access 97 to hide the switchboard form when other forms are opened:
Select Case rst![Command]
' Open a form in Add mode.
Case conCmdOpenFormAdd...
I have a form with subform displaying purchase orders from a pair of tables with a one-to-many relation. The main table is "PO Header" which contains POnumber, Requester, Date, etc. and a child table "PO Details" which contains POnmber, Description, Quantity, Cost, etc...
I am trying to create a pop-up form that a user can use to search for a purchase order. I thought I could use a clone of the recordset for the subform (which contains the desc of items purchased). I don't get any errors, just no record movement on the form. In the debug screen I am verifying...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.