Recent content by Linda354

Does anyone know how much of the market Access holds? Is it gaining or losing ground? If it does lose ground, how hard is it to pick up some of the other app's like Oracle?

Or maybe I was just looking in the wrong pew. Thanks.

No, you haven't added to my confusion at all, I have a sense of it now. I guess the thing I'm still wondering is, why couldn't I find a text on SQL at Barnes & Nobles? It makes me think it's not a competitive skill to be acquiring. In general, how is Access holding out against the...

When I use the "Build" function, is that VBA? And you're saying when I work with queries, SQL is involved. Okay. Is it just a portion of SQL that's being used by Access? I looked for texts on SQL at Barnes & Nobles and didn't find anything. I see want ads for employers looking...

I'm somewhat functional with Access now, and ready to start tackling programming, but I'm confused. This may be a dumb questions, but what is the difference between VBA and SQL? It seems I've been tripping over both interchangeably. There are courses nearby in Visual Basic. How readily...

"Or do you want Bruce to see everything (All users plus himself)?????" Yes, I want Bruce to see everything. What do I say in that third part of the Iif statement that will say , "forget it, there's no criteria here."

Can anybody out there figure out what might be wrong? &quot;The syntax is the condition first then if it's OK then if it's not OK... maybe something like: =Iif((CurrentUser()<>&quot;Bruce&quot;),CurrentUser(),CurrentUser() OR &quot;Bruce&quot;) Is the above logic what we need? If the...

Thanks for the suggestion. It came back a Data Mismatch when I tried to run the form. The &quot;Zoom&quot; window, after saving, turned it into: IIf((CurrentUser()<>&quot;Bruce&quot;),CurrentUser(),([Client Contacting Information].[CounselorID])=CurrentUser() Or ([Client Contacting...

Thanks so much, I was really happy to get some real syntax into this project. I could even read the logic, but it didn't work! Seems like it should. But when I signed on as Bruce it showed me nothing, since Bruce hasn't input anything yet. When I signed on as another user, the records he...

That's what I tried at first, then I realized what it was saying is that Bruce will only see Bruce's files, since when he's signed on CurrentUser() = Bruce. It's just a redundant statement. I need to be saying If CurrentUser()<> &quot;Bruce&quot; Criteria is CurrentUser() Would this work...

I have a query set to show only those files created by CurrentUser(). I want to also set it to show all files for the Administrator, Bruce. How do I code that? It seems like I need to tell the query that if CurrentUser = Bruce, then there is no criteria. Is this something I can't put into...

That sounds simple enough, but with a very large site with which I was unfamiliar, that was more than a notion. Having to check through each file and verify that it looks just like the original would have been the only way to avoid the problems we later had. With 70+ pages that's quite a task.

I guess I should take it from the silence that nobody knows of any way to automatically verify that a site has downloaded properly.

We just had our first experience at working with two users at two different remote sites and it didn't go well. A message that we were &quot;in sync&quot; apparently couldn't be trusted, one person's download of the site was apparently banged up and didn't show up until she tried to upload...

Would it be possible to translate to English what these commands are saying?