Search results for query: *

What if you use Dim dbs As DAO.Database, tdf As DAO.TableDef, i As Integer rather than Dim dbs As Database, tdf As TableDef, i As Integer ? Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

Then you are probably sorting and grouping in the report, itself. Have a look at that. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

Do you have a user-defined function concatenate? Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

Prosperity - really? Holy smoke. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

Your ultimate destination is the last destination. Penultimate is the one before last, and antepenultimate is the one before that! I've actually used antepenultimate in a speech (of course, I had to explain it). Greg People demand freedom of speech as a compensation for the freedom of thought...

Sounds like it was just text wrapping rather than actual blank lines, then. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

MajP beat me to it. The DLookups seem like overkill. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

It's tough (ok, virtually impossible) to use floats if you cannot specify a width. If, however, you know the maximum width of the items in the select box, you can simply specify a width that will accomodate that. Barring that, you may (or may not) want to experiment with overflow. Greg People...

I don't understand the question. Is Co a priority field that is separate from the address field? Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

As I understand it, dbdescending only applies to indexes, while dbfixedfield applies to fields. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

The NZ(1stparm, 2ndparm) function evaluates the expression (or variable or field/column) in the first position. If the expression evaluates to a null or zero, it returns the value in the second position. Thus NZ([building Price1],0) evaluates [building Price1] - if it is null or zero, it uses...

More info needed. e.g. Is it on a shared drive? Can he copy it? If so, is the copy also read-only? Is it at the root level of his C: drive? Is it Thursday? Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

IS ici.TYPE text or numeric? ici.TYPE = '2' If numeric, remove the single quotes. Or, more likely, you simply need to move that criteria from the LEFT JOIN to the WHERE clause: LEFT JOIN domdata.pub.icinterchange AS ici ON ( i.conum = ici.conum )...

How about something like (replace field names and table names as appropriate): Select ymt.* from [yourmaintable] ymt where ymt.Jobnum Not IN (Select distinct ejn.Jobnum from [yourexceptiontable] ejb) That assumes that your users only have table access from a form or a query that you provide...

Try unlinking and relinking the tables. (If that doesn't solve it, go kick some developer butt.) Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

I don't have any issues with BigInt columns in 2003 - Access treats it as a text field. (And allows me to update it). If it's not the id field, just don't use it in your queries and updates. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom...

If that's your actual code, you've turned some of it into a comment with an apostrophe: ' build sql for query sqlReport = " t_dmz_people.mpac = " & [sqlEmp] & "" ' AND ((T_DMZ_EQUIPMENT.START_DATE) Between #" & [sqlBegDate] & "# And #" & [sqlEndDate] & "# AND ((T_DMZ_EQUIPMENT.EARN_CODE)=0)"...

We can't see your html, but this doesn't look valid: .push 1. .footer, .push { 2. clear: both; 3. } It probably should just be: .footer, .push { clear: both; } Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

It seems sort of redundant to repeat the data in a third field, when you can simply build the path later by simply combining the two fields. e.g. txtImageName & "\" & fileName Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

Look in the FAQ section of this forum: faq702-4289 Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard