Recent content by KenG

Thanks a lot, I've been searching and seem to come to the same conclusion about Hauppauge. Thanks again, Ken

Well after thinking about this for a while....I'm beginning to think that I might want to buy a TV card that will record. I've looked around a bit, and I'm becoming swamped in information about PVRs and the like. Are there any good web sites or FAQs out there? Thanks for all your help, I'm...

Thanks for the quick replies. Now I'm really confused. Do I run coax from the tuner box to this card and then run S-Video back to the TV? Or am I better off with a splitter - one to the TV, one to the PC? Thanks, Ken

I purchased a generic PC a couple of years ago with the intention of hooking up my DirecTV tuner to the video card included in the deal. Well... I've forgotten what I have and lost any information on what I bought. Here's 3 pictures of what I've got...

This applies to Access97 / Jet 3.5. In general an index will speed up a query / search of a table. However over-indexing can slow it down. Just index fields that will be used in query joins, or where clauses. One rule of thumb is to not index fields with highly duplicated data e.g. boolean...

Hope this arrives in time to help. Let me know if it works..Or if it doesn't make sense. ------- Private Sub Command2_Click() Dim dat1 As Date, dat2 As Date, i As Integer Dim rst As Recordset, Diff Set rst = CurrentDb.OpenRecordset("Table1") dat1 = Date Diff = Me.txtDate - dat1 For...

I still learning about MSGraph in Access, but this is how I got started. Use the table that has the data you want to plot to create a new chart using the chart wizard. Then you can edit the chart in MSGraph when you double click it in design view.

I think the apostrophe is creating unbalanced quotes. I don't know how to get around this problem other than creating another field (probably an autonumber field) for each record. Then use the new field as the lookup. The user can still look at the list of names with apostrophes, but the...

I'm not feeling kind, but I'll try... What exactly do you mean when you say "if the product type *IS* in the list, a further list box pops up with a list of simular products " My guess is the first list box a set of categories and the 2nd list box is products from the selected...

Try these changes; Set db = CurrentDb Set rst = db.OpenRecordset("TBL1") With rst If .RecordCount= 0 Then MsgBox ("No need to update.") Exit Sub Else .MoveLast .MoveFirst Do Until .EOF Select Case ![FIELD1]...

Thanks Sawatzky for correcting my last post. Are you first setting .Visible = False if the condition is not met? What is the default setting for the text box (if you haven't changed it, it will be set to True) If the text box is visible then the user can use it. Use the On_Current event for...

The Len() function will return the length of a string, so if the user enters nothing in the txtBox then Len(txtBox)=0 I don't know if you can make a field conditionally required at the table level. I think either a field is required or it is not. You can use IsNull() or IsEmpty() or check if...

I'm sure there are many ways to do this. I don't know what your condition to show the text box is. But if it was a simple boolean operator try this... If Condition Then Me.txtBox.Visible=True Else Me.txtBox.Visible=False End If The Forms AfterUpdate event could then be used to check...

Ooops! I found a problem with the function I sent you (remember you get what you paid for ;-) Try this function instead; Function FindAllCaps(str As String) As Boolean Dim i As Long i = 1 Do If Asc(Mid$(str, i, 1)) < 65 Or Asc(Mid$(str, i, 1)) > 90 Then FindAllCaps = False...

Try this function to look for caps (copy and paste it into a module) in your query Function FindAllCaps(str As String) As Boolean Dim i As Long i = 1 Do Until i = Len(str) If Asc(Mid$(str, i, 1)) < 65 Or Asc(Mid$(str, i, 1)) > 90 Then FindAllCaps = False Exit Function...