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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dweis
  • Order by date
  1. dweis

    Searching and updating records without duplicating a key

    I think I got it. Not all the way there yet but that's because now the customer is changing their desire about adding more order numbers. Anyway, my plan is that when a user clicks the "process" button, multiple SQL statements are opened & held as variables. That combined creating a temp table &...
  2. dweis

    Data entry of one field calculates value of other field and vice-versa

    ...in 1 field you would want the other field overwritten only if there wasn't already a value there. Just take out the if...then & end if lines. So, distancewalked onlostfocus would simply read: me.stridenum = me.distancewalked * 63360/[StrideLth] and vice/versa for the stridenum onlostfocus...
  3. dweis

    Data entry of one field calculates value of other field and vice-versa

    You're very welcome!
  4. dweis

    Data entry of one field calculates value of other field and vice-versa

    I would put a "onlostfocus" event on both fields to check the status of the other. If you enter the miles onlostfocus if isnull(me.stridenum) then me.stridenum = me.distancewalked * 63360/[StrideLth] endif And on the stridenum field put the opposite to update distancewalked.
  5. dweis

    Searching and updating records without duplicating a key

    Hi all, I seem to be having a brain fart as I can't figure my way around this without using a series of update queries. I know there has to be a better way. Here's the scenario: I have a customer that needs an order number for invoicing purposes. They issue blanket orders once per month and...
  6. dweis

    breaking a text file into individual records

    ...For Input As #1 Set MyRS = CurrentDb.OpenRecordset("edi_imp", , adOpenDynamic) Do Line Input #1, strLine vSplit = Split(strLine, "*") If UBound(vSplit) > 1 Then strCol = Trim(vSplit(0)) Select Case UCase(strCol) Case "ISA"...
  7. dweis

    Import multi-line text file into one record using text keys

    ...For Input As #1 Set MyRS = CurrentDb.OpenRecordset("edi_imp", , adOpenDynamic) Do Line Input #1, strLine vSplit = Split(strLine, "*") If UBound(vSplit) > 1 Then strCol = Trim(vSplit(0)) Select Case UCase(strCol) Case "ISA"...
  8. dweis

    Import multi-line text file into one record using text keys

    ...EDI using a file parsing program. The problem is the inbound. How can I get the multiple lines into one record? I need everything from the ISA* to the end and I don't really need the qualifiers. What I want is to be able to say, ISA line, from 18 - 25 is field 1, 1st N9 line is field 2, 2nd...
  9. dweis

    Subform is sometimes white/no data in runtime

    I have a mixed OS environment - Win2K and XP pro & home edition. I have a runtime app with a frontend/backend setup. I have a search form where a user enters data in field1 of the main form and the subform, linked on field1, pulls the appropriate data. Of the 10 users, one get's a white screen...
  10. dweis

    Conditional format in 03 runtime causes flashing

    Thank you for your assistance! I installed the Office '03 service pack which patched the runtime and it works perfectly. Thanks again for your help.
  11. dweis

    Conditional format in 03 runtime causes flashing

    I have a continuous form in 03 version. Based on the value of bound check boxes, 2 fields will have formatting set using conditional format. When this is run on my development system, the continuous form works flawlessly. When I distribute to runtime machines, the continuous form constantly...
  12. dweis

    Strange: can't ping vpn IP outside my ISP

    Resolved the problem - IP conflict - thanks for the assistance.
  13. dweis

    Strange: can't ping vpn IP outside my ISP

    Anyone?
  14. dweis

    Strange: can't ping vpn IP outside my ISP

    W2k server - dedicated VPN Test machine WinXP pro VPN setup according to wizard and Microsoft docs 2 network cards, 1 attached to local network, 1 attached to hub that is directly attached to WAN rounter. I changed the default Routing and remote access Input/Output filters temporarily to allow...
  15. dweis

    Print Set Date Range on Report

    You can refer to a date range from the underlying query if you're using a parameter query. In the report, create 2 unbound text boxes. Set the data sources equal to the parameter query's prompt. For example: Query1 is filtered by pickup_dt I place pickup_dt in the query 2 times. The first...
  16. dweis

    Entering a percentage - data entry question

    ...data entry, the user enters 9 for 9% fuel. I have another hidden field that is updated through the first fields afterupdate event to equal fuel_pct *.01. The user sees 9%, but all calculations use .09 to calculate fuel. Example: amt1 fuel_pct hiddenfld fuel_chg $100.00 9%...
  17. dweis

    Unwanted Access Null Value data

    First, there is no quotes around the 0. It's iif(number=0,"",number) Which is "if number equals 0 then use blank else use number." How exactly are you exporting this? Are you opening the query and then using file, export? Is there a button you push to export? Are you mail merging? Another thing...
  18. dweis

    Unwanted Access Null Value data

    Are you mail merging or exporting a table to word? You could try using a query instead and create a custom field in the query that states iif(number=0,"",number)and try a date field that iif(isnull(mydate),"",mydate)and then send it to Word to see what you get.
  19. dweis

    Continuous form form header issues

    Do you have the fixed control's data control source equal to a control in the continuous form? If so, each time you're on that control in a new record, the fixed control will be blank. The following example has Text6 as a fixed control - it will show the current container from the form, but if...
  20. dweis

    problem repairing db

    You may want to do a google search on the subject. 1 way is to see if you can create a new mdb and import the tables and then compact and repair. Check out: http://www.granite.ab.ca/access/corruptmdbs.htm as a start. (They don't mention the ODBC repair, however they address the unrecognized...

Part and Inventory Search

Back
Top