Search results

Yeah I figured that's why it was happening. As much as I dont really like it, I ended up making another column in my table to hold the inputted text so that the field could be bound to something.

I've seen V-Tools referenced before, unfortunately my database is located on SIPRNet for which I do not have admin rights, so there's no way for me to get V-Tools on there. :(

Hey guys, still here. I abandoned the idea of splitting up my table like that after thinking about it more and reading everyone's responses. I am interested in further reading about database theory, so I think I'll find some books soon. Most everything I know about database design and...

In order to standardize terminology and nomenclature throughout my database, I had to rename a bunch of tables and forms. Those are all good with no problems, and now I'm starting to rename fields. I'm basically just changing the word "Packages" to "Missions". Yesterday I renamed my main...

Some background: I have a subform that is displayed in datasheet view, with an unbound textbox (field1) whose sole purpose is to pass the date and time entered into it to field2 (hidden, bound), and also display that info in this format: ddhhnn"Z" mm yy. The inputmask for field1 is 000000"Z...

Makes perfect sense. Each mission has only one terrain, and each mission is performed by only a single Unit, and occurs at only a single location, so those aren't many-to-many relationships and therefore don't need junction tables. With that said, by having the MissionType_ID (FK) in the...

*cracks knuckles and stretches fingers...* Yep, we need to task and track missions that occur every day. Each day has a name that follows this naming convention: YYAA. So all 2014 days start with 14, and each day has an alpha-alpha representation. Today is 14TO, tomorrow will be 14TP, the...

So I was reading Roger's "Entity-Relationship Diagramming" document (http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip), and he mentions that with this method, the fields of the record should depend on the primary key. For example: first name, last name, address, phone...

So far the filter bar is great! But now we're wanting to take it a step further and filter multiple criteria, separated by commas, that can span across multiple fields. For instance, assuming the table below: ID | Field A | Field B | Field C 1 Cat Dog Bird 2 Earth...

Thanks Spike, you've been really helpful!

Ha, filtering works just as well! But why does query criteria cause the subform to reload when a record is selected? I'm trying to wrap my head around the cause of the problem so I can avoid anything similar in the future. Thanks so much!

It seems like the subform is doing it's job in displaying the selected record in the main form, but after passing the Task_ID to the main form something is telling the subform to immediately requery/refresh and/or move to the first record of the subform's recordset which forces it to pass the...

Need help w/Pseudo-Splitform with search box I have a parent form that emulates split view (fmTasks, source: tbTasks). In the footer of fmTasks is a subform that is in datasheet view (sbfm_Tasks, source quTasks). Clicking on a record in the subform (On Current event) loads the record in the...

Sweet deal! After playing with it yesterday, I have it working the way I need it to! Thanks for pointing me in the right direction. I uploaded a zip that has an .mdb and .accdb version for anyone else that needs to do this too. The mdb version cant be compacted for some reason, that's why...

Yeah, looping Allen's method and having it duplicate each record one at a time is what I was thinking, but I'm not VBA proficient and don't know how to tell it which records to duplicate nor how to loop it. :(

In my simple database (attached), I need to mass duplicate Tasks and their Notes. I have three tables: tbTasks (PK: Task_ID), tbNotes (PK: Note_ID), jtbTaskNotes (FKs: Task_ID and Note_ID). jtbTaskNotes is my many-to-many junction table that ties Tasks to Notes. The main form (fmTasks)...

I wouldn't mind this datasheet solution, but you can't add brand new first names through the datasheet. I think that's my only complaint with this. Thanks for your help so far! Edit: If you look at the form fmFirstColor, it's exactly what I need, except I want it to show all records in...

I see what you're doing with that example, but I'm trying to implement just one continuous form. I'd like to avoid using subforms and keep this as basic as possible. I was able to save it as an .mdb for you to see.

I was able to mostly accomplish what I want by creating a query (quFirstColor) that has the FKs from the junction table, and the First_Name and Color fields from tbFirstNames and tbColors. However, the query doesn't let me see all first names, it only lets me see first names that have colors...

If I'm using a combo box for the first name that is configured the same as the colors combo box, then the control source for the combo box will have to be First_ID. This wouldn't allow me to type in a name as it would only accept numbers. Unless I'm not following you correctly?