Search results

no its not in the form when i close it as it won't let me go onto the next field unless i select something from the list.

my combo box is part of a large table but there is not a table for the combo box. i used a value list and i entered the values in myself.

can anyone help me to complete this problem. in case i haven't made myself clear. i am trying to add a value to a combo box if it is not on the list. i have used the code above and the value is being added to the table but not to the combo box. if i press add the list just pops back up and i...

please try. i'm so stuck and i dont know what to do

can anyone help me?

no it isn't working. when i press add the list just pops back up and i cant move on. the values are being added to the table though so its just the combo box. where abouts in the code would i add that line and would it be word for word what you typed?

no it isn't working. when i press add the list just pops back up and i cant move on. i dont really know what you mean about it being added to the table.

ok i am no longer getting the error but when i press ok to add the value to the list nothing happens. the code i am using is: Private Sub Department_NotInList(NewData As String, Response As Integer) If MsgBox("Value is not in list. Add it?", vbOKCancel) = vbOK Then Set rec =...

and also how do i stop error messages rather than ignoring them like you said. sorry i am quite new to access and i just can't seem to get my head around these codes.

how do i find the error number to replace it with. when i press ok to enter a new value to the list a box pops up that says error 2237. i don't really know what to do from there. can you help?

Please help me! i know that i am very close to solving this problem and it is all thanks to this website. you have all been very good and patient with me and i really appreciate it. i think that once i solve this i will have what i want so if any of you have an idea what to do please let me...

ok i know i must be really thick but i cannot find the label. do i do what you said in the subreport or in the report that contains the two subreports? [This message has been edited by janed (edited 03-19-2002).]

how do i do this? where can i delete a label?

i have a code that bypasses a microsoft error but now it shows a message box with the error number in it. is there any way to hide this box? my code is# MsgBox DataErr 'Use this to detect which error number to block. If DataErr = 2237 Then 'If gives some stupid error message number 2237...

i am not sure how to hide the message box that tells you the error number. could you help?

xweyer hi! sorry to bother you but i see you're online at the moment and i was wondering if you could help me with my combo box question. please!!

i wrote a question there about ten minutes ago asking bout adding entries to combo boxes and i was wondering if anyone can help me. i really need it.

a few weeks ago i asked if anyone knew how to add an item that wasn't on the list of a combo box to be added to the list. simon c wrote back and gave me a basic code that worked. however, if i enter an item that is not on the list it asks me do i want to add it, which is exactly what i do want...

thanks a million. ok. i think i do have it set up as an and query. however if these are two different fields how do i know which field to put the criteria into?

yes you can. first of all you make a unbinded report, ie, not attached to any query or table. within that report you put two sub reports and each subreport is linked to what ever you want. however, in the end it will be shown as one report.