Search results

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, 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, 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...

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...

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...

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.