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 Chriss Miller 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. roppetech

    Form default values

    I created a query that finds the max rank value of the class/heat combo +1 for the default value of the Rank field but I'm not having any luck." I've had problems using the default value like this too - i was getting duplicate entries of the same number. for me, the solution was to set the...
  2. roppetech

    Tab Control & Tables - Issues!

    For what you're doing, I'd suggest using multiple tables, each in a subform. You can change the recordsource for the subform anywhere in your code simply by frmInventory_sub.recordsource = "SELECT * from tblPrinters" frminventory_sub.refresh - RoppeTech
  3. roppetech

    Credit Card Numbers

    SkipVought, your 'be advised' messages make me cringe, laugh, cry, and want to gut myself all at the same time :P - RoppeTech
  4. roppetech

    Inserting into a table using values from comboboxes

    you should be able to reference the id field of comboboxes by: cboEmployees.column(0) - RoppeTech
  5. roppetech

    Run-Time 3705, Operation not allowed [open object]

    Are you closing rstRate before your NEXT line? It might help to see the rest of the sub. Also, which line gives you the error? - RoppeTech
  6. roppetech

    Query question -- Access 2000

    It should be simple to create a query with these four fields. Try this if you haven't already: Create a new query in design view. click the 'add table' button add both of your tables double-click each desired field in the field lists You should see all four fields on the bottom of the screen...
  7. roppetech

    Running a OnClick_subrotine Using other events

    I'm not sure what you mean, but functions are pretty much the same thing. You can do one of these: Public Function AcceptQuote(strAmount as String, strName as String) msgbox "Thank you, " & strName & " for accepting this quote of " & strAmount ... End Function Followed up by a few...
  8. roppetech

    How can I find the last date in subform??

    oh shoot! my fault. ORDER BY must be after the WHERE clause. try this one: strsql = "SELECT TOP 1 * FROM tbl1" & _ " WHERE [Invoice Number] = " & txtInvoiceNumber & _ " ORDER BY [Date Paid] DESC" - RoppeTech
  9. roppetech

    Running a OnClick_subrotine Using other events

    something like should work for pressing a button, or calling any other subroutine: private sub form_open() command0_click end sub simple, eh? - RoppeTech
  10. roppetech

    How can I find the last date in subform??

    try putting a space after DESC in this line: strsql = "SELECT TOP 1 * FROM Payments " & _ "ORDER BY [Date Paid] DESC" & _ "WHERE [Invoice Number] = " & Invoice_Number so it reads like this: strsql = "SELECT TOP 1 * FROM Payments " & _ "ORDER BY [Date Paid] DESC " &...
  11. roppetech

    How can I find the last date in subform??

    Great! I'm glad it worked out. To filter by invoice number, use code similar to this: Dim cn As New adodb.Connection Dim rs As New adodb.Recordset Set cn = CurrentProject.Connection strsql = "SELECT TOP 1 * FROM tbl1 " & _ "ORDER BY [Date Paid] DESC " & _ "WHERE [Invoice...
  12. roppetech

    How can I find the last date in subform??

    You'll have to replace tbl1 with the name of your table which contains "date paid". You'll also have to replace txt1 with the name of the textbox you want to display the output - RoppeTech
  13. roppetech

    How can I find the last date in subform??

    try this: Dim cn As New adodb.Connection Dim rs As New adodb.Recordset Set cn = CurrentProject.Connection strsql = "SELECT TOP 1 * FROM tbl1 " & _ "ORDER BY [Date Paid] DESC" rs.Open strsql, cn rs.MoveFirst txt1 = rs.Fields.Item("Date Paid") rs.Close cn.Close Set rs = Nothing...
  14. roppetech

    Open Form Filter Issue (Inconsistent)

    This is how i understand your form structure, please correct me if i'm wrong: frmCompany: company single form -frmCompany_contacts: contacts continuous subform frmContact: contact single form Have you tried this? Define a global variable (in a module) called sqlContact. In your Select Case...
  15. roppetech

    Open Form Filter Issue (Inconsistent)

    Double click on the contact & it "should" open up the contact record. However, it opens up all records. " I assume you mean to open the contact record in a new form? Have you tried: docmd.openform "frmContact",,,"cntID = " & contactID This will set a WHERE condition on the recordset of the...
  16. roppetech

    Remote/Citrix?

    In my company, we don't use citrix at all on our laptops for several reasons. I'd recommend installing all programs, especially outlook, locally on all laptops. We used to use the citrix web client on the laptops, which allowed them to log in to their apps from anywhere on the internet, but...
  17. roppetech

    Citrix Messaging

    I agree with Philly that the best way to deal with it would be to actually show her how you sent the message, using a test, and show her what you are and are not capable of. It also might help if you have other citrix admins with you to 'back you up' that you can't see what she's doing because...
  18. roppetech

    Creating a help option

    I've never really used it, but a friend gave me this address on creating helpfiles: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/htmlhelp/html/vsconHH1Start.asp You should check it out. Hope it helps! - RoppeTech
  19. roppetech

    Copy Date to Text Field

    No problem, always glad to help! Thanks for the star - RoppeTech
  20. roppetech

    Copy Date to Text Field

    try this: set the default value of your text field to "C:\Temp\Files to strip\" & format(now(),"ddmm") & ".lwl" hope it helps! - RoppeTech

Part and Inventory Search

Back
Top