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.

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...

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...

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...

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...

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...

Looking for advice with the following relationship.... Primary Tables Filing(Number, Title, Analyst,etc) Form(FormNumber, Title, Type, Desc, etc) State(Name, Abrv, Address, etc) Bridge Tables FilingForm(FilingNumber, FormNumber) FilingState(FilingNumber/FilingFormNumber??,State, MailDate...

What's the proper SQL for selecting all records where a specific date field is between 2 dates? I know I can accomplish it using a long 'where' statement... but want to use 'between' Select* from table where table.completed_date between '01/02/02' and '04/01/02'; Doesn't seem to work, Help!

Having problems with SQL for pulling all records where 'completed_date' NOT NULL. Select* from table where table.complete_date = NOT NULL; or where table.complete_date = ''; Neither seems to work. What am I missing?

I've set up a table to have a checkbox for y/n, but the form I've auto-created is just a yes/no text field. Why did this happen? Can I convert back to a checkbox, or should I just make a new checkbox on the form and delete the old? Just curious....