Search results

You'll have to loop through your recordset and examine the values of each entry for the fields "Provnam" and "Authno". You also need to sort your recordset first on "Provnam" Ascending. This will bunch all the like entries one after the other so that you can loop through each individual...

You can turn off the annoying message: DoCmd.SetWarnings False

Suggest you store the result of your first query into a temp table, then use that temp table as the source of your second query.

Please unzip attached file. I'm sure you can follow it.

It appears to me that you are using the same query statement as the source of your two comboboxes. You need to create two queries, one for each combobox and do your sorting on whatever field you need to sort on for each one of them.

Try this: Private Sub ApplyBtn_Click() Docmd.RunCommand acCmdSaveRecord ' <<< add this line AreaList.SetFocus 'this is because you can't disable a control (the applybtn) when it has the focus AreaList.Requery '<==== THis is supposed to repopulate the listbox, but it doesn't do it...

I did not get your zipped db. Afraid can't help you without that.

Docmd.setwarnings false should do the trick.

The subform contents you posted doesn't seem to correspond to the query you said you used to create it. Perhaps you can zip your database and e-mail it to me and I'll see if I can help you any further. Send it to edtab@hotmail.com

In the afterupdate of your assets and also in the afterupdate of your liabilities, code it as follows: Me.Equity = Me.Assets - Me.Liabilities. I believe that is all you have to do, if I understand your problem correctly.

You should be able to control the visibility of your two subforms. You can lay your subforms one on top of each other and control each visibility such that if you want to show subform1, you would turn its visibility on and turn off the visibility of subform2. The reverse would be true if you...

Annent to my earlier comment: You do not have to drop down your combobox to capture the partname. With an autocomplete combobox, all you have to do is type in the part number and if there is a match, it will automatically go to that record and as soon as you hit enter, it should then display...

You should be using a combobox instead of a text box for your 'PK_partNumber' . When you drop down your combobox, you should be able to capture the 'partname' using the following code in the afterupdate: Me.partname = me.comboboxname.column(1) Make sure your combobox has at least two columns...

It would appear to me that it is possible for you to link the text file to DB1 then do the updating of the tables from DB1 as well by copying the existing update code from DB2 into DB1. As long as you link all the necessary tables to be updated to DB1, then you should be able to do everything...

Try replacing "Child845" with "frmFinanceProposalDialogue1". This might work.

Product Directorate criteria: ([forms]![frmWhatDates].[cboPD]) or ([forms]![frmWhatDates].[cboPD is null) If you examine the above entry, you will notice that you are missing a closing square bracket in "cboPD". I think this might be your problem.

Open the database where form1 is residing. Go to Tools, StartUp, Display Form then choose the form you want to display first. That should do it.

I have come across the same problem in the past and the way I got around it was to test for the number of records sitting in the report's recordset source (usually a query) before issuing the docmd.openreport statement. If the record count is equal to zero, then I pop up a message box...

Here's an example of selecting a date range (from - to) which a user has input on a form. You have to modify it accordingly. SELECT tblOrders.RequiredDate, tblOrders.OrderDate, tblOrders.CompanyName, tblOrders.OrderedBy, tblOrders.CustomerPO FROM tblOrders WHERE (((tblOrders.RequiredDate)...

You should run instal first, split your database, then make the front end an mde. Alternatively, you can make an mde first then split the mde second. The splitting part is relatively painless as this is handled by a wizard in Access. I have split a number of databases and have not come across...