Search results

  1. jessa_lee

    Thank you all!!

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

    Thank you all!

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

    Excel PivotTable for Utilization

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

    Many-to-Many Relationship

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

    Synchronized subform from button

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

    Command button to synchronized "sub"form

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

    Access VBA help files missing?

    None of the Access VBA help files are showing up within Access help. Instead I get an error message that says to check to be sure they were installed properly. I checked and double checked that all the needed links to help files were installed correctly. I even uninstalled and performed...
  8. jessa_lee

    "DisplayFields" trouble

    New problem. I'm trying to display the fields & field info (not records) within my table, but when I run it, I get the error message "Run-time error '3021': Either BOF or EOF is true, or the current record has been deleted. Requested operation requires a current record." See following: Sub...
  9. jessa_lee

    CreateTable not working

    This is the code I took directly from a book I'm learning VBA from, and when I run it, I get a "Compile Error: User-defined type not defined" on the second line - "Dim Table As New Table", as well as any of the lines with "ADOX" or "ADODB" on them. Sub CreateTable() Dim Table As New Table...
Back
Top Bottom