Recent content by JacobSP

Thank you Spike for all your help. I will have a look at the DoCmd.GotoRecord and report with my success. If you have the time, would you mind elaborating on what you mean by allowing Excel to dictate how my data is stored? As the job goes I dont really have much freedom, I am only hired to...

Damn the fishy smells! Once the data has been put into the tables it will then be reported upon, the Risk Excel Sheets are used by the company all year round and are their templates for writing details about their health and safety jobs and 3 maybe 4 times a year they will all be imported into...

You are right about the excel design, but I dont think its the underlying problem as there isnt really a problem, its just my knowledge doesnt stretch far enough with VBA to know how to WHERE the last row of a table. Total impact has to be inputted manually using the text box and button because...

Hey guys. This is my first proper thread to Access Forums after my introduction one so here goes! I have a table in my database called (RiskForm1) and it has many fields in it one of which is called TotalImpact. Now I have some SQL/VBA code earlier in my project which inserts values into all...

Hello Access World. My name is Jacob and I am 19 from Colchester UK. I havnt been working with Access long but have had previous experience in C# and ASP.NET. Im currently working for a private company doing freelance work (mostly for pharmaceutical companys) writing Databases/Applications of...