Search results

hi i did ask you suggested but the "save the password" check box is no where to be seen , i have done this before in earlier versions of access but for some reason its gone in this version 2016

Hi all its been a long time since my last post but ym new projects has forced me to seek a little help if anyone can offer any. so i have acces 2016 front end and backend is SQL server. All connections work and data is being saved via LAN etc . The data connection is via OBCD 64bit and works...

hi all, thank you so much for all the help you guys gave and the advise . sadly the project i was working on has been cancelled by the buyer despite him having paid for a portion of the project they have decided to go for rebuilt package! shock horror. That said im now free to code something...

hi again doc thanks again for the reply. unfortunately the code isn't ran from the same form its ran after a new payment is entered so its event is when the save payment button is processed on the enter payment form therefore the me. command wont work here at present. do u know another event...

also the database is quite large so i didnt want to upload and remove all data its just a big task i can screen shot anything you think might help of coruse

hi june7 the balance field is used in several places and works well. i can make it work as a unbound field as you say but would prefer it to store on a table and update when changed as it was doing on the slower systems at work.

hi all ive used this site b4 with some success so im hoping i can get some advise with a small issue im having. the problem seems to not work on my pc only but does work on slower systems like the ones at work , very strange!! so basically ive got a subform with some loan repayment payments...

so here is my current issue, ive sorted the dates along the top . thank you Doc ive managed to link the data to a subreport using =[Query3 subreport].[Report]![PaymentMade] easily enough but im thinking is there a way to link to the qry itself rather than the sub report so save me creating 13...

hiya, yes however this is for a sub report on a larger form , id then have to import the data back into access, which i did think would work however the following week the dates change therefore the sub report looks for dates that are no longer creating field name on the cross tab and that opens...

maybe id have to make 12 small queries to find the result of each column in the grid? named them separately and refence each one in the report ? long winded ?

Hi Doc, the output sub report in this case is small there are 12 columns (weeks (Mondays date)) across the top running oldest on the left to newest on the right (in theory) and only one row to display the sum of payments in below it. so for this part at least the data is quite small. the table...

ive been looking at different ways for hours so i guess ill go back and redesign somehow. thinking about what my customer has asked for... we currently have a report "Report-CollectSheet" that shows 5 records per A4 page, customer loan information. Each section shows things like loan date...

ps #I tried to rename my column heading in design view of the cross tab with 1,2,3,4,5,6,7,8,9,10,11,12 representing the 12 weeks but then the sum data vanished , i tried this because i thought if i could fix the name of the headings i wouldn't loose the control in the sub report. once again...

oh i did manage the create a sub report based on the cross tab and thought that would work but when i linked the id numbers from sub report to main report i got a error, ive not seen before but is very annoying because i thought it was working . see photo

i did manage to get this to work "kinda" with one set of data over and over again it worked! However ran into another issue today regarding the data, the date used changes from week to week as we are looking at a 12 week window so between (date) and (date-84). so when we hit a new week the date...

hi all thank you for the comments so far ,

no im using 2019 i think :-(

cray how excell does it in 4 clicks and access sounds like its going to be a big task lol

hi isladogs , not really i dont think it would matter being read only as weekly data can be inserted before this happens so in theroy this is for viewing only, the user can edit each record individually before the qry runs to create the weeks summary. i read somewhere a union query might be the...

i dont mind using excell as long as the process in automatic and the end user never sees it. thats what ive dont with mycross tab previously but i cant seem to find a auto method to transpose