I have a report based on a query. some of the calculated values are less than one. I would like to have those values default to 1 in the report. Thanks for...

Can someone please remind me how to do this?! I have a mainform with a subform. On the subform I have a calculated control; text41. On the mainform, I have...

I am using access 2000. I created a query that pulls info from 4 different tables. I am trying to create a report that lines up the related records, ACROSS the...

my first time using office i wish to write about my life put it as a book how do i set up pages i.e.

I currently have a table that has arrival and departure times formated in the general date format. In my query I would like to subtract the two dates and only...

I downloaded the File Picker routine from Ken Getz: http://www.mvps.org/access/api/api0001.htm and put it into my database. this is called when the users...

help, how to stop access from rounding up values you enter in a table? i enter this 458.59 and access changes it to 459.00. I have the format set to standard...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

I keep getting the following error message...FUNCTION IS NOT AVAILABLE IN EXPRESSIONS IN TABLE-LEVEL VALIDATION EXPRESSION. I realize this is too vague for...

Using MS Access 2003, I created a database. I am entering data records using a form. How do I set up a search of the table to assure that the record was not...

can i change the Allow Additions daat property via VBA code? if so, how? tia, mcnewsxp

i am trying to send a picture into a contest it states the picture must be formatted to .jpg, or .gif...the picture said it is jpg, but when i submit it states...

Is it possible to carry over the result of one calculation and use it in another. For example I currently have a query setup with the following fields: Stock...

Hello I am having a problem in summing a set of values in a form My fields are UPC, Qty and NettT against each ordered product I can get the line NettT by...

Hi all, I wanted to add a notes field to my database. I'm not sure what I'm doing wrong. When I added the field, it took away the capability to scroll down...

Is there any way to have an Access Table list appear automatically MAXIMIZED when the table is open. I know I can do it manually and I do not know VBA.

can anyone help me with stating my job objective?

¤Ñ¤ô³ò¤Ñ´I*b²Ä¤@®y³æ¦ì¤À¯² ´N¦b¹|´I°Ó³õ³ÄÃä ªþªñ¥æ³qª½³q¦U*«*n¦a°Ï »´ÅK¦èÅK¥þ³¡´N¸} ²{¥»¤H¤G¤Q¤C¼Ó¦³¤@³æ¦ì¤À¯² ®a*ѹq¾¹¼p´ZÆU¦@¥Î ©Ð¶¡¦³§N®ð¾÷ ¤è¦V¤@¬y,*±¦V¤½¶...

Hi, I have a splited database. Please show me how to update its switchboard or send me some websites so that I can learn how to do it. Thank you Loi

I put together a 8 pg. newletter for a non-profit. No web site. Can I somehow share work capabilites? Pub.2003. with another pc? email? or what. I am really...