Search results

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...

The first form is being opened 2 ways. The first way is however it normally opens. The second way is when it is called/opened by the second form. Pass a different parameter depending on the case. When it is opened by the second form, have an If statement that SetFocus to the control that you want.

Even better. Create an On Load event for the second form. THERE you close the first form and do whatever you need to do. When done, reopen the first form passing a parameter indicating who is making the call. On the first form, create an On Load event that based on the parameter will SetFocus...

All the code did was close one form and open the second form. You can create an On Load event of the form to conditionally SetFocus depending on who is calling it.

Put breakpoints on both DLOOKUPs and hover over your variables to check what values it thinks it is getting, i.e. txt_RecordName and RecDist.

If MsgBox("Do you really want to change the value?", vbYesNo + vbQuestion + vbDefaultButton2) = vbNo Then Cancel = True Me.cmbRemote_ID.Undo End If This should work.