Search results for query: *

No problemo and thanks for the star -- Fast Learner, I Think Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

You need to bind the control to the field at one point or another, via code or the control's properties. Check the control source of the control itself. An always unbound control is useless always. -- Fast Learner, I Think Here's something to think about. How come you never see a headline like...

OR you can leave the recordsource as you have it now and using the command button, you can change it to the SQL. Then if you wish, you add another command button to reset to standard recordsource. -- Fast Learner, I Think Here's something to think about. How come you never see a headline like...

Correct, but you can set the subform visible property to false to avoid seeing "#Name?" on every text box, and right after you assign the recordsource make it visible. -- Fast Learner, I Think Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? -...

If you are using bound forms, that is normal. I believe you can only link a subform to a form using 1 field, which appears to be the group number in this case. Of course, if you can link multiple fields, I wouldn't know because I have never seen a need for such. If you prefer both fields to be...

By the way, use "OR" instead. Not AND because one field cannot have three different values. And you are probably hoping the results will be all records in which the specific field has one of the values selected. -- Fast Learner, I Think Here's something to think about. How come you never see a...

Seems I skipped over that one. Still it doesn't seem it was resolved, but an alternative was applied. I know, the key thing is that it works. [pipe] -- Fast Learner, I Think Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

Reposting because more than likely if you tried the above you got some errors. Tested with message box but not with actual process, but noticed the syntax error after reviewing my post again. Please try this instead. Sorry for the oversight. Any questions or errors let me know. Private Sub...

Could it be that perhaps you have a line of code somewhere which sets the visible to false for all controls? -- Fast Learner, I Think Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

You can right click on any object and select object dependencies. Not sure if this is what you were looking for, but maybe it helps. -- Fast Learner, I Think Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

Have you tried something like this? Please note that the sample is from a multi column listbox. Therefore I am indetifying a specific column. Private Sub cmdTest_Click() Dim lst1 As ListBox, itm As Variant, strSql As String Set lst1 = Me.lstCurrent strSql = "SELECT * FROM tblInventory" If...

subbywrx, Do you want a nagging pop up? Or display "Unregistered" all the time? For both, you could try something like this. On Main Form: Private Sub Form_Load() Me.txtHidden = 1 Me.TimerInterval = 2000 End Sub Private Sub Form_Timer() If Me.txtHidden = 1 Then If Reg =...

First thread you mention opening a subform. If that is what you need the following sample code should work. on main form Form_Load me.sfmPassword.visible = false on main form "Delete" command button me.sfmPassword.vidible = true me.sfmPassword.setfocus on "OK" command button in subform...

You have to have a unique field which you can connect through all tables. Unfortunately you don't have the client number on all tables (it would have been the simplest solution). If names are mispelled, you will probably need to correct the misspelled names on the tables first to be able to...

The delete button opens the subform and grants the focus to the subform where you enter the password. Before you can expect it to delete the record on the main form, you need to set the focus back to the main form. Otherwise you are deleting the password entry and indeed it did delete a record...

What is not showing? the data in the fields or the fields themselves? If it's the fields, check properties to ensure that "Visible" is set to "Yes" -- Fast Learner, I Think Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

Can't see why it would create records automatically. The only way this will happen I think is if you hit the spacebar in any one field. Even with default values, it should not save records unless an entry has been made. If you are trying to make sure certain fields are entered before saving...

Open Main Form in Design View. Select Subform, right click and select properties. You will see the Link Child and Link Master field properties on the DATA tab. -- Fast Learner, I Think Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

should be fine if you follow fneily's suggestions. link master (SurveyID from main form) to child (SurveryID from subform) in form properties and ensure that they are both the same datatype. If SurveyID in main form is an autonumber (I suspect it would be), then SurveyID in the subform should be...

What is the field name? "frm_Software_Home" or "frm Software Home"? if it is the first one, then it should be fine. If it is the second one, then remove the underscores. Let me know if that works. -- Fast Learner, I Think Here's something to think about. How come you never see a headline...