Search results

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

I don't think I can. I'm just trying to find the total between the two dates. The information is coming from a query which uses a table called tblJournalEntries. The banking details changed on January 1, 2020 so rather than doing a new db I added the date criteria >2019-12-31. I wonder if...

I realised I made an error by referencing the wrong query. I have corrected that and now instead of no result I am getting #Error. Below is the formula with the correct query name. =DSum("[Amount]","qryAccountLedger2","[TransactionDate] > #2019-12-31# and [TransactionDate]<#" &...

Hi, The result is still blank :(

Good morning, I am trying to sum the amount after December 31, 2019 and a date selected on a form. I am not getting an error message, the result is just blank. =DSum("[Amount]","qryStatement2","[TransactionDate] > #31-12-19# and [TransactionDate]<#" & [txtLastStatement] & "# AND...

Yes...I had to go back and add the apostrophe. Don't know why it worked either but it did 🤷‍♀️

Success. I did the following on the Before Update event and it worked! Private Sub Form_BeforeUpdate(Cancel As Integer) this is a dummy procedure as a test End Sub As always...thanks for everyones help :)

I really wish I could but unfortunately I can't upload the database as it has been in use for 3 years and has some sensitive info in it.

I already have an event in the On Load on my main form :(

Good Morning, I changed an existing form to a tabbed form so I could add a second subform. This is causing an error when I first open the form which says "The expression On Current you entered as the event property setting produced the following error: Return without GoSub". The only On...

Thank you! That worked perfectly!

Good morning, I am using Dmax to create a unique sequential numbering in a form. I would like the first entry to start at 1, however it keeps starting at 0. I tried changing the default value in the table design to 1, but it keeps going back to zero. I put the below code in the forms Before...