Search results

Same parameters needed, the context of the letters are different. I just want to run both from one button, versus two seperate buttons. Thanks, Ray

I would like to run another report after this report the next report is ltrvrc, can it be done at the same time or do I need to make a new control button? Thanks, Ray Private Sub cmdcltr_Click() Dim strDocName As String Dim strWhere As String strDocName = "ltrcitation" strWhere...

Thank you very much, that fixed it--Ray

Report on residents. =IIf([unlisted]=True,999-999-9999,[phone]) Unlisted is a check box and if its checked we dont want to print the phone number. data source is a query, the result is #error in phone number. Can anyone shed some lite on my problem, Thanks Ray

IIf ( [visitorlog]![createtime] => 07:00:00 am and <= 03:00:00 pm , 1, 0) gives me invalid syntax

I need to make a report of the amount of records entered into a table based on shift hours; ie midnight shift entered X records, mornings did x and swing did x total entries for the day = xxx how do I count using the time, >07:00:00 AM < 03:00:00 PM Thanks, Ray

I need some help adding records from one table to another. I want to add a record for a date range the user enters. The fields from VRC would be added to VRC Fines would be duplicated except for one, Finedate. That field would be for the dates the user inputs. He enters 01/01/10 - 01/07/10 would...

Let me ask the question different. If you wanted to add 7 records from vrc to vrcfines with the same data 7 times with the exception of finedate how you would build your query? Appending one record at a time works ok, you just have to enter the exact Fine date each time. I've seen this but...

thanks, well this will add a vrcfine for the date I enter, anydate, I want to get it to add multiple records for a date range so I need a second date prompt but cant get the logic to accept. I tried >=[date] and <=[date] its does not like that, is there a "thru" phrase INSERT INTO vrcfines (...

correct, removed all other records to shrink my table. That record would get 7 fines for the previous week if they didnt fix the complaint. So ignore for complaintid for clause, that would actually read the forms complaintid when all is said and done.

This gets it to use the user input date as the finedate...sorry, been experimenting... INSERT INTO vrcfines ( ubl, Name, [vrccase#], complaintid, complaint, fineamnt, finedate ) SELECT vrc.UBL, vrc.NAME, vrc.[VRCCase#], vrc.Complaintid, vrc.COMPLAINT, vrc.Fine, [date] AS Expr1 FROM vrc WHERE...

**correction, thats me playing trying to get it to work...

That date will be the Finedate, if you enter 2/2/10 you should see a fine in vrcfines for $25. dated 2/2/10

and just to note, I would not want to post a dupliate date, duplicate complaint id to vrcfines. In the process the user would see that fines are posted thru say 12/31/09 and would be making a decission to use 1/1/10 as his start date and say 1/7/10 as his end date, issuing 7 days of this fine.

ok, zip worked...thanks

its 660 kb, so its small enough....still trying, get error Database errorThe Access World Forums database has encountered a problem.Please try the following: Load the page again by clicking the Refresh button in your web browser. Open the www.access-programmers.co.uk home page, then try to...

Here is the table the second tab at the bottom is where the user runs the append qry...I hope this uploads, its small..Ray

I appending from a specific complaintid, the vrcfines is an accumlated table of all fines issued, linked to the resident by complainid & UBL(resident). INSERT INTO vrcfines ( ubl, Name, [vrccase#], complaintid, complaint, fineamnt, finedate ) SELECT vrc.UBL, vrc.NAME, vrc.[VRCCase#]...

Hi Brian, Thanks I am using a command button to add record(s) from vrc to vrcfine. I can get it to add a fine by date but only one date at a time. I want to append several records from the form to vrcfines over the past week where no fines we posted yet. When the command append qry button is...

Hi, I have not had any luck geting it to append more than one record. I want to add a record between a date prompt, if I prompt 1/1/10 - 1/7/10 it would add 7 records to vrc fines. You said where clause but I cannot seem to get that to work. Thanks. Ray INSERT INTO vrcfines ( complaintid...