Search results

Not sure if this has been posted yet. Microsoft has released beta of Office 2007, this includes a new UI to many of the old office programs. For the time being you can get it here: http://www.microsoft.com/office/preview/beta/getthebeta.mspx Beta 2 of Internet Explorer 7 has also been...

You can refer to forms using strings as their name. Dim strFormName As String Dim ActiveFormObj As Form strFormName = GetActiveForm() 'Have GetActiveForm return a String Set ActiveFormObj = Forms(strFormName)

Make a table for when emails were sent. If Date Not In Table then SendEmail End If Or instead of doing the On Open, just attach it to a button and manually send it

in the Event handling functions you can refer to a form's text box value many different ways so long as its open. The most common are: Forms("Form Name").txtBoxName.Value or Forms![Form Name]![txtBoxName].Value

use tables; i had code that got hijacked - it was pretty lengthy. it went into unloading references on close and loading them on open. all in vba, it loaded the correct version based on their OS and Office versions.

Make References to Microsoft DAO Library in the Tools>>References menu Dim rs as DAO.Recordset Set rs = CurrentDb.OpenRecordset("SQL QUERY HERE") Me.txt1 = rs.Fields("The field name in the query/table") Me.txt2 = rs.Fields("The field name in the query/table")

are there any spaces around the commas that you can specify in the split function? give a sample line.

I thought there have been posts on this before, but I can no longer find them. Until I can look into the library files, see this thread here and see if that helps

I've started looking at doing this programmatically. I'm still stuck on the: 2)Any player cannot play the same player twice 4)Any player cannot play the same player from the same house colour or opposing house colour within the same class. If they could play the same player from the same...

Group by client Id not name

do not reply to this thread it is a pentuple (five time) post

do not reply to this thread it is a pentuple (five time) post

do not reply to this thread it is a pentuple (five time) post

do not reply to this thread it is a pentuple (five time) post

do not reply to this thread it is a pentuple (five time) post

Flexibility is the key to high-level code, but a problem that people often mistake is that they write their code too flexible. They produce more lines/logic then needed when a simple, timely solution is right at your finger tips. In my experience, I've hardly ever had to reuse short code...

Why? You're making more work on the database. It already has built-in event handlers, why not use them?

QMWIN is statistical software that is good for Transportation, Transhipment, and Assignment problems. In your case, it would be an assignment. You simply add your four constraints and bam it prints out all the possible solutions.

use the button's _OnClick event

The question is why is it becoming 994.999, it was clearly declared 9.95 (the problem occurs with or without the * 100 --> ive tested with starting the number at 995). The absolute value function doesn't effect this (i've removed it)... so,.. We have a double: 995 We use int() to drop the...