Recent content by lexis7

To break it down: The three fields that I want to zero out have the same values but the other fields contain different dollar values which i want to sum in an output(excel pivot) I can't sum the first three fields because then it will double or triplicate the values. see example below...

Here is my SQL: SELECT [TABLE].[Tracking Code], [TABLE].[Clicks], [TABLE].[Cost], [TABLE].[Impressions], [TABLE].[Date], [TABLE].[Orso Type], [TABLE].[Store], [TABLE].[Orders], [TABLE].[Net Demand] FROM TABLE WHERE (((TABLE.[Tracking Code]) In (SELECT [Tracking Code] FROM [TABLE] As Tmp GROUP...

Hi- I have a find dups query set up, which returns 5 fields. I want to zero out Field 1 and Field 2 on just the duplicates. I don't want to touch Fields 3-5 on these duplicates. Is this possible to do through SQL? Thanks for any help. lexis

thanks for the suggestion, but it didn't work. maybe i didn't explain things well enough. let me try again. -i created a form to allow users to enter a new contact. -the fields on the form will be added to the table "Main Contacts" -this table already has 800 entries and a Key field...

Hi- I am trying to create an autonumbered field on a form. I have created a txtbox named "txtAutoNumber" I am using this form to add new records to a table. The table already has 800 records. How do I create the autonumber field to start at #801? Any help would be great...

James, thanks for your suggestion but the code i'm trying to split has different lengths, for examples see below. what i have already done with no success is create a form with a command button(cmdSplit) and have it split the "code" field in the "code" table. Any...

hi, I have tried to read up on this split function, but every code is different and i don't know how to interpret it all. can anyone help me with this. I am using access 2000, and i want to split the following: Field name: Orginal Code example of code entry: 14:863618:4387:0:0:99 I want to...

I CAN'T BELIEVE THAT WAS ALL THAT WAS REQUIRED! I found all this code for calling the print dialog box and spent two days debugging all this code. It was seriously 5 pages of code. Thank you for this wonderful suggestion, so simple!!!! Have a great day!

Hi, Thanks for letting me know this was possible, but I don't know how to code it or where to put the (Is Null or ""). -I call my query through code 'Open the "View" form DoCmd.OpenForm "frmInvoices_Search" 'Pull recordset from query into...

Robert, After a week long battle with this and after your helpful suggestions about debugging, I found the solution to this problem. When I debugged I found that it's recordset value was all my records and not the results of the query. All I changed was having the code written under...

Not quite sure if this is possible.... I have a form(frmEnterInfo) that has many different fields(ex. first name, last name, DOB, job title...). I have another form(frmSearch) that allows users to select a field and type in a value to search. This is done through a simple select query. I...

Hello! I was trying to add a common dialog box for the print function to a command button(cmdPrint). I have read all about NOT using the commonn dialog box. I have also read tons about the saving/browsing of files using API. I cannot seem to find much info about the Print dialog box. Does...

ok- It was my mistake, I had the wrong reference checked off...but now after all that, nothing happens. I don't get any errors but I don't get a msgbox either. aghhh! any suggestions? Thanks alexis Private Sub Form_Open(Cancel As Integer) Dim rs As DAO.Recordset Set rs = Me.RecordsetClone...

Robert, I want to thank you for being patient with me, however I am still getting the same error message. I have been playing around with the code for two days and I can't seem to understand what is going wrong. This is the last thing on my "to do" list for this project. If you can...

Thanks everyone! I just replaced my string value with strSQL= "" and it worked great! I appreciate all your help. alexis