Search results

Hi Minty, The query is based on a few tables and in one of the tables there is the checkbox for the attendance. Maybe I missed something. Greetings.

Hi all, I have a form with a subform in it that gets feed by a query. I have in the subform as datasheet view the participants for a training (connected with the event_id). I use it as well to send email to all the participants. I created a new functionality that will check if the participant...

Hi all, I created a macro to import from excel file into a table. It works great, but only till the point of having the excel cell with a lot of text and not getting it correct into the table. It seems the command to import from excel is from access 2000 and it was never updated after that. The...

Hi all, I have a form that is built from a table that contains multiple questions. each question is a field. I would like to count or sum up how many questions with a "yes" where filled in and have this show up in a textbox in the form. I have now in the form question_1 till question_11 and...

Hi, I made it work :-) Greetings.

OK, I got it working :-) Thanks a lot. Greetings.

hi, I will try this one out, I missed it maybe because I was only having the last part in the line: Me.cmb_status.Column(1)) Greetings.

Hi, I solved it like this: Function whatDay() Dim getDate As Date, getBusDays As Integer, NumberThis As String Dim Busy As String getDate = Date NumberThis = Me.cmb_status.Column(0) Select Case NumberThis Case "status 1" Busy = 1 Case "status 2"...

hi, I'm at home now, I will post what I did tomorrow morning. Greetings.

I managed to solve it with a Select Case statement. I need to hard code it, but it works nice. Greetings.

Hi, Did you have a look at it? Greetings.

Hi Minty, I made it more or less work, but the days are not fine. The message box gives me a different date then the outcome in the date field for the next action date. I believe it is a mess in the code. Can you please have a look at the attached example database and let me know where I went...

Hi all, I found a function to put a next action date into a date field. If in the combobox a status was changed to for example "on client side), then it will know that it has to count 60 days, but not counting the weekends. The combobox is in a form called "frm_main_hrr" called cmb_status. for...

Hi Ranman256, I did actually import the excel file into a table, then run the append query with the concat and that gets into the main table. works really nice :-) Greetings.

Hi all, I'm trying to import an excel file that has some columns that I need to concatenate into one field in the access database. How could this be done. I know I could do it before hand in excel and them import it to access, but if this can be avoid, would be really great. Greetings.

Hi all, I started to create a report where I have multiple queries counting the rows with data. Then the main report will have multiple subreports in it. I was wondering if it was possible to have like 20 tables inside 1 query and each one of the table is one column counted in the query as...

HI, Is it possible to create the email with the amount of participants according the amount of places available? If I have 12 spaces available for a training, clicking on the button it will create 12 lines instead of the now 6 lines: "<TD>Participant 1:</TD><TD id='p1' >enter...

Attached the test database. Greetings.

Hi Ranman256, I actually meen the access report. I'm rebuilding the excel report in Access as a report. I will prepare a small test version and post it. Greetings.

Hi all, I'm trying to get a report embedded inside an email. I have current a report build with excel that I can copy paste inside the email or even automate it to create email and have the selection inside the email of the report. I created now a report based on the current excel file...