Search results

So it is no function i can use, i want this number in a calculation afterwards.

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

arnelgp Should i put the name of the form after Me. in this line? DoCmd.Close acForm, Me.Name If i don't, nothing happend when I Close the form With empty textbox. If I change it to Me.NameOfForm, then I got this error Run-time error '2498': An expression you entered is the wrong...

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...

I'm a newbie in VBA coding, it is possible to help me with the entire code. The e-mail adresses I will send to will be in the vba code.

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...

:) Input TableName: [Input] FieldName: RegDate (Date), AppBy (Text) If RegDate is is more than 31 days since today and AppBy is empty then True otherwise False Output 1 or 0 Then i will summerize the amount in a report. Hopefully this is more clearly.

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

Combobox is not what I want, could someone please tell me what to do when I use a text box?

Hi When I tried the same with a combobox instead of textbox I get what i want. 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?

Thanks a lot, but my knowledge of VBA coding stop my project :)

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?

Thanks for your advise. Do you have some examples. I'm a newbie.

It is for use in an storage database where we have x number of item with a serial number on the stock and send out some of these items. It can be over 100 serial number that is sent at once. In order to make sure all sent serial numbers disappear from the status on stock, we want to be able to...

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