Getting Started

Text box verification
Good day. I have a form with a text box for data entry and a check box associated with this text box. when the data(name of a test unit) is entered in the text box, the person is supposed to click the check box(to verify the test unit has been tested). At the end of the form is a command button to check the ... 16 Jun 2008 15:46

linking tables
I want to make a change to my database that I didn't realize when I created it. There is no data entered in it yet. I created a number of tables which are located in the backend of the secure, split database. These tables are linked to the front end and used to create the forms. I have decided rather than rec... 6 Jun 2008 14:22

Problem with IF statement.
Hello, Does a rule exist forbidding an operator used in an IF statement? If not, why won't the following statement work? If Me![Check154].Value = True And Me![txtSpkExch] = 4 Then DoCmd.OpenReport stDoc3WO, acViewNormal Is it because of my syntax? Thanks in advance for any help, Paul ... 5 Jun 2008 15:17

how do I update records
I need to update a field in a record using the "On Click Button". This is what I'm trying to do. I know there's an SLQ routine I can use but I'm doing this in VB. if status = "working" and shift = "A" then -- {this is the criteria I have.} {I need to replace the status field in all the records with "Off Day"... 6 Jun 2008 05:05

crosstab querys
How do you query two sperate cross tab querys to make one query? ... 6 Jun 2008 23:33

Create and export data from form to excel
Hello, I have a form named frmMain and it has a subform named frmMainSubform. On this subform I have a few controls. I would like to add a button on my frmMain that would generate an excel workbook and in the first rows like A1 and B1 and C1 have the same headings as what I have on my form and with the informat... 5 Jun 2008 20:56

Can ACCESS prompt user on data change?
I have created a database that will track board members. One of the records on my member table is "current" ... the field is a yes/no field. I have reports that will display all members, all members of a specific board and all members of that board being yes or no ... is there a way on a form, that if a user is... 5 Jun 2008 13:13

AVERAGE
Need help. I need a formula that we help me to get an average for 3 fields. A = X B = Y C = Z I want D = average of A,B,C even when one of them = 0 ... 5 Jun 2008 09:37

Accessing webmail for Windows Mail
Does anyone know how to setup webmail for a Window's Mail account, so that if I don't have my laptop I could check my email on another computer? Thanks, Crystal ... 4 Jun 2008 21:48

vehicle maintenance template
I just downloaded the template for vehicle maintenance and for the most part, I love it. There's one thing, though, that I wish I could change but I'm not sure how...Instead of all vehicles being in one form, I would like to make it so that there's a differant tab for each vehicle so I can keep their forms sepa... 8 Jun 2008 21:32