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!

  • Congratulations strongm 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: *

  1. Kativs

    AS/400 Can't delete PO - Qty to dock/insp found

    Good morning, I am probably in the wrong forum area but I will give this a shot. We use the as/400 series and my question is based on purchase orders. We have a very old purchase order in our system. The line item was either cancelled or qty taken out as there's nothing on the line but the PO...
  2. Kativs

    Convert ms access 2000 MDB to ACCDB on Verizon Droid phone

    Hello all...I hope I'm in the right area for this question. My PC uses the old MS Access 2000 database MDB file format. I want to transfer my access database to my new Verizon Droid cell phone. I was able to transfer but I cannot view the file on my phone as it tells me cannot access mdb file...
  3. Kativs

    Duplicate shared folders - Why? And how do I fix?

    Sorry for the very late response. I understand they are one and the same and we try not to touch the one that repeats or duplicates, however they just keep showing up. Reboots, restarts, deleting the dupe...nothing stops the extra folder from showing up. It's not a problem really, just...
  4. Kativs

    Quickbooks 2008 Filter SHIP TO addresses

    Not a list but a "filter". When you search it brings up a list of filters to search by. We need to add the "ship to" locations in the filter. So far I have heard you cannot add them. Honestly that is insane as most customers have different ship to locations.
  5. Kativs

    Quickbooks 2008 Filter SHIP TO addresses

    First, I'd like to appologize if I entered this in the wrong forum. Anyone out there really good with QuickBooks? I have QB Pro 2008. All of the Intuit and internet scannning I've done, I cannot come up with an easy solution to this. With all the customers we have for our business, these...
  6. Kativs

    Duplicate shared folders - Why? And how do I fix?

    I have googled till I cannot google anymore on this. I'm sure there's a quick fix for this but I'm not seeing it. We are using Windows XP Home edition. We are small and are trying to keep our shared folders properly. We have several shared folders in our Network Places. Most created by 2 people...
  7. Kativs

    MS Access 2000 hyperlinks work but display strange

    Since apparently noone knew the answer to this, I'm posting what I found in hopes that it helps someone else. This was very frustrating and it was a stupid answer. If your displays are strange like mine just check your Font. Mine was set at "Mangal". I switched it to Arial and it was fixed. What...
  8. Kativs

    Leading zeros in MS Access form needed

    UPDATE....What a stupid yet simple solution. Amazing I couldn't find the answer to this ANYWHERE!! Folks if you have this problem check your font. Mine was set to "Mangal". I changed it to Arial and boom it's fixed. Go figure. I sure hope this helps someone else in need. Thanks for all your help.
  9. Kativs

    Leading zeros in MS Access form needed

    Thanks. The only differences I found between the databases was "enter key behavior"..one was at "new line in field" and the other was at "default". The tab indexes were different too but don't think that effects this. And of course the After Update event procedure was different and I already...
  10. Kativs

    Leading zeros in MS Access form needed

    My properties all seem okay. There is nothing in the format. However there is an event procedure, After Update saying just that...an after update. I took that out and still the same results. I checked the hyperlink address with the # signs etc and the display as well is all correct. Keep in mind...
  11. Kativs

    Leading zeros in MS Access form needed

    Thanks...I'll check this after lunch......
  12. Kativs

    Leading zeros in MS Access form needed

    EXCELLENT !! THANK YOU SO MUCH. AND THANKS FOR BEING THERE TO RESPOND SO QUICKLY. 20 STARS FOR YOU ! Now, can I sort of apply this to my other problem with my hyperlinks for websites? See my original question. Thanks again !
  13. Kativs

    Leading zeros in MS Access form needed

    ahahhaha cool..now it shows 327.000
  14. Kativs

    Leading zeros in MS Access form needed

    Wow...too smart for me..thanks that worked. Now,,,it's really weird. If I am in that field the number that was originally entered such as 327 shows but once I click out of that field all I read there is 000. How can I get it to stay with the correct number.
  15. Kativs

    Leading zeros in MS Access form needed

    also here's a stupid question. I probably can't do this but if the control is set at 4 zeros and I only want it to read 327 will it still read 0327 ? I would like only the numbers needed such as tray 063 or 327 or 1420. Does this make sense? Most of our tray numbers are 3 digits but we have a...
  16. Kativs

    Leading zeros in MS Access form needed

    Thanks...I took your advice first and changed to say Tray_Num. The control now works however all I get in all my Tray numbers is 0000 but not the numbers entered such as 1827 or 0563. I tried to re-enter a number 0327 for my first tray number, saved it and it keeps changing it to 0000.
  17. Kativs

    Leading zeros in MS Access form needed

    Okay..this is what I've tried and where I've gone. In my form, design view, right clicked on field and selected build event. In the build event I typed in format(Tray#, "0000") I also tried format = (Tray#, "0000") Nothing seems to work. Obviously I'm doing something wrong or in the wrong...
  18. Kativs

    Leading zeros in MS Access form needed

    Where am I putting this? Format, Data, Event?? Sorry I'm just lost now.
  19. Kativs

    Leading zeros in MS Access form needed

    Thanks I tried an = sign but maybe I had things in the wrong order. I will try again tomorrow morning. Thank you again.
  20. Kativs

    Leading zeros in MS Access form needed

    Wow thanks but it still isn't working. Not sure if I'm putting it all in the correct place. Is it in the event timer? Format now says general number. Getting confused as the day goes by. I appreciate your help. I'm sure it's easier than it appears right now.

Part and Inventory Search

Back
Top