Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by leadpro

  1. leadpro

    Default Value in Table Problem

    I need to set the default value in the table to 22.50. The table keeps rounding down to 22. How do I fix this?
  2. leadpro

    Importing Same Records & Updating Fields

    Yes to this: so lets say you import them to a temp table...now you have to do a update on your original table with new values from temp table... is that right??
  3. leadpro

    Importing Same Records & Updating Fields

    thank you, but I don't think I was clear. Clients send me back the edited records in excel, I import them back into the same table, or maybe a temp table, then append? Thanks, GLO
  4. leadpro

    Importing Same Records & Updating Fields

    I'm sending out records for people to edit. After they edit, I want to take these records, match them up by ID, and update the appropriate fields to the new data. ?
  5. leadpro

    Top Value Conditional Query

    Thanks, actually the negative balance could be anything, just so happen to be -10 in the example.
  6. leadpro

    Top Value Conditional Query

    I have clients recieving leads...records. Sometimes, their number of records delivered from my suppliers exceeds thier order, leaving a balance due of (-). How would I query clients [ClientID] that have exceeded thier [OrderAmount], and only pull up the number of records equal to their...
  7. leadpro

    Emailing Report Pages

    I've created report/invoices to print out one per page, however it would be nice to email of these to each respective [ClientID] without creating a report/invoice for each client and then a macro for each client...any ideas?
  8. leadpro

    Including Queries With Active/Inactive Button

    I need a module that will only run a series of select/update queries that have the button [Active/Inactive] = -1 in each select query. The update queries are based on each respective select query. The sequence would look like this: If Active/Inactive=-1, then Run Select Query1 Run Update...
  9. leadpro

    IIF and Update Query

    I have a field I'm trying to update incrementally. Here's what I came up with, but it only updates to -1. When SoldTimes=-2, it stays at -1. IIf([SoldTimes]=0,-1,"") Or IIf([SoldTimes]=-1,-2,"") Or IIf([SoldTimes]=-2,-3,"")
  10. leadpro

    Updating Group of Records with Random Number

    I need to update a group of records I query based on a select query. The field I need to update is [OrderNumber]. Preferrably, I'd like the field to update to the [SupplierID]"-"random and unique 5 digit number". Remember, I need the same unique number for the group of records, not each...
  11. leadpro

    Append Data to Overwrite Existing Records

    I need to append data to a table, but instead of adding these records to the table, I need to overwrite certain values that already exist. Indexed on [OrderNumber] and need to overwrite the fields [LeadsDelivered], [LeadsReturned], [CurrentBalance] Thanks, Leadpro
  12. leadpro

    Extra Blank Page Printing?

    My report is printing an extra blank page. Can also see this in preview mode...report should be 2 pages, but showing 4?
  13. leadpro

    Accounting: Balance is 0, but can't recognize

    I have a query that calculates the balance of a client as the following: Balance Due: [OrderAmount]-Count(LeadsMaster.[Home Phone])-[SumOfReturned] Balance Due is not a field in my table, but can't seem to get this calculation to save in the table. The major problem I have is to recognize...
  14. leadpro

    Showing IP on Web Site?

    What is the code for showing the visitors IP on the site they are on?
  15. leadpro

    Passing (redirect) Form Values

    I need to modify this code to pass values in my form and post to the call.aspx script in this code. Any suggestions? <%@ Language = VBScript %> <% Option Explicit %> <HTML> <HEAD> <TITLE>Loan Application Form</TITLE> </HEAD> <BODY BGCOLOR="White" TOPMARGIN="10"...
See more

Part and Inventory Search

Back
Top