Search results

There is a way, kind of. It looks a little silly though, because tabs containing the page captions stay gray no matter what you do. If you set the backstyle to transparent for the tab control, draw a box the same size, and set the fill color for the box to the desired color. You may need to do...

Myabe this will help. I am making a few assumptions. I am assuming that the table you are attempting to modify is the membership table which contains a MembershipID field and a PeopleID field. For each record where PeopleID is null, you want to assign the value from the MembershipID field. An...

In the afterupdate event of txtMonth Private Sub txtMonth_AfterUpdate() lstListbox.RowSource="Select Amount from YourTableName where YourTableName.month = '" & me!txtMonth & "';" lstListbox.requery end sub

What is the SQL statemtent for your query?

now open the subreport in design view (double-click it) and follow the same page setup procedure.

Please submit the table structures for both of your tables. Field names, and types, and the fields you want to add to table3. After I can get a better view of what you require I'll post back and include how to return the predefined number of records. Or you may email me your database if it...

TADA!!! Me.txtFile = "#" & .FileName & "#" A hyperlink address can have up to three parts separated by the pound sign (#): displaytext#address#subaddress When you've been assigning the filename to the textbox, it has been interpreted as the display text. Adding the # sign around the filename...

Normally, it's not a good idea to save a calculated field to a table. Why do you feel you need to save "P" or "U" in your table?

in the control source for the bal_staus use =IIF(total_bal=0,"P","U")

Try creating an unmatched query between the table that will store the value from the combo and a table that will list the values. Then set that as the rowsource for your combobox.

Filter list as you type Try this thread.

I did a little looking around, and if in design view of the form, you choose InsertHyperlink (you can fill in the path or leave it blank, but uncheck the relative path checkbox). This will insert a hyperlink label on your form. [Excerpt from help file] When you create a label this way...

Just an untested idea that I'm throwing out there for you. Have a ? command button on the form or a toolbar. When the button is clicked, set a public flgCancel variable to true and change the cursor icon to a ?. When a field is clicked, set cancel=flgCancel in the BeforeUpdate event of the...

Yes it is possible. My preferred method is to let the code build the SQL statement. Another method is to goof around with the QueryDef in code and add parameters then set set the parameter values which I've had to do a few times, but I'm not well versed (perhaps Pat can give you an example of...

In the report's design view, select file->page setup then click the page tab. Click the Landscape orientation and then save the report. Now preview the report. Did it fix your problem?

if you are referring to a textbox control on a report, and if I understand your situation. You added the textbox control from the field list for the report, so the textbox control is probably named field1. I think what will probably help is to change the name property for your textbox to...

Do you know what the name of this simple dbf file is? Where does the dbf file come from?

resolved .

I think dbl might be a "Database Link"? Click on the properties of the dbl file (right click then properties) and see if there is a target for the dbl file.

Create a new module then use this code (modify the table and field names) Public Sub AppendRecords() Dim db As Database Dim rst As Recordset Dim qdf As QueryDef Set db = CurrentDb Set rst = db.OpenRecordset("table2", dbOpenSnapshot) rst.MoveFirst Do Until rst.EOF Set qdf =...