Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem Adding Records to Forms 1

Status
Not open for further replies.
prodcontrol

prodcontrol

Technical User
Jan 7, 2004
49
US
When I try and enter data on my forms it not only does not save but on the record select bar at the bottom of the box does not give me the option to select a new record.

When I try and save what I have entered and close the window and then open it back up, I am still on the first record only it is blank again.

Any hints.

prodcontrol.[ponytail2]
 
Sort by date Sort by votes
What recordset type do you have for the form? If it's snapshot, you won't be allowed to add data to the form, only browse thru it.

Having the recordset type property set to snapshot will also disable your new record button.

HTH


Greg Tammi, IT Design & Consultation
Work: Home:
 
Upvote 0 Downvote
for some reason when I go to file_send it does not give me the typical sending options. Do you know of another way to send it?

prodcontrol.[ponytails2]
 
Upvote 0 Downvote
I am back, were you able to pull up that database I sent you?



prodcontrol.[ponytails2]
 
Upvote 0 Downvote
I never received it ... if you're running WindowsXP, right click on the database and select Send To, then select Compressed (zipped) folder.

Then right-click on the zipped folder, highlight send to, and then select Mail Recipient from the list, and try to re-send to me.

Greg Tammi, IT Design & Consultation
Work: Home:
 
Upvote 0 Downvote
when I right click on the database it does not give me an option to send database.



prodcontrol.[ponytails2]
 
Upvote 0 Downvote
prodcontrol:

you have no underlying recordsource for any of your forms - hence, since the database has nowhere to place any of the data that you enter, you'd won't be able to add new records.

I would suggest constructing the tables that you require based on the layout of each of your forms, set the form's recordsource to the appropriate table that you built, and then try again.

Regards,



Greg Tammi, IT Design & Consultation
Work: Home:
 
Upvote 0 Downvote
I made one table if you unhide it with all of my information in it. Now that table needs to be linked with the forms and fill in the appropriate feild on all the forms. how is that done?




prodcontrol.[ponytails2]
 
Upvote 0 Downvote
first step is to open the form in design view, and bring up form properties. set the control source of the form to the table that you want.
next step is to click each control on the form, and set the control source property to the appropriate field in the table you've selected.

note that both these property settings have drop-down menus associated with them, so you don't really have to type anything in - just pick from a list. :)


Greg Tammi, IT Design & Consultation
Work: Home:
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kingz2000
  • Locked
  • Question
Bound/unbound forms
Replies
2
Views
238
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
277
Andrzejek
Andrzejek
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
347
PrimoSteve
PrimoSteve
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
176
renigar
renigar
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
192
visitnag
visitnag

Part and Inventory Search

Sponsor

Back
Top