Recent content by Sola

Hi, all. I have a way to do what I need, but I am trying to make the process more efficient. What happens is the user opens a form that shows four fields: 1. Account # 2. Owner name 3. UseCode = not "HM" 4. UseCodeRequestDate = Is Null (date the user requested use code be changed to HM) The...

Hi, Khawar. Thanks for the alternate method. It works great, too. :)

You seriously rock. I set the 2nd [position] in the criteria part to the # 1-4, then put grouping on: SELECT tblclient.Acct, DLookUp("[LastName] & ', ' & [FirstName]","tblclient","[position] = " & 1 & " AND tblclient.[acct] = " & tblclient.[acct]) AS Client1, DLookUp("[LastName] & ', ' &...

Hi, everyone. I have a database (example included) where I can't get a query to work like I want. I have looked online, but the examples don't seem to match my problem (or I am missing something). Here is the setup: tblMain is set up with one record for each acct #. tblClient contains the...

Hi, all. I have a query that pulls together department names and the # of calls they placed. Due to the way the network tables were made, I often end up with two results for the same dept, like this: dept_whatever 25 dept_whatever2 5 The second entry is identical to the first except...

Hi, Rabbie, and thanks for the response. I have the form based off of a query, actually, but I think I get what you are saying. I will try basing it off the table and get back to you.

Hi, I am looking for some help with VB code. I have a form that lists prescriptions. One of the fields, fldTransactionType, has two options: "Prescribed Rx" and "Voided Rx." In this form that I am working on, the user sees a list of all prescriptions, and I have a button in each row that says...

Hi, Bob, and thanks for the feedback! :) You were spot on - there's definitely going to be more than one followup per complaint. I don't know why I was thinking all the relationships could only be one-way. I have started the db build, and it's working great. Thanks again for your help!

Hey, all. I am looking for some feedback before I start building. I am designing a database to log complaints against doctors and perform followup. The tables and abbreviated fields are: tblComplaint: ComplaintID, ComplaintType, ComplaintDetails, ComplaintResolved tblDoctor: DoctorID...

Can anyone tell me how to mark a thread solved?

Well, asking seems to have jarred my brain loose. :) Quantity: IIf([TransType]="Prescribed",-[Qty],[Qty])

Hi. If someone could point me in the right direction, that would be great. Right now, I am not even sure if I should be trying to create an expression in Design View or if I should be trying Visual Basic. I have a report query that shows each transaction for medications. There is a...

Thank you, Nancy! :) She looks like a good resource, and I may well need it as I have zero experience with SharePoint. I have also picked up a copy of Sams' _Microsoft SharePoint 2007 Unleashed_ to read through.

I am starting a project where I will likely be utilizing Sharepoint 3.0 to make db info available to end users. Since I have not used this program before, I thought I would see if anyone here had recommendations for a good beginners book.