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

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

    Type Mismatch

    Hi - I've used this code hundreds of time w/o a problem, but today is a new day. I keep getting a Type Mismatch error when I run: Dim CurDb As Database Dim rTmpNotes As Recordset Dim sSQL As String Set CurDb = DBEngine.Workspaces(0).Databases(0) 'open Temp Ship notes table sSQL = "SELECT *...
  2. 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...
  3. 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!
  4. 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...
  5. 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...
  6. 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...
  7. vlingen

    Written dollars on a check

    Hi All, I'm working on creating 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...
  8. 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!
  9. vlingen

    Insert statement w/ Wher wildcard "11163*"

    How do you write a SELECT statment when the WHERE has a wildcard 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...
  10. vlingen

    Sync Record Pointer across tabs/subforms

    Hi - I have a form with 3 tabs. Each tab has a subform. Each subform is based on different queries that all pull from table "A". I'm looking for a way to synchronize the record pointers across the three tabs and do it without filtering the data. Example: If the user clicks on the 1st tab...
  11. vlingen

    SendObject

    I am currently using the DoCmd.SendObject to create a MS Outlook email with an attached Report file. DoCmd.SendObject acSendReport, rsSteamship!ReportName, acFormatRTF, rsSteamship![EmailAddress], , , "Subject line of email", EmailBody It works great. Now what I'd like to do is add the...
  12. vlingen

    Highlight data when tabbing

    I've found that if the textbox data format property is "general" - all the data in the field will be highlighted as the user tabs through the fields on a screen. Now if the textbox data format property is "number" or "date" - the cursor flashes in the field and the data is not highlighted...
  13. vlingen

    2003 Server vs Win XP

    I have a VB6 app with SQL 2000 data that works great on multiple Win XP machines. I then installed the app on a 2003 server Sp2 with SQL 2000 and suddenly the code that use to open one window, opens 20+ windows. Essentially its an Order Entry screen and you select a button to open the Part...
  14. vlingen

    Continuous Form Suggestions?

    Hi All, I have a continuous form that's used to enter employee time. There is a drop down box that the user selects a Pay code. The pay code determines if the user enters "Hours" or a "Flat Dollar Amount" I'm either looking for a way to have one Amount field where the Format changes...
  15. vlingen

    Conditional Formatting on Continuous Forms

    Looking for a way to set a numeric text field to either Amount.format = "Currency" or Amount.format = "General Number" The field is on a Continuous form so I need the format to stay with the record based on my expression. I'd like to use the Format-Conditional Formatting wizard, but that only...
  16. vlingen

    SQL Server 2005 Express

    Through my job I've been assigned to customers who have different SQL systems.... Anyone know can you backup a SQL Server 2000 database and restore it to a SQL Server 2005 Express? or to MSDE? Is there a reason I should try to install more than one of these systems on my laptop at the...
  17. vlingen

    ODBC Link & MS Access

    I set up a Database/table in SQL 2000 and used an ODBC link to link to the external data in my Access 2003 project. The parent tracks Warranty Claims and the child Payments. I do not have a relationship set up in SQL. I entered some data via my MS Access forms. Two child records for Claim 1...
  18. vlingen

    SQL 2000 Data - ODBC link

    I set up a Database/table in SQL 2000 and used an ODBC link to link to the external data in my Access 2003 project. The parent tracks Warranty Claims and the child Payments. I do not have a relationship set up in SQL. I have a form set up with a continuous form subform. I add the parent...

Part and Inventory Search

Back
Top