VBA form design, need help creating form which adds things to database

simple VBA data input form (for someone who knows what they're doing)

This is the database format that I require.

database format.png

I need a form like the following in excel which will contiuously add the data (without overwriting)

form input.png

Any help is much appreciated.

Upload a template workbook with the headings you want rather than a picture

Hey Guys I really appreciate your responses. As advised please see attached the relevant spreadsheet. Thanks guys

Any luck on this yet guys? A sample form would be fine. I am just not familiar with the coding. I assume it would be simple if I knew VBA and I used the office for however the layout of the form is just a list of integers which would work however the idea behind it is to add some information which isn't actually typed like "todays date" and "auto assigned number reference"

Did you follow the link posted by John55?

Hey Guys, did as much as I could myself, could you look at this and tell me where the code is wrong?

Much appreciated!

Sorted it guys, Thanks (y)

Hi guys another question, I want to set up the spread sheet to auto assign job number... Example.

There has been 1285 entries on the spread sheet. the spread sheet reference numbers I have assigned are numerical starting from 7000

The last entry was 8285

When I submit my for I want it to auto assign the job number to be 8286. What code should I add to the command button in order for it to enter the correct reference?

Ok it only gets more complicated now. I managed a work around for the job number. However after entering the form information and the database obviously starts taking place. I have tabbed a new sheet which I intend on having a display option for the job sheet

What I have done is recreated the form layout and I want to enter a job number and on the execution of the macro for it to, from the job number given to import all the information from the database onto the form layout.

I believe the macro should have a "findrow" function where column "B" matches "job number given"

Then use the row found to get the relevant info ie. date = row D, on ws.serviceDB copy cell (D, "row No") to ws."view job".(F, 4)

See attached example

I don't understand how that code works. where do I enter the row I need? and how do i activate the macro which pulls in the relevant information to the search

Works good, any way you can build this into a job number (type into text box) and use this text box (job number) to search for that inparticular job number and load up the relevant information with a command button (as per the attachment)