Search results

Hi all, I attached a test database. It will be easier to explain this way. The database we use, is like a helping database. There is the big brother where all data is stored and updated.There all the status changes are captured with time stamp. The helping database is just to have everything in...

Hi Bob Fitz, I will check this as soon as I have the chance. Greetings.

hi, still no solution for this, looks so strange and I can't figure it out. Greetings.

Hi Ranman256, It is telling me that it is missing a closing parenthesis, bracket or vertical bar. I tried all possible things, but can't find the mistake there. Greetings.

Hi all, I have a function that check how many days passed since a request was started. It will stop whe the finalized date is entered. Now I need to make a change that when a new status is set, it should stop counting the days passed and only start counting days passed when another status is...

Hi all, JHB's tip did the trick :-) Thanks a lot all of you for your great help in this great forum :-) Greetings.

Hi all, I have query that has a column to calculate days passed. If I want to filter the column to show the number by order, all I will see that it starts with 1 and then it skips 2 to start with 10. How can I filter it to show correct? As this is not a real column in the table, it looks like...

Hi MarkK, It is very complicated with the IE as it has this silly thing that you can't avoid those messages boxes. will try your tip and see how far I get. If I manage to solve this, I will share it so others can make use of it too. Greetings.

Hi MarkK, I want to print out to xps the webpage. The first macro in access vba will loop trough a table where I put some names I want t check in google. for each name, the code goes to the first page of google, then it should print it out to xps file, then goes to second page in google and...

Hi MarkK, I wanted to print out the website with the xps printer giving it a file name and the folder where it should go. I can print out a excel sheet range, but the website is like impossible. In my below code example, I can print a range from excel: Private Sub Export_to_XPS_Click()...

Hi MarkK, I managed to find out about the printer, but the code I used in Excel is not compatible with Access and I cant re-use it all. I used the below code to go to goople page and print the website. The only thing is that I have to imput the folder name and the file name for each one. I...

Hi all, I wanted to re-use some code that I have from Excel to print out a website to .xps with vba. the below part of the code will use the xps printer. it uses in excel the value of a cell to create the file name. in the access database i should use the field "LE_Name"...

Hi all, I managed to solve it and now it is working fine :-) Private Sub btn_create_word_check_list_Click() Dim objWord As Word.Application Dim doc As Word.Document Dim WordHeaderFooter As HeaderFooter Dim objDoc Dim objRange As Word.Range Dim objTable As Word.Table...

Hi, Made some progress. I made some changes, added a bookmark and then at the bookmark it inserts the table. '==================================================== ' Add the table after the above text '==================================================== sel.EndOf wdStory, wdMove 'Move...

Hi, I just don't get the code working for adding the table below the first text. It is just replacing the text with the table What is working is the adding text after the table. I guess I go somewhere wrong after the text just before the table gets inserted somehow I need to pass the place...

Hi, Thanks a lot for the code, I will be going through this right now and see if I can manage. Once I fix it, I will post back :-) Greetings.

Hi all, I managed to create some code today that will create a word document, add some text from and a table with text in it. I can create the word doc with text, and I can create the word doc with the table. What I'm not able, is to combine them both so I will get the first part with text...

missinglinq, you are my hero :-) thanks a lot for this, it is really great to have help when one loses his way :-) Greetings.

well, conditional formating is not possible as it is set as form and not as datasheet (continuous form) :-( I guess I need something like: if review_id current selected and that field has date, then grey out. Greetings.

Hi all, I should have been more clear :-( The fields and buttons are on a subform that has about 20 fields and 10 buttons. it is not set as a continuous form. the fields on the subform come from another table that is linked with the review_id on review_id on the main table. Maybe this could be...