Search results

Maybe something like this: If Me.Recordcount = 0 Then msgbox "No records found!" End If

Why not scan one item and put in the quantity instead of scanning each individual item? Then the form would automatically group everything for you just like it does when you order something on Amazon. You select an item and enter the quantity of that item to purchase per transaction.

Don't do it. If you have all the raw data already in your existing table, you never add calculated values to the table. If those values can be calculated, you can do the calculations in a report, or show the calculations on a form, but just don't store them in the table. You can create a query...

How many forms are we talking about? You could show them one form built correctly and explain the work involved creating it and all of the reasons behind why this is the proper approach to finishing the database application. They can then decide what they want you to do. They might not realize...

AI could be a technological tower of babel created to elevate above God. Merely an attempt to create a god in man's image that can be used by man to do man's bidding. Think about that for more than a second. But it will never have a real conscience and be able to have free will to choose good...

And you do?

I understand what your doing to be labeling parts with custom part numbers as requested by the customer. So each order will have a CustID, PartID, CustPartNum, and CustomerDescription. Is that right? Or is there only one description for the part? So the design is essentially a standard four...

I think everyone except for democrats are impressed with Fetterman. Also, what miraculous recovery he had medically. God blessed him.

Going back to the simple solution. Why not simply do what LinQ suggested originally, that is super simple. You can add a few extra lines of code to blank out the fields you normally edit and set focus to the first one to edit. Private Sub CopyRecordBtn_Click() DoCmd.RunCommand...

DoCmd.RunCommand acCmdSaveRecord Me.Recalc You will need to run this every time the Product or Qty gets updated.

Is record getting saved? That has to happen first before a me.recordset.requery.

These sort of thoughts happen to every programmer. We all want to refactor, make it more efficient, or make reusable code. So it might be fun for you to post the actual code you are using as an example and others can join in discussing how best to make the code reusable. I know there others who...

Here is the updated example you requested using the OLE object in your color table.

I just don't want the conversation to devolve.

I appoligise. That was uncalled for.

Tariff Derangement Syndrom

I am assuming you mean store the color name associated with each category in the color field of the Data table. The Data table is the record source of the Frm1. I have no idea why there is a separate color table because there is a color already in the category table. So, it would be easier to...

=Mid([C/N], 11)

All that gum makes my jaw hurt just thinking about it.

ACA is one of the good programs, so I doubt there will be much fight against that one.