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 SkipVought 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: benbakelaar
  • Order by date
  1. benbakelaar

    Fibre Channel HD setup

    I promise I have been doing my research on this, things are becoming clearer but if anyone could drop a few explanations or tips they would be much appreciated. I recently purchased a Seagate 39103FC Fibre Channel (copper) HD. The connector on the back looks like this...
  2. benbakelaar

    outlook main PST gone (advanced issue)

    OK... user transfers most of IMAP folder to "Local Folders" (mailbox.pst)... File must be 100s of MBs, but definitely not approaching the 2GB limit (which causes errors). This morning, user logs on, Windows triggers a check disk, user opens Outlook, Outlook pops up "Open...
  3. benbakelaar

    Number Formats

    after doing a little research, and again i'll say im just a beginner, but it doesn't seem like access can modify the actual value of the field, just manipulate the calculated value... i started a blank database, though, and noticed there is a "Decimal" type number variable... in it...
  4. benbakelaar

    Number Formats

    can you post the code that you are using to perform the calculations? all you really need to do is add the ROUND() function to the monetary field variables... so Round(moneyfield1,-2) * Round(moneyfield2,-2). although, i don't know why the help file entry is saying negative rounds to the...
  5. benbakelaar

    multiuser form editing (w/o record locking)

    eh heh, yup, answered my own question..
  6. benbakelaar

    multiuser form editing (w/o record locking)

    when a form is closed and then re-opened, it doesnt requery the table that it is linked to? is there a command to refresh the form? i'll take a look in the help files...
  7. benbakelaar

    Number Formats

    ROUND Rounds a number to a specified number of digits. Syntax ROUND(number,num_digits) Number is the number you want to round. Num_digits is the number of digits you want to round to. Negative rounds to the left of the decimal point; 0 (zero) rounds to the nearest integer.
  8. benbakelaar

    Number Formats

    i'm not sure if this would apply to your problem, but could you set the monetary fields as Currency data type? this might allow you to limit storage to a certain number of decimals. also this note from the DecimalPlaces property help file entry... Note The DecimalPlaces property setting...
  9. benbakelaar

    Command Button to List Box?

    i am new here, and not the best access programmer, but if you are in design mode in the form with the command buttons that are linked to queries, you should be able to turn on the Field List (menu View - select Field List) and then drag-n-drop the fields you are referring to, and they will...
  10. benbakelaar

    multiuser form editing (w/o record locking)

    i have my database on a network server, and all 3 users are directly accessing it in shared mode w/record-locking turned OFF. i have the main form set so that when a change is made, the form is closed and reloaded. however, if multiple users have the database open, any changes made, for...
  11. benbakelaar

    store combobox value in form to table

    ok, i realize this was a very beginner question. i had tried searching around the forums but i did not even know what i was looking for. anyway i figured out to use an SQL statement, and got that working. however, after successfully executing, access gives me an "object required&quot...
  12. benbakelaar

    store combobox value in form to table

    i have a form that has two combo boxes, one selects a students name, the other selects a course name. i need to have a user click at the end of the form and store those selected values to a course registration table. i am familiar with access but do not know how to reference the table inside the...

Part and Inventory Search

Back
Top