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...
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...
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...
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...
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...
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.
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...
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...
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...
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"...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.