Search results

How would I work that into my entire statement? I tried and couldn't get it to work.

I have an unbound text box with the following control source: ="The scores below are based on the number of total evaluations (" & Sum([TitleIDCt]) & ")." I set the formatting of the control to Standard. It reads: The scores below are based on the number of total evaluations (1718). I...

I create a lot of databases using 2003 and open them in 2010. I create toolbars in 2003 and as you know, they are hidden in the later versions on the Add-ins tab. Does anyone know of a way to have the reports open every time to the Add-ins tab? This would allow the user to see the toolbar...

There is a three letter acronymn that describes good database management. I forgot the term. I believe it T?L. The T stands for Transact. Anybody got it? Thank you.

Let me study this some more. I need to clarify it for myself. Thanks for all your help.

Well, back to the original question. Is there anything wrong with the expression itself?

I will try to clear it up. I have a form with tblReferredToHold as the recordsource. There are 2 comboboxes on the form. Combobox 1 is to select an agency. The controlsource is the field ReferredToAgencyID. When an agency is selected. the field retains a number and displays the agency name...

I simplified the query for editing sake. Can you fix this? Start of Code DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE tblREFERREDTOHOLD INNER JOIN tblREFERREDTOCONTACTS ON tblREFERREDTOHOLD.ReferredToContactID = tblREFERREDTOCONTACTS.RefToContactID " & _ "SET...

The query behind the combo box is a Select query. The SQL statement is an Event Procedure in the After Update of the combo box. After the selection is made in the combo box, the Update then runs.

I had the DoCmd.RunSQL. I now have this: Start of Code Dim StrSQL As String StrSQL = "UPDATE ---rest of the code----" DoCmd.RunSQL StrSQL End Of Code I am using a combo box based on a Select Query. After I make my selection in the combo box (the code is in the After Update field), it...

I am trying to experiment a little to get more familiar with the SQL concept. I run this query and it works. I copied the SQL version of it and tried to adapt it to use the DoCmd.RunSQL command. It fails to work. Can you point me in the right direction? Here is the original SQL from the query...

I am trying to do some different things and want to experiment at this time. You may think this is a C# question, but I have searched everything I can and can't find an answer. Everybody seems to understand it differently and do not give good answers. I have found that Access people are more...

That would take me more time than going through them manually. But, I can probably use this in the future. Thanks.

I have a FE-BE database that I created and have been adding to for about four years. Now management wants a copy of it so they can put it on the internet. SharePoint is out. I get the usual resentment when I mention Access. I have over 1300 queries. The last six months I have been using some...

Thanks again for your help. I couldn't get it to work. But, it did get me to thinking. I did solve it another way. The amount ends up in another table. I set the Field Size to Decimal, Scale to 2, and Decimal Places to 2.

I will try this later in the day. I will get back with you tomorrow. Thanks.

The calculator is being used to enter the amount of money received from the customer. After entry is complete the sales person clicks on the “Calculate Change” button and the Change value is displayed on the screen. The control [Amount] is a text field from the underlying table and holds the...

Let's say that the character "5" is in the variable amount and then hits this statement. You will concatenate a "1" to the "5" yielding "51" Is that what you intended? Yes. Amount is a text field from the underlying table.

I created a calculator for a sales program. The code behind each button is: START OF CODE Private Sub btn1_Click() Amount.SetFocus If Amount > 0 Then Amount = [Amount] & "1" Else Amount = 1 End If btnEnterItem.Enabled = True btn1.SetFocus End Sub END...

Thank you.