Search results

I am assuming you will be ridding yourself of the program table because you don't need it anymore? Anyway... Create another field in your table for the program name. Update to the new field to the program name based on the program number field, then delete the number field that you no longer...

OK, so if the text box matches any entry in the table (in a given field), you want the condition to return true. There are two ways to do this: The first way is to put the code in the form as a sub. The second is to set it up as a function so you could call it from more than one place. Below is...

Not entirely sure what you want to do there. What does "if x is in the table" mean? You mean, for each record, if the value of Field A is x then do this...? Check the Select Case statement. This may help you. Or post a little more detail and we'll hash it through. [This message has been edited...

I am not sure what you mean by "switchboard". To accomplish what you want, simply create a button (or label) and place the code you want in the OnClick event of that button. The command to open a report is: DoCmd.OpenReport Check the help files for exactly how to set it up. I was like you. I...

northy, I hope you didn't take my response to imply that I didn't think your question was appropriate. Please, post away! I guess I am just noticing more and more that the same questions appear often in these forums (or are easily answered in Access Help files), showing that the poster didn't...

While I agree with Braindead (that doesn't sound right! ), the code I gave you above does exactly what you want to do. It does not change the name of the field. It changes the entry in that field for the record that was found with your criteria.

Perhaps I am missing something, but I think you just use the following: Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tblYourTableName", dbOpenDynaset) With rs .FindFirst "Your Criteria" .Edit !FieldName = "UpdatedInfo" .Update End With

If that is a fixed record, you could put the value for the Bound Column in the default value of the combo box.

Click the Sum button (the Sigma in the toolbar) and choose "Max" on your Session Date field.

Check out this post to see if it answers your question.

Would you mind e-mailing me that sample? Thanks! dshacket@believethis.org

If you are using code: TotalPaid = Me.TextBoxName If Me.Check1 = True Then TotalPaid = TotalPaid + $40 If Me.Check2 = True Then TotalPaid = TotalPaid + $30 If Me.Check3 = True Then TotalPaid = TotalPaid + $20 Me.TextBoxTotalPaid = TotalPaid If you want to put it in a statement, put the...

You have your SQL string being created with AND. You need to create your SQL to say: WHERE [names1] Like <criterion> OR WHERE [names2] Like <criterion> OR etc. HTH

Queries are not updatable. You cannot add or remove info from them. What you need to do is create an update query to update all records in that table where Date_Field is null to the date you type in. You would not even need a form to do this if you used a parameter in your update query. But you...

SendObject will send the report as an attachment to an e-mail. OutputTo will save it to the computer. Use the one that best suits what you are trying to do.

Look at the OutputTo method of DoCmd

Check this post and see if it helps. [This message has been edited by shacket (edited 08-30-2001).]

Depending on how you are running it, you could design the Make Table query (it would be much easier to run from VBA) and simply run that query to format the other person's info correctly into your table, then run your database off of that. If you are using this information on a consistent basis...

Write a made up field name in the criteria for the date field. In other words, if your date field is named "Date", then in the criteria box, enter the following as its criteria: Between [EnterStartDate] And [EnterEndDate] This will then prompt the user for those two "fields" before running the...

I had to accomplish this through code. It was very tedious. The problem was that a field in the e-mail (like the Bcc line) can only hold 255 characters. So if you want to add all of the names, their characters can't surpass the 255 barrier. One way to do this would be to have VB send an e-mail...