Search results

I have a button when clicked, it creates a relationship between two tables. It works fine but if I have a situation where a relationship already exists, I want it to stop and exit. My current code sends a message box that the relationship exist but it does not stop and proceeds to the next...

Anyone care to take a look of my problem? I attached my DB in my original post? Thanks in advance.

I have attached a sample database which has a continuous form. Its called "frmContinuous". The records that hold the continuous form data is in the tblTempDeposit. The idea of this form is to allow the USER to enter Deposits in a batch format and submit all the records into the tblDeposit...

gemma-the-husky, That is exactly the scenario I need. What do I need to do to make sure BEFORE the USER can enter the next row of data, the current row meets all the validation requirements whether the required selection must be made in an combo box, tex tbox or any other input controls...

PNGBill, You are correct. I erred on my post. Do you have such an example that I can look at?

I am trying to create a form where the USER adds a record but it also keeps a running total. Basically its a check deposit input form. My form is a continuous form so the User can input multiple records at a time. My first field is a drop down box where a user selects a company name (Combo...

Thank you Bob for the clarification. This has helped me and I am sure this will help a lot of posters in the future.

Hello Bob and All, So to make sure I understand this. If I use Round(AnyNumber,2) in my vba code, I should be fine since I am using Access 2003. I dont have to create a custom round function. But in the case where there is rounding issues of the .125, .135 I should use a user-defined Round...

Thanks for your reply BobLarson, I have been going crazy in trying to figure this error out. I went and did your suggestion and I still got my error message. But I see what you were doing which is very similar in what vbainet proposed a few post earlier. I finally realized what is causing...

Re: Formatting 3rd column based on 2 calculated columns This is going to look a bit different from what my original post because I didnt want to add so much detail to confuse. But here is my actual VBA coding example below. Thanks in advance. Private Sub CommandHistory_Click() Dim db...

vbaInet or anyone else, I created this query using VBA. I know using the Round function does work when I create it using the standard query setup or VBA. But here is my problem now. My next step is using the result of that query in a 'Union ALL' query. The column that I am retrieving to use...

I cant believe that I didnt think of that...I guess I was so stuck doing it one way, I stopped thinking of the alias alternative. Thanks. I did that. I created another alias field and rounded it. Thanks again vbaInet!

Here is a sample of a record from a table Table_1 ref_Id, original_Ref_Id, sub_Total, rate_Multiplier, net_total 1, 0, 50, 0.0425, 2.125 2, 0, 120, 0.0425, 5.1 3, 1, 150, 0.0425, 6.375 My goal is to create a calculated field called final_Amt in a query based on two calculated columns. Here is...

Thank you for your reply. My total calculation from my record source query does carry out to 4 decimal places and it throws off my total value because its too precise. I will try to explain my situation in the QUERY section of this forum . Your reply does help me in future situations though.

I have a control text box which outputs a currency amount from a query as its source. I have formatted the amount to be a currency value and display it with two decimal places. But in reality sometimes that amount is actually 4 decimal places. When I do a group total, it messes up the actual...

Glad it worked out. :)

I think when I went back initially to give my variables a better description I gave you an erroneous variable. I should have tested before replying. Look at this new code: Dim getListboxCount As Integer Dim setHeight As Integer getListboxCount = Me.myListBox.ListCount ' Adjust Number...

You can use an event to trigger the vba code. Basically, what I assumed is that on your requery, you wrote a little code to do that. What it does is gets the count of how many records in your listbox and assign a variable to it. The getListboxCount is the name of your listbox i.e. count =...

Can you use vba code? Dim getListboxCount As Integer Dim setHeight As Integer count = Me.getListboxCount.ListCount ' Adjust Number Accordingly setHeight = 217 Me.getListboxCount.height = count * setHeight

Nice alternative. :) I have never done it that way.