RE: [ms_access] Time calculations for flight operations
Hi Dave, I have done something similar, but not to this extent. This is a great application for Access Basic of which I don't know very much, so I used querys instead. For each group/range of data I counted I had a separate query and eventually I linked all the query results via a common key value = 1. To explain this a bit better. The first query would count OpsTime = 7:00 and = 07:59 and the output from this query was in the format Field 1 Field 2 = Qry01 Expr:=1 OpsTime Count Criteria = 07:00 and = 07:59 The next query would count OpsTime = 8:00 and = 08:59 and the output from this query was in the format Field 1 Field 2 = Qry02 Expr:=1 OpsTime Count Criteria = 08:00 and = 08:59 etc for the 24 hours. Sorry I'm not giving you the correct syntax here. I'm just passing on the concept. At the end you have a Qry in which you select all these interim queries and link them via the common Field 1 which equals 1 and this will result in one line of data of 25 fields; ie Flield 1 Qry01.Field2 Qry02.Field2 . Qry24.Field2 I am not sure, but I believe that when this runs the querys are nested. There may be an ACCESS limitation on the number of querys you can string together like this. If you decide to go ahead with this method try 2 or 3 querys first and combine their results into one line of data, before you go ahead and develop the 24 querys only to find out that they don't work. I use ACCESS 97 and if you want more help on this, perhaps you can contact me privately. Ilona Wright Adelaide, Australia -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dave Moreau Sent: Monday, 1 May 2006 1:52 AM To: Access Newsgroup (E-mail) Subject: [ms_access] Time calculations for flight operations I have a field that is listed as OpsTime. It is the time a flight either arrives or departs our airport. I am interested in grouping all times as a total Ops per hour for a graph in Access but am having a difficult time trying to determine how to do this in one query (if this is possible). I imagine a count function will be the appropriate calculation. Is this a good problem for a crosstab query to solve. or is there another way to sort all flight times and group them by the hour for a total number of ops per hour? In such a manner that I can graph the results? (all flight times are military times) OpsTime 07:00 07:10 07:30 08:00 08:05 08:15 08:20 08:40 08:45 08:50 08:55 08:55 This group of times will provide the following results if the query works as I hope: 0700 to 0759 = 3 0800 to 0859 = 9 I will use the numbers per hour of flight ops to produce a line graph showing flight activity peaks and valleys throughout the day. Thanks for any ideas! Dave This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software -- YAHOO! GROUPS LINKS a.. Visit your group ms_access on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -- [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access]MsgBox Error Help Please
Ilona- I assume this code is running in frmAssets. If so, then use the Exit event instead and do: Private Sub ReplacementValueDate_Exit(Cancel As Integer) On Error GoTo ReplacementValueDate_Exit_Err If (Me.ReplacementValue 0) And _ IsNull(Me.ReplacementValueDate) Then Beep MsgBox Please enter Replacement Value Date, vbOKOnly, Cancel = True End If ReplacementValueDate_Exit_Exit: Exit Sub ReplacementValueDate_Exit_Err: MsgBox Error$ Resume ReplacementValueDate_Exit_Exit End Sub The error is occuring in the GoToControl - you can't change the focus in the LostFocus event. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Friday, April 28, 2006 11:54 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access]MsgBox Error Help Please Hi John, I need more help please. In my form frmAssets I have 2 controls; [ReplacementValue] and [ReplacementValueDate]. If a Replacement Value is entered I want to force the user to enter a Replacement Value Date. The following piece of code is converted from a macro I created. I did this so that I could de-bug it, because when this condition is true, the focus would not return to the ReplacementValueDate. The message box displays and then control goes to MsgBox Error$. Can you please give me a clue as to why this is happening? I have done similar bits of code but not with dates in them, and I can't see what is wrong with this. Thank you in anticipation Ilona Adelaide, Australia Private Sub ReplacementValueDate_LostFocus() On Error GoTo ReplacementValueDate_LostFocus_Err If (Eval([Forms]![frmAssets]![ReplacementValue]0 And [Forms]![frmAssets]![ReplacementValueDate] Is Null)) Then Beep MsgBox Please enter Replacement Value Date, vbOKOnly, DoCmd.GoToControl [ReplacementValueDate] End If ReplacementValueDate_LostFocus_Exit: Exit Sub ReplacementValueDate_LostFocus_Err: MsgBox Error$ Resume ReplacementValueDate_LostFocus_Exit End Sub [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Batch Import Question
Gary- Short of writing some nasty code to open the text files directly, no. What's wrong with issuing several TransferText commands back-to-back? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Gary E. Daniels Sent: Saturday, April 29, 2006 4:16 PM To: ms_access@yahoogroups.com Subject: [ms_access] Batch Import Question Hi. I'm using Access 97 (still). I'd like to know if there is a way to batch import files. I have numerous text files. All are identically structured and delimited. Each text file contains data for 1 record of an Access table. I can import these one-by-one, but wonder if there is a way to import them all at once. Or, somehow combine all the data into one text file, then import that file. Thanks. Gary Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Code Help
Garry- How did you construct the switchboard? With the Switchboard Manager? Or, is it home grown? If the latter, open the form in Design view, select the command button you want to investigate, open the Properties window, and on the All tab scroll down until you find the On Click property. You should see either [Event Procedure] or a macro name in that property. Click in the property and then click the Build button (...) next to the property setting to open the code or macro. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Garry Sent: Saturday, April 29, 2006 7:46 PM To: ms_access@yahoogroups.com Subject: [ms_access] Code Help i recently got some very good help from one of our members here on a Comic Book database I was putting together. Now I want to create another command button on one of my switchboards that is similar to the one she helped me with. I want to copy and edit the code from the first button, but I'm having trouble now even finding the code. I know I looked at it and changed it before. But now all I seem to be able to find is some very simple basic code and not the explicit instructions. I know I'm probably just not looking in the right way. Could someone please help me out? Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Time calculations for flight operations
Dave- How about: SELECT Hour(OpsTime) As OpsHour, Count(OpsTime) FROM MyTable GROUP BY Hour(OpsTime) I thought the Partition function might also work to give you a range, but Help says it works only with whole numbers, and a time value is a fraction of a day. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dave Moreau Sent: Sunday, April 30, 2006 6:22 PM To: Access Newsgroup (E-mail) Subject: [ms_access] Time calculations for flight operations I have a field that is listed as OpsTime. It is the time a flight either arrives or departs our airport. I am interested in grouping all times as a total Ops per hour for a graph in Access but am having a difficult time trying to determine how to do this in one query (if this is possible). I imagine a count function will be the appropriate calculation. Is this a good problem for a crosstab query to solve. or is there another way to sort all flight times and group them by the hour for a total number of ops per hour? In such a manner that I can graph the results? (all flight times are military times) OpsTime 07:00 07:10 07:30 08:00 08:05 08:15 08:20 08:40 08:45 08:50 08:55 08:55 This group of times will provide the following results if the query works as I hope: 0700 to 0759 = 3 0800 to 0859 = 9 I will use the numbers per hour of flight ops to produce a line graph showing flight activity peaks and valleys throughout the day. Thanks for any ideas! Dave This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Time calculations for flight operations
Yep, I tried partition because it seemed the best solution for what I am trying to accomplish. I was even trying to think about returning whole numbers for times and then accomplishing the partition. Will try your solution. Thanks again! Dave -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of John Viescas Sent: Monday, May 01, 2006 2:28 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Time calculations for flight operations Dave- How about: SELECT Hour(OpsTime) As OpsHour, Count(OpsTime) FROM MyTable GROUP BY Hour(OpsTime) I thought the Partition function might also work to give you a range, but Help says it works only with whole numbers, and a time value is a fraction of a day. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dave Moreau Sent: Sunday, April 30, 2006 6:22 PM To: Access Newsgroup (E-mail) Subject: [ms_access] Time calculations for flight operations I have a field that is listed as OpsTime. It is the time a flight either arrives or departs our airport. I am interested in grouping all times as a total Ops per hour for a graph in Access but am having a difficult time trying to determine how to do this in one query (if this is possible). I imagine a count function will be the appropriate calculation. Is this a good problem for a crosstab query to solve. or is there another way to sort all flight times and group them by the hour for a total number of ops per hour? In such a manner that I can graph the results? (all flight times are military times) OpsTime 07:00 07:10 07:30 08:00 08:05 08:15 08:20 08:40 08:45 08:50 08:55 08:55 This group of times will provide the following results if the query works as I hope: 0700 to 0759 = 3 0800 to 0859 = 9 I will use the numbers per hour of flight ops to produce a line graph showing flight activity peaks and valleys throughout the day. Thanks for any ideas! Dave This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+access+databasew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=hc7Za8QzEj1t7F8GW0yzhA access database Database http://groups.yahoo.com/gads?t=msk=Database+development+softwarew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=i5H8GCn7HzmglwpvhJg19w development software Database http://groups.yahoo.com/gads?t=msk=Database+management+softwarew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=kzlRmjQuUTEFLTjkEd6-kg management software Database http://groups.yahoo.com/gads?t=msk=Database+softwarew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=CoCmr_EubT5Xd83NiQjcpg software Inventory http://groups.yahoo.com/gads?t=msk=Inventory+database+softwarew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=DHnS8Uu1ImyGVg1J4k0BMw database software Membership http://groups.yahoo.com/gads?t=msk=Membership+database+softwarew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=uEGHlFpqbscHu8mCHe7tzg database software _ YAHOO! GROUPS LINKS * Visit your group ms_access http://groups.yahoo.com/group/ms_access on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . _ [Non-text portions of this message have been removed] SPONSORED LINKS
[ms_access] Re: Cursor Type
adOpenDynamic = allow updates, MoveNext, MovePrevious adOpenStatic = Read only, MoveNext, MovePrevious, Bookmark adOpenForwardOnly = allow updates, MoveNext only adOpenKeyset = allow updates, Bookmark LockType adLockBatchOptimistic = Indicates optimistic batch updates. Required for batch update mode. adLockOptimistic = Indicates optimistic locking, record by record. The provider uses optimistic locking, locking records only when you call the Update method. adLockPessimistic = Indicates pessimistic locking, record by record. adLockReadOnly = Indicates read-only records. You cannot alter the data. --- In ms_access@yahoogroups.com, tam_yehia [EMAIL PROTECTED] wrote: Hi all, i'd like to ask a question: what is the difference between Access cursor type values (adopendynamic, adopenstatic, ...) and also what's the difference between all lock type values (optimistic, readonly, ...etc). and when to use each one. thanks SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [ms_access] Time calculations for flight operations
One last questionI have tried to do this...is there a way to break down from hours into 15 minute increments? Dave -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dave Moreau Sent: Monday, May 01, 2006 8:23 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Time calculations for flight operations You're incredible Johnfirst timeand voila...exactly what I needed. Thanks John! I spent all day yesterday trying to figure this one outgeez I hate it when there is an easier, efficient, solution! Thank you Ilona as wellI was going to try your solution too but this one did exactly what I needed. You're all appreciated by this medium skilled Access man...thanks for sharing your knowledge and time! Dave -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dave Moreau Sent: Monday, May 01, 2006 7:59 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Time calculations for flight operations Yep, I tried partition because it seemed the best solution for what I am trying to accomplish. I was even trying to think about returning whole numbers for times and then accomplishing the partition. Will try your solution. Thanks again! Dave -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of John Viescas Sent: Monday, May 01, 2006 2:28 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Time calculations for flight operations Dave- How about: SELECT Hour(OpsTime) As OpsHour, Count(OpsTime) FROM MyTable GROUP BY Hour(OpsTime) I thought the Partition function might also work to give you a range, but Help says it works only with whole numbers, and a time value is a fraction of a day. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dave Moreau Sent: Sunday, April 30, 2006 6:22 PM To: Access Newsgroup (E-mail) Subject: [ms_access] Time calculations for flight operations I have a field that is listed as OpsTime. It is the time a flight either arrives or departs our airport. I am interested in grouping all times as a total Ops per hour for a graph in Access but am having a difficult time trying to determine how to do this in one query (if this is possible). I imagine a count function will be the appropriate calculation. Is this a good problem for a crosstab query to solve. or is there another way to sort all flight times and group them by the hour for a total number of ops per hour? In such a manner that I can graph the results? (all flight times are military times) OpsTime 07:00 07:10 07:30 08:00 08:05 08:15 08:20 08:40 08:45 08:50 08:55 08:55 This group of times will provide the following results if the query works as I hope: 0700 to 0759 = 3 0800 to 0859 = 9 I will use the numbers per hour of flight ops to produce a line graph showing flight activity peaks and valleys throughout the day. Thanks for any ideas! Dave This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Microsoft http://groups.yahoo.com/gads?t=ms http://groups.yahoo.com/gads?t=ms http://groups.yahoo.com/gads?t=msk=Microsoft+access+databasew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=hc7Za8QzEj1t7F8GW0yzhA k=Microsoft+access+databasew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=hc7Za8QzEj1t7F8GW0yzhA k=Microsoft+access+databasew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=hc7Za8QzEj1t7F8GW0yzhA access database Database http://groups.yahoo.com/gads?t=ms http://groups.yahoo.com/gads?t=ms http://groups.yahoo.com/gads?t=msk=Database+development+softwarew1=Microsoft+access+databasew2=Database+development+softwarew3=Database+management+softwarew4=Database+softwarew5=Inventory+database+softwarew6=Membership+database+softwarec=6s=190.sig=i5H8GCn7HzmglwpvhJg19w
RE: [ms_access] Re: Code Help
OK. What is in the On Click property of the command button that you want to investigate? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Garry Sent: Monday, May 01, 2006 4:10 PM To: ms_access@yahoogroups.com Subject: [ms_access] Re: Code Help Unfortunately, my switchboard is kind of a mix. I've used both the switchboard manager on it and I've done some stuff in design view. It was originally created with switchboard manager, though. I can see code in the way you suggest, but can't seem to find the correct code. I see a very simple code that doesn't show the full code that I know is there somewhere. --- In ms_access@yahoogroups.com, John Viescas [EMAIL PROTECTED] wrote: Garry- How did you construct the switchboard? With the Switchboard Manager? Or, is it home grown? If the latter, open the form in Design view, select the command button you want to investigate, open the Properties window, and on the All tab scroll down until you find the On Click property. You should see either [Event Procedure] or a macro name in that property. Click in the property and then click the Build button (...) next to the property setting to open the code or macro. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Garry Sent: Saturday, April 29, 2006 7:46 PM To: ms_access@yahoogroups.com Subject: [ms_access] Code Help i recently got some very good help from one of our members here on a Comic Book database I was putting together. Now I want to create another command button on one of my switchboards that is similar to the one she helped me with. I want to copy and edit the code from the first button, but I'm having trouble now even finding the code. I know I looked at it and changed it before. But now all I seem to be able to find is some very simple basic code and not the explicit instructions. I know I'm probably just not looking in the right way. Could someone please help me out? Yahoo! Groups Links Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[ms_access] Re: Code Help
Thanks again, Dawn. That tot my new report going. Now, for some reason, the command button for the Artist report that you helped me with is not working. I don't know. I don't think I touched that one. The command button still says to open that form, but nothing happens. --- In ms_access@yahoogroups.com, Dawn Crosier, MVP [EMAIL PROTECTED] wrote: Garry - I was the one who helped you a while ago. You have code behind the following forms: Switchboard. frmSelectArtist and Artist Form The one I helped you with is the frmSelectArtist. The switchboard opens frmSelectArtist. The combo box is an unbound combo box which populated by a query that is stored in the properties of the combo box. When you click the command button it opens the report called ByArtist The recordsource of the report uses the Query called Artist. The combo box called is used as the criteria of the Artist 1, 2, 3, 4, and 5 fields. [Forms]![frmSelectArtist].[cboArtist] Not knowing exactly what you are attempting to do, but I suspect that you need to setup your query so that your report filters for you based on the values you select in a combo box. Hope that helps get you going. Dawn Crosier Education Lasts a Lifetime This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. - Original Message - From: Garry [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Saturday, April 29, 2006 12:45 PM Subject: [ms_access] Code Help i recently got some very good help from one of our members here on a Comic Book database I was putting together. Now I want to create another command button on one of my switchboards that is similar to the one she helped me with. I want to copy and edit the code from the first button, but I'm having trouble now even finding the code. I know I looked at it and changed it before. But now all I seem to be able to find is some very simple basic code and not the explicit instructions. I know I'm probably just not looking in the right way. Could someone please help me out? Yahoo! Groups Links SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [ms_access] Re: Code Help
Which button? The one on the switchboard? Or the one associated with the combo box? Did you happen to rename the report? Dawn Crosier Education Lasts a Lifetime This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. - Original Message - From: Garry [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Monday, May 01, 2006 3:06 PM Subject: [ms_access] Re: Code Help Thanks again, Dawn. That tot my new report going. Now, for some reason, the command button for the Artist report that you helped me with is not working. I don't know. I don't think I touched that one. The command button still says to open that form, but nothing happens. SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [ms_access] Max Size
How many fields are you importing at one time? If more than 255 then you are exceeding the capabilities of the Table Design, not the number of records. Dawn Crosier Education Lasts a Lifetime This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. - Original Message - From: Jeanette Garcia [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Monday, May 01, 2006 3:59 PM Subject: [ms_access] Max Size I'm trying to import just under 420K records and am receiving a Database has reached maximum size error. How can I import this file? Thanks, Jeanette~ SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[ms_access] Re: Code Help
That info was already there. I redid it anyway. It still doesn't work. I created a new button with the same stuff, and this one seems to work. --- In ms_access@yahoogroups.com, Dawn Crosier, MVP [EMAIL PROTECTED] wrote: Go into the Switchboard Manager. Select the Reports switchboard. Click the Edit button. Highlight Comics by Artist. Click the Edit button. Text should say Comics by Artist Command should say Open Form in Edit Mode Form should say frmSelectArtist Click OK, Close, Close. Dawn Crosier Education Lasts a Lifetime This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. - Original Message - From: Garry [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Monday, May 01, 2006 4:04 PM Subject: [ms_access] Re: Code Help It's the switchboard button. The report still works on it's own. I can't imagine that I renamed the report. SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[ms_access] Re: Code Help
I don't know. It seems like everytime I do something, comething else gets disabled. Now my new button doesn't work. Maybe I should make a new switchboard. --- In ms_access@yahoogroups.com, Dawn Crosier, MVP [EMAIL PROTECTED] wrote: Glad to hear you got it working. Dawn Crosier Education Lasts a Lifetime This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. - Original Message - From: Garry [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Monday, May 01, 2006 4:25 PM Subject: [ms_access] Re: Code Help That info was already there. I redid it anyway. It still doesn't work. I created a new button with the same stuff, and this one seems to work. SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[ms_access] Pls Recommend Access Class in SF Bay Area
Does anyone recommend a MS Access class in the San Francisco Bay Area? Thanks. [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.