Recent content by undertm

Hi Bob, Melbourne Australia.

Hi June7 Get the following syntax error, see attached image. Dim i As Integer i = 1 ' Input 14 days Timesheet dataset Do While i <= 14 'this will do x rotations For i = 1 To 14 With Me CurrentDb.Execute "INSERT INTO...

Dave Take a look at the image attached above. Terry

Hi June7 The code did not work. It comes up with Syntax error, its a bit beyond my skills to break it down. Hi Tera Yes, i will simply the code once I get it running. Just for the moment using it to verify the data. Terry

Hi June7 The existing code is working, I am looking to convert it to a loop, so instead of 14 variations of that code repeating, I can have simple loops to manage. Thank you for your input, i will take a look at your code to see if it works. I also found this. For counter = 1 To 5...

Hi Colin Yes, It must be in your signature, I have looked at all your possibilities and there is nothing there. Terry

Hi All Below is one days transactions input for one day of my timesheet. There are 14 days in my timesheet (see image attached) so I would have to repeat this code 14 times, not only hard to manage, but hard to maintain. Here is the code, below, and further down my attempt at a loop. There are...

Hi Colin Thank you very much for your response, however all your website links are showing "Website links: To view links or images in signatures your post count must be 10 or greater. You currently have 7 posts". Having said that I look at many various web sites and could not find a...

Hi All I am writing a Access Timesheet system, but finding too many issues to overcome. Things working A) data entry form (fortnight cycle) B) SQL to push data into table C) Error control D) Templates for certain types of trades. However still so much to do like; Approvals process and...

Hello All I am writing a Timesheet Access app. about 20% into it because I could not find a good sample online. (if anyone has a good one let me know). Anyway I have the data entry screen going and it collects and populates the data into a table using SQL vb script. (see screen shot below)...

Hello Did you end up getting your time sheet working. I have been looking everywhere for a good example, but most online are either very simple or rubbish. Can anyone help if they have an example working time sheet db system. Enter time sheet data Approve or reject Reports Summary...

How do i attach an example?

Hi All I have two tables 1. tblBudgets and 2 tblMaterial_Purchase_Request and one form "frmBudgets" The tblbudgets is a single record table which contains the 2019 budgets. example ID Fin_Year Insurance Stationary When the form opens using the about table, i put the budgets in the single...

Hi Johnathan Could you upload your finished db for the world to share, I will continue to upload as I dev as well. Thanks Guys

Is there a method we could detect where the client is using Outlook or Exchange server. (or does the Exchange server version work with Outlook). Fantastic work guys Could some one add more names of field like Start Time, end Time (both dates and times) Also could some one help me so I can...