Search results

Well you could do away with all the else's by just setting all the visible properties to false right up front. No reason to indent the second and third if as they are not part of the first if. But other than that I would go with it.

Simplest is to use a lookup table with the original values, and the new values. Join the input to able to the lookup table, and use the new values when you do whatever, OrigSC OrigPC NewSC NewPC ....A........A.......A.........1... So joined on Skill Code and Paycode would resolve AA being an...

Where are you putting the values after you split it up? If you populating 3 form fields, the easiest way would be VBA code. On the click event of your button, you would need something like this. Assumptions form field AllNum = 456798987898009009080911 form field CardNum you want 4567989878980090...

Use LEFT JOIN instead of INNER JOIN

The first two can be combined because you are updating the same table. UPDATE QualityMatters INNER JOIN Teledynamics ON QualityMatters.vendor_partno=Teledynamics.[Item Number] SET Teledynamics.map = IIf([Teledynamics].[MAP]>0,[QualityMatters].[productprice],[Teledynamics].[MAP])...

Seems easy enought to create an Append query that pulls the value from the form, then you can use DOCMD.OpenQuery to run it. No?

VBA would be the best. But what do you do if they check it, then think, OOPS, and uncheck it again?

Have you considered just creating a table with the two values and joining them. Would be way easier.

You could create a count query or use dcount with the same criteria and see if it returns zero or not zero and use that, as one way.

What about import, or linking to the spreadsheet instead? Then you could read it directly.

From wikipedia: The phrase separation of church and state is generally traced to a letter written by Thomas Jefferson in 1802 to the Danbury Baptists, in which he referred to the First Amendment to the United States Constitution as creating a "wall of separation" between church and state. The...

McCain a POW? Doesn't life's experiences pretty much make up who you are? Since he would be the Commander and Chief, I would say having some military understanding would be a plus, specially with Iraq and Afgan. going on in the least. Also having a complete understanding of what could happen to...

You could either create a specification for each type you want to import, specifying text. You could use a positional import and import the whole row into a single text column then use VBA to split the elements out and put them in a table. You could use VBA to read the file yourself and parse it...

Have you clicked your join lines and set the proper join (all the records from tbl1 and those that match from tbl2) to create outer joins?

Create a form with the criteria (for user input/selection). Write a query/ies to use the criteria from the form. Create a macro that prints each report from a button the form. Make sure each report is based of one of the queries that use the form criteria. Simple, easy, no VBA. Of course with...

Yup, Thanks, what I needed, and pretty much what I was afreerd of.

If it is everything, I would create a delete query, then use DOCMD to run it. much easier to maintain.

I need a form with about 8 comboboxs of which 4 or 5 will be multiselection. I then need to base a main query off this form to return the selected data based on the selections. Not having had to deal with multi-selection and filters, what would be the best way to base a filter of a...

Depends what you are trying to do. use an event procedure and in it try this (you will have to change it for your environemnt) dim LastInvoiceNo as long LastInvoiceNo = dmax("InvoiceNumber","InvoiceTable") Me.NewInvoiceNumber = LastInvoiceNumber + 1