Search results

I am experiencing some issues with my database and I'm not sure if it's the database or the Access program. One day a combo box or button will work and the next day they won't. Today I updated some customer information and when I went to print the report a field that previously had information...

Yes thank you. Please delete.

I'm going to delete the DB from the forum. I really appreciate everyone's help on this.

Yes! That's what I need to highlight! So it's the order of the expression - [PreInstallationInspectionDate] Is Null As always, thank you so much for your help 😃

That didn't work either :(

Thanks. I couldn't find a shorter description for that field. I will try your suggestion.

I am not familiar with this one. Would I type Len([PreInstallationInspectionDate])>0?

If you use Nz() in your expression, what happens? Not getting the conditional formatting to work with the Nz or with the suggestion of Nz(Dlookup(...),"")

It is a Date/Time field with no default value

Hi, I have a report which is based on a query that includes the following expression named "PreInstallationInspectionDate" (I know it's a long name) DLookUp("[PreInspectionDate]","tblWorkOrder","CandidateID=" & [CandidateID]) In the report, I would like the PreInstallationInspectionDate field...

Thank you for your suggestions. I actually just found the solution myself in the property sheet - I just changed the Separator Characters from "system separator" which by default is a comma, to "New Line" :)

Hi, I have created a form which includes a multi-selection combo box. Is it possible to show each selection on a different line in the field of the report as opposed to separated by a comma?

I misread your answer and tried filtering the form which is why it didn't work. When I filtered the report it worked. Thank you

Hi. I tried filtering but it still saved all the records to one PDF

Hello, I need help with the below code. I am trying to name and save to PDF my Invoices without having to manually name them. The problem with the code is that it is saving ALL the invoices as one document when only need the current record/invoice saved. Here is the code: Dim FileName As...

Thank you! I tweaked it a bit and it is working. Below is how I amended it IIf(Weekday(([ServicePeriod]*30)+[ServiceDate])=1, ([ServicePeriod]*30)+[ServiceDate]+1, IIf(Weekday(([ServicePeriod]*30)+[ServiceDate])=7, ([ServicePeriod]*30)+[ServiceDate]+2, ([ServicePeriod]*30)+[ServiceDate]))...

Hi. I didn't use VBA. It is such a simple DB I actually added a calculated field to the table. The formula is as below ([ServicePeriod]*30)+[ServiceDate] The form is working as it should; the only problem being that a couple of the next service dates are falling on weekends and need to be...

Hello. I am creating an equipment maintenance schedule. I would input the date the equipment was last serviced and then input the suggested maintenance period in months e.g. 3, 6 or 12 months. I have added a simple formula that returns the next service date based on the maintenance period...

That is a date chosen on a form. The Dsum formula is then to find the total of [Account] after December 31, 2019 and [txtLastStatement]. Once the info is input in the form, there is a button which would then open the report.

That didn't work...back to blank result