Recent content by here4real

That didn't work. I put on load of the first form in the DB "docmd.ShowToolbar "ribbon", acToolbarNo" Then in Report Open (not Load), I put acToolbarYes and it displayed the toolbar but then when it actually did the print preview the toolbar was gone again.

I've seen this question asked in multiple places but do not understand the answers (yet). I haven't worked with the ribbon and XML before so I need some assistance. I'm able to turn off the navigation panel and the ribbon completely which gives the user a nice, empty screen. However, when...

jdraw - did that make sense?

Still tweaking it. Since I am matching on the address number portion, I decreased to Simil score to .65 which caught a LOT more.

Correction. I did .9, not .95.

Okay. I broke it down into several steps. 1) I do a join for each record against all addresses. In my case, there is a level above address (there is a limited set of addresses based on a different field) so the number of generated records isn't so onerous. I did this as a MakeTable query...

Yes. Let me give a little background. I have a table of good addresses. We can call that table Good. I have another table that has addresses that for each one I want it to do a fuzzy search against Good and return the best match as long as that match has 95% accuracy. Simil in its simplest...

It is downloadable from the reference library and is a GREAT resource for doing a fuzzy match. My question is how can I implement it take a field on a record and have it return ONLY 1 record from another table that is the best match? Simil will compare 2 strings. I want to compare one sting to...

Create an SQL string with the INSERT statement and the FIELDS and VALUES. Then execute the SQL statement. Easiest way. You can Google the syntax.

I did not type it that way! What funky formatting it decided to do!

I don't think that is how the Case statement works. This should work though: Select Case Business Case "Carton" If Me.Material = "Type 2" Then MsgBox ("You really want to change this!!!") End If Case "Stone" If Me.Material = "Type 2" Then...

You do an Add Record to the table with the PO # or you can do an SQL Insert with the PO # (which I assume is key). Then, the changes the uses makes are Edits. You can Google that.

An alternative is adding the PO record immediately when the number is assigned so that the next user will see an already existing record. Where you will get in trouble is if the user discards the updates to the PO so that it reverts back to a blank PO. The easiest thing would be to allow voided...

The problem you are having is the lag time between when a number gets assigned and the time that the PO record actually gets saved. Here, when the number is assigned, the next PO number should be automatically updated so that the next user will get the next number even though the first user...

How about if you create a table with one record that contains the next PO number? Instead of getting PO from your DMax, you get it from this table. Once you give a new PO out, you update this table immediately BEFORE actually updating the POs. Theoretically, you may end up wasting some PO...