Completely oblivious

[afig]

I recently took up a project to create a database in which there are several forms. I'm familiar with access in the sense that I can work with properties, create forms, I'm even quite proficient in several variations of SQL. I cannot however, simply relate a form to a query.

What I need to do is have a form that has two fields: 'studentId' and 'paid'. Both fields come from the same table in the same database. When the user enters the 'studentId' and clicks the 'paid' yes/no checkbox, it will update the 'paid' field corresponding to the 'studentId' field. Any tutorials or anything worth reading would be great. I'm a programmer, so using programs to make programs isn't unknown to me (for the most part).

Any help is greatly appreciated

 

[TheAceMan1]

How are ya afig . . .

[blue] . . . and clicks the 'paid' yes/no checkbox, it will [purple]update the 'paid' field[/purple] . . .[/blue]

Update the paid field to what?

References:

Fundamentals of Relational Database Design

Normalizing Tables

Table Relationships

[blue]Also, be sure to read one of the links at the bottom of my post . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[fneily]

I don't know what your problem is - are you saying you created a query to pick off two fields, created a form based on the query, tried to update a field and it won't update? Then see:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp

Or are you saying you don't know how to use the form wizard to match the query to the form?

 

[afig]

This might seem funny, but I was just not comprehending how to link between a table and a form. I managed to do what I wanted to do.

Being a backend programmer, I'm not quite fond of programs that make programs for you, I just code what I need done.


I built my own switchboard using buttons and some vb, I'd like to have one of the buttons bring up a report that already exists, is there a doCmd to do so?

 

[TheAceMan1]

afig . . .

You've gone from one thing on one end of the galaxy to another thing on the other. Only to wind up asking the simplest of questions, which doesn't fit the [blue]prowess[/blue] you say you have!

[blue]I'd like to have one of the buttons bring up a report that already exists, is there a doCmd to do so?[/blue]

[blue]Did you look for it in help?[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[MajP]

you have probably found it already but A little word of caution that gets me all of the time. The default view on the docmd.openreport is to print immediately.

View Optional AcView. The view to apply to the specified report.

AcView can be one of these AcView constants.
acViewDesign
acViewNormal default Prints the report immediately.
acViewPivotChart Not supported.
acViewPivotTable Not supported.
acViewPreview

After I forget and send a couple hundred pages through the printer I remember "acPreview".

 

[PHV]

I remember "ac[!]View[/!]Preview".