Search results

Hello all, needing some help. Trying to figure out how to get all the information typed out in a form on a report with a digital signature in place at the bottom. This digital signature is linked by our CAC Cards. I know there's a way to do it in adobe signing signatures. What would be the...

Based off the selection that was made in combo box. For instance, if the user chooses "Full Kitted" in combo box, it would add that day's date to "Date Kitted" field. When user changes to "In Work" in combo box, that day's date is added to Mfg.Start Date field. Does that make sense?

Hello all, I've been asking for a few final questions to get this database up and running. I'm very new to VBA, but imagine this feature will have to be done VBA. So, under the "Scheduling" form, when a new record is selected, I'd like for the REQ# to auto generate the next F#. The F# goes in...

Maybe I'm not being clear enough on what I want. Here's a picture of my form interface. This might help. What ever option is chosen in "STATUS", it populates that day's date in one of the green choices depending on selection. Again, I'm still a little fuzzy where/how the code you provided me works.

Sorry, I'm still new to access. So, just to be clear, I put that code in the afterupdate on the combobox? How does that populate the dates in the respective fields? Thanks in advance!

I forgot to mention, it would be the date the selection was chosen... So, Date()

Hello all, I'm creating a form that when the user selects the following categories in the same combo box (Date Received, Date Reviewed, Date kitted, In Work, Complete) it auto populates dates in the respective fields. As I mentioned, it's only one combo box. The dates will be spread out, so the...

oops... I forgot to post the database. Here it is.

Hello, again. I've been working on this access database for the last week or so. I've had a lot of learning experiences as this is my first one to do... I feel I've taken a lot of steps back and forth. But, I think I'm getting close! So, on to my question... I have a form (frmJob) that the user...

Disregard everything in Gray. Those were some older versions that I had initially. I was going to delete them, but was trying to get ideas before I did. They are completely meaningless. If you look at the query "Target Date of Completion", it will not let me do a report on that. I'm confused why...

I gave you an older version... Sorry. I actually did follow Plog's advice and completely restructrued my tables so I could sum the columns instead of the rows. I have it exactly how he suggested as far as table layout is concerned under "PieceParts" Table. I followed JHB's post by using the...

Hello all, I've asked a question on here before regarding the same database I'm creating. I've ran into another snag... Right now, I have an entire job with multiple piece parts. All of these different parts go through different processes (They are shown in the table "Piece Parts New"). I've...

Not to take any of JHB's Credit, but I had to research that function when I first saw it. Here's what it does... The Microsoft Access iif function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE. iif ( condition, value_if_true...

One more thing, the stopped column shows when each step is complete, any way I could show the start time for each given step. Basically move all the stopped column down one. Is there an easy way to do that?

Awesome work! Thank you so much!!

Hello All, I'm working on a query ("Target Date of Completion") that takes the initial date started (from Step 1 of date started) and adds the EC (Estimated Completion) which is just shown in days. This will give an EST (Estimated Start time) for the next step in date format, which I would need...

Okay, So I created the table from your recommended structure. I'm not real sure on how to do the query. Can you help me? Sorry for my ignorance, I am very new at this. Also, should I be worried that each piece will have a different amount of steps? Will this work for multiple piece parts in the...

Hello all, I'm very new to access, but see it has potential for a big payoff for a project I am doing. Currently, I'm stuck summing across the columns for Step 1 EC (est completion) - Step 8 EC. This may be a poor design on my part from inputting the data in the table. But all of these jobs...