Search results

Why do I have to be all the way over here! Damn lol

remove extra space in the details portion of your design view.. above and/or below your text boxes. Might do the trick.

I'm saying that when using public variables, I've never had success with them carrying out the entire duration of the use of the application. Though that was way back when I first made the transition from working in .NET to working with Access. My idea was to place your queries either into a...

Ok so like I said, we're going to have to either have a sub query that joins your 3 distinct status/issues into a single field in the return collection or redesign your report. You have to think about your set of data that is being returned. and how it is displayed.

You can also redesign to use a group header.

send a screen shot of it in design view. Seems to be that you just have some extrea space in your detail design area.

Lets try showing us the code. This isn't a theoretical problem lol

Dim i As Integer For i = 0 To lst.ItemsSelected.Count - 1 MsgBox lst.Column(1, i) Next

If you only need the first two words use my inital suggestion but change the indexes to what you want lol.

Here is a function to test: Public Function ShortestWordLength(ByVal str As String) As Integer Dim var_split As Variant ShortestWordLength = 0 For Each var_split In Split(str, " ") If Len(var_split) > ShortestWordLength Then: ShortestWordLength = Len(var_split)...

You need to come up with some validation rules. limit the input to 2 characters for the initial or something. One way to test the current state of the initial lengths is to run a query that returns the results of the distinct shortest word length of each name. That way you can see what the...

Best way to approach this without running queries and what not every time is to select BOTH fields in order of name, email. then set your column widths field to = ;0" that way you are setting the first field to take what ever room it would naturally and hiding the second one. With that you...

Place this function in a new or existing MODULE Public Function SplitReturn(ByVal str As String, _ ByVal delimiter As String, _ ByVal index As Integer) As String SplitReturn = Split(str...

within a query or vba?

subquery. SELECT tblSomething.*, qryCount.Count FROM tblSomething, ( SELECT [link_field], COUNT([field]) FROM tblSomething GROUP BY [link_field], [field] ) as qryCount WHERE tblSomething.[link_field] = qryCount.[link_field] ORDER BY tblSomething.id

If there weren't so many queries and what not, you could store them in TempVars on load but that doesnt seem to be an option here! lol

I wonder if Binary Access Read / Write would be faster than linking to tables and using recordsets? Though in Access I find it is harder to load things into memory, and making them last a whole session.

Cool! Thought I was just throwing a wild pitch out there, glad someone with some credit has also come across it! haha

Something like this sub could send your queries into a table, once backed up and removed you could use the function as a quick mod method to your query calls. Might take awhile but saves lost time in the long run... maybe. Private Sub PlaceQueriesInTable() Dim qry As Variant Dim rs...

I've always thought of creating a query management form. One that saves all your queries in a single table, that way instead of loading and saving 300 queries you narrow it down to one table. The form would be able to load an instance of a design view form and break it down into a new or update...