Search results

It seems correct that the relationship between players and cards is a 1-* that is because a player can have many cards but a card can only have one player. You mention the fact that one card can only show one player. This is the '1' side of the 1-* relationship. But the fact that one player...

It's hard to say without a better understanding of the discourse but you do appear to be on the right track.

I don't know why but on my form in Form_Open me.openargs = null and the Form_Load does not seem to be running. (there is a msgbox in there that is not running) Made a new form and put the code in Form_Load instead of Form_Open and it worked. Don't know what was going on with the old form but...

I also have this problem. I will reply if I figure it out.

okay thanks, I was sure that the syntax was sound. So I'm glad you confirmed it. I changed the Sub from Public Sub SetFile(ByVal sFullPath as String) to Public Sub SetFile(ByVal sPath as String) and now it works... :confused: Thanks for going through that with me :)

Year that works for me too. All of me Get and Let Propeties work just as I would expect and are similar to how you have shown. but I have a sub in my class: Public Sub SetFile(ByVal sFullPath As String) But when I call it like this: Call oFile.SetFile("S:\Lifelong\Contacts.mdb") It does...

I have used classes in vb6 a while ago but never in vba so I am hopeing that I have missed something blindingly obvious. I have a Class Module called FileObject It has 3 Public Get Properties for FullPath, FilePath and FileName It also has a Public Sub SetFile(ByVal sFullPath as String) This...

I don't fully understand your problem. What is a bank rep. A report? someone who works at a bank? I'm unsure. I'm no billy whiz but your join between bank and client looks okay to me.

I don't know what ven and sch are but it does appear to be the wrong way to go about this. If you have a table with a Ven# and sch# that are foreign keys then you shouldn't duplicate data by holding ven name and sch name in this table as well as wherever they are linked from. i.e. if you had...

You can see what is happening here if you try to add a new custemer by opening the customers table and typing the details in a new row at the bottom. If you fill in all of the details but leave the addressID field as 0 then you get the same error. You are trying to add a customer without an...

You could do some kind of nasty loop in your code using the start date and number of days: Dim nDayCount As Integer Dim StartDate As Date Dim nNumberofDays As Integer nDayCount = 0 While nDayCount < nNumberofDays 'INSERT SQL Statement to add the staff member and Date...

It's frowned upon for various reasons but if you are determind to find a way like this then you could look into using goto statements. I have never really used them so dunno if it would be suitable but it might be worth a look.

When you add a combo box to a form you get the wizard... all is dandy. After the wizard is completer you can see the things the wizard has done to get the requested features from the combo box. For instance if you say I want the values from these fields from this table then you can see the SQL...

It sounds like i would have the code split up into seperate functions. i.e. all the code after the form open command move to another Sub and then on the button on subform call that Sub.

I implore you to adopt a more appropriate naming scheme for your controls. An EVIL DIRTY solution may be to: "Call List7_Click()" at the end of Frame33_Click That is bad and the purist in me is praying that it doesn't work. I'm sure someone will be able to give you a good answer.

I was hoping that this wasn't the only solotion. Thanks for your help.

I understand that I cannot change control.enabled to false while the control has focus. Does this mean that if I were to make a form with only one control that can have focus then I cannot disable said control? I'm used to plain old VB6 and am unfamiliar with this restriction :mad:

I am very inexperienced in databases and I am currently attempting to design a database and there is one part of the schema where I am unsure how to proceed. I need to model schools, pupils and teams. Schools have a number of pupils as do teams. I rushed in with the following design but it...

I have decided how to go about my original problem. Thank you for your time. :)

If I may be more specific. My table holds 3 yes/no fields disability, mobility, learning difficulty and then a text field for ellaboration. I understand you telling me that this needs to be in a seperate table. Is this a many-to-many? I thought it was one-to-many.