Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Duane8889
  • Content: Threads
  • Order by date
  1. Duane8889

    update form with combobox selection

    Hello I'm trying to update my contacts form with a combobox. I'm using Access 2k. I tried this code: private sub cboName_AfterUpdate() me.recordsetclone.FindFirst "[ID] = " & Me![cboName] me.bookmark = me.recordsetclone.bookmark end sub private sub Form_Current() cboName = ID end sub...
  2. Duane8889

    missing reference

    Hello I'm trying to open an Access db that is an older version than my 2k but I'm getting the error "Compile error. Can't find project or library". It refers to this bit of code - Dim dbs as Database If I press the help button on the popup with the error description it refers to the help...
  3. Duane8889

    delete a listbox entry

    Hello I want to delete a selection from a listbox. My wizard created this delete routine for me but I think it pertains to a textbox choice for deletion. Private Sub cmdDeleteEmployee_Click() On Error GoTo Err_cmdDeleteEmployee_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, ...
  4. Duane8889

    update textbox

    Hello I need to update a textbox that shows the number of items in a listbox. I tried using this code but I suspect that asCmdSave Record isn't right Private Sub lstEmployees_AfterUpdate() DoCmd.RunCommand acCmdSaveRecord DoEvents txtCount.Requery End Sub It doesn't do anything...
  5. Duane8889

    Requery listbox

    Hello I'm trying to update a lstbox after adding an entry to it through a textbox. I suppose it works like I add make an entry to the textbox that goes to a table. The listbox shows records from the table from it's RowSource. I hope that made sense. It will show the update if I leave the form...
  6. Duane8889

    number of items in a listbox

    Hello How do I count the number of items in a listbox? I've been playing around with the listcount prop but with no luck. I wish to put the number on a label or textbox. thankQ
  7. Duane8889

    sort a listbox

    Hello I would like to sort the items in a listbox alphabetically. In visual basic there is a sort property but I don't see one in Access 2k. What is the best way to sort listbox items? Duane
  8. Duane8889

    Buttons on a report

    Hello Am I losing my mind or is it not possible to put a button on a report? I just get the magnify glass with a + or a - in the middle of it. Not the usual cursor arrow. Duane
  9. Duane8889

    recordcount

    Hello code gurus Is it possible to get the recordcount without using ado? I just want to know how many entries are in my employees table. In Visual basic I used code like... lblRecord.Caption = adoPrimaryRS.RecordCount but as I mentioned I didn't go with using recordsets etc in this project.
  10. Duane8889

    Date

    Hello How can I display current date in a textbox? ex June 12, 2005. I don't want 6/12/05 or Sunday, June 12, 2005. I tried =Format(Date(),"mmmm dd "," yyyy") in the control source of the textbox on a form but I just get #Error in the textbox.
  11. Duane8889

    ByRef argument type mismatch

    Hello I'm trying to call this function but am getting the error "ByRef argument type mismatch" I'm using Access 2k and calling this from form code. Private Sub cmdDeleteRecord_Click() Call DelRecord(strName) ' error here End Sub ' delete routine Private Sub DelRecord(strName As String)...
  12. Duane8889

    give focus to textbox in report

    Hello I'm trying to pull a report from a form and have a textbox in the report have focus. I'm using this code in a click event... Reports!rptRotationTwoDay!txtDate2.SetFocus but I'm getting the error"MS Access doesn't allow you to use this method in the current view. Any ideas? thanks Duane
  13. Duane8889

    Modify Date

    Hello I am using Access 2k and what I'm trying to do is create an expression that will change a Date label on a report. It is a two column report and each column is for a different day, generally consecutive days. But, if the current day is Friday it will ask the user if they are working the...
  14. Duane8889

    Best fit for report

    Hello I am using Access 2k and when I show my report it defaults to 100%. I have been able to maximize and minimize but what I would like to do is the best fit choice. A friend gave me this code... Private Sub Report_Activate() DoCmd.OpenReport "rptRotationOneDay", acPreview...
  15. Duane8889

    loop and validate

    Hello I am using Access 2k and have a form with roughly 50 combo boxes. They are in 3 columns as each column represents a time slot and each row is an equipment set. The combos will pull down with a list of employee names. It's basically a rotation schedule for work. Anyway I would like some...
  16. Duane8889

    query with multiple comboboxes to create report

    Hello I found this query bit that does a nice job of retrieving all the tables in my db. SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name; So I have a combobox that uses this query to...

Part and Inventory Search

Back
Top