Search results

Hope I can describe this well enough. I am creating a DB for a youth organisation (Air Cadets), details of which are stored in tblMembers. They attend twice a week, each of these days is called a parade and on each parade certain members are given a duty, so the date of the parade as primary...

strange, it works now, must not have saved properly last time I made changes, thanks for all your help!

unbelivable, I completely didn't look at the iif format properly, thanks for pointing out my mistake!!!:o

i have the following query statement: intext: IIf([calllogs]![InternalCall],"0","External") in "InternalCall" there is either a "0" or a "1", these represent external and internal calls So I want to turn the "1" and "0" into "internal" and "external" I've done half of it, but I can't use an...

hmm, that gives the same results, tried playing around with the code you posted but can't seem to make it work, still gives errors? Thanks for this, im getting through this DB bit by bit!

thanks, got that working, only trouble is, if it comes accross a blank field, it puts an error as the out put, messing up the data, I looked at the module to see if I could change it to skip trying to put a space in if there is nothing in the field, but couldn't quite figure it out

cant get that to work at all, what does pname refer to? whatever I put in that box, it just comes up with a message box asking for input for "pname"..... So I have to link to a module? There is no way of doing it pure query using functions e.t.c. Thanks again,

Great, just what im after, so to define a "capital letter" is Asci values 64-91, trying to keep just with queries, how can I define those Asci values in my InStr statement thanks for the help guys,

Just been searching around, found a few posts of uppercase questions, none that quite fit with mine, anyway, Basically, the data I am working on produces names as such "JoeBloggs" "FredPerry" Anyway, Im going to use a query to seperate these out into first name and last name, but, I can't seem...

Didnt come across that before, thanks Had a look through, alot to get my head round and im afraid I don't understand most of it, maybe it looks more complex than it is, would I need all of the code on the import form to just browse for a file, it looks like theres other stuff going on in the...

Looks like this might be the one that brings me into VBA Ive got my import spec all set up, importing a text file running querys on it e.t.c. But, as soon as this DB is moved to another computer, the file name is going to be different, so for fuller automation, I need some way of bringing up a...

just tried setwarnings again, didn't realise it had to go at the top of the macro, just played around with it abit, thanks again would use VBA code if I had the knowledge, wouldn't know where to start, will work my way there though

right, tried setwarnings, didnt actually know it existed! It doesnt stop the messages that I get, because they require "user input", not just a straight "ok" but "yes" "no" "cancel" tried <Enter><Enter> in the sendkeys box but guess its not as simple as that thanks

Right, I have a macro running that firstly imports a .txt document, then runs a delete query on the data, this delete query brings up two warning messages about the deleting of data before carrying onto the next query. I am trying to use send keys to just send "enter" twice to get past the two...

just tried that now, still no luck, it just returns a zero value if there is data in "callednumber", looks like it should work fine, ........ edit: realised the zero value is irrelivent, because the change is being made in callednumber, it still does not remove the "?", odd

still the same results, should I be putting this in the criteria box or after "callednumber" in the field box, I get confused as to which goes where, I've tried it in both anyway, in the criteria box it returns no results as before, (I see what I missed in my query, the second part of the IIf)...

Should this statement work? IIf([CalledNumber] Like "*?*",[CalledNumber]=Mid([CalledNumber],2)) Some of the fields brought in from the CSV file have random "?" in front of some of the names, so I made this to remove the first character of the field if there was a "?" there. Maybe there is an...

I didnt realise that the calculation had to go in "field" and not "criteria", so all working well now, thanks

its ok, I sorted it, my silly mistake, thanks for all the help, lots for me to work on now, great!!

thats great yes, but, access still gives me an error, I copied it in, changed the fields appropiatly, but as before, still errors, access says: "The expression you entered has an invalid .(dot) or ! operator or invalid parentheses" Thanks for explaining all of this!