Search results

this won't work..would anyone be willing to accept an email?

d'oh....notice i haven't eaten today, a little out of it... it wont let me post it. its a 170k file , but its saying its too big. this may take a minute or two....bleh

that's pretty much it, fizzio, except i need the first few chars of each field, except the third one wherein i need the whole thing.

er i tweaked a bit and still got nothing. here's a bare bones sample. the pafsc prefix box doesn't seem to want to work in this new stripped versoin, but that's not really relevant to the issue. any help is as always appreciated :)

adding me. yields an invalid use of . or ! operator, btw

the data is in three columns though. essentially column 1 is a prefix, column two is an afsc or job code, column 3 is a skill level, column 4 is a skill level, and column 5 is the result of an extraction of specific characters from all 4 previous columns. col 1 = 1st char col 2 = chars 1, 2...

well i think i'm getting better at this vba stuff.. Private Sub cmdGeneratePAFSC_Click() txtOfficerPAFSCFull = Left(cboOfficerPAFSCPrefix, 1) & Left(cboOfficerPAFSC, 3) & _ cboOfficerPAFSCSkill & Left(cboOfficerPAFSCSuffix, 1) End Sub except it doesn't work, needless to say:P i've tried...

i used to work at a company like that. the problem is if you make them realise your efficiency, then they take advantage of it :p maybe some freelance DB design on the side oncompany time?

thanks a load, miles. i should start looking for threads more often!

afterupdate would be fine except that it has to stick even when they're not changing values. basically i need to to recheck the if statement everytime a record is loaded, AND everytime the rank box is updated, so afterupdate would accomplish half the battle. i have it on click for testing...

With this syntax: Private Sub cboGrade_Click(Cancel As Integer) If Me!cboRank = "AMN" Or Me!cboRank = "AB" Or Me!cboRank = "A1C" Or Me!cboRank = "SRA" Or Me!cboRank = "SSGT" Or _ Me!cboRank = "TSGT" Or Me!cboRank = "MSGT" Or Me!cboRank = "SMSGT" Or Me!cboRank = "CMSGT" Then...

So before i release this onto the server for all 7 of my users, i'm curious, how will it perform? i'm running access 2000 and everyone uses either XP or win2k. generally at any given time 5-7 people will be manipulating one form, and possibly generating queries/reports/etc. there's not too...

the showering with other men isn't so bad... i mean, um, er, uh, no! its horrible! just kidding. i'm in the air force :) its club med compared to the army! i'd be glad to, nam, if i wasn't positive it would result in simply me getting laugehd at :)

Ahh fantastic. Took me a while to work out all the kinks while integrating but now it works exactly like i need. maybe you should consider joining the us military nam :P we could use efficient guys like you!

Oh come on nam, you have to let me beat around the bush and pretend i dont know you're going to help me out first, otherwise i'm imposing! :) I'm afraid i dont entirely uderstand the term restriction? you mean criteria? yeah in the query that sources the combo boxes i do have the criteria as...

so i'm addressing a problem ive been working on for a month or so, here goes: i have 2 cbo's on my form, one of which has a list of values: a b c d e f The second box is a list of possible suffixes for each possible value in box 1. so we'll say its 1, 2, 3, 4, 5 if a can only hae 1, 3...

hah, i work for the government, i can't even pay myslef ;)

hah at this rate i'll have to credit you as technical support on this database nam :P

i have 3 cbo's on a form, which all hold data in the format similar to this: CBO1: A -- operational Warfare Instructor CBO2: 45V -- Nurse CBO3: C -- Pediatrics What i would like is a txt to be populated with certain characters from all cbo values, so the txt should read A45VC so i need...

from what you say mile that looks like it'll be sufficient for what i need, i'll explore that func a little bit. thanks for undoubtedly saving me tons of time snooping around help files :)