Search results

It seems to be working now... without doing anything, that's weird. Although when I update the ID the form doesn't autoload the related registers, so I have to exit the form and enter again to see them there. Is there any solution to this? Thanks a lot!

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...

Oh my god... THANK YOU so much! It is incredible how we sometimes complicate our own lives... ;). That approach is far better and easier. It worked perfectly. Thanks again, you've saved me some hours and a big headache. Cheers!

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...

Re: Defaulting a "Medium Time" field to be "p.m." instead of "a.m."? Oh, that's sad... but what can you do! Thanks for the reply. Cheers!

Oh! Thanks for correcting! This is what happens when being a newbie... Thank you both!

Thanks a lot! I remembered it could be done... the problem was that I was selecting the whole subform and I had to click on the upper left square of the form in order to see that option. Thanks for helping!

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 again, boblarson, after trying out your form it works great. If you could help with some little things it would be all donde and really perfect to what I need. So if you or anyone can: 1. I'm struggling with this tiny but important bit. WHen I enter a date for a race it automatically...

I've downloaded it and I'm trying it our right now. Many many thanks for taking the time to do this for me. I really didn't about this possibility. Although as you said is not what I had in mind with a little tweak it's going to be perfect! Again, thank you very much for this, it's great to...

That's too kind on you... and I would have never expected that. Just in case you have time and don't mind to have a look, I have attached the databse in question. As it's a new project it doesn't have any data on it. Anyway, although I thank you a lot for your willing to help, it really is...

I'll try and have a look at how to relate those... I know I related Master/Child fieldsin the past, but I really can't remember nor find the property right now. Anyway... I want to browse by date, so I guess that has to be definetely my main form. As I want quickness in inputing data and the...

Hello again and thanks for replying. What I really want is a "fast" way to input data... so one sheet would be better than more than one. Anyway, I tried putting various subforms... the only problem is that I don't know how to bind fields between subforms. I have tried through the "Source"...

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...

Thanks a lot for answering, If I have to program anything I think I'll just go and make a little C# then. I just thought of Access because I was given the database in that format. But if automating input is going to be a programmatical task, I think I prefer other options then. Thanks for...

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...