Recent content by trickg

Hey, no problem. It wasn't an urgent issue. Actually, my issue here really isn't Access - I just figured that if I could add that little feature to this small app that I created to track these changes, it would make things easier. Right now I'm in the process of making a beta environment...

Nevermind - I had my form based on a query so that the records were returned in a specific order - I changed the form data source to be that of just the table and now I have the third option in my dialog box. Thanks for nothing.

Tim, I've done this before, I just can't seem to locate my code that does this. I have been working as a SQL DBA and I created a small access database to manage some server updates that I am making - quite a laundry list of changes that I am making - and I want to quickly be able to referece...

Um....what if you only have two choices? What code am I looking for that is generated by option #3? The two options that I have are: "I want the combo box to look up values in a table or query" "I will type in the values that I want" Like I said, I don't have the third option but that's...

Pat Hartman? You aren't from Nebraska by chance are you? Here is my thought on saving the text rather than the ID. For historical purposes, you may not want to save the ID because that forces you to keep every category that has a corresponding item, even if that category becomes obsolete and...

Yeah, I've done that, but unfortunately, it's not really what I need. Basically, I'm trying to track pieces of office furniture and parts to make up cubes. Here is what I have so far: ITEMS Item_ID E_Number (This number is unique, but I want to use “Item_ID” as the PK) Item_Desc Category (For...

Has anyone here ever developed a project to maintain and control inventory for a warehouse? I'm trying to get my mind around this new project, and I'm not quite sure how I want to handle it. (i.e. tables, relationships, etc) I figured that someone on here is likely to have done an inventory...

I feel your pain! I'm trying to do something similar. I have no problem entering the data and I have the tables set up so that I can track events and people, but I can't figure out how I'm going to display the data in the end. ARG!

Yeah, I suggested Outlook right off the bat but apparently (and this project will service just one person) Outlook doesn't do what they want it to do. I beg to differ, but since this is contract work, who am I to tell them not to pay me to build a redundant system in some other form? Thanks...

I have been tasked with coming up with a scheduling tool so that someone can create a schedule with ease for a number of people and events and then print it out so they can tell at a glance where and when everyone is tasked so that they know what people and resources they have available. The...

I need to check all fields on a form, which is a considerable number, and update another field if any of the data in the record gets changed. I don't want to use the change event of each field on the form (Form has a tab control with 5 tabs, all full of fields) so basically if someone checks a...

I keep getting errors on a project of mine to the tune of: "You canceled the previous operation." multiple times and I don't know why I'm getting them. I can't think of any changes that I made to my project that would have caused this. Is my project file corrupt? Do I have a couple of forms...

Well, thanks for that anyway, even if it isn't what I was looking for. At this point, I know just enough to get myself into deep trouble! ;)

Along the same lines as the original post, is there a way to get a combo box to actually display multiple columns. I have a form where I'm displaying a number (ID) a name, and then another name (if applicable) in the same combo box for a lookup form. The user uses the combo box to find the...

Pat, Thanks for the syntax tip. I will definitely keep that in mind and try to use that in the future.