Search results

Apparently you figured it out while I wrote my book... :D

Hello Paul, I've had similar stuff in the past... I'll try to give you a hand, but keep in mind I'm a noobie. I use forms to enter data, and fire events that update tables... which is where the "After Update" event is that Trevor was talking about... the tables just store the data, the form...

I finally got it... figured I'd post the solution on here in case anyone else needed it. My Code for the First Button takes into account I want it to display two columns of data, I had to set column count for three and make width "0" inches to hide the "ID" column. Code for the button called...

I've been thinking about it... and I might have a solution for myself. I can stack 5 listboxes on top of each other, with each formatted the way I want them for a particular data set. Then I'll set them visible or not based on the button selection... this seems to me a sloppy way to do it...

By the way, I changed all the names to generic stuff so it would be easy to understand (so everyone doesn't think I named my List Box "LstBox" :)

Hello again all, My current problem involves a listbox, which I want to show me data from different tables when I hit a button like "View Table One" and then change when I click "View Table Two". Some of the tables have different numbers of columns, and I think I cracked part of the code...

Thank you much! I should be able to work on that :) Pick

I've seen some impressive Access reports, but these letters will need to be on a Letterhead. Not to mention being able to save copies that can be edited or used later will also be useful. I appreciate the help! Pick

Ok Pat, I think <additional stress on "think" intended> I understand. I store the supervisor's EmpID in the supervisor field of the table, then write a query that populates the "Supervisor" Combo box. This query will return First Name and Last Name (and maybe Middle Initial or something if I'm...

So, Access will output a report to a Word document? Can access maintain these Word documents as well?

Hello again all, I'm sure there's a proper way to phrase this question, but I really don't know how to ask without explaining my goal and the situation... so here goes: I am building an Access DB and it (when complete) will manage all the personnel and administrative functions for my...

Thanks Pat! Appreciate the help. My only concern right now is whether this new table will populate itself based on information entered into the "members" table, or if I'll have to populate it on its own. I'll keep playing with it and see if I can figure it out. Pick

Hello All, I'm really new to this... so please be gentle :o (I tried to look for this in other threads... so if it's a repeat I apologize) In any case I'm trying to build a database that keeps up with all the admin on employees (performance reports, qualifications, etc). I want to be able to...

Hello! I typically go by "Pick" although my name is Brent... I am Extremely new to programming. I had one college class in C++ about 14 years ago (Don't remember any of it), and now I'm trying to build my own database using Access and VBA. I've hired a tutor who can answer my questions, but...