Search results

Hello, I need to make a query, which will use one table. This table has a field called "participatedHow", which stands for how did worker participate in a certain event (1 = present, 2 = via telephone, 3 = ..., 4 = ...). The problem is that this field is represented by numbers 1 to 4, but there...

Hello, i'm lost. The boss wants to be able to write text and design it as he wishes (bold/colors/different fonts/different sizes/etc). I handled that as follows, every time he wants to write text i create a word document, it's saved and can be viewed at anytime. The problem is, i later have to...

Hi, I have a mainform, and a subform in it. The main form contains current event details. The subform has ListBox control which contains assignments of that event. To add a new assignment, you click on button and another form opens. The thing is, if the listbox already contains some assignments...

Hello, i have a multicolumn listbox, and all the fields in the row source are from one table, but one of them is "assignType', a numeric field. It can be 1, 2 or 3. The thing is, i need the listbox to display text based on this numeric value, i.e. 1=assignment, 2=decision, 3=text. In other...

Hello I have a form (which is a subform) called frmAssignments. In the Form Header there's the "main" listbox, which contains assignments. Each assignment can have a subassignment, so when i click on one that has, another listbox opens (it was defined invisible before the click). In the same...

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

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, 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 = ""...

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

I'm trying to fill up a recordset with the following values: Set rs = CurrentDb.OpenRecordset ("SELECT assignInCharge, workerEmail from tblAssignments, tblWorkers WHERE assignInCharge = workerNum and assignSend = -1 and assignIsSent = 0 and assignNum = " & strAssignNum) I checked with "If...