Search results

Thanks so much for all your help guys! I have a subform of revisions and I already have the PK set to autonumber. I have a field inside the table which is a sequence number. I would like this field to autonumber when a new revision is added. But as you all know you can't have two autonumber...

I can't thank you enough jzwp22! Did you use the wizard or design view? I need to add atleast 8 different text boxes or places for different revisions. Like in my previous post I had the RevLevel1-8. Where can I add those in? I split my HWName into a HWFirst & HWLast. How do I make the name...

How can I reset my ID autonumbers? I have been testing out how the data entry will work and each time I enter a record it assigns a value. I know this is what it's supposed to do but can I reset them after I delete the record? Thanks! I'm trying to get the form functional. How would you...

So I can't just fields to my Drawing Revision Table? I need to go back re-design my structure?

Sorry, I updated my last post with a question.

That was my first choice of just using the word document but my VBA coding skills aren't that great. I can't just code from a blank page. I tried searching on linking Word to Access but didn't find anything to useful. And it seemed like a lot of extra work. So that's when I choose to stick with...

Thanks jzwp22 for the great start! I can still have form look like one from my first post right? But if I need to print than I can just save the form as a report correct? How do you get the data entered in text box to show up in a certain field on a table?

Ok, great! I have one more question. Would you suggest using the autmated processes for designing the forms? I tried designing one from design view and I couldn't figure out how to get the data entered from the form into the table. I'm guessing now that the structure and relationships are set...

So in the HW Team table where did the subdatasheet + come from? Is it because the relationships are set? So if I wanted a first and last name I should have two different fields? So what is the next step? So I can get started on some tutorials and play with it. What was the RevLevel...

I keep getting the Relationship error when trying to connect everything I'm reading on the error now. Here is my Database if you don't mind. Thanks so much for your help.

I have a couple forms that I have to do this and i just meant I need to focus on one database for this form. That's a great start, thanks for your help. I'm sure i will bugging you again. What should I do about 6 different people that review the document? For instance there only 2 Hardware...

Thanks jzwp22! Alright, Taking a step back. I think I should focus only on the Drawing Change Form that I attached on the first post. Drawings get reviewed and this form is used to track those changes, who is suggesting the change, and whether or not it should be made. Before, these forms were...

Hi guys, So I don't know if I am over my head yet but I'm sure trying and learning. I would greatly appreciate any help. So here is the situation: I have been given a couple tasks but i think I need to focus on one portion of it and get it running like we want. I have attached an example of...

Thanks, does anyone know of any walk-throughs? I need to make a blank table first right? I'll keep searching.

I'm new to Access and I have tried searching but I don't even know what I'm looking for. Can some please point me in the right direction of a tutorial for data entry. How do you get data from a form into a table? One more question, if I wanted a person to enter data in the form how would I send...

Thanks again!

Awesome! Thanks. :) But now Access freezes when I try to open the (...) I'll get it!

Thanks SOS! Just wondering why the cursor always has to active.

Hey SOS, sorry for the two threads. So I have to choose my drop-downs and then save as report? I have been able to print my forms very well.

Sorry SOS, So I have the Combo box in my form. How can I access from there? I'm still new to Access. Thanks for the help.