• WSNight

    WSNight

    @wsnight

    Viewing 15 replies - 46 through 60 (of 169 total)
    Author
    Replies
    • in reply to: Web Hosting and Domain Registering #835577

      you’re telling me they selling it at 5 bucks a month? you’re right it does sound to good to be true. I will definately check that place out as well. Thanks a lot for the info. cheers

    • in reply to: Web Hosting and Domain Registering #835578

      you’re telling me they selling it at 5 bucks a month? you’re right it does sound to good to be true. I will definately check that place out as well. Thanks a lot for the info. cheers

    • in reply to: Web Hosting and Domain Registering #835397

      Thanks Mark. I will check them out a little later today. I appreciate the suggestion. Any other suggestions are still welcome. Just doing a little research before I make the move. I do want to change hosts for sure though. Thanks.

    • in reply to: Web Hosting and Domain Registering #835398

      Thanks Mark. I will check them out a little later today. I appreciate the suggestion. Any other suggestions are still welcome. Just doing a little research before I make the move. I do want to change hosts for sure though. Thanks.

    • in reply to: P2P software? #638606

      Thanks. I am also not a big mac person but it is for my mom’s computer at her work. So I am just looking around for her. Thanks again.

    • in reply to: two column combo box (A2K) #605171

      I understand that Charlotte. I thank you. But this is how they wanted it. They never do seem to listen to my advice. Either way though it’s done so I don’t have to mess with that DB again.

    • in reply to: two column combo box (A2K) #605042

      well the reason is this. The way reocrd management works here there is a number corosponding with every Record Series Name. There could be multiple numbers for the same Series name because it could be a different department that has that name as well. So I needed to put the numbers by the name so people would know. Now, I needed the second column to be stored as well because if it wasn’t then I wouldn’t be able to pull a report by the number which some people very well may likely do. That is why I did what I did.

    • in reply to: two column combo box (A2K) #604984

      yeah I knew I was retarded. For some reason more complex things I can figure out, but the most simple of concepts I have trouble with. Ah well it works now. Thanks.

    • in reply to: Populating form from search. (A2K) #604000

      here is my code for the selection.

      Private Sub BySearchType_AfterUpdate()
      Display_Click
      End Sub

      Private Sub Display_Click()
      On Error GoTo OK_Click_Err
      If IsNull(Me.OpenArgs) Then
      MsgBox “You Cannot Display Records in the Definition Mode”, 16, “Definition Mode”
      Exit Sub
      End If
      If IsNull(Me![BySearchType]) Then
      Response = MsgBox(“You Did Not Select a Record to Search For”, 32, “No Record Selected”)
      Exit Sub
      Else
      ‘First Update the Definition Table with the Last Option Chosen
      Dim CurDB As Database, SQLStmt As String, GetData As Recordset
      Set CurDB = CurrentDb()
      SQLStmt = “SELECT * FROM ezs_SmartSearchDefinition WHERE SearchID = ” & Chr(34) & DefEntry & Chr(34) & ” and Sequence = 1″
      Set GetData = CurDB.OpenRecordset(SQLStmt, DB_OPEN_DYNASET)
      If Not GetData.EOF Then
      GetData.Edit
      GetData!LastSelectedOption = Me![TypeofSearch]
      GetData.Update
      GetData.Close
      End If
      Dim Criteria As String ‘ This is the argument to the FindFirst method
      Set GetData = forms(CallingForm).RecordsetClone
      ‘Build the criteria.
      Select Case KeyDataType
      Case “Number”
      Criteria = “[” & KeyField & “]=” & Me![BySearchType]
      Case “String”
      Criteria = “[” & KeyField & “]='” & Me![BySearchType] & “‘”
      Case “Date”
      Criteria = “[” & KeyField & “]=#” & Me![BySearchType] & “#”
      End Select
      ‘Perform the search.
      GetData.FindFirst Criteria
      If Not GetData.NoMatch Then
      ‘Synchronize the form’s record to the dynaset’s record.
      forms(CallingForm).Bookmark = GetData.Bookmark
      End If
      GetData.Close
      ‘Return to Me![CallingForm] and Close the EZ Search Manager
      DoCmd.SelectObject A_FORM, CallingForm
      DoCmd.Close A_FORM, “ezs_SmartSearch”
      End If
      Exit Sub
      OK_Click_Err:
      MsgBox “Invalid Search was Found”, vbCritical, “Invalid Search”
      Exit Sub

      End Sub

      Hope this helps at all.

    • in reply to: Populating form from search. (A2K) #603923

      Well here is what I have. On the Access Bible CD there is an easy search that was created by database creations. I basically built this same type of search function. The search is on it’s own form. I have a form where I enter in data, so on and so forth. On that I have a button that brings up the search form. Now I can click on the Radio button depedening on what I want to search by (Publication, Title, Date) whatever. In a combo box below all the things matching what was selected above show up. When I click on one of the different choices that are provided it SHOULD populate my form. For some reason though it is not. That is the only problem I am having. Once I figure this out, I am done with my database. Thanks for the help.

    • in reply to: Enter Parameter Value (A2K) #603520

      It must be in my SQL statement then. I will go check it out. Thank you much.

    • in reply to: Voodoo back? #602182

      Just curious as to what was edited in my post. Doesn’t look any different that before. confused

    • in reply to: Voodoo back? #601948

      Edited by WyllyWylly on 18-Jul-02 11:02.

      Oh I’ve found the geforce4 for a resonable price already. But as I stated I am going to wait because for all i know they’ll Release another card by the time I start to do the building. Right now I’m just working on my case and such so I still have a month or so before I start putting it together.

    • in reply to: Voodoo back? #601942

      I don’t know though. That card seems to do rather well when stacked up against the gf4. But I haven’t decided yet. The video card will be the last thing I buy because there may be another set of cards out by the time I am ready to build.

    • in reply to: Automation (A2K) #600847

      Alright, I managed to talk my manager out of storing this data into another table. So now all I need to do is pull it into my retention box based on whats selected in the Combo box. They are related in the same table this is the DLookUp what I have now. Thanks for the help

      =DLookUp(“[RetentionField]”,”tblRecordMgmt”,”[RecSerNameField] = ” & chr(34) & [RecSerName] & chr(34))

    Viewing 15 replies - 46 through 60 (of 169 total)