Search results

Well, today I had a problem with my main access db. It stopped letting me create MDE files, and my usual trick of decompiling it didn't work. I eventually got it working by importing everything into a blank database and setting the startup form and references again. However when I did this, I...

ComboboxName = ""

heh :) someone has done too much C style programming ;)

as a second bit of advice. I think you needed the archive='yes' in quotes, like so: Me.Filter = "[archive]='yes'" as otherwise the expression would evaluate to either true or false straight away and put 0 or 1 as the forms filter.

Access 200 and 2002 have an MDI view that lets you have forms open with the main access form minimised.... but to minimise access in code requires using API calls to find the access process and then send it a minimise command.... it may work, and it may not... I don't think MS makes it easy as...

not sure if that is possible, unless you are confident with windows API calls and are able to minimise access using that...

well, the big enter key on the kb has as its code vbkeyReturn, perhaps thats what is worng?

If you want to keep the data, then in the onclick event you would want textboxHistoricalfield.Value = Date() & ": " & textboxWeeklyfield.Value & vbcrlf & textboxHistoricalfield.Value Otherwise just textboxHistoricalfield.Value = Date() & ": " & textboxWeeklyfield.Value and always in the...

I think best bet would be to turn off warnings on DB close, and then turn on warnings in your startup form after running the queries that bring up the warnings.

I think IsNotNull and IsNotNumeric and so on are new functions for VB.NET or possibly the next planned version :) It could be from there that you got the idea... you can just use Not IsNull to get the same effect though, or wrap that around a function called IsNotNull to do it :)

Oops... thats what I did with the CurrentDB.OpenRecordset bit... ignore the commet :) Basically I meant getting a recordset type variable populated with the result of the query :)

See the attached text file with a good library of string functions in it :) Credit to Roman Koch (roman@romankoch.ch) for this, even though I have never met him :)

Oh, good point :) Oh, btw if you don't put things with multiple spaces in tags, it strips out the extra space. So my replace should be [code] Replace(.Field("PostCode"), " ", " ")

Query 1: "SELECT Key, Postcode FROM table WHERE Postcode LIKE '* *'" get that into a recordset in VBA, then do Dim rs as DAO.RecordSet Set rs = CurrentDB.OpenRecordset("SELECT Key, Postcode FROM table WHERE Postcode LIKE '* *'") With rs While not .EOF CurrentDB.Execute "UPDATE...

I don't think its possible to hide that window, but the next questiuon is why do you need to? It is slightly comforting to the users to see it flash up quickly and know that they did click print. If something goes wrong and they can't remember that window, they may click print about 20 times and...

Even so, I would suggest update queries, but perhaps run them through VBA code, e.g. CurrentDB.Execute "UPDATE Grades SET Comment = 'cooper' WHERE Comment = 'co-oper'" will do what those ten lines of code of yours did ;)

Well, a form has an 'AllowEdits' property, I would guess you change that in the code :) On the other front, is this combined in an SQL query or into another text box or...?

I think the recordset might not be updateable, or perhaps access won't let you change data values like that In any case, I think an update query would be better suited in this instance. "UPDATE Grades SET Comment = 'cooper' WHERE Comment = 'co-oper'"

As in find out what software is on each machine through the network? I don't think it is, as that would require remote registry access which is not possible in windows afaik.

Hmm... I would suggest putting the strings into an array and using a bubble sort or something on them :) But if your way works, then stick with it until it doesn't ;)