Search results

I'm going to create a theatre database, but I'm having trouble creating the basic relationships of the tables. We have multiple shows and I want to be able to add shows in the future. Each show has a Cast and a Crew. Each Cast/Crew list is populated from a Contacts table (names, phone #'s...

Yes, this site has been incredibly slow for me.

Make a copy of your database before trying this . . . Go into design view and change the primary key from autonumber to integer. Copy past the relevant records in and manually enter their primary key numbers. Sort the table by number. (So, the table will look like this: 1, 2, 5 1, 2, 5, 3, 4...

One of my teachers is us having graphically add vectors. I choose not to use paper/pencil/protractor, but instead to draw them in Excel. The only problem is that Excel doesn't automatically size the charts appropriately. I can set the min/max for the x/y values to be the same range, but how do I...

When I put the cursor into the Combo Box then start typing a name, it sometimes says, Run time error '2001': You canceled the previous operation. The debugger then comes up highlighting the Me.Bookmark = rs.Bookmark line: The Combo Box's AfterUpdate() Dim rs As Object Set rs =...

Ah, got it -- it was returning the maximum date that was more than 6 months ago. So, if a person had a note of 8/1/2005 1/3/2006 It was returning 8/1/2005. So I moved the test for Eff Date to the second query. SELECT [Soc Sec], Max([Eff Date]) AS [MaxOfEff Date] FROM [Note Info] GROUP BY [Soc...

Thanks, I appreciate the help. :)

People ----- Name Number Type Notes (1 to many relationship with People table, based off Number) ----- Number (lookup to People table) Note Date I need to take all people of a certain type whose newest note is more than 6 months old. Here's what I have so far (it doesn't take into account the...

As Pat put it, but make sure to wrap the code (01,02,05,07,09,10,15) field in Nz(), when doing comparisons so that you don't run into a problem if you test a record that has a Null in that spot. If you tell us what you do with tblSales (how you use it), we can tell you where to insert...

Has it seemed to anyone else that the site is getting slower? Taking longer (possibly even freezing) when posting a reply or a new message, some forums not even loading the first time, etc.? Is it me and my connection or has everyone experienced these things?

To delete a message, click [Edit] in the bottom right corner of the message, then two radio buttons will appear at the bottom of the message. Change that to "Delete Message" then click on the [Delete Message] button that appears over on the right. You posted this message several times.

I'm sorry, I'm not understanding that there. "Table1 T1" doesn't need to be "Table1 as T1"? Where does the PK and FK come from in LEFT JOIN GruntSounds GS ON GS.PK = HS.FK AND GS.Sounds in ("OOGA","BOOGA") Perhaps this will make the setup clearer: People ----- UniquePersonNumber Name Address...

The part that I'm a little lost on is the WHERE part: Table1 ----- UniquePersonNumber blah yadda GruntSounds ----- ooga booga blargh HowSpeak (1 to many relationship with Table1) ----- UniqueNumber (lookup to UniquePersonNumber field in Table1) Sounds (lookup to GruntSounds table) The part...

No, it didn't make a difference if I put that into Form_Load or Form_Current. The left bar is the bar immediately upon the subform loading, the right bar is the bar after clicking into the subform. Looking at Me.RecordSetClone.MoveFirst, it looks like it makes a clone of the recordset then...

I want to add 13 to the number displayed (well, I actually want to add 83 or so). It's for a small table and I'd like for the record number to match up with their number in our phone speed dial program.

Wrapping the field in Nz() enables it to return the value correctly -- replacing the Null in the field with whatever it is that Nz() replaces it with. I don't really understand why Null has special properties -- how are we helped by that? SELECT * FROM [aTable] WHERE Nz([aTable].[aField]) <>...

Dim junkVar as String junkVar = Nz(Me.Names_Combo_Box.ListCount) The above code sets up a combo box's slider nicely. Otherwise, the slider is really jumpy and can only slide short distances. I have a query that is the basis for a subform of a subform. The query pulls information from a main...

Is it possible to change the record numbers displayed at the bottom of a form? For instance, rather than 1-10, make it display 14-23?

SELECT * FROM [aTable] WHERE [aTable].[aField] <> 'thing' The query is returning most of the results where [aField] is not equal to 'thing'. But, it's also not returning results where [aField] IS NULL. Doesn't this mean that the query is thinking that "thing" = IS NULL?

Sometimes whatever program you're using is smart enough to read your mind and know how you "really" want to use things. If you use something in a non-standard way, though, you're apt to get non-standard results. When you do: "Mr" + " " + "Andy" + " " + "Seabrook" Access realizes that what you...