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 strongm 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. SoCalAccessPro

    adding calculation to form

    This. Use DLookup, DSum or a user defined function. Here is how I do the same thing. I have function (This could have been Dsum, BTW) Public Function Sold() Dim sql As String Dim rst As New ADODB.Recordset sql = "SELECT Sum(tblTrans.SellPrice) AS SumOfSellPrice FROM tblTrans" rst.Open sql...
  2. SoCalAccessPro

    access macro continue on error

    You'll probably have to convert the macro to a VBA sub routine, and have another sub routine that checks and verifies the files exsistance. Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  3. SoCalAccessPro

    How to pass the value of a combobox to another function

    Assuming you have a user form. Create a combo, cboData and two textboxes, txtOffset1 and txtoffset2. Now, create a command button and drag it on the form. The follwing code should give you an idea on how to access the values in the objects. Private Sub cmdGetComboData_Click() MsgBox...
  4. SoCalAccessPro

    adding calculation to form

    Can you post your expression ? Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  5. SoCalAccessPro

    How to pass the value of a combobox to another function

    Or better yet, store the data in a database. Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  6. SoCalAccessPro

    single company with multiple locations, How to setup the table

    Yeah, you'd have a new table, tblCustLoc for arguments sake. In that table, you'd store the Main Customer ID and a new Location ID. Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  7. SoCalAccessPro

    Distribute Access Application - DSN

    Or.... Create a routine that checks the conencted tables and automatically creates a DSN as needed. I've done this with success on distributed applications. Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  8. SoCalAccessPro

    Error 461 Method or Data member not found

    Does your combo have more than one column ? If so, is the default/bound field the same type as the underlying table you're trying to write to ? Is the .Attended field boolean ? Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  9. SoCalAccessPro

    Data validation

    Maybe look in to select case and for next ? This is just psuedo code, but might give you an idea (I don't even think te allowedvalues property exsists): Select Case Me.field1 Case cva1 For i = 1 To 4 With Me.Controls .Item(i).Visible = True...
  10. SoCalAccessPro

    multiple phone numbers producing multiple details

    Well, yeah, with that conditional statement it's still gonna return a record for each phone number, only if it's not the primary it'll return empty string "". What you really probably want to do is make sure each customer has a phineprimary with a value of one, and inlclude that in your where...
  11. SoCalAccessPro

    handeling deleted records

    Not unless you have a command button that takes the original data and appends it to an archive table before you delete the record. What you just descibed is one reason i never give users direct access to tables in my applications. Another solution I have used is double entry type tables, kind...
  12. SoCalAccessPro

    Update Query Access 2003 using Global Variable

    If all your trying to do is retun the username, I do that all the time. The following SQL was just tested in a query and works fine. fosUserName is the name of the function that gets my user data. SELECT [2006 USD PRINTER MODEL CNT].*, FOSUsername() AS UsersName FROM [2006 USD PRINTER MODEL...
  13. SoCalAccessPro

    DAO vs ADO

    Yeah, you need ADO to play with other databases. I remember the panic back around 2000, and converting TONS of databases from DAO to ADO. I think I even wrote a FAQ for hear. One of the benifits of working with DAO is, IMO, the ability to access the DB Objects (Table Definitions and Query...
  14. SoCalAccessPro

    VBA/OLE documentation/howto request

    That code you reference is pretty generic for opening a recordset and spitting the results out to excel. For the data range, simply parametize your query. For the formulas, it's pretty simple. Look into the Formula property of the cell object ihn Excel. Tyrone Lumley SoCalAccessPro...
  15. SoCalAccessPro

    Error creating outlook email

    I've used the same code, and the only difference is I didn't explicitly reference the mail item as an Outlook.mailitem. I'm looking at code right now that works, and here is part of it: Dim olApp As Outlook.Application Dim olMail As MailItem Set olApp = New Outlook.Application Set olMail =...
  16. SoCalAccessPro

    Comparison

    That's because you deleted the join on Range and Code. Unless I'm totally mis-understanding you, all of the feilds combined should be a unique ID, correct ? Why would you drop 2 fields ? Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  17. SoCalAccessPro

    Setfocus afterupdate event question

    Should be as simple as: me.entryID.setfocus Should also be the last line in your code. Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  18. SoCalAccessPro

    Mail Merge from Access to Word

    Change SQLStatement:="SELECT*FROM qryDDDDocumentMerge" to SQLStatement:="SELECT*FROM qryDDDDocumentMerge WHERE [Your Field] = YourCriteria" Dunno about the warning. Have you tried docmd.setwarings = false ? Tyrone Lumley SoCalAccessPro http://www.socalaccesspro.com
  19. SoCalAccessPro

    Embedding Excel components into Access Report

    I've never done that. I have done it with powerpoint though. What I used to do was highlight my chart in excel, copy it, go to PowerPoint, right click, and use paste special. Actually, I just did it in Access. Use paster Special, Paste Link, Choose Excel Chart in the window. Updating the...
  20. SoCalAccessPro

    Comparison

    OK, this will get you every unique combination of records that is the same on both tables, and return the GroupID and the Code from the 2nd table. Note: I renamed some of your fields as you're using reserved words. Never name a field Type, Name, Range, Etc. SELECT tblGroupCode.GroupID...

Part and Inventory Search

Back
Top