Search results

Hey Husky, Thanks for the reply. I am working on a query that retrives 1 record at a time and locks it. I'm testing it this weekend. Thanks Rich

Hey Pbaldy, Thanks for the reply I have qry that calls the records that need to be called. I have added a field to the table of these records called RecHold. So run a select query or a update query? I've tried this a few times and can't seen to get it right...GRRRRRRRRRRRRRRRRR I have...

Hello All, I have a call center and Im trying to work out a call que. I have 8 operators. 10000 records that need to be called. I'm trying to create a query that will select the first record avilable from my table. when the next operator has completed his call do the same thing and so on...

Hello All! I am trying to to create entries into a table called tblinvoice for auto loans. If I have a 12 month loan then the re will be 12 entries with the due date and payment amount due. etc. I am using code I got here and I have part of it to work however ther are always problems. My brain...

Ar Hey Bob, Im trying to figure this out also. Any suggestions? Rich De Gray

I would be very interested in any code you have for movin gInvoice data from Access to Quickbooks. Thanks RIch

I just upgraded my operating system to XP from 2000. Lot's of problems with my access 2000 database. Any help would be appreciated. All my controls are not working and functions are hit or miss, Date() function not working at all....................HELP! Rich :confused:

Tony, That would be great! Thanks Rich

Hey PDX, Thanks for the help! It worked great! Rich :D

I accept Credit Cards Over the Phone. I send a receipt to the Customer with the entire CC Number xxx Out. I want to set up an Input mask in my receipt report that will only x out the first 12 numbers. Like this: XXXX-XXXX-XXXX-9999 I have try several times to accomplish this. Any help would...

I had the same problem. I store the hyperlink path in my table but I had to run an expression to get there. Before Update If (Not IsNull([Debtor ID])) Then Me![Hyperlink] = "\\DbServer\Documents\" + [Debtor ID] + ".tif" This added it to the hyperlink field, now all I have to do is figure out...

On my Main form I have a drop down box with catagory's that can change for the current record. I want to be able to use this to update the catagory in the Sub form records. There may be 1 to 6 subform records that relate to the main form. Any suggestions? Rich De Gray

Drilldown Ok Great any suggestions on the best way to accomplish this?

I want to be able to drildown thru my data say in a report that totals sales figures for the month to the basic data behind the totals in a report or form. As suggestions? Rich1968

I run A collection Agency. I know i know but someone has to do it! My fee is 40% Example 1000 Owed 400 Fee 1400 Balance Due Thats the easy part! When a payment is made how do I calulate the fee? 1400 Payment *40% Fee Percentage 560 Fee Earned This should be 400 It gets worse when...

I have a data entry form. On this form are a number of fields I would like to populate with information based on the Account type of the Customer. ie. nsf checks, apartment leases, legal claims etc. When I enter the Customer Id I use a combo box to pull down a list and choose the correct...

Using my Data entry form I have a combo box to lookup my Customers ID. After selecting the approporate ID I go to the next field. in the before Update event procedure I have the following code. 'Dim VarX As Variant 'VarX = DLookup("[Account Type]", "Customers", "[Customer ID]= Me![Customer...