Search results

I don't post on these forums often, but I'm on here searching through all the great questions and answers listed here all the time. I just wanted to send out a great big THANK YOU to all of you who support this forum and take the time to offer your knowledge and wisdom on building better Access...

I don't post in the forums often, but I search through them for help on a regular basis, and I always find the answer I'm looking for, and learn new ideas along the way to finding my answer. I just wanted all of you who contribute to this forum to know how very much I appreciate all you do to...

I'm sure I'm just missing the forest for the trees here, but I'm trying to make a utilization report from the attached data with the following criteria. I need the parent level to be sorted by the Home Dept Descr and then by Full Name. This is like a utilization report to determine how many...

I can see how needing to work through the linking table rather than the employee or phone tables is necessary. I need this as user friendly for my co-workers as possible, with as little room for user error as possible. They will be constantly adding new employees and deleting terminated ones...

Check out my database (see attached). I threw a bit of random data so you could see what I'm seeing.

Thanks for all your pointers so far, but I already have the tables set up as you suggested: tblEmployees -EmpID# (PK) -Fname -Lname -Title -Dept tblPhones -PhoneNum (PK) -LinePurpose (fax, cell, desk, etc) -LocationCode tblLinking -EmpID# (to link Employees) -PhoneNum (to link Phones)...

Now what?

I'm building a company phone directory in Access to make updates/changes easier (since they previously spread it over 8 Excel spreadsheets *aack*). I have a table for employees, one for phone numbers, and one for location information. Some employees have multiple phone numbers, and some phone...

Yes, actually the correct box to link to is the "txtVerN" which is hidden on the form (behind the tabs section). It is identical to the Version#'s unique ID from the table (i.e. txtVerN = SWI_VER.VER_ID). I'm curious to know what you find out. I've got a few errands to run after work. I'll...

Hehe - the zip file was too big, so it didn't go through... I PM-ed you - can I send it to you via email?

I'm not sure what I'm doing wrong... Could you look at my DB and give me pointers that way? I hope I'm not being too much trouble - you are such a great help! Open frmSWInventory. The second button on the bottom, "Enter Purchases," is the one I'm working on. The subform I want opened and...

I'm getting an error when I try to run this: Option Compare Database Private Sub Form_Open(Cancel As Integer) Dim sql As String sql = "SELECT VER_ID FROM SWI_VER INNER JOIN SWI_PUR ON " sql = sql & "SWI_VER.VER_ID = SWI_PUR.VER_ID WHERE VER_ID = " & varVerN & ";"...

Thanks for all your help! I'll be playing with that today. It makes perfect sense - now let's see if I can get it to work!! -Jessa

On the command button, the code is: Private Sub btnPurch_Click() On Error GoTo Err_btnPurch_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmSubSWI_PUR" stLinkCriteria = "[VER_ID]=" & Me![txtVerN] DoCmd.OpenForm stDocName, , , stLinkCriteria...

I put a command button on my main form, and want it to pop open a (sub)form with data that is synched with whatever record is currently displayed on the main form via an unbound text box. In my software inventory DB, the main form data pulls the Manufacturer's name. From there, I link the...

The info I'm linking to is an unbound text box, not info directly within the master form.

Maybe I'm just totally missing it, but I didn't see the Master/Child fields anywhere in the properties for the button... maybe I'm just looking in the wrong place?

I put a command button on my main form, and want it to pull up a "sub"form with data that is synched with whatever record is currently displayed on the main form via an unbound text box. How do I do that? If you need me to attach any specifics from my DB, let me know. -Jessa

Actually, no, it's "Sams Teach Yourself Microsoft Access 2000 Programming in 24 Hours", but thanks - now I know to stay away from that "Wrox" one too!! hehe Thanks again :) Jessa

Quality. Very nice :) Thank you for your help.