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 derfloh 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: *

  1. vlingen

    Type Mismatch

    That worked! Thanks so much, but I don't understand. I've written the code as displayed many times in the past without any problems. This time I'm dialed into a customer and suddenly I need the "DAO" Thanks for you quick response.
  2. vlingen

    Type Mismatch

    ...Database Dim rTmpNotes As Recordset Dim sSQL As String Set CurDb = DBEngine.Workspaces(0).Databases(0) 'open Temp Ship notes table sSQL = "SELECT * FROM _TmpShipNotes" Set rTmpNotes = CurDb.OpenRecordset(sSQL, dbOpenDynaset) The error occurs on the last line. Any suggestions would be...
  3. vlingen

    Word 2007 - Macro on Quick Access Toolbar

    Hi All, I have a simple macro that works great when run from the View Ribbon - Macros window. It basically enters the file path & date into the document. But if I try to run it from the Quick Access Toolbar, I get an error with only an OK & Help buttons. (Help takes you no where) Any...
  4. vlingen

    Test if form is open

    Hi All, I expect this is an easy answer... How do you verify if a form is already open when working on a different form? Thanks!
  5. vlingen

    Table Data in a text box

    Thank-you that worked great!
  6. vlingen

    Table Data in a text box

    Hi All, I'd like to take the data from a query and list it with commas in a report text box. Query data Record # Value 1 A 2 B 3 C 4 A 5 B I'd like to display the results as "A, B, C, A, B" I know there will never be more that 7...
  7. vlingen

    IIF statement matching with another field

    Lets say your Main form is called "Mainform" and it has two fields: Area and Perimeter. Then your subform contains two fields Combo123, AorP You might want to try something like this in the OnChange of the Combo123 IIF(me!Combo123 = "Area", Me!AorP = Forms!Mainform!Area...
  8. vlingen

    Adding with SQL data

    Hi All, I am having a "timing" issue. I have an Add button that opens a form in Add mode. The Invoice header info on top is linked by InvoiceId (autonumber)field to an Invoice detail subform on the bottom. Tables: InvoiceHeader: InvoiceID, CustId, InvDate... InvoiceDetail: InvoiceID...
  9. vlingen

    Locking Fields

    I'm working on a very simple inventory form. A single form 10 fields, no sub-forms or tabs. I have some code set up that when the user moves between records on the form, it performs some data validation. It checks if the inventory item is found on an Order. If it is, I want to "Lock" certain...
  10. vlingen

    Written dollars on a check

    ...and my issue is on the line where it writes out "Twenty-five dollars" or whatever the amount is. I have the written words, but I need to add the "*****" to fill up the blank space. I'm missing the function that fills in the "****" for a select number of spaces. The total Length of the line...
  11. vlingen

    Hide Visual Basic Code?

    On the OnOpen of the Login form I call the Module... DoCmd.OpenModule "GlobalVar" The only thing in the module is: Option Compare Database Public StrRights as String Public pTerminal as string Then the User enters in the User name/password press OK button. The VB window opens before the...
  12. vlingen

    Hide Visual Basic Code?

    I'm still having the same problem, but here are some things I tried... I created the mde, but get an error when it tries to define the Public variables in the module. I tried moving the Public statements into a function of the module - error there too. You can't define a Public variable within...
  13. vlingen

    Hide Visual Basic Code?

    I set a "login" form and when they press the OK button it calles a module "GlobalVar" which has: Option COmpare Database Public StrRights as String Public pTerminal as string and that's it.
  14. vlingen

    Hide Visual Basic Code?

    My project has a primary form that is launched at startup of the MS Access 2000 application. On this initial form, I define some Global variables. When that happens the Visual Basic window opens exposing all the underlying code to the end user. Is there a way to hide this? Thanks!
  15. vlingen

    Edit Hyperlink browse to C drive

    Did you find a solution to your problem? I'm experiencing the same thing. Thanks.
  16. vlingen

    Insert statement w/ Wher wildcard "11163*"

    ...SALENTRY.BLDG_STYLE, SALENTRY.PIN, SALENTRY.AC_SF, SALENTRY.ENTRY_DATE, SALENTRY.YEAR_BUILT FROM Salentry WHERE Salentry![Pin] Like 11163* But I get a Syntax error (missing operator) in query expression 'Salentry![Pin] Like 11163*', occured in CmdFilter_Click Thanks for the help.
  17. vlingen

    Insert statement w/ Wher wildcard "11163*"

    ...in VBA? Example: INSERT INTO SFilterTable (ID, Field1, Field2) SELECT Sale.ID, Sale.Field1, Sale.Field2 FROM Sale Where Sale.Field1 = 11163* Essentially what I have a a Find Form where the user can choose to include or exclude criteria for every field in the table. One request was to...
  18. vlingen

    Sync Record Pointer across tabs/subforms

    Hi All - Thanks for your help. Here is the code that finally worked. (I had the subform name wrong) Dim nid As String nid = Me.SID If Me.TabCtl0.Value = 0 Then Me.SALENTRY1.SetFocus Me.SALENTRY1.Form.Recordset.FindFirst "SalentryID =" & nid End If If Me.TabCtl0.Value = 1 Then...
  19. vlingen

    Sync Record Pointer across tabs/subforms

    No matter what I can't get past the error - Method or data member not found. I tried: Me.SALENTRY1.SetFocus Me.SALENTRY1.Recordset.FindFirst "SalentryID =" & nid Me.Page2.SetFocus Me.Page2.Recordset.FindFirst "SalentryID = " & nid Me.Page3.SetFocus Me.Page3.Recordset.FindFirst "SalentryID = "...
  20. vlingen

    Sync Record Pointer across tabs/subforms

    I tried this: Me.SALENTRY1.RecordsetClone.FindFirst "SalentryID =" & me.sid Me.Page2.RecordsetClone.FindFirst "SalentryID = " & me.sid Me.Page3.RecordsetClone.FindFirst "SalentryID = " & me.sid but get an error - Method or data member not found. I also get this error as a "Recordset

Part and Inventory Search

Back
Top