Search results

Hi In a report a want to Count the amount of dates in ColumnA that is before today and ColumnB is empty. Is that possible? The output should be a number. Thanks

Hi Can someone help me with a VBA code that will check if a Textbox1 in Form1 is empty / null when you click the close button? If the specific Texbox1 is empty/null a message box with a text pop up and when you click OK you are redirected to the form. You can’t close the form if Textbox1 is...

Hi all I’m looking for a vba code that can auto generate the text in an e-mail based on cells/textbox in the form you are looking at. When you click on the e-mail button, the email will put in fixed text + [data from name of Cell1(textbox1) in table1/Form1] in subject field automatically...

Hi I have a challenge regarding that the first post in a table change contain automatically. (only one of the column in the first post. I will generate a report for a specific work order number, use a form where I can specify which WO I will generate report for. The challenge start when I...

Hi I want to Count the amount of not treated improvements after 1 month in a report. The rules will be if the improvement cell is empty one month after the date the improvement is registered, then it should be counted.

Hi All It is possible to include numbers from multiple queries in one calculation in the report? I have to calculate the amount of rows from two queries to get the percent calculated in the report. Both queries have between dates as term. Thanks

Hi Maybe i need a vba code for this. I have a form with 3 pages, the third page is only a textbox. I only want to print first and second page if the textbox in 3.page is empty. (I know that you could choose to set to only print page 1 and 2 in print setup) Can someone please help me? Thanks!

I want that a text string in a textbox is controlled by the word picked in a combination box. For example if I choose apple in the combination box the text string will be "red" in the text box (not colored red)and word pear will give "green" in the textbox and so on. Thanks

Hi When I try to present a calculated field from a Query in a form I get "#name" in cell. What I have done in the textbox in form to call up the query and calculated field is in the control source I wrote =[QLinjetotal]![Linjetotal]. Could someone please help me with this issue?

Hi I want to link a button in my access database to a excel sheet. The excel seet will show me a lot of due dates. It is poosible to link the button in access so if one due date in linked excel sheet is less than 30 days to expire the button will change color to red?

Hi Could someone please help me? I want to write in one cell a series with number or text separated by commas or semicolons like; 1234; 1342; 1543; .... ; n then this will generate a tables with all this number/text in separated rows. Thanks