John I'm not sure I agree, but I don't have a lot of experience with Citrix. It's my understanding that each Citrix user gets his own folder, and they all...
You're probably right. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside...
Not yet. At worst, I should be able to get away with not importing the file date if I can kick out an error when the file date isn't in MMDDYYYY format. I'm...
Hi Crystal Nice to see you, too. Hope you finally got settled into your new digs. Generic is good, but I'm not sure all members would understand the...
Hi Shay, consider creating a function to return a date data type or null (so it will have to return a variant) given a text date when you read your source...
Shay- I recommend that you open the file in VBA first to test the file date and reject it if you can't use it. If it's OK, then run the query. John Viescas,...
Hi Bill, I am thinking about interface term more for videos since they cover multiple versions ;) "keeps defaulting to red" yes, that is annoying but here is...
Kick start to the brain! thank you, I didn't even think of creating a function to use inside the SQL. combined with john's assistance on the run date, this...
Crystal That's about how I was doing it. The little converter (ColorPix) I mentioned is pretty slick. You open it and click on the acreen where the color you...
I've just realised that this is probably really a VBA question about the Word object model, but maybe someone here can offer a pointer. I have a set of student...
Might you be able to help me? I am looking for an online collaboration tool which allows the exchange of database files in their native formats. To date, I...
Crystal- Great idea! The code should probably check to see the length is at least 8. John Viescas, author Microsoft Office Access 2007 Inside Out Building...
I am using Access 2002 but I build in Access 2000 for more compatibility. I am totally lost. I have tried Crosstab Querys and Chart Reports Here is a mock up...
Why are you looking only at rows where the action is "Practice"? It's not clear why you expect to get a count of 2 in June and 3 in July - that's a count of...
Hi Bill, @ColorPix "click on the screen where the color you want is" thanks, Bill -- this will be very handy (and a time-saver) when I need to do this ... I...
Zipping doesn't always work. Today's scanners look inside zipped files. I've had that problem even when sending an attachment intra-office and had to result in...
Not a great solution but I have set up an account at dropbox.com and then I give my contacts the login and password. This works well in that I can use it to...
Bill and everyoine. I actually had no idea how efficient or inefficint access was regarding its methods to maintain relationships. BUUTTTTT....One thing I can...
I've found a bunch of lists for the cure for this problem, but very few explanations of the cause. Any input is appreciated. One of the databases here is...
Thanks John, "Data Type Mismatch in Expression" Where do I look for that? If I remove the criteria I get a full display of expected data. Robin Chapple...
Hi, I have a query that sums up time card hours and pay amounts. I noticed one of the numbers had about 8 decimal places in it, despite the field being set to...
The below results in table info that is distinct by virtue of 2 fields (ie cat and ID) What I want is both feilds(Cat and ID) but i want the distinction to...
Ozansi, Let field Prefix in table named T_A hold the values of all prefixes while field Txt in table T_B holds the complete string including the suffix. ...
Robin- If any of the rows are missing Birthday (a Null value), then that's your problem. You'll need to build a query first that returns all non-null rows, ...