Hello Eileen, It sounds like a possible data problem to me. Try testing the field for a numeric value before conversion. Maybe the field contains the word null...
Sorry for waiting so long to reply. I do not have bound controls defined in the detail section. What is happening, is I am creating a subform. Then using the...
bob- Unless you define bound controls in the detail section, you won't see any data. And if the record in the outer form has no related records in the ...
John I think I misunderstood your question. Yes, the detail lines in the subform are linked to actual fields on one of the tables. Here is an overview. It is a...
bob- Is the default view of the form inside the subform control Single Form or Continous Form? If so, then records in the Form Header section should appear in...
Hi John, I'm sure this is a dumb question but I have to ask, to make sure I am right. If I have a form with underlying code and I make a copy of this form via...
Ilona- A copy is a copy. Deleting something in one copy won't affect the other. John Viescas, author Building Microsoft Access Applications Microsoft Office...
Thank you very much John. And thank you for being so quick. ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com]On Behalf Of John Viescas ...
When I switch from datasheet view to single form view, the header will show, but then the details won't. Any clue? bob ... ~ Bob Rosenblum PO Box 3027 Albany,...
Bob- If, as you said earlier, you have bound controls in the Detail section, there's no reason for the data to not appear. Perhaps you should compact, zip,...
Hi All: This is probably going to be a simple problem you all you experts out there but....I'm stumped. I'm using a card reader to scan cards for membership...
Dave- Perhaps use the BeforeUpdate event of the control to eliminate the junk - keeping only the numbers. John Viescas, author Building Microsoft Access...
Hi John: That sounds like a plan. However, could please give me a "sample" of coding that would eliminate the "junk"? I'm assuming something like "If it ain't...
Hi John, I need more help please. Sorry this is so long. I am having a lot of trouble getting my head around filters, etc. I want a report that prints out...
Hi John, I had an incorrect variable name in the Where Condition. Should have been DelDate. Interesting that Access did not pick it up. Sorry if I have put you...
Ilona- Love it when posters solve their own problems. Your first one should probably be: DoCmd.OpenReport stDocName, acViewPreview, "", "DelDate Is Null" John...
Hi John, In the On No Data event of my Computer Register report I have Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data for this report....
Dave- If there are always 10 digits starting with the fourth position, you could do: Me.MemberNo = Mid(Me.MemberNo, 4, 10) If you need to scan character by...
Ilona- Add an error trap around your DoCmd.OpenReport. Setting Cancel = True creates a trappable 2501 error - your code canceled the action requested by the...
See Stephen Lebans page: http://www.lebans.com/mousewheelonoff.htm Dawn Crosier "Education Lasts a Lifetime" This message is posted to a newsgroup. Please...
Thanks for this John. I'm sorry, but I do not understand why I need he On Error BEFORE the DoCmd.openReport. The way I see it, the DoCmd.OpenReport is called...
Hi John, I put the On Error Resume Next before my DoCmd.OpenReport statement and it worked. I don't understand it, but I am very happy it works. Thank you...
Worked like a charm...Thank you !!!!! ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf Of John Viescas Sent: Monday, June 05,...
Ilona- Your DoCmd.OpenReport is asking that a report be opened. Your code in the NoData event of the report discovers the report is empty, displays a message,...
Thank you John. That makes sense. As you can see, I am still trying to get my head around event driven code. This is probably another dumb question, but do you...
Ilona- Flowcharts make sense in a batch sequential system, but not in the global scope of event-driven systems. I still build flowcharts for navigation ...
Hi John, What you say makes sense. I guess I am looking for a diagramatic way of presenting and event driven function. I am not imaginative and don't think ...
Greeding... How do I right click and paste (using mouse) into the Access 2003 Find and Replace Window? When I try to use this window to search for a record a...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
