Search results for query: *

Please tell me what is the correct syntax for acess 97 to: The user selects from a combo box to fill a text box. I want the field of the non-data source table to say exactly what is populated from the combo box. It should be something like this: If Not IsNull(Text1) Then...

Hi i am used to 2000 but am using '97. I have a form which uses a combo box from a table that lists all possible classes/days/times for students to enroll. When the user selects the class, i would like to store the information in a different table for that student id. I am trying: If Not...

I am using access 97. I have a form based on the classschedule table with a combo box from which the user can select a certain class/date/time. After the class is selected I would like the info stored in the classregistration table under the studentID. I am trying to use the following but it...

I am using access 97. I have a combo box from a classschedule table from which the user can select a certain class/date/time. After the class is selected I would like the info stored in the classregistration table under the studentID. I am trying to use the following but it isn't quite right...

I'm using '97 and havent' for a while. Could someone please give me a hint on syntax to fill a table field from a form. I have tried If Not IsNull(Me.Combo1) Then Table![Registration]![Class]!.Value = Me.Combo1.Column(1) I know this is close but i have something wrong with how I have...

I am working with Access 97 and havent' in a long time. I can't remember the wording to have the combo box selection populate the text box. It is something like If Not IsNull(combo10) Then text1.value = combo10.column(2) But this is off somehow because it is debugging every time i try this...

I'm sorry I am brain dead. This is probably easy but I have been working all weekend. ACCESS97 I have a form that I want to add a text box that populates from another table than the one the form is based on. I put a text box on the form and in the control source i built an event =table!etc...

I am trying desperately to total inventory levels. I have tried update queries and DSum's in my form. Something is definately not right. I have a table which lists starting quanitities. I have another table in which via form users are entering inventory changes. How can I just have the...

ACCESS 97 I am trying to create an update query so that my form can show the most current balance of inventory. The query "runs" so to speak but there is no entry to the table. Am I missing syntax??? UPDATE tblDataEntry INNER JOIN tblAssemblyStQty ON tblDataEntry.AssemblyID =...

I saw a post regarding this and now I can't find it. IN ACCESS97 how can I make my form NOT save until the Save button is clicked? Thank you!!

For all of you who have been searching for the correct set up for Calendar Control....after MUCH searching I have found the answer in a brilliant article. Here is the link!!! Enjoy and PLEASE pass on to anyone who needs the calendar!!!!!!!~!!!!!!!! http://www.fontstuff.com/access/acctut09.htm

This calendar control is crazy. In Access 97 how do i make the calendar update my text box on a form to set the form so that the records entered have that date? I have tried an onclick and an afterupdate event but neither populates the text box unless you click into the text box. Then it only...

I am using Access 97. The users of my database are committed to a calendar but I dont know how to get it to work I would like the date selected on the calendar to update a text field on the form and set the date to that date. Right now it "updates" the text field but only if you...

this is my first post so i hope i say this right I have a table where users enter amounts of inventory changes for parts. I need to see or at least report a running or current sum for the parts that have been received or shipped. I think DSum sounds close to what I want but I don't really...