Search results

  1. A

    Last edited date in a label

    Excellent! Works great! Now for the next task. Apparently there's something called %USERPROFILE% (short for C:\Documents and Settings\*username*\). In theory this is supposed to make it more flexible in that you can use it in a different environment at the same time (so each computer doesn't...
  2. A

    Last edited date in a label

    I can't seem to get the files to work... Either that or I'm not using them right or don't have the right one. Can one of you put together some code for me? The label I'm trying to update is Label139 (yeah, I know I should name them better, but this is database is only for me) and the file name...
  3. A

    Last edited date in a label

    I'm not seeing where it "should" be built in. The code on the page is some form of C, not VBA.
  4. A

    Last edited date in a label

    Well, I don't mean to rain on your parade, but we're dealing with VBA, not VB or VB.NET. If I put the code in a VB compiler (Visual Studio 2005 to be exact) it has no problem with it. I think a translation may be in order. How? I don't know... Yes, your replies have helped some. Thanks :)
  5. A

    Last edited date in a label

    How much more information does one of you need to figure out a problem like this?
  6. A

    Last edited date in a label

    Well, I would like all three updates. What is the My.Computer.FileSystem for? Ok. Just to get things straight (in my mind), C:\blah\blah\blah is the path to my database, labelname is the name of the label that will display the date, and you don't need the & if you aren't going to put in the...
  7. A

    Last edited date in a label

    I'd like to have a label that updates everytime the database (forms, tables, queries, etc.) gets update. I'm guessing it'll take code, but I may just be overlooking a property. Any thoughts?
  8. A

    Converting Alphanumeric characters (and spaces) to Numbers

    Ah, figured it out. I needed to fill in a column. Problem is it has >2200 rows and again, I don't really want to fill it in by hand. Any suggestions?
  9. A

    Converting Alphanumeric characters (and spaces) to Numbers

    Yep it works. Now to make it ALL work. I have four tables I need to link together and make it work in VB.NET. I keep having troubles trying to make the relationships work in that it keeps asking me what the relationships are. When I tell it what to think, it doesn't do what I think I tell...
  10. A

    Converting Alphanumeric characters (and spaces) to Numbers

    Well, I ended up doing the opposite of what I wanted, so backups, here I come. It seems as though it will work though. We'll find out when my backups finish backing up... :)
  11. A

    Converting Alphanumeric characters (and spaces) to Numbers

    I get the same problem with a single, double, integer, long integer, and decimal. I'm not used to update queries. Could you explain how to use them?
  12. A

    Converting Alphanumeric characters (and spaces) to Numbers

    Text into Long Integer
  13. A

    Converting Alphanumeric characters (and spaces) to Numbers

    It's complaining about it being too big... Something about "Microsoft cannot change the data type. There isn't enough disk space or memory."
  14. A

    Converting Alphanumeric characters (and spaces) to Numbers

    Excellent. Works great! Now will it just easily convert between a "Text" field and a "Number" field?
  15. A

    Converting Alphanumeric characters (and spaces) to Numbers

    In working with a database, I need to convert 39,000 text fields (i.e.: 6002.2 , 2723 , 6004.55 (Notice the spaces)(commas denote next line)) to number fields. The number of spaces is random, so I can't say "cut off the last n number of characters." There may also be characters...
  16. A

    Need genral info on .Net ADO and Access in VS05

    Just a heads up. This isn't the best place to be looking for answers to VB.NET. Even the name suggests this ("Microsoft Access Help Center"). Try something like The Code Project. They seem to have a more active forum and many more answers for Visual Studio.
  17. A

    VB.NET <=/=> Access database (help)

    Ok, I have this somewhat large number (3800-ish) of, well, numbers (actually project numbers). There is a list of the products (assemblies) that go under project, and some sub products (actual parts or small assemblies) that go under that, and maybe even another level for the extras. I'd like...
  18. A

    One specific error message

    :) Well, an update to the full version (from Express) of Vistual Basic.NET fixed the problem, but now I can't get a pull down combo box to display the project numbers. Actually the program doesn't even run. Anyone know of any active VB.NET forums? :)
  19. A

    One specific error message

    I keep getting the following error message when I try to link to an Access 2000 database: "The .Net Framework OleDb Data Provider requires Microsoft Data Access Components(MDAC) version 2.6 or later. Version 2.53.6307.0 was found currently installed." What does it mean?
  20. A

    EXACTLY how to use a TreeView control

    Well, I decided to with a VB program. I'm a much more avid programmer in VB than I am in VBA or Access (even though I can hardly program in VB, but at least I understand its syntax). Thanks for the links stopher.
Back
Top Bottom