Recent content by Bill Moore

Close - Maybe?? John, I took a look at your database and have a good idea of how it works. In my app, I took the code for printing the record, substituted my key "groupname" for your "customerID" and placed it in the "on click" event for my cmdPrintReport command button. When I run my form...

I'd like to put a command button on a form that would run a designated report but have the option of only printing selected records. I know I could just use the File/print option using selected records but that only prints the record fields displayed in the form. I want to run a special report...

Hoooray!! I got it to work but not sure why. On the form, I resized the detail area to about the size of 1 record. Suddenly, it worked. Strange, but thanks.

No luck I enlarged the detail section of the form, at least enough to hold 20 records or so, but no luck. Still just one record displayed. My test case should display 4 records. Record selector at bottom says 1 of 4 but only the first is displayed in the detail area. Any more ideas? Thx.

Default View I did. Just checked and the Default View property of the form is 'Continuous Forms". Still, only the 1st record is listed. Thx.

almost working I have one additional problem. When I run the form and make a selection from the combo box, if that selection results in say 4 records, my detail section doesn't expand to show all 4 records. The record selector at the bottom of the form indicates that I have 4 but I only see...

Thanks Thank you very much. I get the idea and will revise my app accordingly. Bill Moore

I'm trying to do the following: 1. Create a main form with a single text box that will contain a complete or partial name of a client. There is also a command button that fires a query to select records matching the text box value. 2. I would like the returned records to display in a...

Pat, I must have caused confusion when I mentioned printing or print preview in my original post, causing you to think I was trying to put the listbox in a report. Actually, I was referring to my desire to print a form for use in gathering data. I kind of started over. I switched the...

Pat, Any thoughts on my original question of the back/fore colors for the listbox? Thx.

Pat, You're saying a listbox only selects a single value but mine has 2 values it could select from. Am I missing something here? Thx.

I've got a situation with a list box whereby it seems as though the back/fore color options selected for the control display correctly when the default selection appears. Then, when the user selects one of the list box values, the background color switches to black where I can't see its...

I need to have the user enter a date on a form and would like to immediately append a time part "23:59:59" to that date. I can do it when using two text boxes (txt1, txt2) by changing the control source of txt2 to: =txt1 + time("23:59:59"). I'd like to use only 1 text box (txt1). Thanks in...

I have 6 text boxes in a report detail section. I want them formatted all the same way (I really don't even care which way), just the number with no decimal places as an example. I selected all 6 text boxes, selected properties, format, and changed them to fixed, with 0 decimal places as one...

Should be real simple. I've got 6 text boxes in a report. All I'm trying to do is select 1 or all of them, go to properties, and change the format to fixed or currency (or actually anything other than what it is) with 0 decimal places. The changes appear to be in place but when I run the...