Search results for query: *

Thank you everyone for helping me, the union query is exactly what I needed.

I have two seperate queries performing a different task in each but each query has the identicial field names. The calculations are correct and I want to print them in a report. Since they are in seperate queries I can't get them together. When I combine them it gets all messed up. If this...

I have sort of the same problem. When I am changing the time into minutes I am getting a negative number. It is the correct calculation other than it is negative. The formula is the following: HourtoMin: Sum(CInt(CDbl([TotalHours])*24*60)) I have search the knowledge base, in fact that is...

I figured it out. I created a query off of the form into a table. It might not be the easiest way, but at least it works. Thanks, Shannon

The one field is a memo field and I thought that was my problem but it isn't. When they say 255 characters are they talking about the data that is being copied or characters in the command line in my SQL statement? Thanks!

I have built a command button that copies 7 different fields from a form into a table. It does not work all the time because I am sometimes over the 255 characters. I am using DoCmd.RunSQL "INSERT INTO mytable (7fields) VALUES (7fields);" When using the DoCmc.RunSQL it only...

Is the rule with 255 characters apply to the code characters or what the code is transferring? I tried the CurrentProject.Connection.Execute 'SQLstring' as you recommended and the I get the error "Argument not optional". Shannon

In a form I have created a command button with the following code: DoCmd.RunSQL "INSERT INTO TblIncentiveDetail (VenNumber,VendorName,IncentiveDescript,Criteria,GrowthIncent,DetailYear,IncentiveTotal) VALUES...

I have a related question. I want to click on the e-mail address in a form and hyperlink it that way. Do I select the hyperlink data type in the table? Then what? I got lost when you said to choose a website. Any webiste? I also didn't find the conditional formatting command line. Thanks...

I got everything working perfectly. I just listed the field name = null. Thanks for all your help! Shannon88

I would like to add it to the same code. So, after the user clicks on the button that specific information is copied to a table. Which we have done. I would like the FIELDS to become empty so the user knows that they have saved the specific information. I have been looking for a code to...

Sorry to bother you again but I have one more question! I have been trying to write code to delete specific fields that we just copied into a table. I have been searching EVERYWHERE for just an example of this code. Do you have an example of the DoCmd.RunSQL DELETE code. Thanks Again...

WE DID IT!!! Here is the code I needed! I didn't even need the previous code. DoCmd.RunSQL "INSERT INTO TbleIncentiveHistory (VenNumber,IncentiveYear,IncentiveTotal) VALUES (VenNumber,IncentiveYear,IncentiveTotal);" Thank you so much jbehrne. I really appreciate it! You just...

I have a table that within it I want to open another form (pulling up another table). The table that I want to pull up has 23 products that will change often with checkboxs for yes or no. My primary key is the Vendor #. The problem is that each vendor # can have mutiple files within. I could had...

OK, I am so close I can taste it! When I run the code, it asks me for the values of temptext 1, 2 and 3. When I type in Test Data, IT WORKS. So something is wrong with the first part of the code. I have been searching for a long time and only came up with is acCopy, but I can't get it to work...

Thanks for the great start! I am still running into some errors. This is what I got: Private Sub roll_history_Click() On Error GoTo Err_roll_history_Click Dim TempTex1, TempText2, TempText3 As String Dim db As AcDataObjectType 'This will copy the text values from form'...

I am trying to create a command button in a form that will copy only three fields on the current form into a table. I have tried creating a query but the query will give me all the RECORDS from that vendor. I also attempted to create a macro that I miserably failed at. Any Help would be...