Search results

So could I use something like this. I have gotten around to most of the questions I had re this one and I feel like I am almost there I have checked and it does return the last record financial year, Im trying to get this to tell me the highgtest number in that FY 'Check the Financial year on...

@MajP that worked! I imported into a whole new one and it worked. There are some things broken now but I can work through them, possibly they were causing the glitch. Thank you so much everyone. I feel silly not doing that in the first place.

Ok so that is another weird thing I have noticed with my installation, I cannot right click on anything in the navigation panel - I was trying to rename something a while ago and it wouldnt work.

@MajP I am having trouble understanding this with my limited access understanding. If I already have the financial year in the table as calculating when the job opens do I need the first function? The other issue is as well is that the ID field will start again with each new FinancialYear So...

I think I might just get up, step backwards a few meters then run into a wall!! Urgh. I will try and see if I can use it on a completely different installation of access. Thanks @June7 & @theDBguy

I I cant, no. Looks like @theDBguy can however

So maybe something is corrupted in my version? I have tried two computers and tried to repair my access version

Hopefully this works

Ah sorry I see what you mean. Yes it does look the same.

No it doesnt do anything there

You can see the design view icon is there but when you select it nothing changes

Sorry it did open in layout view. Its access 2016 and Im using Windows 10 if that matters

Hi experts! I have one form in my database that will simply not open in design view. Any clues? All of the others will. It is a form that came from someone else but I cant see why that would be it? Thanks in advance

Thanks @plog I was overthinking it

So check the Financial year is current first, if its not just calculate the field to "1", else DMax + 1... Actually it might be easier to see if the new financial year is unique and if so start at one... Is there a way to look up that? Unfortunately the data that came across means the financial...

@plog if only it delivered a fine wine... It just did nothing, zip zero. You actually answered what I was going to say to @GinaWhipp I thought it would just find the Max and it could be higher in another FY, so you are saying I can do that by checking the highest number in the FY? :rolleyes:

This is what I have so far and it doesn't work! I still need one more field to add to the project number calculation. I am not sure if checking the prev record is right? 'Calculate fields required to generate project number Dim PrjIDNo As Single Dim FY As String 'Financial Year...

Thanks @GinaWhipp . The client wants the numbers to start again at the start of a new financial year (July 1 in Australia) So I cant even really use autonumber. Im thinking I need to check the FY is the same as the last record, then if it is add one to the numerical field, if not start at 1 again