Search results

Re: Select Case between two dates VBA Why dont you use a IF THEN STATEMENT Dim currentDate As Date currentDate = Now Dim date1 As Date Dim date2 As Date date1 = DateAdd("d", -25, currentDate) date2 = DateAdd("d", 5, currentDate) If Me.Next_Payment_Due >= date1 And Me.Next_Payment_Due <=...

better way is: =Sum(Nz([Weight],0)) This insures the answer will be converted to a 0 if any of your weight value is null.

You are correct. The DB is not split...possible in the near future I will do so. I appreciate the code you gave. I will look it over and modify it on my end. I appreciate the solution. This is great. Thanks again! :D

Basically, I have a working access application but if I need to modify my code in a development access application that uses the same tables from another database, I cant just import the tables. It tells me that in a nutshell to import the table from another database, I have to delete the...

I have written some VB code when I create tables, I establish relationships to it. I can see the relationships when I view them in the Relationships view. But what I need to know when I manually created relationships with other tables not using VB code. What is the name of the relationship...

Magster, thanks for your reply. I have considered that, but boss doesnt like that solution. I figured it out so if anyone wants to see the solution, just PM me.

I have 3 subforms in my main form. The data from the subforms pull from 3 different tables. To get the data to populate the subforms, they choose a given month i.e. Jan, Feb, March...etc. for the criteria Depending on the criteria, I can have upto 3 subforms to appear or no subforms at all if...

Ahhh!!! I see what you mean. I just fix the LateFee > 0 in my Union Query. That did it!

Yes in hindsight, It wasnt normalized all the way.

Bob and pbaldy Wow you guys are fast! Thanks. BTW, The actual example was not my original syntax but my question was made to be made simple so I didnt have to type out everything in my actual code. Yes, I wish I could have normalized it more, but this is what it was given to me. Maybe Ill go...

Actually, can you help me with the syntax?

How can I achieve this? In my table I have Id, Month, Amount, LateFee i.e. 1,October,10,0 2,November,5,15 3,December,20,0 When I enter my records in a table, I enter the Month, Amount, and if applicable, a LateFee If I query my records for the month of November, I would like my result to...

Thanks to both (Air_Cooled_Nut and David) of you. This helped me today!!!

Your Select statement needs some work. Your "WHERE" statement => Me.Permanent_Address will not work because you are trying to reference a control field with a "ME" syntax. The Me.Permanent_Address should be a column name in your "Residence" or "Residences" table. I am not sure which is the...

In this example above and I want to round my value to 2 decimal places Currently if I use the round function where my result is 2.515 => 2.51 Desired Result 2.515 => 2.52 I saw the explanation where if the value is "odd", it rounds down but "even" it rounds up. So I get why you should watch...

khawar, Thank you very much. That is exactly what I needed. I modified it to meet my actual needs. This definitely put me in the direction to finish my project. Thanks again for your assistance. Cheers! :D

Attached is the sample.mdb The data can be found in SampleHistory Table What I would like to have is the end result that looks like the records in the FinalSampleHistory table. The data is the same as SampleHistory table but I maually deleted the records that I dont need. I am looking to...

I have a sample query from a table and this is my result. My goal is to get the latest and greatest record of a given Start_Period and End_Period. In the Revision Column, if it has a -1 value it supercedes the given period with a Revision of 0. If the revision of a given period already has a...

Hello, I have form which the Default View is set as Continuous Forms. Its Record Source comes From tblBatchAmt tblBatchAmt Company_Id Check_No Amount In the form, I added the three fields from tblBatchAmt, alongside of it is a combo box called cboQuickSearchById which the RowSource comes from...

By looking at this code, after you execute the check for a null value, it will continue to execute. Try redoing your if then clause like this. Private Sub Search_Click() On Error GoTo Err_Search_Click Dim stDocName As String Dim stLinkCriteria As String 'Check txtSearch for Null value or...