Search results for query: *

In previous versions, in a macro, there was a command of SetValue, argument "". I used that to clear password boxes on ONLOSTFOCUS or when using a command button to validate I tried the SETPROPERTY in Access 2007. Couldn't get it to work Any ideas

Here is the reference point: Forms![frmMainMenu]![List8] I wish to put in a condition in a macro to reference Column 7 in List8 Forms![frmMainMenu]![List8] (column7)="None" Any suggestions, it is easiest for me to macros as i do not know how to write code Thanks in advance

I am using Access 2007. To make a long story short, I have developed a database for my father, a mechanical engineer, and have duplicated a CERTIFICATION FORM for pressure vessels he inspects. I developed this with the intention of allowing other inspectors to get a copy and use it themselves...

Is it possible to use markup language like in this tek-tip board in the database? Quick example I have a list box with all active employees, I have done a concatenation with the employee's last name first, first name, and middle initial (the Employee Number is hidden in the first column) and...

I have seen a website (unknown this one or another) just 3 days ago where the poster had a simple 2 line code that disabled the shift key on startup (I have already done that through code) and then had code to view database window (got that one also), but I cannot find this same website to...

not just viewed. I have been trying to read the faqs and searched posts, but I could not find anything that matched my scenario, and user level correctly QUICK BACKGROUND Employee table employee ID (primary key) name etc Overtime table otentryID(primary key) employeeID...

I read through the entire FAQ on tables and other, and I could not find anything like this, so I am sorry if this duplicates a previously written question I have a database that is controlled through a log-on screen I created, everyone has a unique User ID and password. On verification of...

I know : =[forms]![frmName]![fieldname] - active form =[sfrmName].[Form]![fieldame] - subform what is the correct criteria for a subform on a subform on a form? also, I need it to be a like statement as well, similar to an active form version of Like [forms]![frmName]![fieldname]&"*" Thanks...

Like "*" & Between [forms]![frmSearchMenu]![txtBeginAge] And [forms]![frmSearchMenu]![txtEndAge] & "*" this is the criteria I have in my query, it does not work I have an unbound form that includes 7 unbound fields that can be typed into to search for a list a results that will appear in a...

I have an unbound form with several command buttons and subforms that I have hidden visibilty unless you click their command button, that way multiple screens do not open. Keeping with that train of thought, I would like to be able to preview a report in an unbound or bound object frame, or...

I converted a 2000 format to 2002, and split the database. I then tried to make a mde file out of the front end and it simply returned the message "cannot make the mde file" with no further explanation. I created a database from scratch in 2002 format, and a mde was created no problem. Am I...

I have a table named tblOffender which contains a field strLastName. I am trying to create a query based off of a form named frmOffenderVerificationEntry which contains an unbound text box named LastNameSearch. I need a query to return all Last Names from tblOffender when a partial name is...

I have figured out that my ACCESS 2002 must be corrupted somehow, all of a sudden one day, any command button I created would not work and any subform would not relate to the parent form. I know that all of my relationships and such are correct. I took the database to another computer, created...

I have created a button in the toolbar that runs the below code. The purpose of this macro button is to send the MS Word document that is currently open via outlook email to a particular address . When the following line is Remmed out, it send the email like it should, when the following line...

The field I have is a Date and Time field - Name - dtmBeginDateandTime Format - mm/dd/yyyy_hh:nn Input Mask - mm/dd/yyyy_hh:nn The Problem when I type 01/01/2005_05:00, Access converts the entry to 01/01/2005_5:00 I need the entry to remain in true Military Time 05:00 the reason I need...

I recently built a database in Access 2002/XP, in Access 2000 format. All machines on the server but one have Access 2002 which has Access 2000, none of the shortcuts will work with the Access 2000 program. The database will open when the file is clicked on in the Windows Explorer, but when...

The following is a input mask I was able to create : 99/99/0000\ 00:00;0;_ This allows for a user to type in the date and military time, very useful for projects involving time accounting especially when one shift starts on one calendar date and ends on the next etc. Also, I created an...

I have a parameter query set up to return all activity between any two dates entered. Of course, the number of entries returned could vary and I would like to know the number without having to physically count. I am sure it will take an unbound text box, but for the life of me I could not...

I have a form called AMain. When AMain is opened it is maximized by a macro. On that form I have a command button which opens a form directly related to the data on that page called InspectionMaster. I have used the MoveSize macro but that command only works properly when the AMain form is...

I have been tasked with tracking firearm data, inspections, and repairs. I am 99% finished with this database except for the following report because I cannot figure out how to build a query. I need to combine the following information with a query to get the report I want: Table -...