Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rsch
  • Order by date
  1. rsch

    Datasheet Validation - Add/ Edit records

    Exactly what I needed. Thanks much.
  2. rsch

    Datasheet Validation - Add/ Edit records

    I have built a datasheet subform that holds user login information. I added validation to ensure that a user cannot be entered twice (code follows). My problem is that now I can't seem to edit the records because of my validation code. Any thoughts on how I can do this? Private Sub...
  3. rsch

    INSERT Query - number fields

    mndrlion - That is perfect! I added the additional text fields into my query. For reference (anyone following this thread), here is my final result: strSQL = "INSERT INTO ClientFirm (ClientFirm, Address1, Address2, City, State, Zip)" & _ " VALUES('" & Me.cboClientFirm.Value & "', '"...
  4. rsch

    INSERT Query - number fields

    mndrlion - Thanks for the quick follow-up. I do have all the fields' Required value set to "No". In my query, I am pulling from form values to populate the table. One of my number fields is Zip. So, if I were just trying to save this one value, my query would be: strSQL = "INSERT INTO...
  5. rsch

    INSERT Query - number fields

    I have written an INSERT query that will let me save a new record from an unbound form to a table. My issue is that I have two number fields and the INSERT query will not work if they are empty. I have allowed for Zero Length on my text fields, but there doesn't seem to be such an option for...
  6. rsch

    Windows File Open

    PHV - Thanks for the update. Let me ask one more question. I am trying to create a browse button that will allow users to open a Windows browse box to locate images. These images will then be stored in a text field. Upon saving the record, the file in the text field will be associated with...
  7. rsch

    Windows File Open

    Disregard previous post. I solved it. Thanks for the help, Krystoff
  8. rsch

    Windows File Open

    I am trying to create a similar command button, but have not been as successul as Crystalguru. In my inexperience with Access, I cannot see how to create the Macro that Krystoff recommends. Any thoughts would be much appreciated.
  9. rsch

    DELETE from 2 tables

    Great catch, BNPMike. All of my tables have referential integrity, but I forgot to add the Cascade features.
  10. rsch

    DELETE from 2 tables

    I have created a 'Super User' form that allows supervisors to add/remove/edit data. The form has a Tab subform associated with it. On tab 1 (Company), there are 2 list boxes - one for companies and one for the companies' staff. What I would like to do is create a DELETE function that allows a...
  11. rsch

    Build Data Entry Review Report

    Worked great. Thanks, luceze.
  12. rsch

    Save button problem

    I have a slight variation on this issue. As suggested above, I am using DoCmd.GoToRecord , , acNewRec, but it never goes to a 'new record'. Couple of items to note: 1. Using a data entry form - can I even go to a new form? 2. When users click the Save button, three SQL queries run in the...
  13. rsch

    Build Data Entry Review Report

    I am trying to determine the best way for a user to review the entry inputted in a data entry form. I figured a dynamically generated report would be the easiest way for the user to review all their information. Question 1: Is this the best way for the user to review? Question 2: If so, how...
  14. rsch

    find duplicate record before posting

    While my posting to LMRollins is quite outdated, I wanted to give my solution in case anyone is interested. I want to thank thornmastr for his excellent post! I solved the error message by adding Current to the line, so it reads: Set rs = CurrentDb.OpenRecordset(strSQL, dbOpenSnapshot). Hope...
  15. rsch

    If Statement; depending on value turn off other functions

    Wonderful. Thank you! Exactly what I needed. In case anyone is interested, I modified my code slightly. Here if the final version: If KeyAscii >= 48 And KeyAscii <= 57 Then MsgBox ("A Ticker cannot contain numbers.") DoCmd.CancelEvent Me.txtTicker.Value = Null End If End Sub
  16. rsch

    If Statement; depending on value turn off other functions

    I have an IF statement that validates that only text is in a text box. For reference, here is the code: Private Sub txtTicker_KeyPress(KeyAscii As Integer) If KeyAscii >= 48 And KeyAscii <= 57 Then MsgBox ("You entered " & "'" & txtTicker & "'" & ". A Ticker cannot contain numbers.")...
  17. rsch

    One form two tables to populate...... How do I????

    KenReay - First, congratulations on being TipMaster of the week. A well-deserved honor. Second, my issue. I have a form (bound to a query) that is for data entry. When completed, it needs to update data to two tables (both with less than 255 fields). I can populate the first table because...
  18. rsch

    pop up Calendar and subform

    adamroof - Followed this thread and was successful in implementing a calendar - thanks! But, as you suggested in your thread, "Sometimes...you cant click on today". I have tried your fixes, but still can't get it to work. Since I am using the calendar in a data entry form (new records...

Part and Inventory Search

Back
Top