Search results

Does anyone have a suggestion for a 3rd Party Software product for form design? I am specifically looking for one that will let you create templates (for forms and the database structure if possible), has ActiveX controls, etc.? Thanks!

Calculation Correct, 16 ounces per pound. I will try the converter, and check to see how much of a round on the number is tolerable.

Calculation Figured I would have to use 2 boxes but was hoping otherwise. Yes, these are NICU (Intensive care infants, many premies) so that is why the ounces are so critical to take into account. Then the problem of 4 lbs 5 ounces does not equal 4.5 lbs (which is 4 lbs 8 oz) becomes...

I have a bound text box where the user is supposed to enter weight in kg. I would like to have an unbound textbox where they could enter weight in pounds & ounces (these are infants) and have it show the conversion for kg, so that could be entered correctly. First, how could I get the box to...

Query problem I did enclose it, and after reading your comments, I decided to change the format back to include the date, and change the way I was going about it to use a parameter query instead of just looking for things in a format like 4/2004. Thanks!

I have a query that calculates 18 mos. from a date and is formatted like 6/2004. Another field that calculates 2 years from the date exactly like 6/15/2004. It's your typical calculated field Letter: DateAdd("m",18,[CourDt]). Question 1 is why can't I put in a criteria like >6/2004 and get a...

I am using a tab control with subforms. Because a subform has so many fields and I wanted to be able to see the tabs, I broke it in half and have subfrmPostopP1 and subfrmPostopP2, each on a tab. The parent and child fields link by Pat_ID2 to the master form Preop. Problem is every time I...

Error trapping How would I do that? All the preop queries start with qryCC PRE and then the actual query name, so do I make a variable for each set (qryCC PRE, qry CD POST, etc) or one that covers all the queries no matter what the set? Can you give me an example? Thank you!

I have a cleanup procedure that checks a bunch of queries and prints the ones that meet the criteria. Each one looks like this: 'this code will print the cleanup routine for the Preop form '************************************************* Private Sub Command4_Click() Dim PreopPrint As Integer...

I have a tab control with 5 pages. Tab 1 is not a subform, and when you enter through it, it scrolls so you can always see the field you are entering in without using the scroll bars. Tabs 2-5 are subforms. When entering, they DO NOT autoscroll down so you can see the fields that are below...

Send keys problem resolved Thank you so much for your suggestion. I took out all of the send keys and it worked perfectly. Yesterday I had the problem and the contents of one of my folders I had open at the same time were all deleted with what I thought was no reason - I thought maybe a virus...

Send Keys This db is something I inherited, and yes, it does use send keys quite a bit. Let me take those out and see how it goes. Thanks for the suggestion!

Strange problem. Every time I open my database the numlock button on my keyboard goes off. I can turn it on, and if I go to another database, it stays on, but if I go back to this one, it blinks then goes off. Any ideas?

Tab control problem See the thread by canadaboy re Tabs disappear in form view. It has to do with the tab page being too big for the size of the screen, and needing to shorten the tab page.

Tab control size question I have shortened my tab page as much as I can still allowing for the fields on my form (which MUST match those on the paper collection tool in layout). There are alot of fields on each of my forms. Is the idea that everything must fit into the size of the screen...

Checkbox question I decided to use the default yes (checked) and then they have to uncheck it and the boxes disable. Works great. Only question is a checkbox further down in that section I would like to grey out (I set the backcolor property of other textboxes in that section to grey if they...

I have a checkbox that asks if a person is in the program. If this box goes unchecked, I want a number of fields following to be disabled and focus to go to the next section. I know how to code this, however, the question is..If a person tabs into this and then out without entering anything...

I have a tab control whose first two tabs control various fields, and the next 5 tabs contain subforms. Problem is when tabbing thru , some forms put the highlight around the checkbox when you tab onto it (which is what I want), and some highlight around the label for the checkbox and not the...

subform problem solved On the issue of being able to view the tabs, I needed to resize the subforms on those tabs. If they were too large, when the tab was selected, the rest of the tabs would "disappear" until you scrolled up. Shorter subforms allowed the tabs to stay visible at all times.

Subform problem Figured it out, I needed to have the mother tabs come first so on the infant page the mother's ID would automatically fill in and "connect" the infant to the mother, since the relationship is 1 mother to many infants. Works like a charm. Another question, when my form opens...