Search results for query: *

Thanks-this code is pretty cool too--This could come in handy when I'm contruccting the "where" variables in my code.I'm grateful for the input!

My Apologies--it turned out to be several days before I could even return to this issue (for a variety of reasons)WayneRyan, you out me on the right track, and I finally knucked down and learned how to write the SQL in code myself. Here is what I came up with so far, and happily, it works: Dim...

HI, I have a user that wants his own query wizard of sorts. Does anyone know the easiest way to have users run their own queries based on field names they choose, say, from a list box? In other words, they need to be able to choose which fields they want, not just filter given fields by a set...

Oh, This does look promising--just the type of procedure I've been trying to write but not succeeding at... I am getting a "Type mistmatch" error on For Each fld In dbs.TableDefs(table).Fields But I'll keep trying...

Thanks-- I was trying to get around having to write a separate query for each field (I do have a bunch of them now, but I have a bunch more to write, I guess) but if that's still the simplest option, then I guess I'll have to write a whole bunch of queries and then set up a macro to run them...

HI, I am trying to find the easiest way to clean out all chr(10) and chr(13) from a table with alot of fields. The replace function works, but I can only update one field at a time with that (at least the way I'm doing it). I also tried the switch function, but something must be wrong with my...

Thank you for the suggestion :) That does post does look like it will ehlp me some, at least to better understand what I am working with--thx again

HI, This seems like it should be simple, but I guess I'm just woefully inexperienced with charts, nor am I a very experienced coder either (I can code some though). Here is my data exmple: Employee Skill A Skill B Bob 22 18 Mary 19 24 Rating A might be the y...

Maybe your lowest DAO reference library on win2k is still higher than your higest DAO reference library on Win95? You could either install a lower reference on win 2k (we did something like that, but it was actually on an NT, not win2k), or go with different front ends, as suggested...I had to...

Yes, very good, I see what you are saying about creating another front end for the 2000 users--feel very silly that I didn't think of that myself! I still think Microsoft should have made it so that another front end wasn't necessary, but at least, as solutions go, it shouldn't be that hard to...

Hi There, I have a user -level secured Access 97 database, which has to stay in Access 97 because most of my users are still in Access 97. However, I do have few who use Access 2000. I've got shortcuts, bat files, etc working to where their Access 2000 program goes through the correct workgoup...

HI, I usually don't use autonumbers as primary keys because, as the "aside" statement indicates, there usually is nothing to prevent a duplicate record from being entered in an autonumber as primary key situation. Since autonumber generates a new number every time a new record is...

You should be able to remove the navigation buttons in the format tab of the properties section of the form.(set navigation buttons property to "no") As for your code problem, I am having the same problem. I am trying to do something like this: (this is incomplete code, "eof&quot...