Search results

it didn't work. Here is my code: Private Sub Command20_Click() On Error GoTo Err_Command20_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "SearchResult" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Command20_Click: Exit Sub Err_Command20_Click: MsgBox...

Hi, I have a question; If I hide the Database window and uncheck the Allow Full Menu checkbox from Tools--> Startup The next time I open the application how can I get them back? Any help will be very appreciated, Thanks, CS.

Hi I need a button code in the OnClick event. I want when clicking on the button, to close the currently opened form and open another one. Any help will be very much appreciated! Thanks guys! C.

Thanks Pat

Hi, I have a report that contains names, (each name in a row), I want to create a serial number for each name (i.e. 1, 2 , 3 , 4 ...) Please note that these names are grouped in sections, I want in each section the serial starts from 1 Regards, CS.

I think i'm going to change the structure back to One-To-Many (one parent can have more than a student in this school), I don't want the user to create the student, then the parent and afterwards" manually" attach their IDs. I'm trying it now..

Thanks alot Rural. I was looking at Northwind and I'll check this link now. You are my hero!

me too, I'm lost too! actually I have 2 equirement from the user: 1) the student information has to be added before the parent information 2) a parent can have more than one student ( we need only one parent for each student) so it's actually a one-to-many relationship i did it the way I did...

where should I do the update?

but how are they going to be linked in my structure I'm linking them using another table student_parent which will have the primary keys of both students and parents?

I passed the Auto number (because it's the primary key) not the Student ID. but in the Open form event in the parent form it highlighted Me.Student_Auto with an error (Method or data member not found)

where and how? Can you please explain I didn't do something like this before.

Rural, I'm getting desprate about thing combo box thing and I'm really on a deadline. so I'm trying another thing and I need your help. I'll put student information and parent information in 2 separate form. First the student information is entered normally and then a button is clicked to...

Rural, I tried to do it for the parent instead of the student, but same thing I'm attaching a sample of the database, The form "GUARDIAN_PARENT4" it has 2 tabs, first one for student and the second one for the parent. In the parent tab, I put the combo box in which the IDs are, try to add an...

you mean requery it when clicking the close button of the "add form" ? I'd really appreciate it if you could a attached a sample of your system (without any data). I just want to take a look at how you did it. I know there is something wrong with mine I just don't know what!

Same thing. I got the Could not Locate message.

ok I changed the code now whenever I come back from the "add form" to the combo box in the original form I get a code error when I say debug it takes me to AfterUpdate Code and hightlight: DoCmd.Requery There is one thing I noticed: my relationship is as follow: Parent: has an auto number as...

When I enter a new ID in the combo box the NotInList event kicks in and it asks whether I want to add it to the list, I say yes and it takes me to the add form where I add the related information (the system gives it an auto number, for example 49) I go back to the combo box when I try to...

yes this is my new one: Private Sub Combo48_AfterUpdate() DoCmd.Requery ' Get any changes to the table first. ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[Auto] = " & Me.Combo48.Column(0) If Not Me.RecordsetClone.NoMatch Then Me.Bookmark =...

sorry, same thing. Why do you think it keeps giving me the Couldn't Locate message?