Recent content by debbieg

Any ideas or suggestions?

I need some help! I have 2 tables: Hotel_Coupon Player_ID RedeemDate Gaming_Details Player_ID GamingDate StartDateTime EndDateTime Actual Theo Type (Pit or Slot) Example of one player: Player_ID Type Actual Theo GamingDate StartTime EndTime 14841 SLOT...

It won't do it because all the fields are not enabled and locked. The only thing the user can do in this field is add or delete. If they want to edit, they do that in another form.

I have a form with a subform in it. The subform is a continuous form. The subform has a combobox for the user to select a record and there is an Add button for them to add a record. There is also a Delete button to delete an existing record. The Add and Delete buttons are functioning...

Maybe I didn't get an answer because I didn't explain my tables. Members MemNum (Primary Key) (Auto Number) Gender FN MiddleName LN Suffix Nickname BirthDate Died etc., etc. Teams TeamNum (Primary Key) (Auto Number) ManagerMemNum (Foreign Key) Gender TeamName TeamYear TeamSeason NightPlayed...

I can get what I want with 3 queries: qryPlayersByYear gives me what team every member played on in each year. SELECT Players.MemNum, Teams.TeamYear, Teams.TeamNum FROM Teams INNER JOIN Players ON Teams.TeamNum = Players.TeamNum; qryPlayersByYear_2 gives me the year every member played in...

Some more information: Teams TeamNum (Primary key) (auto number) TeamYear ... Players MemNum (Foreign key) (Primary key) TeamNum (Foreign key) (Primary key) When the above 2 tables are joined on TeamNum that's how I know which team(s) they played on which gives me which year they played...

Thanks for your responses. The 2 tables are joined on TeamNum. I can see what players are on each team and what teams each player has played on. The data that BigRed1212 showed is a good example. I very unfamiliar with subqueries. I cannot get either of the example code to work without...

TheAceMan1, Slick! That got rid of the error. I'll remember that one! Thank you so much for your quick responses and your help. Debbie

TheAceMan1, Thank you for your help. I had to check for NewRecord because it wouldn't save changes to an edited record. I had to add the extra quotes because some names have apostrophe in them. If Me.NewRecord Then Dim NL As String, DL As String, ID As Long, Cri As String, DQ As String...

I have the following tables: Teams TeamNum TeamYear ... Players MemNum TeamNum I have trying to get what I want all afternoon! I want to get the number of players by year. Players can play on more than one team per year and I want to count them only once. I've done a select query with...

I have created a database for a senior softball league. If we sign up a new player, I would know to check to see if they played in the past, but I'm going to be giving this database to someone else and they may not. So, I'm trying to put some checks and balances in it. When I add a new...

I have created a database for a senior softball league. I have a main form and subform which is working great to display players on team by year and season (e.g., 2008 Fall). The main form is based on a query. SELECT Members.MemNum, Members.LN, Members.FN, Members.Nickname...

The Split function worked great! Here's what I did: LTemp = Replace(LDesc, "</QMTABLE>", "") LTemp = Replace(LTemp, "</QMSTDFEAT>", "") LTemp = Replace(LTemp, "<QMSTDFEAT>", "<QMTABLE>") Dim tempstring() As String tempstring = Split(LTemp, "<QMTABLE>", -1, vbTextCompare) Model = tempstring(0)...

I have inherited a database. One of the tables has a Memo field with what looks like a field within a field. Within the Memo field is text between <EXAMPLE1> and </EXAMPLE1>, and <EXAMPLE2> and </EXAMPLE2>. I've been asked to create a report and the I need * the text before <EXAMPLE1> to...