Search results

Hi smig, i needed exactly what you asked here in your post, so thanks for posting:) I wanted to ask whether you found an answer for the parantheses problem Thanks

Thanks for all your answers, but i hurry to inform you that my problem is solved. The problem was that i'm a ***.. :) I totally forgot that "assignType" is a text field... although the error message was a bit odd. As soon as i put ' ' around numbers of assignType, it worked fine

Thanks for your reply James, Me. i tried that, doesn't change anything I don't think that the code is the problem, since it works fine when it's on the main form.. but i tried it anyway, here's the beginning: Select Case FrameFilterAssignTypes Case 1: Filter = "assignType in (1,2,3)" FilterOn =...

Ok, i have yet another question... I have a main form, frmEvent, and a subform inside it, frmAssignments. On the subform i have an option group, which is supposed to filter the assignments by type. Here's the code: Private Sub FrameFilterAssignTypes_AfterUpdate() globFilt = "assignType in "...

correction, allows

All the "alows" are set to Yes The bound control in the combobox was set to 0, but when i changed to 1 it didn't help either. Any more suggestions?... :(

Hi, thank you for your reply Actually i had this column unbound, cause when i make it bound (Control Source = forumNum) it becomes "locked", the list drops down but doesn't allow me to pick anything. So i can't even run debug and check the code. Do you have any idea why the combobox becomes...

Hello I have a combobox with Forum names in it. When user selects a forum from the list, i need to determine which one is it, go to tblForums (or form) and pull out the content of the field "forumParticipants" (of course, participants of the forum that was selected by user). The problem is i...

Hi Simon, i entered "Cancel = True" inside the code, right after the MsgBox, and then tried the "eventDueDate = "" ", but still the same error pops up.. or maybe you meant something else?

It looks like this: Private Sub eventDueDate_BeforeUpdate(Cancel As Integer) If Weekday(eventDueDate.Value, vbSunday) = 6 Or Weekday(eventDueDate.Value, vbSunday) = 7 Then MsgBox "You chose friday/saturday, plz choose another date" Me.eventDueDate = "" - it doesn't...

Hi, I'm checking whether the date entered on my form is friday or saturday, and if it is, a message pops out. But in addition to that, i want this field to empty, so the user can enter a correct date (that would be a working day). I tried all these: eventDueDate/eventDueDate.Value = ""...

Before you answer.. i think i got it working! I'm really happy, thank you so much! But if anything else pops up, as it always does, hope you will be able to help:) Honestly you are the only one who took the time to answer, and i asked on several forums.

And of course, i want it to return only the ones that i want to send mail to, and not all of them.

Good morning After replacement of my rs by yours (Set rs = Me.RecordsetClone), here's what's happening: i'm in event that has 4 assignments, ticking the 2 middle ones assignSend. The loop goes over all the 4, and ticks the assignIsSent, so when it's is done they're all sent, allegedly. When i...

First of all, thank you for staying with me this far But i'm pretty new to this, so i'm afraid i need direct instructions.. :( Like you did the first time, amending my code Did you mean i should replace my rs (Select ".......") with set rs = Me.RecordsetClone? I tried that and it doesn't throw...

I tried your code and it gave me the following error: Runtime error 3027, Cannot update. Database or object is read only. I stumbled upon this mistake before, when i was trying to update my recordset. Is there a way to make it updatable and maybe this will solve my problem?.. workerNum is an...

Yeah, but i have no idea how to execute it.. Maybe you could take a glimpse on my code and suggest the needed change? In bold is the problematic stuff. I realize that these variables aren't attached to anything, so it can't possibly work.. .... Dim rs As DAO.Recordset Set rs =...

What i have is this: main form (frmEvent, single form), which has several assignments in a subform (frmAssignments, continuous forms). One of controls in the subform is checkbox "assignSend". Assume i have 3 assignments for a certain event, and i want to send mail regarding the third one, so i...

Yes, the form is continuous

On a form with few lines, where each line has a checkbox (the same one, with one name), when i check the checkbox, how can i make the code understand that this checkbox belongs to a specific line? Because as it is now, if for example i check the third line's checkbox the code just takes the...