Search results

Gemma is right. I pasted his code in there...with the exit subs and it works perfect! Thank you Gemma. Thank you SOS as well. Since this form code is so small because it is only 2 fields, I don't need anything to elaborate so I'm happy with this.

alright, ill send it over..just a min

That is not working. I left out Vendor Name list on my form and hit save and it told me "Recird saved". Then I got another access error about changes to the table were not sucessful because they woyld create duplicate values.

Can you show me the line of code so I know what IF your referring to? Original If I'm not following lol

Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.ControlType = acComboBox Then If ctrl.ListIndex = -1 Then MsgBox ctrl.Name & " cannot Be Left Empty!" Cancel = True ctrl.SetFocus Exit For...

SOS, Mic Visual Basic Run-time error '438' Object doesn't support this property or method. Once I hit debug: It has your edit in yellow.

VBA, I'm getting a compire error: Exit For not within For...Next. It is highlighting the first "Exit For" in your code. I'm a noob when it comes to coding so I'm not quite sure what that means? Here is my code: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control If...

SOS, that caused an Access Error. VBA...how would I alter my code to do this?

Hi All, Access '03. I have an input form with 2 fields that I am requiring. The first field is a combobox where I select a Vendor (which is a lookup to another table) : SELECT tblInputNewVendor.VendorNameID, tblInputNewVendor.VendorName, tblInputNewVendor.VendorFedID FROM tblInputNewVendor...

Hi All (Access 2003), I created a simple input form (frmVendorInput) with the fields 'VendorName' and 'VendorFedID'. I set up custom code to alert the user when they have entered a duplicate Fed ID: Private Sub VendorFedID_BeforeUpdate(Cancel As Integer) Dim Answer As Variant Answer =...

I will give this a try..may not have time today though. I will keep you posted and let you know if I need a "S.O.S" haha

Thank you, that one works haha. Well the tables aren't related at all...except that when I'm running this final report I want all of the information to be displayed by the month search. As I explained in the first post, given the user, they will input to a specific form to track their work...

Ok, i didn't understand your wording to the previous month thing. That criteria line is still not working for me. Would it be possible for you to send me back my database with it working since you said you accomplished that? Ok, so you see I actually have 8 forms, if I set up 8 of those...

The actual message is: This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifyting the expression by assigning parts of the expression to variables. This is my expression: Between...

Brian, That expression isn't working. Says too many arguments or something like that. I fixed the misspelling of Dashboard too. I don't want to see the last day of the previous month? Why would I? They are all seperate tables because ultimately it is just going to be a giant query with...

I need to attach my database because I don't think I'm doing this right. If anyone can help...feel free to jump in. I'm using qryMainRpt with just one of the form's fields to make sure it is displaying properly (will add the rest after that) In the criteria of this query, I added...

Brian, Thank you so far for your help. This last post has confused me. I want the users to use numbers for the date. I think your suggested me to create two text boxes with one being for the month and one being for the year? And the code you suggested is to go in the On Click of the...

Ok, I'm trying to do one form's worth of records before combining them all but I am running into trouble. Under ReqInputDate in the criteria section of this field, I put: [forms].[frmDashboard].[text25]. Text25 is on my Dashboard(menu) screen with a command button to activate the qry that is...

Hi All, Access 2003. I know this is cumbersome, but please bear with me, I’m trying to be as thorough as possible. My question will basically be how to design this search/calculation, but let me explain my set up first. I have 5 tables with 5 corresponding input forms. Each input form is...

Thank you guys, all i needed. I set it up and worked as advertised. I only asked here first because I was dealing with a linked table of about 30 fields and I didn't want to set of the database again if the memo change wasnt a solution.