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

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

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

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! ;)

Hi everyone, I am using this code to hide Access when my DB is running. Forms are set to Modal + PopUp, and then it works. However, Access is also hidden from the Process bar in the buttom of my screen so I cannot switch between running apps unless I use ALT+TAB. Is there a way to modify the...

Hi all! I have a query that returns some fields with "#Error" ... The reason is that I call a function in the query, and the function chokes if there are no matches in my query criteria and therefore no argument is sent to the function. I tried putting this in the function: var =...

Is there a way to see my total edit time for my project, like I can see edit time in a Word doc? (File -> Properties) Thanks all :)

I have a couple of forms with the same source - or rather sources are different queries accessing the same table. Both forms have edits allowed. My problem is that when I have had one of the forms open, the second form cannot get its data when I load it ... Even if I do a: DoCmd.Close acForm...

Does anyone have a sample of a db with a report that will print the records 3 across and 8 down to an A4 sheet of labels (24 per page)... I have absolutely no clues ... :confused:

When I view customer details in the attached db, the list (liste26 on frmDetails - lower left on the form) doesn't get data. The SQL syntax should be correct since I got it from a qry made with the wizard. Whats wrong???? I'm sure there's a simple explanation ... :rolleyes: