Search results for query: *

I feel like I'm going insane and that this is should be simple... I want to update Students.TestRetakes with data from ProblemStudents.CountofRetakes. Students has many more records in it than ProblemStudents. Table relations are connected by SS#. I keep getting either only those records...

How do I create a Command Button that has a pic and also shows a word? i.e. pic of 'open folder' word 'OPEN' I feel it must be possible as I see it on the Access database window tabs and on toolbars.

If you are sure there aren't any typos, perhaps you need to actually refernce a field of the subform that has focus and not jus the entire form. Forms!Form_Quotes!QuoteLines_Subform!Quote_Id.SetFocus

I think its.... Forms!MainForm!Subform.SetFocus i.e. Forms!Form_Quotes!QuoteLines_Subform.SetFocus

I understand what you're saying.... but how do I indicate mulitple values for a combo box in SQL or VB? (I'm not wanting to pull from a table for cboLOB.) If cboCompany ="Exxon" then cboLOB = "Gas", "Oil" elseIf cobCompany ="Avon" then cboLOB...

Not the normal multi-comboBox question.... I have 2 combo boxes. cboCompany and cboLOB (line of business. cboCompany pulls from tblProduct.Company Row source SELECT DISTINCT tblProduct.Company FROM tblProduct; I want cboLOB to look at cboCompany and then do an if/then check to see which...

Hey thanks! :-) I knew I had seen it somewhere, but thought I was getting '97 confused with 2000.

Seem to be having problems connecting down to the subform level with the command buttons... 'Save' works, but I wonder if it is really just Saving items because the record has lost focus or because my code is working. 'Create New Record' & 'Undo' aren't working... On Access's Database window...

I have a 5 tabbed form with subforms from 5 separate tables. Currently each subform has it’s own set of command buttons for ‘Add New Record’, ‘Delete Record’, ‘Save’, ‘Exit’. What I’d like to do is to move the command buttons from the subforms to the face of the tab form as we see daily on...

Thanks LittleSmudge! I was afraid that was the answer. Was feeling momentarily optimistic when I read about the 'splitter'. I've got 2000 at home, but of course this is a work project and they don't wanta upgrade. :-( Thanks for your prompt response!

Hey Evalesthy, How do you do it in '97? Tools --> Database Utilities --> (Database Splitter- not an option) I've got 'compact', 'repair' & 'mde' as options...

Help! I'm not good at JOINs and would like to modify the following sql to allow for another scenario. To understand better..... think of a 'Filing' as a Mailing... a 'Form' as the 'Mailed Item'. tblFilingState (Id, FilingForm, State, etc) FilingForm fk to tblFilingForm.Id tblFilingForm...

Sounds good.....I knew it could be done, just needed direction. If I can't get it working, I'll get back to you. Thanks!!!!!

I posted this the other day, but it seemed to have disappeared from the site….. Am creating a form that would allow the user to create multiple new records when sending out a Mailing. TblMailing TblStates TblMailingStates Have an Option Group for (1) All States, (2) All, but NY (3) User...

How can that be done? When the Tabbed form is opened from the Switchboard, the first tab should show. But when opening from a different form, tab 3 to show. I know how to set the general focus of the form on open, but how do I establish exceptions when being opened from different forms.

Basically my question is this: How do I have the Tabbed form open to a Tab other than the first one? I have a tabbed form for table updating. Each tab is for a different table. On normal 'opening' it doesn't matter which tab is shown upon opening. However, I would like to establish a link...

To allow the user to print mailing labels for either 'all states' or '1 state' I have a form that has option buttons for each item. I also have a combo box (lists all states) which must have a selection made if for 2nd Option (1 state). The report I've created to populate with either selection...

To allow the user to print mailing labels for either 'all states' or '1 state' I have a form that has option buttons for each item. I also have a combo box (lists all states) which must have a selection made if for 2nd Option (1 state). The report I've created to populate with either selection...

Sounds good and seems to be working. I really appreciate your assistance! There is the possibility that a StateSpecific form may be for more than one State. So I assume that I should add it as a new separate Form and add it the Filings' ~ FilingForm. Questions: 1 - How do I set up the...

Been out of the office for a couple of days.... Yes, I agree with the scenaro. It is the same that I had originially... but while I was creating my forms I came across some problems... Problem ... A State MAY request changes to a Form, if so then a new 'state specific' form is created...