Search results

In addition to spikepl comments, I would like to add the following:- 1. Avoid using names for buttons as Command20 etc. Use a more meaningful name like assign_frequencies this will save time when trying to debug code. You may know what Command20 does now but will you know what it means say next...

You can use Case statement but it must be in the format Select Case Name Case 1 Case 2 Case x End select In your case do the following Dim aging_result as string Select Case [Age2] Case Is < 31 aging_result = "0-30" Case 31 To 60 aging_result = "31-60" etc... Case Is > 240...

When I copy from Access to Word or emails I prefer to use the Snipping Tool that is part of Windows 7 Accessories. I do not know if it is in later versions. Using this tool I am able to copy the selected screen area etc.

Use Do.Cmd.Requery "the name of the subform"

Use Call module name e.g. assume module name is save_data then you would use Call save_data

This is the code to add your Period. Replace the [Name of your field] with the correct field name as I am not sure of the field name you will be using. The first [Name of your field] assigns 0 to the field The second [Name of your field] assigns 1 to 6 to the field each time the code loop.

The error means as you stated the field name ExpectContactDate is not as field in your table. Is the spelt correctly and are you using the correct table? You should have a line of code similar to this Set rst_output = db.OpenRecordset("tbl_Followup") I changed the code in my copy of your...

This is the code to add 1 day for the first record and then add 1 month for the next 6 records using your Save Placement button. As PBaldy stated you are adding 7 days. Have a look at your FollowUp table and you will notice that you have 7 records all with the same date. I am using...

Yes, you can pull the field values from an open form e.g.![your table field name]=me.(your form control name). Using your Placement form as an example you add the value of the start date in the AddNew to the CreateDate in the followup table e.g. ![CreateDate] = DateAdd("d", 7, Me.StartDate) this...

I have a problem this statement in your post. If a payment is missed etc. why would you change the historical entry? This would change any previous status reports? A better method would be run the process and produce a snapshot (audit) of the loans, for any discrepancy add a manual repayment...

Look up the following in Access - DateAdd function to add days and months. - For .. next as suggested in message 3 - AddNew method This is the work flow that follows this line of code Me.ChangeDate = Now() You will need an AddNew statement to add the first followup date which will be 7 days...

Post a sanitised version (i.e. No personal data etc.) and I will give you assistance.

You could use 7 queries to append the records for the specific time intervals or use a few lines of code to append the records for the time interval.

Bill 1. What is average number of the 8,000 loans have late fees? 2. How long does it take to process an entry with a late fee? 3. Briefly what does the process a late fee involve e.g. update the existing record or append the data to another table etc. ? Using the ODD and EVEN method would...

Use an append query to append your scanned results to your existing survey data.

1. Create your sub CreateTempTable() as CreateTempTable2() module then run the module and check if there is any error. You could use F5 or F8 to step through the module. 2. Also in your Private Sub CreateTempTable() add a message to check if you actaully enter this area. 3. You do not need...

Yes I know stDocName is a string and it is storing the name of the form BUT you must enclose the name of the form in double quotes when using DoCmd.OpenForm e.g. DoCmd.OpenForm "Employees"

Remove the compact on close and give it a test.

The name of the form must be enclosed in a string stDocName =" & Forms!CopyfrmLogon!cboEmployee.Column(2) & "

How big is the front end? Maybe a compact and repair is required.