Search results for query: *

Hi all! I am trying to generate a report that counts the number of questions answered by applicants. I am using two tables (more, but they aren't relevant to this question): Table A: (main table) review number (primary key) Date of review applicant info etc, etc Table B: (questions table)...

Hello all: I'm trying to include a variable (form value integer) in my SQL statement and I'm having difficulty with the syntax. I tried using VALUES without success. My code (removed extraneous VBA stuff): I am trying to insert "strInteger" into TableB in the "IntegerID" slot. dim strInteger...

Hello all: I am trying to get a count of unique dates in a report. The date field in the Detail section is formatted as a general date. The dates are at random entered by the end user. I want to count each unique date entered by the user. The data looks like: 1-1-2009 1-1-2009 1-2-2009...

Hello all: I have a form that populates a listbox and a text box in Access 2003/Access 2003 MDB format. Typing a name in the text box triggers a "FindFirst" routine that attempts to match the information in the text box with a column in the list box. The user can then double click the matched...

Hello all: The title of this thread says it all - I'd like to remove the toolbars from my MS Office 2003 applications. I am sure it's a registry key somewhere that activates the toolbars, but I am at a loss to find it. There is no file in the Office/Startup folder I disabled the "Speed...

Hello all: Another issue arose with my Date/Time syntax question located HERE: http://www.tek-tips.com/viewthread.cfm?qid=1248419&page=1 It's a different question so I started a new thread. This is a (hopefully) simple question about syntax of the "DateAdd" VBA command in MS Word 2003. I'm...

Hello all: I have an MS Word 2003 document with two VBA text boxes. In one (txtDate) is displayed the current time. The other (txtAfterHrs)is to be blank unless the current time is "after hours". The time displayed in "txtDate" is subject to change by another control in the Word doc, which is...

I'm trying to copy the contents of one Word 2003 form field (NOT a VBA text box) to another on exit of the form field. I found a wonderful code written by "Fumei" back in June '04 that ALMOST works: Sub PassToAppraisee2() ActiveDocument.FormFields("APPRAISEE2").Result = _...

Hello all! I receive the following error message in Access 97: "Run Time Error 2501: The OpenForm action was canceled. You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box. For example, you used the Close method to close a...

Hello.. I have an Access 97 frontend/backend setup, the backend contains ONE table only. There are others with the same setup on their workstations. Centralized backend is not possible due to infrastructure limitations. I have set it up so that the frontend e-mails their backend MDB files to...

Hello! I am using a form to call up a report, and sometimes there are no records that fit the criteria specified in the form, (TEAM and YEAR) and the report loads but the fields contain #ERROR in them (obviously because no records were retrieved.) What I would like to do is have a message box...

Hello! Trying to create a date formatted text box with a default value of January 1 of whatever year happens to be current. Tried DateDiff and DateAdd with no success. If I enter the value #1/1# in the "default value" property the year 2003 is automatically added to the default value...

Hello.. I have a Word 97 userform Combo Box that I would like to populate with data from an Access 97 table. Example: User starts Word doc, userform pops up, User can select a name out of the combo box (values taken from Access), click OK button, value from combo box is placed at a bookmark...

Hello! I would like to add up the currency column in my table for only dollar amounts that are classified as "open", ignoring all records classified as "closed." Table: STATUS EXPENSE open 500.00 closed 500.00...