How can I made a form that has some pre-populated fields that can be edited?

[kaschlegel]

We use the same basic schedule each day, so instead of entering every field each day, i want employees to be able to just edit where they need to. I have no experience with VBA. Can this be done with simple forms and macros? Thanks

[rzw0wr]

What do you want in the text boxes?
Where are you getting the data.

Give us the complete story.
post Pictures and/or the database.

Dale

[kaschlegel]

We currently use an excel spreadsheet to fill in dispatch data on a daily basis.
I would like to use a base form with the "scheduled" information, and have our operations agents fill in the blanks or edit whatever doesnt go as scheduled. It's also multiple fields, including everything in and out on a given day. I shift report photo.pdf
I had it set up with just a split form that was blank, and it worked great. I got too many complaints from the people that are used to the excel format that was already half-filled in.

[rzw0wr]

Busy ain't it?
We need to look at your tables.
Can you upload the database?

Dale

[kaschlegel]

Shift report template.accdbI know it's busy. I couldnt figure out a way to make it the way they're used to (they're resistant to change), and improve on the current out-dated system we have. This is only my second database, so don't be surprised by how screwey it is . It did work great, until I tried making the changes they wanted.
I hate to transfer the main info into a new database, to get it uploaded. The one titled "blank shift report form" is what I would like to open to the OPS agents when they enter the database, with the info filled in that's showing. The other shift report form is what we ended up with yesterday, and that won't work for us.
Thanks for whatever tips you can give me.

[rzw0wr]

Below is your database with what I think you were looking for.
I did not complete fully. It should be enough to get you started.
Post back with questions.

The bases of the database is that someone enters data for a flight.
This is entered on the frmEnterData. Then someone wants to view this data. This is viewed on frmViewData.

I made table for the data you needed. Thid should not be all in 1 table.


I know this is not exactly what you asked for however, we need to get the data into you database in the proper manner then we can fix you problem.


Shift report template.zip

Dale

[kaschlegel]

Thanks so much. I'll work on that.