Search results

i agree with David...don't go down this road. you won't gain anything in terms of making the db smaller, etc. and it will drive you absolutely crazy in the long-term al

mostly it works because MS got it right for currency type fields... some good info on the problem appears here: http://www.fmsinc.com/tpapers/math/index.html hth, al [This message has been edited by pcs (edited 12-14-2001).]

think you need to post the fields in your tables... al

Knobbie, kind of hard to keep up when you post to 2 different forums... do you absolutely need 2 different delimiters (~ and |) ? what application are you trying to export to? hth, al

if you are using a97 or earlier, the answer is pretty much no. if you are using a2k check help for 'conditional formatting'. hth, al

oops. think i lead you astray...forget the No Duplicates part! set both fields to indexed no. then select both fields and right click and select Primary key. sorry check Help under: multiple-field primary keys for more info... hth, al [This message has been edited by pcs (edited...

make the key for the participation table a multiple key (<customernr> and <tripnr> ) and set allow duplicates to No. hth, al

pat h. is correct, access has no built-in function to do this. further, the soundex algorithm was not designed to operate on a general vocabulary. it was designed to operate on surnames (many, many years ago). it would appear you want a more general solution: you wrote----- (eg. if the user...

a couple of final thoughts... to verify that your 3of9 codes are viable...decrease the scan distance from 5 inches to something lesser, if the 1st read accuracy improves, you may have faulty printing of your barcodes. (i doubt this is the case, however) you wrote: --------------------------...

edit: or what AlanS said chuck, a wedge is a method of connecting the scanner between the keyboard and the computer. the scanned characters then appear to the application as having originated on the kbd. i haven't worked with scanners in a while, but most have a means of setting how fast...

i assume you are using a kb wedge... when you say: occationally the first scan will reveal only part of the number is it consistent...ie, does it always drop n characters from the scan? al

from help: Numbers stored in Text fields are sorted as strings of characters, not numeric values. Therefore, to sort them in numeric order, all text strings must be the same length with shorter numbers padded with leading zeros. For example, the result of an ascending sort of the text strings...

rich, thanks. i'm sorted on trumps and croppers. as to Weston Super Mare, i'm clueless! but also not sure why anyone would want to live here either. btw: as i recall, John Cleese (a very funny guy, imho...Fawlty Towers was a real gem!) comes from Weston. and Jack, i don't walk with my...

rich, i'm a really bad choice for picking lottery numbers...only got one right and that was years ago. got a number in the draft lottery that probably prevented me getting my butt shot off in Vietnam. (that's a good to clue to my age!) jack, still don't know if i want to come up 'trumps' or...

for starters...change Now() to Time(). Now() returns Date and Time... think you also need an AND in your expression...something like... If (Time()>= 730) And (Time()<1530) Then also make sure your regional settings are using mil. time (24hr) hth, al [This message has been edited by pcs...

hey jack... see you anticipated my edit

if you are asking if a command button with a graphic on it can have a shortcut the answer is yes. just put it in the caption property as usual. it will not, however appear on the command button but will function ok. if you are talking about an image control with an onclick event the answer is...

i never have understood when to use: 'came up trumps' as opposed to 'came up croppers' any elucidation appreciated... al

you are right steve...my error. been hammering out too much Unibasic code this week...my syntax has gotten confused al

yeah? well she told me she had acute angina... and i said 'well i hope so...cause your face is really UGLY' al btw: dbbyron said "we rock". have the 'Stones' done a 'Steel Wheels' performance at your nursing home yet...they appeared at mine recently...many of the women threw their teeth at...