Search results

Hi All, I have been away from this forum for a long time. Haven't used Access for a number of years - Time flys. Good to see some old names still posting. All the best from Tokoroa New Zealand. Bill

I moved the Line to the Top of the Detail Section and took out any code to change it's position. The Expand and contract facility works well now that it does not also need to move the line. there should be a way to move the line but it appears fine at the top.:)

Thanks JHB, Your sample works perfectly. My problem may be the Line. I Will take my line. It may be preventing the Detail from shrinking. I will try some more in 24 hours. Appreciate your assistance.:)

Thanks JHB. This advice helped with the Lines and Text but still have a problem with the Detail Section not shrinking. Maybe Detail uses a different method ?

Hi Forum, MS Access 2010 accdb In a Continuous Form I want to Include (or Not) a memo under each record. If included, the Detail Height and a Line Top need to change ie, fill the space provided. This code is half working. it appears even thought the Text Box control is Not Visible and its...

:) Resolved !! I just noticed the Transaction Table was not in Relationships. Added it a Wala, the forms work fine.

Further tests show the issue is the new form not accepting the vba RecordSource in the Open Event. What could be causing this ?

MS Access 2010 accdb - Using TempVars open forms either for New Record or Edit Record. Two sets of forms - One set works perfect but the other will not accept the criteria for New Record MsgBox checks confirm the Variables are still valid in the 2nd form Open Event yet the If Then does not work...

Hi Forum, We have Fishbowl Inventory and Manufacturing software at work and use iReport. If we need a New report or changes to an existing report, we are at the mercy of Paid Support. I can find a lot of reference to iReport being user friendly. Before I go charging around like a Bull in a...

Running the procedure for loans that have had an Activity since the last Late Fee run would reduce the Recordset to process. This would require some changes to our Database. The Audit Trail would be an improvement. All Repayments are taken from Bank Statements and if a entry is not identified...

The Recordset is only the relevant LoanID's. it is not so large. What needs to happen with each of the records is quite a process. That is what takes the time. Is this what you mean with the faster method ?

Thanks Poppa Smurf, I came to the same conclussion and used an InputBox to get a number between 0 to 8 which will then only use the RecordSet where it is > & < accodingly - wrapped the code in this IF Then and it now handles the Up To 1,000 records in an aaceptable time. :) Thanks jdraw, The...

Hi Forum, MS Access 2010 ACDB. A VBA task is to run through some 8,000 loans and check them for Late Fees. his is very slow on our current PC and I thought of breaking the task into say 4 groups. This could be done by checking the next record and either Processing or going to the next record...

I have just started a new job and may not be able to assist until coming weekend.

Have a lok at this web site. http://allenbrowne.com/casu-15.html There is a lot of good advice here. Including naming conventions.

Some ideas you may wish to consider. Do not use spaces in Field Names and Text Box Control Names - any names. You can use spaces in Captions. Ensure Text Box Control Names and Control Source are not the same. eg Control Source is EmpID then Control Name could be txtEmpID. Your DoCmd code...

If you create a Comand Button to do a task but it doesn't work :eek: then it you need to confirm where the problem first appears. In this case I suggest you test for your recordset working ie does the code return the correct data (what emails to send) and if this is Ok then test the Email send...

This appears to me similar to the age old problem of producing a Catalogue and or Price List from a table of SKU's where the "word" price list document needs to be presented in a way not related to, SKU, Description or other field. Sometimes, more then one ordered document is required. Even...

Maybe you could have a table of significant dates. eg Term start and finish dates. Public holidays etc. this may allow your code to refer to this table when dealing with a given year. Where this would differ from a full year able is the annual input is less but not avoided.

You could add Calculated Fields to your data (query) that uses WeekNumber This additionl field should allow grouping in your Crosstab.