Access form to populate additional rows

[Indep99]

Hi,
I have been researching the internet for the last two days but I can't find anything that's related to access without using javascript...
I'm not very good at coding but this is what I would like to do

I have one main form that I would like users to enter data that will populate tables in the background, but based on what the user enters, some information gets greyed out or some sort of drop down that shows up additional buttons...

As well, each file that the user enters in the form, might have more than one type so I wanted to create a button that would open up a new form where the user enters the different types the file can be (it can be 1 or it can be 10+) I have no idea how to do this so that later on I can filter based on the type of file...

Help would be greatly appreciated

 

[Alansidman]

You are looking to do many different things that will entail a fair bit of VBA. Not all that difficult but there is no simple solution, out of the box solution. I suggest that you start with what you deem the most important and progress through in a somewhat systematic way. Your current description is too vague for any real response that will be beneficial.

Start with some direct questions with examples of what you want to accomplish along with the criteria and expected results. There are lots of people here who will help to guide you and teach you how to do it.

It is important to note that you try to ask specific questions with explanations. Also, posting a copy of your db sometimes helps the forum to better understand your issues.

Good luck with this project.

 

[Indep99]

Thanks Alan, I figured I was all over the place...

I guess my first question would be how do I set up a formula in access... I understand I have to create a query, this is the formula I have currently in excel
=IF(IFERROR(D2-TODAY(),0)=0,"TBD",D2-TODAY())

D2 being another column in access

There will be a lot of columns with if conditions such as if column A is X then the data will be column B - Y

 

[Alansidman]

If statements in Access are similar to Excel in that the syntax is generally the same. You would use IIF instead of IF meaning Immediate If. Also, "And" and "Or" operate slightly different. You have to spell out each, ie. IIF(A=B or A=C, X, Y) or IIF(A=B and A=C, X, Y). Here is a link for a tutorial on this.

http://www.techonthenet.com/access/functions/advanced/iif.php

Also how And and Or work in a query.

http://www.datapigtechnologies.com/flashfiles/andorinqbe.html

The Term "Today" is not used in Access, the equivalent is "Date()", therefore the term "Date" is a reserved word and should not be used in naming a field.