Search results

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

Just to save you a LOT of trouble in the future, I'd replace "Paid" with having a Date Paid in your invoice field. It will save hours the first time you get that abominable entitled client who wants to argue they are always up to date on their account as the invoice shows "Paid" but doesn't...

I would suggest looking at the Clarion programming language to see if their templated application development is what you are looking for.

Depending on what fields are prompted, I can see a separate form that is used with cash purchases to avoid prompting for payment method. This is especially true when you don't want an employee to "Accidentally" print out the "Paid in cash" receipt for a CC or invoice purchase. May even require...

Looks like you want the TOP value SELECT TOP 1 entry_date, entry_amount_kg FROM Tbl_Daily_Entry ORDER BY Tbl_Daily_Entry.entry_date Alternate you could use MAX which implicitly only returns the greatest (TOP) value. In SQL, MIN and MAX are often used, but TOP with either asc or desc on the sort...

As you are looking to treat updating the parent and child/children as an SQL transaction, you can either save the original state(s) of all values so it can be rolled back OR (if you really want to spend some time on this) you could create an array for each field to allow you to store its values...