Search results for query: *

Good afternoon, folks. I have been looking at this procedure for three or four days now and I can not see what is wrong with this procedure. I have a form with four checkboxes on it and a subform, I want to have at least one or more of the checkboxes check before I can enter data in the...

Good morning, I have a procedure in which I am using SendObject to send an E-Mail message to users when a command button is clicked. Most of our users have Outlook on all of the time, and they have no problem, but a few don't turn on Outlook at all. My question is if a user, who does not have...

Good afternoon, in the final stages of building this dbase, I was asked to add help/instructions to it. ControlTips text "appears" to to the job that everyone seems to like, with one major draw back. I would like to have three or more sort lines of text appear, but one long line of...

Good afternoon. I have a dozen or so textboxes with cmdButtons next to each one of them. When a cmdButton, is clicked, the code will fill in the textbox with the correct data. That all works great, the problem is any one can just put a cursor in the textbox and enter data, correctly or...

Good morning, I have a Switchboard with Five buttons on it, one of those buttons is for the Maintainance Tables. Is there a way, so that when that button is clicked, it asks for a password? Thank you to anyone answering this question.

Good afternoon, folks. I have two dbases, the first is the working dbase, where everything is done, and I have a second dbase, which is for archived records. I have the tables from the archive dbase linked to the working dbase. In the working dbase, I have an autoexec macro, which runs a delete...

I have six append queries and a delete query to transfer completed ECN's to an Archive dbase from my Working dbase. I created a macro to execute the append queries and the delete query. I tried to run the macro in the Switchboard's OnExit event, and the entire dbase started run very strangely...

Good Morning, I have a main table with a couple of linked sub-tables. I created a archive dbase with the exact same tables and then I A link to the archive tables on the active dbase. I created a couple of append queries and a delete query, then I created a macro to run them. All of the data...

Good afternoon, folks. I have a WHERE statement which I need to modify to say anything three years old today. Here is my statement: WHERE (((tblECN_MasterData.DateEnd)<=Date())) OR (((tblECN_MasterData.DateCancelled)<=Date())); Thank you to anyone answering this question.

Good afternoon, folks. I have a main table and four subtables all linked thru the pkey, ECNNumber. I want to append the data in all of the tables for each ECNNumber that is completed, CompleteDate=Date(), to five exact tables in another dbase. My question is basically would I have one large...

Good afternoon, folks, I have I small problem that I just can't quite figure the last bit out on. I have a form and the pkey is ECNNumber, when I tab from one page to another page the ECNNumber has been changing, so to stop this tried to put a procedure in the OnExit event of the last textbox on...

Good afternoon folks. I got the label of the SubForm to change to a different ForeColor when I go into a Subform from my MainForm by using this code: Me.Parent.[PartNumber(s)_ Label].ForeColor = 33023 There I enter several PartNumbers then I would like to exit the SubForm and have the SubForm...

Good morning folks, got a small question. On GotFocus I have been changing the ForeColor of the label and OnLostFocus I have been changing the ForeColor back. That all works great. In the main form I have a couple of SubForms, I would like to have the SubForm's Label change ForeColor while I...

Good afternoon folks. I am going to write an Update query and a delete query to archive my completed records. I have a large main tableand four small linked tables, my question is would it be better to use a tblname.* or list out all of the fields in each of the tables? Thank you in advance...

Good afternoon, folks. I have been trying to figure this out for the last couple of days and to no avail, maybe someone here can straighten me out. To start I have a function, which collects e-mail addresses from a table and sends a message to everyone who has a certain checkbox checked. Here...

Well, nice to see Tek-tips back on line. I have a procedure that is sending out e-mail notices and it is working. But everytime I send the e-mail notices this Outlook2000 popup window opens and there is a yes and no button in it and I have to manually click it. Is there a way to answer yes to...

I have a procedure where I am using a couple of DCount statements to validate data and automate the data entry. The first one works correctly and if everthing is true it fills in a textbox with my LogOn and puts the date in another textbox, if all is not true I get a message. This is what is...

Good afternoon, folks. I have a table of users, tblAuthorizedUsers. In the table I have a text field, LogOn, and a checkbox, ApdCCD. I have a main form, and on that form I have a command button, for approval, and in the OnClick procedure I am try to run a validity test to see if the checkbox...

Good morning folks. I have a table of users, tblAuthorizedUsers. In the table I have a text field, LogOn and a checkbox, ApdCCD. I have a main form, and on that form I have a command button, for approval, and in the procedure I am try to run a validity test to see if the checkbox, for the...

Good afternoon. I have a form with a command buton and three textboxes. I have a function, which is supposed to get the user's logon name from the system and set the date to today. My OnClick procedure is: Me.CCDApprovedBy = fOSUserName() Me.CCDDate = Date Me.CCDComments.SetFocus...