Search results

Hello, I have a subform that displays selected records according to the relationship with the main form. On the subform I have a listbox to navigate through the records (navigation buttons are not visible). To populate the listbox I currently use a OnCurrent event of the subform to query...

Pat, Thank you for taking your time. The procedure I use to copy data from the Quote table/form to the Projects table/form is a button with a "OnClick" event. Since not all the projects have quotes, when the user comes up with a new project that has an associated quote he/she fills in the...

I have the following tables: tblProjects ProjectsID (Primary key - exclusive) ClientProjects tblProjectsDetails ProjectsDetailsID (Primary key) ClientProjectsDetails (Secondary key) tblQuotes QuotesID (Primary key - exclusive) ClientQuotes Service Rate tblQuotesDetails QuotesDetailsID...

Hello, I have a similar situation. However I have a table to each employee. The table is like: IO DateIO TimeIO IN 11/10/2004 09:02:00 OUT 11/10/2004 14:01:00 IN 11/10/2004 14:23:00 OUT 11/10/2004 20:27:00 IN 13/10/2004 08:32:00 OUT...

The version I posted had the problem with the query name: should be "qMemberStatus". Nevertheless, I get error 3164 with the code the the DB attached. If I remove the line rst!MailingListID = ctlRef.ItemData(i) only the first record is updated, regardless it is selected or not or how many...

Update records on same table Pat, I have used your example to set up a functionality that I need to implement. I have added a field "Status" to the tblMailingList and created a new form (frmStatus). I need to update multiple records with a given value. Please take a look at the "frmStatus"...

Not working to update same table Thank you for the nice DB example. I have modified in order to suit my needs. I need a particular field to be updated simultanously. However when I click the "update" button, only the first record of the list is updated, regardless which of them are selected...

Hello, Does any of you know how to make it possible to edit the fields of a form displayed as a dynamic table? If the form is displayed as a data sheet the records can be edited but when the form is displayed as a dynamic table the records CANNOT be edited. Basically I would like to have the...

No! If the user selects a record on the frmMain I want that same record to be displayed in there. As it is now, subform pops up. It should not.

Dave, Thank you for your help but it it not solve the problem. You understood the form/subform has to display the content of the list. In fact the list shows the result of a given search. The objetive is that when the user clicks over a given record in the list, such record is diplayed entirely...

Dave, Thanks for your reply. I have have not made myself clear in the message with the DB samples. What I want is: 1) use frmMain 2) when I select a record in the list, that record is displayed subfrmTest is displaying correctly... Any hint?

It does not seem to work in the way I need. I am attaching an example. First open 'subfrmTest' and click on any record of the list box. Then open the 'frmMain' and try to do same. Thanks,

Hello, I have the following command in a listbox: Private Sub List15_AfterUpdate() DoCmd.Requery "List15" DoCmd.OpenForm "fmProjects", , , "[ID] = " & Me.List15, , acDialog End Sub I want to use a similar command when the form "fmProjects" is within a tab of another form, such as...

Thank you both for your suggestions. It did work. I have to code in VBA to offer the users different forms to order the listbox. The code I have sent is just one of the several commands. Thank you!

Hello, I need to have a query written in VBA and I am having problems with the WHERE paramater: Private Sub Comando38_Click() Dim strSQL As String, strOrder As String, strWhere As String 'This is the original SQL query 'SELECT Projetos.[Número], Projetos.[Nome], Projetos.Deadline...

Thank you mike.

The fact is that due to the large number of combinations I cannot let the user make them. I need them made automatically. What the client tells me is that he cannot guess which invoices have been paid as he issues invoices in a continued basis. I also thought of a math prof. But there should...

There are not too many records. Not more than 20. My client issues invoices with different amounts. When their clients pay him, he wants to know each invoice that refers to a specific amount. Lets say the Client A pays him a total amount that corresponds for the payment of 4 or 5 of the due...

Hello, I need to know which records sum up to a given value. Lets say I have the following entries in a table: 1 = 78 2 = 56 3 = 120 4 = 24 5 = 480 6 = 89 7 = 489 8 = 98 9 = 54 10 = 569 If I provide to the query the value 752, I need to know which records sum this amount. In this example I...

Any ideas at all?