Search results

Is what I'trying to do even possible?

It is getting better but the problem now is that my computer thinks it has to add the value of strField and not the value which is already entered in the [strField] of the record to be changed. What is going wrong? As far as the other part of the If Else statement, I have been trying to...

I have been trying to figure it out, and ended up messing around with VBA. After hours of endless error messages, I have posted a clearer description of my problem on the Modules and VBA forum. Any help may save tons of hair from being pulled out...

Hello, I will be forever greatful to anyone who can help me with this. Here's my problem: In a form based on a query, I want to modify al the records by using a command button. Here is what I have so far: When one clicks the command button, a form with three controls opens: Field (combobox)...

I use a query.

Hi everybody, I would appreciate any help I can get on the following: I have a form that is based on a query. What I would like to be able to do is to create a command button that allows me to change all the selected records at once. e.g. one of the fields is a text box containing relevant...

Thank you Thank you for helping me to move forward!

I fail to create a button on a form which opens another access database if clicked. Any suggestions anyone? Thanks!

thanks Thank you. It works the way I want it to now.

I have the following code: For i = 0 To conMaxControls - 1 If f.Controls("cbxFld" & i).Enabled = True Then If f.Controls("cbxFld" & i).Value = strcbxFld Then f.Controls("txtVal" & i) = strKeyword f.Controls("txtVal" & i).SetFocus End If End If Next i strcbxFld is a string...

You have done it yet again! Thank you!

How do I do that?

I have a command that creates a table1. However, when I run it two times, I get an error message because table1 already exists. That's why I used the command DoCmd.DeleteObject "Table1" in the Err_Create_Table section. However, when there is no table1, I get an error message. Is it possible to...

I have five controls named cbbx0 to cbbx4 on selectionform. I have a loop for i = 0 to 4. I have f set as forms!selectionform How can I refer to the controls? If have this For i = 0 to conMaxControls - 1 If f.["cbbx" & i].enabled Then ... But it doesn't work. Can anyone help me? Thanks...

Hi, I have the following problem: I have a search form that searches a table which is composed of various tables of other databases (built with append queries). Because the table is composed of different tables (of different people), their keywords may vary (basic list which can be updated by...

OK. Now it works. Thank you.

Query1 Query1 is a query created using db.CreateQueryDef right before I create table1

comment here is what is have so far: db.Execute "SELECT Query1 INTO " _ & "[Table1] FROM Datatable; " Query1 is a query selecting records fro m Datatable

Hi, can anyone tell me whether it is possible to create a new table1 in which all the results of query1 are entered by using the select ... into command? I just don't seem to manage to do it. Thanks.

That did it for me. Thank you. When I run the command, I get a message box now. Is there a way I can avoid that?