Search results

Welcome to the forum. :)

In short, put a button on your form and cancel the wizard. Write code in the button's click event to copy the rich text box to a string variable. It copies as plain text with HTML tags. e.g. <div>Everything <font style="BACKGROUND-COLOR:#FF0000">and </font><font...

Quite often I find I have been logged out while typing a reply. Can you have the activity in the reply pane detected so this doesn't happen?

I see where you're at, I believe. It is like a library database, where different types of media have properties that do not apply to others. Books have pages, but CD's and videos do not. One combines what is common in one table with an item ID, and creates 1-to-1 relations with tables designed...

Quick fix: Make a duplicate of your button, and change the reference so that you have one for each occasion. Set the visible and enabled properties of both to No. Park the new button on top of the old one. In the On Open event of Mainform, check to see whether Mainform is in the Forms...

The source of your problem is in how Access shows, or rather, doesn't show a subform. I added a button the same as yours, but with the following Where clause: [MainData]![RecordNumber]=[forms]![NavigationForm]![NavigationSubform].[Form]![RecordNumber] It worked as intended. If you wish...

You have PRODUCT CODE in the Inspection table; you do not need PRODUCT NAME there, too. Set the PRODUCT CODE field in Table Inspection Records to lookup from Table PRODUCT. Make a query that includes the fields from Table Inspection Records, including the foreign key PRODUCT CODE. Add...

Typically, an invoice is the main form, and the details are the subform. Courier and sender (customer?) would be lookups for Invoice. tblInvoice pkInvoiceID fkCourierID ... lookup from tblCourier fkSenderID ... lookup from tblSender . . . tblCourier pkCourierID CourierName . . . tblSender...

Well, let's just keep it quick and dirty for now. I looked at the copy that Severin attached. It looks like you may have changed an older version, because the most recent db you attached has none of Severin's changes in it. Find the correct version, add your last set of changes, and you should...

I am not seeing a field for dates in the db you posted. I would have structured a table like so: tblActivityRecord fkSchoolID ActivityDate fkActivityID ActivityQty Regardless, you need to account for dates if you want your subforms to act right. The more I look at it, the more it looks...

It all seems clean, so far as I can tell. Make a copy of it, and populate the copy with a series of test data to see how it holds up. Don't forget weird stuff to account for input errors (nulls, negative values where only positives should be, etc.). No matter how pretty we make it, there is...

tblSpecies would be necessary to hold the information relevant only to a given species and not necessarily appropriate to the higher levels of classification. If you are using tblAnimals to represent individual members, tblSpecies is a part of the analogy. :) However, my only experience...

When I looked at your snapshot, my first instinct was to grab my mouse and arrange without crossing any lines. lol So far, the only thing I see wrong is that you have fk_OCCID in two tables, one of which is a child of the other. You do not need to duplicate the reference in Purchase when it is...

You will be hard-pressed to find a better way than what Galaxiom has laid out. :)

Are you certain you need the button on every row? If you put the button in the header or footer, you can set its enabled property by placing your code in the Current event. This way, the button's status will depend on the values in the currently selected row. :) Private Sub Form_Current()...

It sounds like you have a one-to-many relationship with Categories and Items, with a foreign key in Items to tell which category belongs to. Create a form for the the Items table, and open it with a button from your listbox form with the selected Item as an argument. Your selected item will...

It sounds like Access still has a reference to that table in one or more of its system tables (the hidden, secret ones we are not supposed to fiddle with ;)). You could try creating a new blank database, and then import all your objects from the old one. This should give you a database that...

Excellent. I am happy to hear that. :)

I really couldn't put it better than the article jdraw linked. All of your data is listed once, in one place. Only the references to them are duplicated, which is normal. You will not acquire erroneous data elements from typos if you have to select one from a list. Database size is generally...

Hello, SamLis. Do not nest your properties. What you are trying to do is make an inventory of unique combinations of entities. The separate tables you have made for these entities are your lookup tables. Your Inventory table should have a record ID field as a primary key, and a field for...