Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

cann't save data to table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tigerking - 23 Mar 2008 21:59 GMT
I am doing a parts list inventory .  so I have a form named View_all_parts
that show the whole parts in Continuous Forms, and I have a command button at
the end of each record that open invoice_form and retrieve some data for a
specific record ,
invoice_form have these fields:
customerID    "autonumber"
part_number  "from Countinuous Form"-"using =Forms!View_all_parts.Form!
part_number"
part_name    "from Countinuous Form"-"using =Forms!View_all_parts.Form!
part_name"
price            "from Countinuous Form"-"using =Forms!View_all_parts.Form!
price"
quantity       "I have to put the number"

everything works fine except I can not save them to another table, only the
customerID and quantity have been saved.

so how can i save the other data in that table?

thanks
Nicholas Scarpinato - 24 Mar 2008 20:27 GMT
This syntax:

Forms!View_all_parts.Form!part_number

is wrong. It should be:

Forms!View_all_parts.part_number

That should solve your issue.

> I am doing a parts list inventory .  so I have a form named View_all_parts
> that show the whole parts in Continuous Forms, and I have a command button at
[quoted text clipped - 16 lines]
>
> thanks
tigerking - 25 Mar 2008 12:22 GMT
thanks Nicholas, I have change the syntax you wrote but still the same
problem, I can not save the data field that come from View_all_parts only the
field I fill have saved.

>This syntax:
>
[quoted text clipped - 11 lines]
>>
>> thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.