Search results

Yes, a date is being entered, it's defaulted to today's date. Ok, your code makes sense to me mostly, I have coded in other programs before, but I'm afraid my usage in Access has been mostly with the wizards so far. Where would I enter this code? Would it be in the expression builder of the...

Hi all, I need to create an "autonumber" field in the following format: FYYMMXX Where F is a constant, YY is the year, MM is the month, and XX is an incremented number. So for example, the first record in August of 2013 would be "F130801". I've been checking other threads but haven't been...

Hi, I am new to Access, and I was hoping for advice on how to setup my database. I'm trying to setup a database that will track which raw materials/submodules are built into submodules/products at various levels of assembly. So I have 3 related tables: KITTING: Records the workorder...

Thanks so much for posting... I tried that, but I must be formatting it incorrectly, because it's not working yet... To explain my steps: I'm opening my Form in design view, selecting the field, opening the property sheet/Event/Before Update and in the line beside it typing: = If...

You know, what I probably should be asking for is general help/advise in setting up my database... Here is what I'm trying to do: I'm trying to setup a database that will track which raw materials/submodules are built into submodules/products at various levels of assembly. So I have 3 related...

Hi all, I am a newbie, and I've been struggling with this problem for days now. Every different way I try has an undesired side effect with the userability of my form... I have a bad feeling that this won't do what I want it to do. Is there a way for me to have a field in my form/table...

It seems to be working now, I had posted in a new forum (because I felt bad for cc'ing dab1477 on all my correspondence about my issue, not knowing how long it would take to solve...) and it was suggested that I add the DLOOKUP to the AfterUpdate and change my syntax in both locations to...

It seems to be working perfectly now! Thanks so much for your help!

I did try adding it to "AfterUpdate", but it still behaves the same. I added it to "On Change", "On Dbl Click", "On Enter" as well, but with no luck. The field only updates if I close the form and then reopen it. Am I missing something? Thanks so much for any help you can provide...

Hi, I've managed to make it work, but I've noticed that if I change my workorder entry in the form, the value in the text box does not change. To explain, here is my syntax, which I've entered into the Control Source of the unbound text box...

Hi pbaldy, I've managed to make it work, but I've noticed that if I change my workorder entry in the form, the value in the text box does not change. To explain, here is my syntax, which I've entered into the Control Source of the unbound text box...

I was just reading 204126, which seems to be the same problem as I have, but I'm not sure where to enter the vba function... Does that go inside the unbound text box properties? Where does it get defined?

Hi, Inside my form, I would like to have an unbound text box display a field from a separate table based on a user-input into the form. I've tried a DLOOKUP, and just putting a direct equation into the text box, but to be honest, I can't even tell from the tutorials if this is an event or a...

... ok, it is working now, I had setup my Query originally to use the product field from the KIT table, but of course it should have been in the PRODUCTS table. I'm still wishing to add a text field though that would display the PRODUCT name inside the form though. If the operators merely...

I've tried using a query, and unfortunately the result is the same. It displays the ID# of the product from the other table, not the product name. I should explain what I'm trying to do a little better. I have 3 tables: TBL_PRODUCTS. This table is a list of products. This includes...

Probably the standard Microsoft tutorial will help... I will try that and post an update when I've had the chance to review it. (probably not today, I'm on vacation, just trying to catch up)

... probably, to be honest I haven't gotten into queries too much yet... Can you recommend a tutorial that can show me how to do that?

Thanks so much for any help you can provide...

This post sounds very similar to the issue I've encountered, only in my case the combo box wasn't working because the field in the table I want to display is in itself a lookup to a third table, so when I display it in the combo box, it displays the ID# to the third table that is saved in that...

Hi all, my name is Laura, I'm a total newbie, trying to teach myself Microsoft Access in my spare time (of which I have little or none) to try to improve data collection at my job.