Search results

Thanks Yellow! I also received an answer to the same question at AskMe.com as follows: That functionality IS NOT part of the Access report engine, and it cannot be added, as a report DOES NOT provide events that are raised when the user presses the Page_Up and Page_Down keys. Yes, you are...

Greetings! [Access97] My client wishes to be able to use the Page Up/Down keys to move among the pages of the multi-page report regardless of the Zoom level. I have searched high and low in forums today and found no indication that this is possible. The events for the report object also do...

I've searched in this forum for some time and have not found my problem described although some folks have come close. I have a form, 'Visitation Schedule' that is for user input. Data is actually entered in a subform that is displayed in datasheet view. The subform has code in the...

Rich & gHudson, Thanks for your comments! I never thought of being over zealous. Perhaps I am but I think what you see is a style I just sort of stepped into it as a single catchall function when there are several exits from the form. I know more about the Tag Property but that still is...

I found the problem but not yet the solution. The SetFocus commands in the function are called from the last command button on the form. To make sure that a new record is not opened, I have on the LostFocus event of this command button a SetFocus to the first control of the form. This...

Rich, Here is the function: The text boxes do exist, are visible and enabled. ============================================ Private Function Client_InfoOK() As Integer ' CHECK FOR REQUIRED FIELDS ' ' Client_InfoOK = True ClientInfoOK_Flag = False If IsNull(txtFirst_Name) Then MsgBox ("You...

I have a form for entering a person's address information and it has a few required fields that I check in a VBA function behind a command button. If a required field is not completed, I send a message then SetFocus to the control. The problem is no matter what control I SetFocus to in the...

Jon K, Thanks for the syntax! I still don't know the problem with the SQL but the query sure runs good! I will return to the SQL question later when my client is not pressing me so hard.

Peter, Thanks for your response. The 6th line is a wrap-around and is to my knowledge correct. It is an integer value. Line 7 is the same way. The query runs and if I knew how to do so behind a command button, I'd just assign the query to the recordsource and run it. But I've never...

Is this a Quick or a Trick question? :p Why would you not be interested in select or update queries? I think you need to reply with a slower question!

I searched the forums for an answer without success. The SQL assignment below is returning the error: Microsoft Access can't find the field "Task_Ordered" referred to in your expression. The SQL receiving this error is: Me![subTask_Maint].Form.RecordSource = "SELECT...

Dynamictiger, You are correct. I found out and should have updated this thread. I still shake my head in wonderment that the keyword MDE is not in the Access XP Help file! Most of my programming is in Access97 and would be curious if there is any overwhelming reason to fully move to XP or...

Greetings, I cannot load an Access97 MDE file in Access XP. The Help in XP does not have the keyword "MDE". Of course, there is no index in the XP Developer's Guide. Does anyone know what Microsoft did with this capability. My program MDE runs fine in Access97 and 2000.

Thanks WebFaktor, I think the 'Cancel' will handle this problem, I know it has for the first half of the validation but I had not thought of your approach and will keep this in mind as a similar challenge comes down the road!

Ah, the power of Knowledge. For how many years have I wondered what the function of (Cancel as Integer) as in Private Sub Form_BeforeUpdate(Cancel As Integer) could be. I am so happy that I can reply to my earlier questions with: Add to your code...

Hello, I have a similar problem with a subform in datasheet view. In my case, in the subform BeforeUpdate, I check on the user input before he/she leaves the record. My IF statement constraints are working fine and I then SetFocus to the offending control as noted in Dawn's post above...

Batchfile, If you could, let me know what the table relationship was that caused the problem. I have the same problem and cannot resolve it. Unlike the example provided in this thread, my subform has to be in datasheet view. I can get the fields in the data table to update correctly but the...

Rich, My error with the brackets, they were in the program, I was recopying from memory [faulty :)] The first IIF statement is in a report control, or would be if it worked so that if there were no data in the control source field, was more complex but both returned the error in preview. My...

[Access 97] I hate to add this thread as it should be so simple and I must just be missing something, but an hour is a long time to be beating one's head against the proverbial Access wall! I want the field Home_Phone to be displayed in the report if it has data and not if it does not. This...

I see there have been 16 views here and no replies. I'd really like some help. I've been to a lot of threads on OpenArgs and this property is used. What do you folks do when you are using this and calling a form from different forms? Am I just being stupid or is my question legitimate?