Search results

Hi all. I have a main form that displays records in a list object. The list is populated with a queries that changes with some controls on the form as well (buttons and textboxes). Is there a way to create a report based on what's displayed in the list? When I do a report on the form, it...

My table has a list of calculated values corresponding to a date. I need my query to sort by date/time and accumulate the values. Pls see the simplyfied attached db with the table and query. I can't see what could possibly be wrong with it :confused: It works fine when I accumulate non-calc'd...

Hi all. I need to convert a date string like '2006/07/24' to some sort of number. I seem to remember that there is a built-in function that does this, but what is it called?? :rolleyes: Thanks all :)

Check the attached mdb file. Can't figure out why the query returns -1 instead of the letters that are stored in the table :confused: Many thanks! Steff

Hi all :) I'm trying to build a duty roster to get rid of my Excel spreadsheets. Check the attached file and open the form. The Query populating the listview doesn't perform the way it should. What am I doing wrong? Try selecting TPO or MC on the form, and the query will return "0"s even if...

Hey Lagbolt - thanks for your tweaks! Good stuff to learn from. ;) However I need the query to have a given name only represented once: e.g. "J.S. Steffensen" only appears as row header once and then all the days from 1 to 30-ish to follow in that same row. Will post that question in the...

Okay - here's the mdb file. I'm building a duty roster, but cant seem to get the recordset straight ... When I paste the SQL into a query in design view it works fine :confused: Try opening the form frmvagter ...

I have a recordset that has a number of fields including days from 28 to 31 ... I want to put the data in a ListView control but how do I loop through the changing number of days??? Here's what I got so far: rs.MoveFirst Do Until rs.EOF Set lstItem = Form_frmvagter.MainList.ListItems.Add()...

Mousemove on ListBox: What Col/Row?? I have a ListBox called MainList. I do a MainList_MouseMove(Button as Integer, Shift as Integer, x as single, y as single) and get the X and Y values of the cursor hovering on the list, but how can I get the value of the cell I'm hovering on? I tried...

Perfect! :) Thanx a million.

I need to build a query that concatenates the values in my table as follows: The table: monkey horse pelican zebra The query output: monkeymonkey monkeyhorse monkeypelican monkeyzebra horsemonkey horsehorse horsepelican horsezebra pelicanmonkey pelicanhorse pelicanpelican pelicanzebra...

I have a two tables with about 44.000 words that I need to search. I need to find words that are exactly 10 characters AND where each letter is only represented once ... Anyone that has an idea how to write that query? Any help would be highly appreciated. Thanks from cold Denmark, Steff

I need to hash values into a string of a fixed lenght of seemingly random characters, like MD5 or alike ... Any function to do this in VBA?

I have an .mdb (A2K) with a function that uses both String$() and Left$() ... I took the mdb off that network and worked on it, and then put it back again. Now I can no longer use these functions. I have another .mdb on the same network that uses the same functions without problems ...

I am currently operating queries in my A2K DB that are 35458 characters (~11 full sheets of A4 paper with 12pt). It takes roughly ½ second for the form to load due to the heavy query that is also calling functions (calc'd fields) from within, but it works fine. Are there any problems in this...

Thanks! ;) Works now :)

First set the "bound column" to get data from in listbox property in the data tab. -in this case 5. Then the value is ref'd as Form_frmMyForm!List1.Value Thanks Steff! :) You're welcome Steff! ;)

How can I set a label caption to Wingdings characters like "0x8C" or "0x81"??? "0x8C" is unicode format, right? Me.Label1.caption = StrConv("0x8C", vbFromUnicode) changes the caption allright but to a wrong character ... The label font type property is already Wingdings of course :rolleyes:

I need to ref the value in the selected row, column 5 in a list for a DLookup. Form_frmMyForm!List1.????????? ... :confused: Thanks! ;)

Also, you probably want a: "Exit Sub" before the Error: :)