Search results

One problem down, Two problems left Thanks for the replies. Qecko 1: the inputbox works, so I'm getting closer. Modest: thanks for the reply but that would not work for me, cause I use the field with the emailstrings to send emails to the group. I have a form with a listbox that allows me to...

Did I ask an impossible question? Does anyone think what I try to do is even possible in Access? Can I do it some other way?

I'm stuck again. Here's what i'm trying to do: I have a table with adresses with multiple fields (ia emailadress and a check box) I have a table with emailgroups with two fields: groupname and groupmembers. The field groupmembers is basically a string of emailadresses seperated by a...

I've figured it out now. Thanks for the tip!

Hi, I'm strugling with the following: I have an existing table with columns ResID, StID, WCID, Res, Com. StID and WCID are linked to other tables. The StID, WCID and Res columns look like this: StID WCID Res 1 1 12 1 2 12 1 3 14 1 4 15 2 1...

Thank you! Yes, that's what I was trying to achieve! Thank you for helping a very unexperienced Querier!

The table with the persons contains students that have to be evaluated on eleven tasks. The names of the tasks are in a different table that is linked to the column which has the numbers 1 through eleven. The table in which the records are created have to more columns (score and comments). When...

I have a table with names of persons. They all have a unique ID. I have a different table with a column which is linked with a one to many relationship to the unique id. I would like to be able to automatically generate the following: for every ID in the PersonsTable, I would like eleven...

Unfortunately I have been unable to convert the previous suggestion into a working solution. I'll keep trying. Meanwhile, any other suggestions are very welcome. Thanks.

Thank you. I'll see what I can do with it. I'll be back.

I'll be a bit more elaborate on what exactly I'm trying to achieve. I have a form with a subform. The subform contains two textboxes linked to a table (memo and text). The memo-textbox contains a quote. In the timer event of the subform, I've added a procedure to cycle through the records of the...

Same question Searching through the forum, this is the only post that I found asking what I was looking for. However it was never replied to. I figured I'd bring it up again. Any suggestions anyone? Thanks in advance!

I've messed around with it a bit more, and now it works! Thank you! It would have taken me days if I had had to do it all by myself.

That's a great example, but for some reason, it doesn't work in my case. Well, that is to say, it works only once. When the value is chosen the controls appear, however, when after that I chose another value, they don't disappear. I guess, the code interferes with other code on the form.

Oops, looks like I missed some replies as I was trying to figure it out. There are six controls that have to be enabled/ become visible. Maybe I should just list them all. I'll try it out and come back to you!

I'm sorry, but I'm really an amateur. Do you mean, loop through all the controls after the value in the listbox is chosen? Do you mean that looks a bit like this: Dim ctl As Control Dim strvalue As String Dim strtag As String strtag = "Enable" strvalue = "References" If Me.lstTables.Value...

I have a couple of controls on a form that I wish to hide/disable. So far no problem. However, I want them to be unhidden or enable when a certain value is chosen in a listbox on that same form. Any one any suggestions? Thanks in advance!

I've solved my problem by no longer trying to do it all with one pop up form. When one clicks the button to edit the selected records, he gets to choose between adding text to a field of the records and removing/replacing text from it. If he chooses the first option, a little form pops up with...

I was able to solve the problem with the update query for the situation where the textbox Old is blank by using the following code: DoCmd.RunSQL "UPDATE Query1 SET " & Me.Field & " = '" & Me.New & "' & '" & " & Me.Field & " ;" So one of the three options is working now, the situations where...

Thank you for the suggestion. The message boxes work fine. I have changed the code to the following: Private Sub Change_Click() If IsNull(Me.Field) Then MsgBox "Er is geen veld geselecteerd.", vbExclamation, "Example" Exit Sub End If If IsNull(Me.Old) And IsNull(Me.New)...