Search results

Hello all, I've done this tons of times, so I don't understand what's happening... The title says it all: when I update the ID of one record of the main table, the referenced records on related tables won't update even though they have a relationship between them with the option "Cascade...

Hello all, I have received a horrible legacy DB. It basically is to keep track of sales to clients of products which each has a different tax (referred as IVA). I am trying to get for each order, the total price BEFORE applying the tax of each group. For example: Total of $100 @ 4%IVA => $104...

Hello all! I have a form with a datasheet. I would like to be able to remove the datasheet "toolbar", the one that has the buttons to navigate to next/previous, first/last records, the search field, etc... It's just a stetic thing, but I haven't seen any option to remove it from the "Format"...

Defaulting a "Medium Time" field to be "p.m." instead of "a.m."? Hello all, I assume this must be a pretty basic question but after a while searching I haven't found a solution. I have a Date/Time field in my database with a "medium time" format. The problem that I have is that if you don't...

Hello all, I have the following database (I hope normalization is ok here): http://img718.imageshack.us/img718/4016/relationships.png I would like to make a form where you select a date and below it there's a datasheet that would have all the necessary fields of every table. I mean I should...

Hello, I plainly don't know how to import data to an Access database while maintaining all relationships intact. Of the data imported, parts of it go to different related tables. The database structure is as follows: I have a program that extracts all the info to input, so I can really tweak...