Search results

There is a command for undoing the current record, which is Docmd.RunCommand acCmdUndo This can be done on the main form, or the subform, but I am not positive if it can be done to both at the same time. I believe once you go to the subform the mainform record automatically saves, but maybe...

I believe you may need to take a look at your table structure. You have a table for loaned videos, and a table for returned videos. You should really only have one table called tblLoans. THis table should include what you've said, VideoID, CustomerID, DateLoaned, DateReturned, and any of...

One additional thing, if you find that you can't fit all the controls on a single form, you can use a "Tab Control" on the form. The form would then have many "tabs" that can be switched back and forth, with different controls on each. You can even do the groupings in the tabs much like you...

I did something similar before for one of my databases. I opened Adobe, then I took a printscreen, opened it up in paint.exe. I then took the small logo from the Top Left hand corner, and saved it as a small jpg. If you're still looking for one (your last post seems to say you might have...

Edited: Sorry, misunderstood your original post. I got ti working, it wasn't a problem with the join types at all, but the actual direction the link was created. Thanks very much for all your assistance in helping me understant one-to-one relationships.

This is what I have been trying to do, can you give a bit more detail on how access allows this with referential integrity however, or if I would have to turn referential integrity off for these links. As I said, it will not let me enter the information in only one of the three child tables, it...

Thanks for the ideas of how to hash out this system. The Doc Man: Those are some great workarounds to those issues, thanks very much. I like those ideas very much :)

Ok, I have tried editing the one-to-one relationships so that they change the join type to 2 (I also tried 3). I then created a query with tblBooks and tblMainItems, but it still says "You need a relating record in tblLetters". I am using my Scheme2, I can upload another screenshot of the...

I understand what a normalized database is, and your system makes perfect sense, if all documents needed the same types of fields. Unfortunately where this breaks down, is that because the documents are so widespread, and different types of information are kept from many different types of...

AH, you learn a shortcut everyday :) Thanks guys, I'll remember that this is a shorter way to do the same.

Thanks for letting me know that Scheme2 is in fact the correct one. However which is the best way to work with so many one-to-one relationships like this, if I have only an entry in tblMainItem and one of the other tables, let's say tblBooks, the database will say you need a relating record in...

You can use a General Number with Auto, and it seems to keep any amount of decimals that the user enters.

Under the On Click event for the button, add the line of code: Me.checkbox = True Attached is a sample database of how you do this. If you don't want the checkbox to be shown to the user on the form, set the visible property of checkbox to False. The checkbox should be on the form, but just...

I'm not sure why rstData.update had to be removed, but glad it works. How it works is, the recordset stays on the exact same row unless you tell it otherwise. The .addnew means it creates a new entry, and that line is the current line. Meaning you can enter multiple different fields, that all...

What I do for my users is make them a new form that lists the dropdown list in datasheet view, so they can add a new company or whatever they need to the bottom of the list. If you really want it to only add after the button is clicked then you can use... Dim dbCurrent As DAO.Database Dim...

The way I would think to go about this is, retrieve the primary key value they're on, requery the form, then go back to that primary key... such as Dim key as string (or whatever it datatype it is) Dim rs As Object key = primarykey Me.requery Set rs = Me.Recordset.Clone rs.FindFirst...

It is definitely the AfterUpdate event you want, here is an example database demonstrating the correct code, it's the same as what DCrake said. But maybe this example will help you figure it out. If this code doesn't work for you, there is something else messing it up, and you would have to...

Actually, I'm gonna slightly reword a question here, because as much as I like the attribute idea (if I had it correctly), it would be difficult to manage in many ways for the users I believe. My new question is, if I use scheme one, what problems will the database run into (I can see that I...

So you are saying, there should be an attributes table linked as a one-to-many to the main items table (each item has multiple attributes). The attribute table has fields such as "Attribute Name", and "Value" so that... for example Attribute Name = "Book Title" and Value = "Access Manual" and...

Yes, the tracking is the same, meaning I only need one tblTransactions, the separate table is for the document types themselves, which all have different fields. I will look more closely at your scheme 3 later, thanks.