Search:

Yes. One that doesn't exist. This was my solution, which seems to work.


Private Sub Form_Open(Cancel As Integer)
Dim strWhere As String
strWhere = "ReceiptNumber=[Enter Receipt Number]"...

I have a switchboard that has a Edit Record button. When the Edit Record button is clicked in call frmCheckInEdit. The operator is instructed to enter the receipt number. The On Open event on...

sorry for the belated response. I was called out of town expectantly. Many thanks.

Tom

I am try to select records based on the following:

1. I want to include the record if RentPaidDate is prior to ReportBeg date and the RentBeginDate is >= ReportBeg date. This I think this would...

Thanks for your solution. I solved the problem slightly differently. Leaving out the rounding functions I used

TotalTaxeAmt: [RoomRate] * [StateSalesTaxRate] + [RoomRate] * [LocalSatesTaxRate]
...

I have two fields in tblTaxRate where StateSalesTaxRate = 5.75% and LocalSalesTaxRate = 2.00%. Both fields are set up as follows:
DataType = Number
Field Size =...

Thanks. I am not trying to read the SNP file in Windows 7 but to E-mail it to a user that is using Windows XP. The addressee has no problem reading SNP files send from other non Windows 7 users. It...

I have a database that uses the following On click event code

Private Sub cmdPrintSecurityDepositRefund_Click()
If [TrfDepositCheckBox] = -1 Then
Me.DepositRefundAmt = 999
Else:...

They have the Original Office 2000 disks and it is currently installed. They have 25.2 gigs of unused space on the hard drive. Having the Office 2000 disk in the drive did not change the abort.
...

Am trying to have a remote location install SR1a to Access 2000. They are running windows XP Home with SR 3 installed.
We tried installing Access SR-1a from...

Sorry for the delay in responding. I was traveling and did not have access to a computer.

When the frmCustomer is first opened, the first record in the table is displayed. We were having a problem...

I am attaching a stripped down database. Thanks for looking at it.

Tom Goodwin[attachment=85525:Woody.zip]



You are trying to Save in a context where Access cannot Save.
What is there in...

Thanks for the suggestion. I had previously tried this to no avail. Tried again, also to no avail.

I will post a stripped down database in a few minutes.

Tom


quote name='PeterN'...

If you close frmCustomerEntry without clicking on the Check In button, all of the information is saved correctly. If you reopen frmCustomerEntry and use the locate record functon for the record just...

I have a frmCustomerEntry on which customer information is entered. After completing the information, the operator presses the Check In command button on frmCustomerEntry. At this point I am trying...

Many thanks. That solved the problem.

Tom


Are you using DLookup to retrieve the values? DLookup tends to return a string value even if the field you're looking up is numeric.

If so, try...

Thanks. I thought the field size might be causing my problem but that was not it. I have several tax rate lookups that are working fine. I have a query that does the lookup and returns...

What is the best number format for a percentage in a table that would always be less than 100%?

Tom

Many tanks for the assistance. The formula turned out to be working correctly. The problem was in another field which was adding the tax amount in which made it look like the formula was not working....

I verified that the date in the formula is #06/30/2007# and RentPaidDate is in fact 06/01/2007.

RentPaidDate is a field in tblRental
Date/Time
Short Date
99/99/00;0;_

Tom

Yes.

Tom


Is the RentPaidDate a Date/Time field?

I have a calculated field, ExtraKP, in a qryRentCalc0

I am trying to make a tax calculation when two conditions are met:
1. When [PState] = “SC”
2. When [RentPaidDate] is after 06/30/2007.

My...

Many thanks the new code works fine.

Tom





Sorry, I had the condition wrong, try this instead:

If I don't add tblTaxRate to query, the queryasks for EffectiveFrom and EffectiveTo. The query returns records but the State Tax Rate field is blank. I am trying to figure out the quotation marks....

I currently have tblPropertyName that has among other fields 4 tax rate fields. There are multiple properties that are identified by PropertyIDs. Currently there is only one set of the 4 sales tax...