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 Programming / December 2005

Tip: Looking for answers? Try searching our database.

Forms based on Query & Data Entry

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gage - 22 Dec 2005 15:35 GMT
Using a form based on an Access 2002 database to create labels. Prompt
for 2 things, one is a part number, other is a serial number.

Part number does a search, and comes back with description and othe
information, and the Serial Number is pasted onto the label.

What I need to figure out how to do is allow me to enter in multipl
serial numbers into an array, and have it generate a form for each one
all using the same Part Number entered, so they each show as a separat
page in the Print Preview Form which comes up.

I know VBScript (at least I used to, been a while since I worked wit
it) but can't seem to figure out how to hardcode prompts and return
like this, since the prompts appear to be done automatically by th
varius Text boxes on the forms. The code section of the form itsel
appears pretty much blank.

Note: This is an already existing and functional form, I need to modif
it

--
Gag
TC - 23 Dec 2005 13:49 GMT
Sorry, I think your question is too unclear for people to answer.

You have a form. The form requires you to enter a part number. When you
do enter a part number, the form replies with the part description &
other relevant information. So far, so good!

Then you enter a serial number. Exactly what does happen then? Exactly
what would you like to happen instead?

TC
TC - 23 Dec 2005 13:51 GMT
PS. And where does VBScript come in to this? The programming language
for Access is "Visual Basic for Applications" - VBA. VBA is similar to
VBScript, but not identical.

HTH,
TC
Gage - 25 Dec 2005 03:57 GMT
Sorry guys, after I posted this I realized that I had mistaken Forms an
Reports in my head, and posted this in the wrong forum. That's why
edited the first post to ask it to delete it, since I couldn't find th
option to delete it myself

--
Gag
 
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.