IF Statement in a Macro

[Elbows]

I wish to do the following by using a macro. I cannot write VBA.

Open a form that has one field.

If the text in the field says yes then open the yes form, if not then open the no form.


Thanks.

What I am actually trying to do is to populate a table automatically.
I receive an Excel sheet like so:

1	Data
	Data
	Data
2	Data
	Data
3	Data

Im want it (through an automated process) to end up looking like this, ie filling in the blanks:

1	Data
1	Data
1	Data
2	Data
2	Data
3	Data

I can do it through a series of queries but it is a little untidy as it just creates a null expression and I have to "stop all macro's"
As I mentioned I don't do VBA.
I have done this before in Access 2003 but I've lost the database that it was on.
I basically did it by opening a form. If it was yes it opened the Yes form (which triggered the loop) or No which triggered the "Done" form

[June7]

Why not VBA? Time to learn?

I don't see any way to do this with macros except for executing the series of queries as you are doing.

[JoeM]

I agree with June, that VBA in Access (or even Excel) is the best way to go, if you are looking for automation.

A manual, but fairly quick way to go about it is to fix the file manually in Excel like this.
1. Find the first blank entry (let's say it is cell A3), and enter a formula in that cell referencing the cell above it (=A2).
2. Highlight the cell with the formula you just entered and select the Copy button.
3. Highlight the rest of that column, down as far as the bottom of your data.
4. Press F5 (Go To) and press the "Special" button
5. Select the "Blanks" radio button, and press "OK".
6. Hint you "Enter" button on your keyboard.

This should "AutoFill" all your missing entries.

[June7]

Oh Doh! I should have seen that prepping the Excel first is probably simplest approach.

[Elbows]

Thanks people I agree VBA is the way to go. I've ordered the book !!!!!!
However If you could answer the first part of my question :

Open Form1 that has one field (Field1) from Table1.

If the text in Field1= "yes" then close Form1 and open Form2, if not then close Form1 and open Form3.

I've got the first bit in the macro but cant figure out how to you use (or what to write) in the IF Statement after the "Open Form1". I know it should look like [Form1]![Field1}="Yes" but it doesn't work.

Any further advice is much appreciated.

[June7]

You show a } instead of ].

I don't use macros, only VBA.

[Elbows]

That was just typo.

I know it should look like [Form1]![Field1]="Yes" but it doesn't work.

Would appreciate somebody who DOES use Marco's to reply. If nothing else but to save space!!!

[June7]

I don't routinely use macros in my projects (used macros only twice) but have debugged a few dbs that use them. Unfortunately, I have to analyze the db directly. If you want to provide, follow instructions at bottom of my post.