Forms

Validate/Verify entry in MsgBox
I have a button on a form to open a report based on a parameter query. The button activates the parameter query and the parameter msgbox says enter MIL or CIV. I would like to ensure the user spells MIL or CIV correctly so the parameter query runs correctly everytime. The current button code is below. Can ... 22 Apr 2010 11:23

What is equivalent to "acSpreadsheetTypeExcel9" in 2007 i.e .xlsx
I have a button when clicked does the following .. DoCmd.OpenQuery "qry_ExpToXl_LotNo" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qc_details", "c: \work\QC_Details.xlsx", True transfersheet fails if I use .xlsx , i.e I could not open the spreasheet after creation, but it works fine if I gi... 21 Apr 2010 10:31

Pasting in Tab Control pages
Hi. I use Access 2003. I have a couple wide rectangles I need to duplicate. I do copy and when I do paste they are pasted almost outside the page area stretching the page and creating a mess. Looks like it takes the rectangles width and pastes horizontal shifted by that width. Is there a way to have pa... 21 Apr 2010 06:22

SpellCheck Will it work on the Access 2007 Runtime?
I have a program that I have compiled. It has the following. Private Sub cmdSpellCheck_Click() Me.Call_Notes.SetFocus RunCommand acCmdSpelling End Sub Is this going to work on a runtime or will I need a full version of Access to use it? ... 21 Apr 2010 05:20

Form tries to insert row when it starts
Hi, I'm running Access via Office XP Pro on Windows 7. I have a data entry form. The record source is a query (logical view of a table) of a table where the keys are manually entered. When I lauch the form, the form immediately tries to create a new record. I know this because the Form_BeforeInsert event... 21 Apr 2010 01:11

record count issue
I use recordcount to check my DAO.recordset is empty or not. The recordcount returns 1 when the resordset is empty. Are there any work around for this? Your help is great appreciated, ... 20 Apr 2010 16:32

Copy form datasheet to table
Currently there is a command button that brings up a form (datasheet view) and populates it. I would like to add to this code the ability to copy this form's data into a table (tblPE_Temp). Ideally the new code would delete the current data in the table and re-populate it with the form's refreshed data. Any ... 20 Apr 2010 11:22

rs.RecordCount
Hi Guys I need to know how many records I have in my record source that why I am using rs.RecordCount after my sql statement, if there are no records I got zero that is OK, but if I got more than 1 record I got a 1, what I want to know is the exact number of records in my record source. Thanks ... 20 Apr 2010 18:34

Form Field Auto-Resize - Access 2007
I have a form based on a table with Memo fields. Is it possible to have the form fields automatically resize if I cut and paste text from documents into the form? Thanks, (B^>)-]=[ ... 20 Apr 2010 16:32

Making a combo box enable for two case
i Have a combo box name Cbmonth when click a specific case i.e. month sales the box enables, Me.cbMonth.Enabled = (SalesPeriod = byMonth) what i need is when we i select Sales person case i need the cbmonth to enable i've tried this me.cbmonth.enabled= (SalesPeriod = byMonth and BySalesPerson) but i... 20 Apr 2010 10:20