Search results

i've given up and taken the easy route out. A subform. Thanks for your attempts RG!

the checkboxes are called "chkQuestion1, chkQuestion2,..." I tried: chkQuestion(loopy).Visible = False to no avail. says that chkQuestion isn't defined, but i don't know what to dim it as. I have to leave the office now, but i'll be back tomorrow to grab this database by the balls and finish...

I've got 20 checkboxes which i need to do the same thing but individually. If IsNull(DLookup("[question 1]", "qryQuestions")) Then chkQuestion1.Visible = False Else chkQuestion1.Visible = True End If I tried this: Dim loopy As Integer Dim tmpquest As String For loopy = 1 To 20...

I had this problem and i fixed it but i don't know how i did it. i THINK that it's got something to do with the "Enter Key Behavior" being bugged or something.

code isn't necessary, but it would work. On the form properties there is a DataEntry option... put that to yes, and allow edits and additions. That should work for your needs.

I'm going to assume that the form is set to data entry mode and all additions and deltion setting are "yes"?

before anyone else says it: You shouldn't give more than one person access to the same database. Use the database you have currently as a backend, and create a front end (a replica) which links to the tables in the backend. This probably has nothing to do with your problem, but having more...

Put this in your row source for the combo box, chaning Name to the field you want displayed and MyTable to wherever the data is stored: SELECT [Name] FROM MyTable ORDER BY [Name]; Change Column count to 1, and bound column to 1 Hope this helps.

Private Sub cmbCompanyName_AfterUpdate() 'Me.RecordSource = "SELECT * FROM [qryDataEntry] WHERE [company name] = '" & cmbCompanyName & "'" Text2 = [cmbCompanyName] & " - Mystery Shop" Me.Refresh Me.Caption = [cmbCompanyName] & " - Mystery Shop" QuestionTick End Sub Private Sub...

When the cmbbox is updated, it goes to a sub which does all these changes. so, apart from making the checkboxes visible, it doesn't affect the updating.

no problem. :)

don't save as Jpg in paint... only saves at 60% quality and looks poor. If it's a reccuring image then find the first instance of the pattern and try your damndest to get it as small as possible. Then just repeat the image in the form.

OR Let's say the fields in the table you want updated on click were "field1", "field2" and "field3". Put those fields in the form bound to the right place and hide them. Create 3 new textboxes that are unbound and call them "txtField1" etc... In the onclick event, just put: field1 = txtfield1...

They're linked to fields in the record source, so there is none. The only code that links them both is a whole bunch of If statements (caution, this is messy code, but i'm still in early development): If IsNull(txtQuestion1) Then chkQuestion1.Visible = False txtQuestion1.Visible =...

=DLookUp("[question 1]","Questions","[Company Name]='" & [cmbCompanyName] & "'") next to these text boxes are checkboxes, once when ticked, all textboxes with DLookUp flicker.

glad to help :)

I'm using 2003. I don't really want to dive into using code for all 20 text boxes. would it be an idea to turn echo off when the form is opened? and hen turn it back on when the form is closed? or will that defeat the object? my other option would be to create a subform with a different...

I put this in my combobox's "AfterUpdate" and it made my access crash... HAH! Where should i put this?

Glad to help. I'm not a pro with access but coming here and reading random topics has taught me a lot! I suggest coming here even if you don't need help, it's good for learning new things about access.

Glad to help. I'm not a pro with access but coming here and reading random topics has taught me a lot! I suggest coming here even if you don't need help, it's good for learning new things about access.