Search results for query: *

Exactly what I needed. Thanks much.

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...

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

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.

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

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...

Worked great. Thanks, luceze.

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...