Description:
Microsoft Office Access newsgroup.
|
|
|
Loading Table with Associated Foreign Table
|
| |
Hope I've expressed my question correctly in the title. I have two separate tables. Table1: fldIDRepairName << AutoNumber and Primary Key fldRepairName << Index, Unique fldIDGroupName << Link to Foreign Table Table 2 ( I call this Foreign): fldIDGroupName <<AutoNumber and Primary Key... more »
|
|
|
Years of Service Calculation to 2 decimal places
|
| |
Hi there In my database, I have used the following calculation to determine a person's years of service. YearsOfService: DateDiff("yyyy",[HireDate],Dat e()) -IIf(Format([HireDate],"mmdd") >Format(Date(),"mmdd"),1,0) A t the moment, the result is rounded to the nearest whole number. I would like to see at least 2 decimal places. At the moment, if someone has... more »
|
|
|
Converting a Number
|
| |
Does anyone know of a rotuine to convert a number into its equivalent in English, e.g. 400,000 = Four Hundred Thousand. Thanks.
|
|
|
If using checkbox, how to show checkbox and value
|
| |
Hi there In my database, there are instances of checkbox usage. Is it possible to have the checkbox and a "Yes/No" adjacent to the box? That is, if the response is yes, I want to see a checkbox and Yes or if the response is no, I want to see a blank box and No. Thank you in advance.
|
|
|
Access 2007 + Time Formats - Sports Clocking
|
| |
I have a database I am starting to create. I need some guidance in how to best create a time format for a "sports watch". What I need to record is minutes:seconds:hundredths, however the times will need be manually inputted or imported. There will also be basic calculations performed on times e.g car a time for... more »
|
|
|
Learning to send E-Mail
|
| |
Hi Tom and Karen, Glad to hear both of you are out enjoying golf - and that Jerry is getting out with you! Am sure you are glad for the rain - but it's nice to see the sun again! We have had a very mild winter but last week gathered 6 " of snow. and this weekend lots of rain, but will be back to sun and mild in a couple... more »
|
|
|
Error Messae - need help
|
| |
All of a sudden I am getting the following message. Nothing happens when I click on Internet Explorer. The message is: 16 bit Window Subsystem NTVDM has encounterd a system error NTVDM has encountered a system error coh choose 'close to terminate the application What can I do? Any help is appreciated.... more »
|
|
|
Queries returning different formats
|
| |
Hello, I have cut and paste the same expression from a query to another, however when i do this it changes the format of the information returned. In the inital query it returns (Hours:Minutes) perfectly, expression is "LOS (Hours:Mins)": (EDMain!EDDischargeDate+EDMain !EDDischargeTime)-(EDMain!EDPr esentationDate+EDMain!EDPresen tationTime).... more »
|
|
|
If "Yes" in check how do I show value and if "No" no value
|
| |
I have a check box with combo "Yes" or "No". I have created a calculated field that shows a value and would like that value to be displayed if the check box selection is "Yes" and to show a 0 or blank value if "No" is selected. Can I simply add something in the Record Source of the calculated... more »
|
|
|
|
