Search results

Hi, I am trying to create a macro in excel to clean up data that I export from another program. What I did is I recorded a macro, and the macro works beautifully for the set of data that day. However, the next day when I export, the number of rows is different, so the recorded macro I have...

Thanks! I have been reading up on the Junction Table, and that will do exactly what I want

I am trying to setup a database to track athletes and their off season conditioning. The athletes will be entering their workouts online, and then the coaches can access the data. The athletes register online, and one of the questions is to choose what sports they are participating (or think...

I have written a database that keeps logs all the track and field results for my school, and I want to make it a little more user friendly. On the form where results are entered, the label for the field where the results are entered says "Final Time" But I want to change the caption based off...

Thanks for the feedback. I didn't know it was possible to over-normalize. That setup makes perfect sense. And with my athletes, that dropdown box is tied to a table of athletes, each with their own ID number, so I have taken care of that potential duplicate issue. Thanks again!

Hi - I am trying to design a database to keep track of rosters for some athletic teams. Here is how my basic design is setup: tblYear: Has two fields, YearID and AthleticYear, with Year ID being the primary ket tblSport: Has two fields, SportID, and Sport tblLevel: Has two fields, LevelID, and...

How would you go about doing that? Deleting the records I mean. I have tried tying it to a table called tblDefault in the past, but I have found that it creates a new record each time, thus there are multiple records in the default table, and that doesn't work well.

Hey. I have been working with basic Microsoft Access for many years, creating basic forms, tables, queries, and reports. But I don't know how to do something that keeps coming up again and again - making a default value through coding. What I have done for years is create a form that had a...

Hi. I am using Dreamweaver and I want to filter some records from a database I have. The records are a listing of all the sports teams from the past year and what they did. But one long page of results doesn't help me. Dreamweaver has the ability to filter by 1 field, but how to I filter by...

That is what I am looking at accomplishing. If a user enters 1:30 into the unbound textbox, then I want it to automatically put the 1 in the "finaltimeminute" field and the 30 in the "finaltimeseconds" field of a table. So when I look at the record in the table, I see the 1 and 30 in the...

I have been working on this database of mine for quite some time, and I have run into a roadblock. Here is my situation. I currently have a form that has two texboxes, one that is linked to the field finaltimeminutes and one linked to the field finaltimeseconds. The user hits tab to jump...

Once again, you knew exactly what I needed to accomplish. Thanks!

Thanks! That is exactly what I needed to have happen. I was trying too hard to think of some other way to combine fields in the detail section, but using the grouping option worked exactly like I wanted. I do have one more question, and it has to do with trimming. Currently a lot of my...

Thank you so much. That worked beautifully. One other question - how can I suppress a whole record when it is a duplicate? I setup the criteria for my field to suppress based off of a condition for the record, but what if the record is identical? I see the option to suppress a field if it is...

I am trying to make my crystal report look better, and I am having one issue - records that aren't visible. Whether it is the visible property set to false, or supressing duplicate records, all crystal reports is doing is putting white space where the record actually is. However, I don't want...

I have one more question about this setup - how do I put in a criteria so that only the records that don't have null values show up? I have a field called final time, and if that value is null, I don't want it to show up.

Currently I have two fields that makeup the time of day - a minute textbox and a seconds textbox. Currently, a user has to hit tab to go from one textbox to the other. How could I code it so that if a user hits colon : it will automatically jump to the seconds box for a more natural feeling...

Yeah - I understand now. Once I made the sortkey expression in a query, it made a lot more sense. Thanks again for your help!

I got it to work. I ended up having to take my FinalTime and using that in my IIF statement. Thanks for your help!

I understand what you are saying conceptually, but to me this solution is an endless loop. For my Field Value, doesn't it already have to be sorted to know which record is first, which record is second, etc., then to sort it again by the second value messes up the original sorting order. Am I...