Recent content by Ecron

Hey All, I am in need of a Date Repeater in which the user can select a Start Date and an End Date as well as any of the weekdays (denoted by checkboxes). These dates will then be used to insert entries within one of the tables via SQL. Does anyone have any examples of such a function or...

Mmm. Good idea! I'll give it a shot, Thanks

Hello, First, I'm using Access 07. I am opening up a form with a filter. I also have Navigation Buttons enabled on this form so the user has the ability to go through each of those records that are filtered out of the set. The problem is that with the Navigation Buttons toolbar comes the...

Yah. When I checked out the msdn article I came to that conclusion. I will just have to break them into individual INSERT statements. Thank you!

http://msdn.microsoft.com/en-us/library/bb208861.aspx I found that article. I'm hoping it will help me! :p

I am trying to insert into a table using the SQL INSERT INTO statement. The table I am trying to insert into is called t_comments. That table has 8 columns. This code works for 1 record: INSERT INTO t_comments VALUES (1,2,3,4,5,6,7,8); But, if I attempt to enter into multiple records: INSERT...

Thanks guys! I was having a similar problem and this helped me with it! :)

Hello. Firstly, I would like to thank you very much for your aide and advice. I notice now that there are two recordsetclones and was completely unaware of that. After editing the code to match your first example, the problem still arose and instead of highlighting the entire line it just...

I have been trouble with a function that i coded to requery a subform and keeping the same record position. My function is as follows: Public Function Search_AND_Requery(search As String, frm As subform, nPK As Integer) frm.Requery With frm.Form.RecordsetClone .FindFirst...

That's awesome! I was just searching for the answer to this... Thanks!

As idiotic as this sounds, if you right-click the form and choose FormFooter, and under Format please be sure that Visible is set to Yes.

I do not have the Northwind 2007 database, but from looking at it, it appears they are using a continuous subform with a header and footer. You could create a footer and then create a textbox in that footer with the recordsource: =Sum([Qty]), that would give you the sum of the quantity for the...

You could potentially build a query that has totalling enabled. If you did that, you could do a Group By selection on the primary key (the unique id of your table) and select Sum for each of the fields that you want totalled. This would give you the totalled amount for specific fields that are...

Moniker, Firstly, thanks for the reply. And here are the answers to your questions: I have tried using the DoCmd.FindRecord. It does not work because my PK is not selectable within the subform, which is the way I would prefer it. I am unaware of the Find Method, but after searching it within...

How can I select the record of a subform, using its PK, if that subform is continuous? I've searched the forums for quite awhile and seen the usage of bookmarks, and also read that bookmarks become invalid when records start getting deleted and that would propose a problem. Any aide would be...