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!

  • Congratulations Wanet Telecoms Ltd 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: zevw
  • Order by date
  1. zevw

    Editing Table by looping through fields with different number

    This was all for a temp table and not a structural permanent table! I also did not have a chance to read the article! Thanks guys!
  2. zevw

    Editing Table by looping through fields with different number

    I searched while waiting and did this and it works! rst.Fields("Field" & Cnt) = splt
  3. zevw

    Editing Table by looping through fields with different number

    I am going through a description field in a table separated by spaces I am using Split to capture each word in a separate field and the place it in the same table in field1, field2, field3 each time I loop around How can I code the rst!field1 = splt since the number 1 is placed in through a...
  4. zevw

    Looping through all forms and deleting them

    I am looping through a Database and want to delete all its Forms, in the middle of looping it gives me a error the object or Name does not exist or invalid. Is there a more proper way how to do this? Dim frmName As String, i As Integer For i = 0 To CurrentProject.AllForms.Count - 1...
  5. zevw

    Getting the name of a subform

    How do I now combine the variable with this string WrdNum = "Forms!ReviewForm!" & FrmName & ".Form.WordId" doesn't work its a string WrdNum = Forms!ReviewForm![FrmName].Form.WordId It doesn't recognize FrmName as a variable?
  6. zevw

    Getting the name of a subform

    Thanks! Since it was in tab control it was giving me the name of the Tab. So I used FrmName = Screen.PreviousControl.Form.Name
  7. zevw

    Getting the name of a subform

    I have a record selected in a subform and I click on delete in the parent form I know I can do Form![Parentform]![Subform].subform How can I get the name of the subform with Me.Name Me.Name gives me the parent form name not the subform name
  8. zevw

    Displaying Message While Form Loads

    Thanks! It works great!
  9. zevw

    Displaying Message While Form Loads

    This form that I"m loading takes 15 to 30 seconds to load, I am looking for a way to display a message to the user while its loading like every 5 second like this! "Have Patience ... this will take a moment to load!" The msgbox is not appropriate because it waits for user input what can I do...
  10. zevw

    Figuring out which object type opened

    I put it all the way at the end the Load Event Procedure and it works fine. Thanks!
  11. zevw

    Figuring out which object type opened

    I Thank You for the valuable information. I have a minor problem I created a function and call it in the open event procedure Private Sub Form_Open(Cancel As Integer) CurrentDb.Properties("AppTitle").Value = Nz(DLookup("HName", "Company"), "") Me.Company.Caption =...
  12. zevw

    Figuring out which object type opened

    Is there a way to figure out if the object on the screen is a form or a report. Can I write a function when a form opens I can capture if its a form and if its a report capture the report and manipulate the menu bar. Thanks in advance!
  13. zevw

    Manipulating a button of a menu bar

    Thanks I will try it tomorrow!
  14. zevw

    Manipulating a button of a menu bar

    I created a custom Toolabar and use it as the default menu Bar (I'm not sure if this is the same as a command bar?) I"m trying to find the On Action property and can't find it. Can you please guide me where I can find it? Thanks!
  15. zevw

    Manipulating a button of a menu bar

    I understand that I can disable a button on a menubar with the following code: CommandBars("MenuName").Controls("Print").Enabled = False Or to hide CommandBars("MenuName").Controls("Print").Visible = False However I want to manipulate the Print button and see what is being printed a form...
  16. zevw

    When Clicking on Printer Icon check if its a Report or Form

    Thanks vbajock I appreciate the links and understand how I can see which screen is active at the moment. However I want to know where would I put that code when I click on the Print Icon or hit Ctrl P. (in other words is there an event procedure that occurs when the print icon or ctrl p is...
  17. zevw

    When Clicking on Printer Icon check if its a Report or Form

    Can I manipulate the printer icon with code that when its a form that the focus is on, it should prompt the user to ask if they want to print the form, and when its a report it should print it without prompting? Where would I place code like this since it a global function? Thanks in advance!
  18. zevw

    Navigation Bar Reappears

    The "Displane Navigation Pane" is unchecked in Access 2007. However Every time I change Function (Dinner, Fund Raiser, Tea Party) it raeppears and I don't undestand why? [code] Private Sub Form_AfterUpdate() Dim dbs As Database, tdf As TableDef On Error GoTo Err_Form_AfterUpdate If...

Part and Inventory Search

Back
Top