Search results

Couldn't unzip your project - can you make a copy with less data and remove unnecessary forms etc, rezip and send. By the way I am using A2k. It is bedtime for me here so I will not be able to look at it till morning. Some things for you to try. I assume the RecordSource for your main form...

You will need to write the values to a table if you want them to be available next time you restart the database. Set up the rowsource for the combo to the table. Add something like this to your NotInList module, you might want to include some error handling - Dim db As Database, rs...

Andrew In your "Update" button code, try adding Me.Requery after the update command. peter

Andreas Private Sub cboComboBoxName_AfterUpdate() Select Case cboComboBoxName Case 1 Case 2 Case 3 Me.SubForm4.visible = false Me.SubForm5.visible = false Case 4 ... End Select End Sub If you are currently doing something like this and it is not working, then show us your code. Peter

Elhan, you're welcome to send it to me at peter_rallings@dodo.com.au and I will see if I can help.

What is in the Row Source, Column Count and Column Widths Properties of your combo box?

Here is another method I came across. Particular example ignores report name if it starts with sub (for subReport) and as with SJ's solution inserts a space before Capital letters. ----- Public gsReportList() As String Public giNumReports As Integer Sub BuildList() Dim l_db As Database...

I have several forms each with a listbox - users search or click a line in the listbox to move to that record. The listbox can be sorted on any of the columns by clicking on a column header. If the listbox is filtered or sorted then I use the listbox SQL as form recordsource to have everything...

thanks Pat - that makes a lot of sense. I will either overcome my parameter query/subform development phobia or test with parameter held in subform until I'm through testing. thanks all for your input on this... Peter

Len, hate to be the one to point it out, but you, as a psychiatric researcher, should be a little worried when you start talking to yourself.... and more so when you answer.

Thanks Pat, I will revert to the two query method. I am using stored querydef, but instead of setting the criteria via Forms!formname.control etc.... I am getting the qdf via code, modifying it and recreating the stored querydef. I am doing this mainly because of my intense hatred of the...

tried the expression in brackets SELECT tPlayers.LastName, tPlayers.FirstName, tPlayers.Handicap, tScores.PlayDay, tScores.GrossScore FROM tPlayers LEFT JOIN tScores ON (tPlayers.ID = tScores.PlayerID AND tScores.PlayDay = 1); but it only returned records on both sides (like an Inner join)...

I tried the solution suggested by FoFa and got the error - Join expression not supported. My actual SQL is:- SELECT tPlayers.ID, tPlayers.LastName, tPlayers.FirstName, tPlayers.Handicap, tPlayers.Status, tPlayers.Comment, tScores.PlayDay, tScores.DayHandicap, tScores.GrossScore FROM tPlayers...

Thanks FoFa

DLB, That's what I wanted.. thanks vm.

The value entered into your contact combo is 'NewData'. The value selected in your client combo box is me.cboClient if it is the bound column or me.cboClient.column(n) where n is the column you are after.. starting at column 0. use something like: Dim strOpenArg as string strOpenArg = NewData &...

I have two tables joined thru the ID field TableA ====== ID, fldA, fldB TableB ===== BID, fldC, fldD I am wanting to list all records from TableA and those fields from TableB where fldD = X. My current SQL, which works fine, to print all records is: SELECT TableA.fldA, TableA.fldB...

Thanks Pat, I will rethink the table layout. I originally moved away from that as the client will basically download the championship players from another system. The seperate db's made it simplier to do most functions for each comp - anyway will rethink. As far as women members are concerned...

Thanks a lot , lobodava, that was perfect.

I am wanting to change the db where my linked tables via code. I have an access application that remains consistent with only one concurrent user. each user may belong to a different group and I was wanting to keep their data seperate in linked tables. the application would have a menu such as...