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...
The issue isn't speed. In fact it works perfectly normal. The only issue is the order in which the control panel applets are ordered. They are still alphabetical, it's just that it starts and ends in the P's with the A's in the middle. Insted of starting with the A's and ending with the Z's...
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...
Thanks for your response. Although I have checked all those simple things, I'm sure it is something equally simple that I'm just not thinking of. I've tried all three...
datagrid.columns("BO") = "Yes"
datagrid.columns("BO").Value = "Yes"
datagrid.columns("BO").Text = "Yes"...
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...
...Private Sub DataGrid_AfterUpdate()
Dim dblTotal As Double, rstClone As ADODB.Recordset
rstNew!Exten = rstNew!Qty * rstNew!Cost
rstNew.Update
Set rstClone = rstNew.Clone
rstClone.MoveFirst
dblTotal = 0
Do While Not rstClone.EOF
dblTotal = dblTotal +...
It took a little mental chewing to figure it out, but once I realized that DBgrid and DataGrid wasn't just a matter of semantics, I realized that I didn’t have what you were referring to and looked to the Components List to add Microsoft Data Grid Control to my tool bar, which shows up as DBGrid...
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...
Well, I found a workaround for the time being. The Envelope report prints with each applicant entry upon being saved. So, at least, data entry can resume.
If I eliminate the PREVIEW the report prints properly. But this isn't the end of it. The user needs to SEE the codes for the envelope...
I thought for sure one of the two above approaches would work, but alass, not to be.
I changed the report call from the form to:
DoCmd.OpenReport "Envelope", acPreview, ,
"SSnum = '" & Me!SSnum & "'",
...
Thanks guys. I knew I came to the right place to resolve this.
The suggestion to use a hidden listbox lead me to a VERY elegant solution. In essence, it appears and feels like a combobox with the ability to multiselect items from the list.
It took a bit of code using the OnKeyPress event to...
If I understand you correctly, create a "visual equivalant" of a multiselect combobox?
That is, hide the listbox starting at the vertical level of the textbox that contains the result, downward over the top of other fields that lay below the textbox. Making it visable only when the...
The form contains all of the information about an employment applicant, including certifications and past history with the prospective employer. The applicants are part time, most returning for the fourth or fifth year. Hence, the form has a hugh amount of data on it. Far more than one would...
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...
In another thread I saw some references to "Form On_Dirty" in regards to Access 2000. I failed to mention that I am using Access 97.
I just tried mstrmage1768's suggestion which seems to effectively disable the the Form's CLOSE button as well as the Access Close button! It doesn't...
Bingo!! You're my hero! Two months of struggling only to find the problem and solution to be so trivial. That's always the way. The solution to the most exasperating problems are the most innocuous.
And how did you find that article. I have searched the knowledge base 6 ways to Sunday...
The application is a Tree Inventory for a major city. The main form is a continuous form listing the trees thoughout the city that the Forestry division must trim on a rotating basis.
Each day the crew foreman prints a list of addresses that the crew is to trim that day. When they return to...
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.