Recent content by Mark_

Old way of getting the buttons to look "Just Right" was to make image files and use those. Allowed you to "Press" a button and have it stay down (work like a toggle) or change colors or the such. If you are not getting ACCESS to generate the image you want, you can always make your own.

What are the three things people love about computers? 1) They do exactly what you tell them to 2) Never try to second guess you 3) They come with lots of documentation What are the three things people HATE about computers? 1) They do EXACTLY what you tell them to 2) NEVER try to second guess...

If you really really really want your control to look like a raised button, you can set your Me.Button.Picture =

For myself, I would create a small app that "Reads" the CSV in through a query. This will allow you to review the data and resolve any issues you have. Then create an append query that reads your properly formatted query to actually add to your table. This allows you to also create other...

At the top of your loop, you can set a variable (or several) to TRUE. Then you can use the OK / CANCEL in a msgbox to turn it off once your sure that value is correct. Other way I've done this is to write to a log file. Debugging inside a LOOP can get rather... challenging if you don't set up...

I've found a way to sell cat lovers a lovely cardboard box for their cats to play in and make a lot of money. I put a useless object called a "Scratching post" inside that gets tossed after purchase!

He's trying to figure out what their birth day is this year based on each date of birth. Basically sawing off the "Year" and plugging in the current one.

Depending on exactly WHAT you want to view, I've often found MsgBox to be a great tool. In your code you can have a msgbox that shows what you need and, optionally, allow you to exit out of your code.

Something that seems to be missing in your application is the DATE of price changes. If you have this date, then you would not need a user to select each product. You would have a query that just returns products that have had a price change since the DATE you last submitted. This would avoid...

Buying a cat is pointless. The Cat Distribution System exists because CATS are the ones who decide with whom they wish to live. Paying money is a total waste. Also explains a lack of bonding. 😁

You may want to show this thread as "Solved". If not, we'll see post 115 far to quickly. :)

The times I've had to deal with "Keep the list you are working on", I do so by having a local table in the front end that holds the IDs of the records they need to work with. Then the query runs on this table and grabs the matching records to show. Other option for assigned records uses the same...

Something you may want to do to keep your hair in place. For the values you use in FilePath, CategoryID, and the year you pull from your CkDate, I'd put them into a field on a form you can edit OR store them in a table. This is to prevent you needing to go back in to code some time in the...

Yes. More importantly you can assign specific templates for specific needs so you DON'T have to use a giant template. Think of it more as "I get to turn on and off specific functions on a per control basis".

Fundamental differences between storing code to control behavior for a field in a table and how Clarion does it with templates are 1) Clarion is a compiled language. Updating the template and recompile to achieve updates rather than update code in a table. Benefit is you get the speed of it...