Recent content by lmonroe

I have a query which returns the top 10 contract numbers based on a predetermined rank. Right now the report is very detailed which ends up with one contract per page. Does anyone know a way to list the top 10 in the report header so it would look like this? 1. Contract A 2. Contract B 3...

So...I really have very little experience with writing in vba...I looked up QueryDef but I think it's above my current knowledge level...anyone want to try and help me write this using spikepl idea? Here's the info My combo boxes are all in the form called : frmSL_Search1 The names of the...

This definitely looks like a great alternative, however i have a question: In the example, it displays the results within the form...is there a way to use the vb approach and get the results in a table the way a query does? I need to be able to create a report from search results.

For work I am designing a query the refers to a form for answers to parameters. I need the entries to allow null entries. There are 11 different parameters. I know how to put in the code and everything, but the query is so large that the computer doesn't have enough memory to run it....I...

Hello! I'm new to the forums but have already found it to be very useful! I'm about to graduate college and not an expert in the least, but I'm on my way (thanks in part to help from this forum)! Currently working for the state and working on a database for our procurement system. It's been...

It works!!! Thanks so much!!!

Ah! Sorry for the confusion! The first value in the column is the ONLY cell in the column that contains data. I was just trying to clarify that the data happened to be a date. (shouldn't matter though right?) I hope that clears that up.

Thanks for your help guys! :) Sounds very useful, but I am having a bit of trouble writing this... I need it to look in my tblPrioritazationScoreboard under the column As_of_Date and return the first value in the column which is a date. How would I write this with DLookup? I don't...

That was it! Thanks!

I have a bunch of Vendor Names, just a normal text field entry. I tried typing in Dell into the text box and got the results I described.

I tried doing it the way you suggested and doing it without the Like and & "*" the first way just returned all of the database and the second returned nothing...

I've been trying to figure this one out, and I'm not sure if it's possible, but rather than create a combo box for the form can I get this to work with just a text box? I have not had any luck thus far. I want it to be like when it asks for a parameter value, and you just enter something...

Hmm...is there any way to do this in a report? I'm just trying to return a single value from a table to show in the report. More specifically, I want to include in my reports that last day that the database was updated. So if there is another way to do this....

Can you be more specific on how to load a vb variable from a record? I can't seem to figure it out...please help!

That fixed it! Thanks!