Search results for query: *

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

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

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

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

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

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

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

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

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

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 " &...

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

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

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

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

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

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

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

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

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

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