Search results

it should be according to the conditions you describe. =IIf(IsNull([Due Date])<(Date()) Or IsNull([Completed Date]);"Overdue";"")

Access allows you to draw Line and Rectangle objects only. If you want to decorate your form with different shapes, save your drawing in advanced picture editors. Then, introduce this image to the picture feature of the form.

What do you call real values? I don `t get it.

Yes no need it. It can be stored in a variable. But when you enter the Criterion, you must add the appropriate marks. You know that the data type is important when determining the criteria, String, The spelling of the Number and Date fields are separate from each other. Remember. I gave the...

I think you should transfer the criteria to the variables. Dim a,b a = Year([TenderDate) * 12 + DatePart("m"; [TenderDate]) b = Year(Date()) * 12 + DatePart("m"; Date()) -1) txtTotal = DSum ("TotalSum";"tblTender";"a = '" & b & "'")

"m" 'm' which one is right ?

Hi In subformed forms, the fields that link subdomains and upper domains must have the same data type. Why do you need to convert the subform to the text field. In this way, working in the database reduces efficiency. I think it's not a good idea to convert it to text. If you still insist on...

You must first create a query that takes the sum. You should then include this query in another query that contains all the fields. SELECT Sum([Query Office].RunningTotal) AS ToRunningTotal FROM [Query Office]; SELECT [Query Office].Event, [Query Office].Invoice_Date, [Query...

Give the default value as a date, not as now, If you also want to keep the time information open the time field and assign it the default value as time.

Hello I think if you normally see the printer in Excel and Word, if you can't see Access and see the printer in all other applications, you need to uninstall Office 2010 and do it again.

You can take advantage of ms access EMailDatabaseObject macro. You can set all parameters in this window.

So how does your other office programs open? For example Excel, Word, Powerpoint, Publisher.

Take advantage of the round function. Add a field to the query design window and use the expression below. Test: Round([field])

What was the result? Were you able to fix it?

The problem with no report name is caused by this, specify the report name and try again.

Sample Data: ZS-RPB(30551)Sliding door handle mechani Sample Data: ZS-RPB (30551)Sliding door handle mechani Have you analyzed the problem thoroughly? I said the 9th character since I saw an extra space in front of the document number. It's true what you say. It will start from the 8th...

Guys, there is no need to write such long things that the problem is obvious and the problem is solved very well with the code I suggest. It ends with just one line. No need to use anything other than MID function. But I assume the length is the same until the 9th character.

What are the consequences? What error do you get

There is a value in the Logged_IN field when you open the form, right? DoCmd.OpenForm "AuditClicksUsers", acFormDS, , "User = '" & Logged_In & "'", acFormEdit

look here. ComboBox Problem