Search results

Hey guys; What I'm looking to do is setup up an invoicing-type system. I want to create a form wherein there will be several list/combo boxes to select various parameter (ie. product id, accessories, materials etc). As well on this form I want to put a "submit" button that will open up a report...

holy jeez, thank you so much for the help selena, you're a peach

I'm looking to do something similar to merwonder. What I want to do is to have a form with several list boxes. These list boxes will be a selection of several various parameters. After all boxes are filled up I'm going to include a button at the bottom that will open up a report showing the data...

So I want it to update the DateModified field each time a value in the Hours field is modified through the form

Ok, here is a simple example of what I'm trying to do

Ok, I get what you're doing now. But what's with the button? Can it be done without that?

Still not working, although I really can't follow your example.

Thank you very much for the help Selena

The name of the table is "ProductionHrs". It seems to me that this should be pretty easy. The date thing works properly when I create an entirely new record, but doesn't when I modify and existing one

nope, still nothing showing up in my table. Maybe it has something to do with the way I set up my text box? What I did was in design view, I just put in an oridnary text box, then under properties I put the Control to DateModified, which is the field in the table I want to export the values...

Still can't get it to work. What I did was I made an invisible text box on the form and used my Date field as the control source. Then under Before Update I put the following code me!DateModified = Date() or Me.DateModified = Date() However, neither of thse work to input an entry into my...

Still can't get it to work. What I did was I made an invisible text box on the form and used my Date field as the control source. Then under Before Update I put the following code me!DateModified = Date() or Me.DateModified = Date() However, neither of thse work to input an entry into my...

that's a very good suggestion, will try. Thanks

I think I'm getting closer to the answer. I think I can figure out how to do it if I include the date field in my form for updating values, but I don't want this to be visible on the form. What i want is to only include updateable values on the form and have the date of modification updated...

Hi all; I know this thread has probably already been done but I've tried searching and nothing I've found seems to be what I'm looking for. What I want to do is incorporate an automatic Date update to a table, every time an item is updated in that table. I've tried creating a new field...

I figured a work-around for the blank record entry, thanks for the help Ken. However, this whole "switchboard" think has peaked my interest. Does changing it to an actual switchboard make it more efficient than just using a regular form to do the same thing?

How do you create a switchboard Bat? All I thought it is was just a form with buttons that open up other forms. What's the difference between that and a "switchboard"?

Any ideas? I know it can be done, I just don't knonw how

No, this form is solely for adding new records, I have an alternate form for modifying records that's based on a parameter query. I'm going to use a switchboard similar to the Northwind sample so that the interface is painfully simple

Could you add something to the control source like an "&" or some such so that it does this? I'm really new to Access so I could be horribly wrong but it seems to me there should be an easy way to link them.