Search results

HJAMES, "Just condition the message code on the status of your check box"... I don't know the code for this and I also don't know how to get a check box on the message box. I'm fairly new with VB coding so if you know how to do this, or where I could find an example of this code for...

Thanks Charity and PCS, I really appreciate your help... Sincerely, kevin

HJAMES, Thanks for the help, that worked like a charm. I have another question regarding msgboxes that you might be able to help me with: The message box you just helped me create asks the user at the start of database if they would like to update the current US Canadian exchange rate...

Another question for this fine morning!, I wanted to use a MsgBox with the Vbyesno buttons. DOes anyone know the way to code these buttons so you can have then either (1) - Open a form with the Yes command (2) - Close the msgbox with the No command and resume function If someone could help...

Good morning all! (I know I'm pretty perky already this morning but I'm on my third cup o' the juice ) I have a question regarding currency conversions: Is there an activeX control or some other downloadable appendage to deal with currency conversion issues in Access 97'? If not, I need a...

Loki, You could do it this way, its a little more rinky-dinky, but it gets the job done: Instead of having the third field [Estimated time to complete] as the box that preforms the calculation why not use and unbound text box to do this, for example we'll call it [calcbox]. Write your...

Please Help!!! I need a little assistance from you good folks on a notinlist and autopopulate function. This is what I have so far: I have an unbound combo box which pulls up an [mcID] numbered record from a customers table. The afterupdate code is: Sub Combo51_AfterUpdate() ' Find the...

Doug, I turned of the tabstop prop. on the combo box, that doesn't keep the user from hitting tab to get out of the text box. I also can't lock the other field's for the customer data because I will need to be able to enter data in thouse when a new customer is added. My main form and subform...

Doug, I think we are getting closer... BUT, I set my form properties to allow edits? = yes. I then inserted a combo box to find a record in the table based on the [custmcID] field. Set Limit to list = yes Set autoexpand = yes I then put your code in the onnotinlist event procedure: Private...

Doug, The problem that I see in the future,(going back to the thread on 6/12, is that if I set up the notinlist function this way, how will I get the rest of the controls to autopopulate. In our previous threadd you suggested that I use a subform and set it's property with the after event...

D-Fresh, The SQL statement that you suggested before didn't work. I don't know if it was because the mc# is set to text because it has letters and numbers or not... I would have responded to you previous posts, (which I fully appreciated!) but when I returned from vacation the intern using my...

Pat, first off, thanks for the reply... Secondly, I'm not sure what you mean by two field? I thought all I would need is the custmcID field for the combo box because it is a unique value? I also don't think I am setting up the combo box properly before I even start adapting the code to fit...

(v. '97) I have read previous posts, microsoft support database, help, other examples(northwind, Orders) and I still cannot get this thing to work so I am bring it to you good people for some help, here goes: I have a form that has 2 catagories of information: 1 - customer info, 2 -...

Try this to get rid of your null values: When you can the value up to the main form use an IIF Null statement: =IIf([subform_name].[Form]![subform_control] Is Null,0,[subform_name].[Form]![subform_control] You can use this to either display the value or use it to preform further calculations...

dhoffman, Worked like a charm!!!! Thanks for your help on this matter, I really appreciate it! Sincerly, Kevin

I haven't been able to find the answer to this on my own, so I was hoping one of you good people could help me out! I have a form, [products], that lists sale items. At the bottom of the form I have 3 txt boxes that sum up the information. The first txtbox, [sale_total], calculates the...

I have a few option groups and combo boxes that store a number value for selected entires. The problem I have is that when I print out my reports I want to transfer those number values back to text. i.e.: 1 = blue 2 = red 3 = yellow etc.... Does anyone know the best way to accomplish this...

D-Fresh, I appreciate your continued assistance on this but it's still not working for me. Here's what I have now for the code: Private Sub Combo32_NotInList(NewData As String, Response As Integer) Dim MyDB As Database Dim MySQl As String Set MyDB = CurrentDb MySQl = "INSERT INTO [Customers]...

D-Fresh, This is the code I put in per your recommendation: Private Sub Combo32_NotInList(NewData As String, Response As Integer) Dim MyDB As Database Dim MySQl As String Set MyDB = CurrentDb MySQl = "INSERT TO [Customers] (CustMC #) values (" & Me("Combo32") & ")" When I saved and went back...

D-Fresh, Thanks for the reply but I still have questions: For step two you say, "where you can write your code to inster a new customer..." That would be great if I was any good at writing code. Any idea on how I can set up the code? Any help is appreciated. Thanks again, Kevin