Search results

I need to pause this one for a while as I will need to implement something else. I guess in a few days or even few weeks I will get back to this. Greetings.

I did the join, but the next problem is, that the query slows down and then times out on the server side. Will just forget about this. and just create a query based on a report. I will click on the field in the report from the customer name and then a report will open in the main report...

Hi, I have the query like this: SELECT PERSONAL_CUSTOMER_ID, CUSTOMER_NAME FROM PERSONAL_CUSTOMER WHERE (((PERSONAL_CUSTOMER_ID)=[tbl_related_id]![PERSONAL_CUSTOMER_ID])); Greetings.

Hi, I did all the above. If I enter only one record in the criteria, it runs perfect. I get the annoying parameter box asking for a parameter. what ever I do there, it will return no data. really strange thing. Greetings.

Hi all, I try to run a query that gets the results from table. the table has only one column. in the criteria from the query I have referenced the table and the field name. But when I run the query, I don't get results. Any clue why this could be? is there a easy way to do this...

Thanks Minty :-) Greetings.

Hi Minty, It was easier than expected :-) to get the criteria from a field to the query. I tried to feed one query with another (as I found some info that you can use one query and enter it in the field name of the query...

Hi all, I have created a report that has sub reports in it. I feed each sub report from a different query. but, for now I have the criteria in those queries hard coded. I would like to know if I can pass the criteria from a field in the form and then when I press a button it will use it to...

Hi, I did, but could not open that one becouse of my internet explorere showing me a blank page with nothing. Will try firefox to see if I can get it visible. Greetings.

Hi all, I have the below code where I want to use it to update instead of insert. I wanted to update the record with a cancelation date where the event_id and participant_peoplesoft_id is equal in the table. How to change it so it will update? I tried to use the UPDATE instead INSERT INTO, but...

Hi, I changed it to this, and now it works. It was looping fine, taking the first (I had left only 4 users enrolled in the tabel to test it with having the available places to 5), when it looped the second user, the "strEventID" would be 5 and as it was less or equal, it would still take the...

Hi, I got so far with the below code. The only problem so far I see is that when there is a multiple enrolment and 1 place available, it will stop the whole thing and not enrol at least one for the training. How to solve this? Next part is the email response the user will receive if the...

Hi, It works great :-) Will play with the DLookup to see where I get :-) Happy new year :-)

Hi all, I have some code that is used to scan Outlook emails and then entering them in a database for trainings. The idea is to automate the emails received in the training team. a person would reply on the email, and when the automation runs, it pulls it to the enrolment table in the database...

Hi, I fixed it by using a form that pops up when doulble click one of the Event ID in the datasheet view. The form that opens shows all the data from the current selected record. The unbound text fields that are now in the main form, I use them to create a new event. Greetings.

hi, I actually discovered that it will not be a easy task. The subform in datasheet view is based on the table tbl_create_event. I added another subform based on the same table to the main form as this one has some fields in it, but from different table. I can't link 2 sub forms on eachother...

Hi Bob Fitz, Thanks a lot, very nice and easy :-) And I tried to solve it the hard way. Great solution I can use across different databases :-) Greetings.

Hi all, I found nice page to figure out the cascading combobox to limit the choces, but as hard as I try I can't implement it on my test database. http://www.fmsinc.com/microsoftaccess/forms/combo-boxes/cascading.html I guess there must be a simpler way to do this. in the attached test...

Hi all, I added a example database to make things easier. Greetings.

Hi all, I have main form where I have a subform in datasheet view. The datasheet is on top and below in the main form I have a set of unbound text boxes that I use to create an email. What I need now is to use the datasheet that displays events created earlier to pass them to the the unbound...