Search results

Eureka! I found it. I looked back through some old posts and databases that I had and found something that was closely related. I don't understand the syntax, but it works. I changed the line to strLinkCriteria = "[PONumber]= '" & Me.lstPOInfo.Column(0) & "'". Here is the working code...

I tried it without "[PONumber]=" & and it still opens the box and it no longer links opens the correct record.

I am trying to use the double click event of a listbox to open a form to a specific record. The problem I have is when I double click a record, Access pops up a box asking for PONumber (which is in column 0 of the listbox). Here is the code that I am using: Private Sub...

This is a wierd problem, at least to me. I used the report wizard to generate a simple report. It simply pulls a list of customers from the customers table. In the customers table, the CustomerID field is my primary key so no duplicates are allowed. When I view the report, however, the...

Yep, it runs without anything in the text boxes. Thanks for the requery line. I didn't even think about that. It worked though!

I'm having trouble clearing a form and the query results at the same time. I have a list box that is populated by a query that gathers search criteria from user input in unbound textboxes. If the user types in criteria, then that is used in the query. If they just click search, then all results...

Thanks. Thanks for the help. Using your example I was able to get what I need. :)

Ah Hah! Ah hah! My problem was similar and this is the bit of code I was after. Why is the syntax for text different than for everything else?

I guess the trouble I'm having is getting the search form to return the value. I have attached an example. I just need help getting the value from the listbox to the purchase orders form. :)

This is probably failry simple if you know what you're doing, but I don't know what I'm doing.... I have a form (Purchase Orders) and on that form there is a search button to allow the user to search the customers table by customer name. When the user clicks the search button a search form...

I found it After more than a day of searching, I found what I was looking for. Here is some information on running a Crystal report from Access. http://support.businessobjects.com/library/kbase/articles/c2009907.asp Here is an example of how to run a crystal report (ver 8, 8.5 and 9) from...

Has anyone around here successfully implemented the Crystal Reports Viewer Control from Access? I have the Viewer control placed on a form, but from there I'm lost. The instructions I have say to set the 'ReportFileName' property to the path to the report, but I do not even see such a property...

Aah ha! you were right. :) I changed the line around a little bit and now it works. :D strNextAvailable = 1 + Nz(DCount("[InvoiceDate]", "tblInvoice", "[InvoiceDate] = #" & Date & "#"), 0) Thank you for your help!

I know I know, another Dmax/Dcount question. :mad: I didn't want to ask it, but I just can't figure out why my Dmax/Dcount statement won't increment. Every time the string is combined I get a value of 1 from Dmax/Dcount. I have tried both Dmax and Dcount and I get the same results from them...

Not sure about the Dmax() part I know this thread is a couple of years old, but it describes exactly what I am trying to do. I do not understand how to use DMAX to determine the next available number for the "YYMM" combination. Could someone please explain? This is what I am using so far...

I think I found what I was looking for. :) http://www.access-programmers.co.uk/forums/showthread.php?t=50389&highlight=count+query

What if How would this be done if you wanted the "000" to be used up? Format([NextSeqNbr],"000") would always give me three leading zeros, correct? If my number were INV0001 and I used Format([NextSeqNbr],"000") what would I do when I had ten orders? How could I make INV00010 (one digit too...

Thanks, it worked Hey thanks guys, that's exactly what I was looking for.

Hey thanks for the tip about the date! I have a project that I have been messing with where I can use that!

I am trying to create a product code based on the text that is in several different text boxes. I have a product name (W22) a manufacturer (Stuff Manufacturing Inc.) and a product type (Wiget). I would like for the product code to be a combination of parts of all three. The result, for example...