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...
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 & "', '"...
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...
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...
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...
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.
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...
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...
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...
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...
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
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.")...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.