[RBASE-L] - Form field colors

We have a report that specific fields change colors depending on a condition. If due color is black, past due color is red.  Works great Is there a way to do this in a form using a scrolling region? Thanks, Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guideline

[RBASE-L] - Email

This is NOT actually an R:base issue, but is driving us completely nuts. Many places in our R:base X application automatically sends out emails. (invoice, confirmations, etc) We use the EMAIL ON code in the print command.  All the settings are drawn from a user table. For years all worked fine,

[RBASE-L] - Arrange by

I hate it when I have used a command in the past, need it again, and can't find the documentation. There is a command to use when editing a multi table form to arrange one of the tables in a certain order. HELP. Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group gu

[RBASE-L] - Telephone interface

We are contemplating switching to a VOIP telephone system.  Has anyone had experience on tying R:Base software in to pop-up customer info based on incoming phone no? We are just looking into all this, but that would be a real plus. Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138

[RBASE-L] - What users are in the database

Seems like I used to know a command that would show which users had the DB open. Of course that was before my brain was fried. Any clues ? Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php ---

[RBASE-L] - WHERE Clause ?

I have a table that may have multiple lines from an order that are identical. I want to create a form with a where clause that will allow editing, but only  one of each line that is unique. IE: Table holds: 180500  Red 180500  Red 180500  Red 180500  Blue 180500  Blue 180500  Blue My form us

[RBASE-L] - DB problem

Looks like I have a problem with a table with spurious rows that a reload or a pack is not fixing. I have never needed to inspect my data in this way, but is R:Scope the product I need? Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guidelines, visit http://www.rbas

[RBASE-L] - Lost rows

Help... We are having a problem with occasional rows just disappearing from a table.  We know they were there in the beginning, because we print an order when entered. Sometimes coming back to the order later, 1 or more detail rows are missing.  I have no idea how that can happen. The quest

[RBASE-L] - Phantom number

Have an integer column in our order table that holds our order numbers.  Maximum ever is  99 Command to generate a new number for new order, is to compute Max no. from table and add 1 That becomes the new order no. Last week the system conjured up a number or 10 or 12 digits, and added 1 If

[RBASE-L] - Buttons in a scrolling region.

Having problems with buttons disappearing in a scrolling region. Tried Push Button and Bit Button. Both occasionally disappear during use. Strange behavior. Any suggestions? -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guidelines, visit http://www.rbase.com/support/usersg

[RBASE-L] - Scrolling Region question

Building a form with a scrolling region.  I have 4 bit buttons, one button duplicates on additional rows, 3 do not. What am I missing? Dick Fey Carpet Broker Inc. -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guide

[RBASE-L] - Form

Thanks Karen... Fixed! This list is so awesome. Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group.

[RBASE-L] - Form problem

Building a form with 2 db grids.  Left grid displays all products that contain a certain color name or number. Upon clicking the desired style with a on click eep,  I want to display all the colors in the selected style in grid 2. I project a temp table containing all the colors.  If you look at

[RBASE-L] - Syntax, Load command

Trying to load a price file from a vendor. Have it ins CSV format. Unable to figure out how to limit the number of rows. Tried all the syntax in the Load help, but nothing seems to work. It is loading thousands, but there is only 400 lines of data. Dick Fey -- Carpet Broker Inc P: 913-894-9211

[RBASE-L] - Rbase

It might take a little more work up front, but for 30 years we have been running our multi-million dollar business totally from R:base. No peachtree, No Quickbooks. We do everything in R:Base. Accounting, Payroll, Sales, everything. Even print customers Fax checks. No outside problems to deal

Re: [RBASE-L] - Date Picker

37 -Original Message- From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On Behalf Of Carpet Broker, Dick Fey Sent: Wednesday, April 05, 2017 9:58 AM To: RBase Maillis

[RBASE-L] - Date Picker

Have a form with an start date and a end date. Using a dbdatepicker, how can I make the end date calender open with the same month as the start date, when the user picks a month later than the current one? Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- You received this mes

[RBASE-L] - Dialog options

I know I could handle this is various ways, but is it possible to do a dialog command with more than 2 buttons ? (YES NO MAYBE DON'T KNOW) -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To

[RBASE-L] - Form size

OK, so this is really weird. If I examine the form in form designer, I can see nothing that shouldn't be there, but if I open the form, at the r-prompt scroll all the way to the right, and the blank space is MUCH wider than it looks in form designer, I can see two db-labels that are the problem.

Re: [RBASE-L] - Form size

Sorry Albert, that shows me nothing that I cannot see. Dick On 2/24/2017 11:59 AM, Albert Berry wrote: Open the object inspector on the right side of the form designer. There is an object in there that is outside what you can see. Albert On Feb 24, 2017, at 10:35 AM, Carpet Broker, Dick Fey

[RBASE-L] - Form size

Am having a problem I have never seen before. I cannot change the size of a form. I have a form that is actually too large for our 23" screens,, but because all the info is top and left, it runs just fine on our 23" monitors. Mine shot craps yesterday, and I replaced it with a 27". Now I hav

[RBASE-L] - DB Grid

Have created a DBGrid from a temporary table, in which every line is unique. When the display is populated, some of the lines are duplicated. ? -- Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- You received this message because you are subscribed to the Google Groups "RBAS

[RBASE-L] - Brain Dead

Have a table with previous Yr & Months sales in currency. Want to reset to Dollars only. Can't for the life of me figure out how to do that in a table. Thanks Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- You received this message because you are subscribed to the Google Gro

Re: [RBASE-L] - My solution to awkward parishioner name searches

Karen; We use a computed column of called 'CustomerInfo' (customername, city, zipcode, customerphone) to allow an almost instant search for a customer to open an order form. The search is 'Where customerinfo contains'.Works great You can enter any of those criteria to find the customer

[RBASE-L] - Form mystery

and the winner is JAVIER... I have not used one of those pop ups in a long time, but you were right. I was about to pull out the few hairs left in my head. Thanks so much. I would never have thought to look there. Never realized they would not show up in a trace. Thanks Javier! -- Dick

[RBASE-L] - Form mystery

Just put a line in the first field eep of the form just for the purpose of finding out where this is happening. The choose is happening before entry into the first field, but is definitely not in the form properties. Crazy Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- You re

[RBASE-L] - Form mystery

I have a small form I made several years ago to edit a work order. It works fine. When you enter the form there is a choose statement to fill in the first edit. Wanted to make a change in that choose statement, but cannot find it. I have been using R:base for 25 years, so don't laugh. It does