Search results

3 separate rules may be the way to go. Here is the screen shot anyway. Along the bottom middle the box with the "4" is the txt_Percent, the box with the "-7" is the txt_NPercent and the box with the "5000" is the txt_Dollar.

I need conditional formatting to take 3 arguments: 1 - Greater than or equal to 5 - form control txt_Percent 2 - Less than or equal to -5 - form control - txt_NPercent 3 - Greater than 5000 - form control - txt_Dollar Here is what I have so far: ([txt_PC_Due]>=[txt_Percent] Or...

This worked, Thank you!

Here is what I am trying to do, I need to meet three conditions. If txt_1 is above 5 OR less than -5 AND txt_2 is greater than 5000. Not sure how to go about this. Here is what I have so far. Any help or guidance is appreciated, =IIf([txt_1]>="5",IIf([txt_1]<="-5" And...

That seems to do it, however, probably unrelated, but I now see a "#Size!" error? Any additional advice?

I have an error that I can use some help on: I have an unbound textbox that performs a dlookup. The formula looks like this: =Replace(Nz(DLookUp("tblInvoiceLog.NOTES","tblInvoiceLog","[VOUCHER_NUMBER]= " & [txtADJ_POLICY] & ""),""),Chr(13) & Chr(10)," ") This works fine until there is no...

Thank you all, So the "ITotal" and the "[Reports]![RPT: ON_SCREEN_REPORT_2019]![txtMajor_2017]" was all placeholder data. I was trying to get the actual function to work, then change the pieces to be dynamic based on which report it needed to be on. I will try the suggestions, and report...

I know what yo mean by the detail section, but from the looks of it, I don't see which event would apply?

Good afternoon all, Here is what I am trying to accomplish I have a group of controls (unbound calculated text boxes and labels) on a report that I only want to be visible if there are values in the calculation. For example: When I open the Accounting report, I only want to make fields...

Good thought, tried (this is a very small DB with 4 tables and 4 forms). Compacted and Repaired, tables relinked!??? :banghead:

There are no relationships to delete, and I have tried recreating the tables and importing the forms, with no luck. The tables continue to establish a link to the original data

How do you do that? There is no relation between the 2 databases? Thanks,

I have 4 tables in a database that started life out a linked tables. I want to convert those to local tables. And have done so by using the "Convert to Local Tables" option in MS Access 2016. In addition, I have exported all the data out of the the database into an excel file, deleted and...

Ranman256 & plog, Both of you raise good questions. There are instances where duplicates are acceptable, for example if we are paying an invoice with no invoice number, say like a telecommunications invoice where they use an account number. So ruling out duplicates all together is not an...

I have a data entry form that takes numerous pieces of information. Mainly up to 5 invoice numbers (in 5 separate bound text boxes). In the after update of each text boxes I have this piece of code running: Private Sub Invoice_1_AfterUpdate() If Me.Invoice_1 <> "" Then If...

NauticalGent, I do, Thank you for all your help!! I am going to expand on this on Monday. This code started as basic, but is really starting to take shape! Thanks again, have a great weekend!

After I posted, I edited the code a little. I was trying to account for the point that mark made about inconsistent indentation, and the error handling. Here is what I have: Private Sub Command28_Click()...

It definitely does get the job done, My concern is I do not have any error handling, I'm sure I am leaving myself open to some potential error. No checking for illegal characters perhaps??

Good morning all, I have a command button on a form that will create a new subfolder within each folder in a specified directory. This code runs fine, but I would like any input if this is the best way to do this, or if I am missing something crucial. Here is what I have for code: Private...

Mark, Thank you so much for your time on this Very educational, and helpful!!