Search results for query: *

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?

Why are there two similar statements? Is one to be used in the query criteria, and the other in the update of the form? If so, this is the best I can make of the necessary substitutions Me.sbfForm.RecordSource = &quot; Select ID from Client Contact Information where ID = &quot; &...

Not sure if I can read that straight. Do the <> brackets indicate where I put in my own values and objects?

Thanks for answering! I don't want to put the value into a field, I want to use it to serve as a criteria in a query. All I want to do is show a list of clients to the user, who selects the client he wants, then, in a subform, the client's first appointment sheet will pop up, and the user...

I'm using the list box wizard, it asks me if I want it to &quot;Remember a specific field value for later use.&quot; I say yes, but then I can't find anywhere in the properties where that value has been stored, what it's called, etc. I have no idea how to access this info &quot;for later...

I've been trying to use the list box wizard to set up a form that will list all clients entered by a specific counselor, then when I select the client I want, clicking will open the main form in edit mode, calling up that client's record. The wizard creates some code under...