Search results for query: *

Zathras, Thanks for the help. The solution you provided worked like a charm. Thanks, Tim

Hi, I am creating a VBA application and would like to use do linear regression in VBA. I am trying to use the Slope( ) function, but it just doesn't seem to work no matter what I use for arguments. Scenario: Given three collinear data points {(1,1), (2,4), (3,7)}, you want to determine the...

Hi, I am currently trying to write a small VB application to print barcodes on a zebra 90xiII printer. Currently, the printers is hooked up to a computer and shared via the network. My VB application allows me to select the printer from the network and print out labels. The problem occurrs when...

I have a access form in which a command button call the following sub procedure located with in a code module. The module then opens excel and displays the common dialog box using the GetOpenFilename function. Currently, the diaglog box opens to the excels default filepath which is the "my...

Golom, I gave the sql statement a try. The output was exactly what i wanted. Thanks again for you help. i would of never thought of doing the inner join part of the sql statment. i was trying to do everything with just one instance of the table. Never thought of creating two instances like you...

Golom, Ok, makes sense know. Will give it a try and see if it works. Thanks for you help. Tmreic

Golomn, Thanks for you input but I am bit confused where the A1 and A2 comes from in your sql statement. The data for both assays are in the same table. Are you using A1 and A2 as table names? Tmreic

Doug, Unfortunately i am not generating a report. The query is exported to a excel document for reporting purposes, etc. The current work around is to export both assays values into excel and do the subtraction in excel. But was looking for a way have this done automatically within the query...

I have a table with the following columns below. THe table contains results from different assays. I would like to write a query calculation to determin the amount of total Sucrose in each sample(A or B). To do this i need to subtract the glucose value that is related to the same sample (A or...

Tony, Thanks for bearing with me. In my real life i am a scientist and in my off hours i am trying to learn computer programming. So I am using projects at work to teach myself VB. Anyway, I took your suggestion of adding the Cancel = true statement and modified the controls to a beforeupdate...

Tony, I have tried the before and afterupdate events, change, lostfocus events. I did use the beforeupdate events with this code but it does not check the value of the textbox until i enter data into the rest of the textboxes and update the form. What i am trying to do is validate the value in...

I currently have the first listed set of code located behind one of my textboxes on a form. It is used to validate data entry on my form. The code works like it should when entering the data. But everytime i close or exit the form the code excutes and diplays the msgbox and inputbox. Is there a...

I currently have the first listed set of code located behind one of my textboxes on a form. It is used to validate data entry on my form. The code works like it should when entering the data. But everytime i close or exit the form the code excutes and diplays the msgbox and inputbox. Is there a...

Thanks for the ideas i will give it a try. However, do you all think this will just start all of a sudden. I was using the computer for 1 day before this problem occurred. But i guess you never know. I guess i can give it a try and see. Thanks again, Tim

I just built a new computer that contains a asus a7n8x mother board, amd athlon xp 2700, 512mb memory, 120 GB hard drive. I am running windows xp. Everything was going find until i added back my old 20GB hard drive. Since adding it everytime i restart and click on my computer i can not access my...

I will try to further explain what i mean when i wrote "Doing it all at once". When i perform the append query i get a error message stating that not all of the records can be appended due to key violations. Instead of first trying to figure out which records are violating rules. I...

Foolio12, I tried your suggestion but it did not work since my records were not appended to table2 in the append query. The append query only added records to table2 that had a Receiving ID in table1. The records that had a Receiving ID that was missing from table1 were not appended. Table1 and...

I am currently using the append query method to update a table from one database to another. My question is, I would like to find a way to display and capture the records that were not updated due to key violations? The key violations occur due to enforcement of referential integrity. I am...