Saving Records to a table

[homeguard]

Hello,

I have some unbound text boxes on a form and want to save the information to a table, how would i do that with a command button?

also does anyone know any good calendar that auto populate off of a table? something like what a sharepoint calendar does.

Thanks

 

[TheAceMan1]

How are ya homeguard . . .

[blue] . . . how would i do that with a command button?[/blue]

have a look at [blue]Append Queries! . . .[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[homeguard]

hmm that kind of looks like what i am trying to do. But im not sure how to do it still.

I have a Series table and an Events table, the series populates the events table based on start date an number of reoccurances, so say i have an event every week for 3 weeks, so say when i add a record to the series table it will add an event for the next 3 weeks, ie. 3 records.

Does this make sense of how i am doing this, do you know if there is some easier way?

 

[djayam]

Have a look at

http://www.tek-tips.com/viewthread.cfm?qid=1398262

- the answer is buried in there!

I think you need to loop until the number of occurances is reached and each time use the INSERT INTO command (DoCmd.RunSQL).

Jason

 

[homeguard]

so i got it all working, thanks for the help.

but i have another small problem.

access prompts the user everytime it appends a record, is there anyway to remove this prompt?

Thanks

 

[homeguard]

ahh found it, tools > options > edit/find > action queries