Search:

Thanks Mark.
I actually used tblVendor->tblServices-Categories->tblServices (One-to-Many, One-to-many) this arrangement essenturaly creates a list of categories with the services for that category....

Thanks Mark I'll try it.
Frank

Thanks Mark I'll try it.

I have two queries: 99865-qryChartOfAccounts and 99870-qryChartOfAccounts-Items.
These are from two tables tblChartOfAccounts and tblChartOfAccounts-Items joined one-to-many....

Your requery method was spot on.

Forms![60300-frmJobCost-MainForm]![65100-frmSales-MainForm]![65500-frmSalesInvoice]![lstSalesInvoices].Requery

Frank <img src=/S/bouncenburn.gif border=0...

Yes but it was very sloppy as it selected the list box way down through the subforms and did not look good as the form blinked each time lstvendors was selected.
Frank

I have a main form frmVendors
A tab control TabVendor with two tabs: Vendors and Services.
On the second tab I have a subform:25100-frmServices-MainForm-Tab.
Within this subform is another tab...

Has each subform been linked correctly to its parent by setting the master and child link fields?
===========================================================================
Yes...

Both

I have a series of subforms and tabcontrols on the last subform When I try to create a new record I get an error when I enter data in the companyname control but then when I click on the dialog box I...

Well thanks Charlotte and David.
The code worked perfectly and went to the exact control I needed it too on the other subform!
Private Sub GI_Exit(Cancel As Integer)...

I provided a quit button but have been using the forms close button, I sulute you on your astute grasp of the form events sequence-I was not thinking of that and just thought the form just closes....

I have two subforms on a tabform.
When I tab from various controls and then in the job subform and tab down to the last control, it does not tab into the other subform. How do I get out of this...

Private Sub Form_Close()
Password = Null
End Sub
I get a runtime error that says I can't assign a value to this object.
Frank

Hi Hans,
I have a field I use for a password and want to clear the password everytime the form and database is closed.
Frank

When I use a maco go to control password, run command delete. I get any error message that the control is not selected. humm.. how could that be? I just want to clear the password with I close the...

Imput mask-(Password Format) forgot all about that one.
Frank <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

I thought I saw once a textbox that mimics a password control-here asterisks replace text.
Any Ideas?
Frank <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

Hi Mark,
I tried previously to post a screen shot and I got an error of "internal server error."
The app now is about 6 meg,
If you can just imagine it. It opens with a switchboard that when...

Well, I think I finally have my database secure from prying eyes. I deselected all the startup options so the user has to go to the splash screen switchboard and can't open up the database window or...

Is there an easy way to find what has the focus. (Sometimes there is no cursor)
I'm having problems transversing through forms and knowing where the focus is-especially when a new record is created...

Thanks Charlotte and Rupert,
I think that's what I'm going have to do-The shareware program mentioned by Rupert looks interesting-Thanks Frank

You might check the registry.
I've had similiar problems when reinstalling programs and had to track down the offending entry that stayed there and did not let me reinstall the program.
Frank

Is there anyway to limit i copy per CPU.
I'm going to install a beta version of my app on my clients' computer but not give her the disks.
She indicated she was going to copy it and distribute it...

You hit it on the head. Yes it is a price list or several prices lists that is vendor specific.
lstVendors pulls up the first price list for the vendor and lstServices-Categories on this subform...