Request Form, No Idea How To Set Up
Jan 17, 2005
I am thinking of adding a Request form to my database so that if the user wants to add a code to the system, they could fill out the form click send and i would then be able to retrieve all the requests via a report.
I have designed the form to something like what i am after...
i have a few issue's here:
A)
i have set up an option wizard so that user can select if this is a new code or a failure mode request
if the user selects "New Event Code" i want the the text box and label for Eventcode Description to become visible and all others to become inactive.
i will explain what happens if the user chooses "Failure Modes" in a minute.
B) I have no idea what is the best method to sort the following section, if you look at my form at the bottom (Highlighted in red) i need this to be a continuous option as the user may wish to add more than one Failure mode to an Event Code.
C) going back to my options if the user select "Failure Modes" i need the bottom section to become active.
D) If that was not bad enough i have no idea on how to store this in a table.
Definitions:
Event Code ---> Top Line Code
Failure Mode --> Is the Event code description but broken down further
Any Advice or help would be much appreciated
All the best
Andy
View Replies
ADVERTISEMENT
Jul 19, 2005
Hi . I need to have a single form , or nested subforms for data entry. The proble is the main form requires information from 2 other forms, and these forms in turn require information from other primary key fields. I know its basic form design, but i just cant seem to get my head around it. Any ideas?
tblVehicles
VehicleID Autonumber PK
MakeID FK to tblMakes
ModelYear Number
'any other fields that describe ONLY the vehicle
tblMakes
MakeID Autonumber PK
MakeName Text
tblTires
TireID Autonumber PK
MakeID FK to tblMake
TypeID FK to tblTypes
DatePurchased
tblTypes
TypeID Autonumber PK
TypeName Text
tblTireLocation
TireLocID Autonumber PK
TireLocAbbr Text
TireLocation Text (Front Passenger Side, Front Driver Side, etc.)
tblVehicleTires
VehicleTireID Autonumber PK
VehicleID FK to tblVehicles
TireID FK to tblTires
TireLocationID FK to tblTireLocations
DateAdded Date/Time (Short Date)
DateRemoved Date/Removed (Short Date)
tblVehicleChecks
VehicleCheckID Autonumber PK
VehicleID FK to tblVehicles
CheckDate Date/Time (Short Date)
Mileage Number
tblTireChecks
TireCheckID Autonumber PK
VehicleCheckID FK to tblVehicleChecks
VehicleTireID FK to tblVehicleTires
TireMM Number
TirePressure Number
View 4 Replies
View Related
Aug 18, 2004
Bax, I am still dealing with that problem of getting my statistics form to show. Is it possible for me to set it up so that when a new player is added into the player information table that the statistic table will populate itself with the [Uniform #], [FirstName] & [LastName] and default 0's to all statistical fields?
Just a thought....
View 1 Replies
View Related
Apr 14, 2005
i have a curious and annoying problem :eek:
I have a Access 2000 db, been working fine for 6 months+ and suddenly today, two out of three forms give "not a valid password" error on trying to open them.
There has never been a password set on the db, nor on the forms - and the same user who used it successfully yesterday now gets this error, along with any other users.
What has happened and how do i fix it? All ideas welcome!!
Sham :confused:
View 5 Replies
View Related
May 4, 2006
Each time a person enters a part number into the form they will have an option to pick and load other forms. Looking to have 1 form with a cmd button that when pressed will go out and retrieve an object or objects (spreadsheet, word document and etc) and then place in the OLC’s and rename and store this object on a drive with the name of the part number and form name
I want the templates never to change or be updated. Only the objects store on the drive after the command button is pressed or the Ole object is double clicked can be edit.
I've tried hyperlinks, do not want to have operators do save as, also I would have to have all the forms entered for each part number prior to versus just using templates and having them be stored.
Example of save forms names
c:mydocuments racking12341234-Template-1
c:mydocuments racking56785678-Template-2
Not even sure this can be accomplished. See attachment for a visual idea.
thanks dmh
View 7 Replies
View Related
Jun 25, 2014
how to associate the request with column and rows with an existing form?
View 14 Replies
View Related
Aug 20, 2012
I have a form with three subforms (Request, Employee Availability, and Employee Assign) in the image below. The user enters the ID in the Assign form (#4) which relates to the request at the top. When the user moves to the next record I want the value of the "Assigned" field at the top to be updated to "yes" for the record with the same ID as enter below.
In the end the following item with disappear when you return to the record: ID #4, Employee ID 109187, and Request ID 2 from the below form. My problem is I not sure how to get the Request form to update after the user moves to the next record.
View 1 Replies
View Related
Aug 11, 2015
I have been tasked with setting up a certificate request database. I have an Access 2032 FE & SQL 2012 BE. I need to store PDF documents from all our branches.
I have been working on this for the past 3 working days and I have seen a great deal about saving the file path to the database vs saving the actual document in the DB. The documents would be located on each users computer.
I have a Form with all the information that is required by the certification department. On the form is a button (Called InsertID(ID in this case is the persons Identity Docuement)) and the button is linked to a table called dbo_CertificationSupportingDocuments. The table is referenced to the Main Certificate Request table.
The dbo_CertificationSupportingDocuments table is structured as follows:
Code:
[CertSupportingDocID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[CertificateRequestNumber] [numeric](18, 0) NOT NULL,
[RequestBlob] [varbinary](max) NULL,
[RequestFileName] [nvarchar](50) NULL,
[RequestFileExtension] [nchar](10) NULL,
[RequestFileMimeType] [nvarchar](50) NULL
When I click the button I get a Run Time error 3075 "Syntax error (Missing operator) in query operator.
The code I am using is:
Code:
Dim fd As FileDialog
Dim strFileWPath As String
Dim FileNoExt As String
Dim FileExt As String
Dim StrSQL As String
Dim db As Database
[Code] ....
I have been looking at this code for so long that I cannot see what is wrong.
View 14 Replies
View Related
Apr 7, 2015
I'm working on a database to organize and streamline the process that the manufacturing facilities in my organization use to request removal of defective product and raw materials. Currently all of the facilities send me their requests on individual excel spreadsheets via email, which are difficult to keep track of and report on since nothing is consolidated. What I've done is create a form in access that mirrors the current spreadsheet being used, so all the facilities have to do is enter the info into the access form rather than excel. The use of access is more for my benefit than theirs though, as it will keep track of the requests as well as make reporting on the request data much simpler.
When the facilities fill out the request form and select their facility number from a drop down list, I'm wanting them to be provided with a "Request ID" so that they may keep track of the progress of the request. The request ID should be a sequential alphanumeric value that includes the facility's three digit facility code, the last two digits of the year, and the number of the request. An example would be PL1-150001. The kicker here is that I want each facility to have it's own set of sequential numbers. So for example let's say I receive four requests in one week, three from facility 1 and one from facility 2. They should be assigned request ID's such as PL1-150001, PL1-150002, PL1-150003, and PL2-150001.
View 10 Replies
View Related
May 3, 2014
I have a simple access search form , that's based on a query that fill parameters from the form textboxes, when the access form loads its keeps prompting for parameters value which looks ugly .. I want to open the form, displaying all the records in the table and filter when i click search ..
I have a data entry entry form, that i want to generate success message after successful insert in database. I have done it in the button event if no error happens, still if i left all fields blank and clicked save, it displays the message ..
I need to change that to display please fill the textboxes then click save , and display success message when the row is actually inserted ..
Check the following attachment for sample.
View 14 Replies
View Related
Apr 13, 2008
Is it possible to run a query when a check box is pressed? If it is possible how would i then go about comparing the result. I would like it so that a count query is run when the check box is pressed and then if the result is 20 or greater then a command button is disabled. Any help?
View 2 Replies
View Related
Oct 28, 2005
Hi,
If you look in the database below posted ...there is a table that keeps a track that logs the user that logged in and logged out.
What I want to do is based on the last userID logged in show reports for that specific users.
LogID UserID LoggedIn LoggedOut
17510/28/2005 11:33:21 AM
Can someone help we write the code that can do this?
Thanks,
View 5 Replies
View Related
Jun 12, 2006
Hey everyone,
I have a crazy idea that I think would be very cool if I got it working, but have no idea where to start. I have a database that is broken down into a front end and a back end, and there are about 10 users who use it off and on throughout the day. This database has an entry form to enter new records. I am wanting to put a text box or a label on that main form that would turn green if the database was in use by another user, besides the one that was currently looking at the form. It would be red if there are no other users accessing the database. Is this even possible? Any suggestions or input would be greatly appreciated.
Thanks,
Chris
View 14 Replies
View Related
Jul 27, 2006
Yesterday I redesigned some of the forms in our database and all was working fine. It works fine on every pc in the office except 1.
On his pc he gets the following error when opening the database:
"An error occurred while loading form_ContractChargessub. Do you wish to continue?"
If you choose yes the database will open but it doesn't work. I have no idea how to even begin to solve this problem.
I did notice that he was running Access 2003 and everyone else is on 2002. Could this be the problem?
Thanks for any help you can give.
Dianne
View 5 Replies
View Related
Oct 14, 2004
Looking for some advise and help. I think an array will be recommended and if so, please help with code on how to do this.
I am trying to track prescription (Rx) dates (RxOutDate) going out to medical professionals on a particular order. There can be mulitple Rx going out so there will be multiple dates of when those Rx went out. What I would like to do is have the earlies date posted. ie one Rx went out on 10/13/04 and another goes out on 10/14/04. I would like for the 10/13/04 date to show. I'm using a continuous form to display all Rx's per order, on frmRx. I'm trying to display the date out on the form containing the order (frmOrder).
Any thoughts would be greatly appreciated. If an array is suggested. Please help with code on how to it. I've never written one so I would definitely be in the dark.
Thanks ahead of time,
Shane
View 1 Replies
View Related
Jul 5, 2005
hi ,
see below for the current code to find a duplicate surname (this works Fine)
now that ive properly thought it through what i need to do is insert a surename and if (by Chance) when i insert the Date of Birth if this is the same highlight it as a duplicate record. However if these people are twins then i need the option to insert the duplicate record.
any ideas on how to go about this, see code below.
Private Sub Text24_BeforeUpdate(Cancel As Integer)
Dim SID As String
Dim stLinkCriteria As String
Dim rsc As DAO.Recordset
Set rsc = Me.RecordsetClone
SID = Me.Surename.Value
stLinkCriteria = "[Surename]=" & "'" & SID & "'"
'Check StudentDetails table for duplicate StudentNumber
If DCount("Surename", "tblData", stLinkCriteria) > 0 Then
'Undo duplicate entry
Me.Undo
'Message box warning of duplication
MsgBox "Duplicate Name " _
& SID & " has already been entered." _
& vbCr & vbCr & "You will now been taken to the record.", vbInformation _
, "Duplicate Information"
'Go to record of original Student Number
rsc.FindFirst stLinkCriteria
Me.Bookmark = rsc.Bookmark
End If
Set rsc = Nothing
End Sub
View 1 Replies
View Related
Sep 19, 2005
My primary key for my database a WorkOrder Number. The issue is that sometimes problems span a selection of WorkOrders. For example, if we get a lot of bad parts, 3 different WorkOrders might be affected, and each may have different resolution to the effect.
To speed up data entry, I've had a request to make a button that copies the all the information from a current record into a new one.
If much of this information repeats, it this a poor way to handle this data?
Currently it is pretty straight forward with ostly one->many relationships, and this would make things pretty complicated with a bunch of many<->many relationships.
Just want to know ya'll opinions.
View 2 Replies
View Related
Jan 13, 2006
I’m working to ever-improve a Help Desk-like database and I got this idea for “templates.” That is, a quick way to fill out the as much of the ticket form as possible when common issues come in.
So I’ve created a table (Templates)that mimics the structure of my ticket table (Incidents). I’ve gone into Templates and put the values I want automatically entered in each field and I’ve added a combo box and a button on my ticket screen. The combo box is populated, from Templates, with the name of each Template.
My problem is that I have no idea how to make each field on the Incident form populate with the values from the Template table.
Any help would be greatly appreciated!
View 7 Replies
View Related
Aug 4, 2005
I need help with table structure, They keep way too much info. Now that I have said that here is what I need help with. I have been asked to make a small "Ha ha" Database this is what small became. Most of the data for this is in a spreadsheet now I know I can import it where I want it. The main concerbn is that the main piece of information would be the Job Address. Because of all this other information I was not really sure how to setup the tables here is what I have started .
Buyers Information (tbl)
Fname
Lname
Address City State Zip (with a look to qry)"cool zipcode code"
Phones (3)
Email
Ect.
Buyers Realtor Info (tbl)
Fname
Lname
Company Name
Address City State Zip (with a look to qry)"cool zipcode code"
Phones (3)
Email
Ect.
Sellers Information (tbl)
Fname
Lname
Address City State Zip (with a look to qry)"cool zipcode code"
Phones (3)
Email
Ect.
Buyers Realtor Info (tbl)
Fname
Lname
Company Name
Address City State Zip (with a look to qry)"cool zipcode code"
Phones (3)
Email
Ect.
Job Information (tbl)
Address
City (Filled in by Zip)
State (Filled in by Zip)
County (Filled in by Zip)
Zip (with a look to qry)"cool zipcode code"
RoofType (With a lookup to A list tbl)
RoofCondition (With a lookup to A list tbl)
Job Notes (memo)
Appointment Information
Time (now real sure how these time and date will work)
Date ( " )
Appointment Type (With a lookup to A list tbl)
Contact Name
Salesman (With a lookup to Salesmen Table)
Appointment Results (memo)
Referral
As I mentioned this data is in a spreadsheet and most every row has all of the above information ("ha ha, small") but I wanted to get some other Ideas and see if anybody had a better one before I tryed to make it all work.
Thanks
View 6 Replies
View Related
Feb 28, 2006
I may be oversimplifying my idea here, but I'm trying to have Form A, which has a source of Table A have fields automatically filled out with values from Table B when I select a template name and click a button that's on Form A. I simply have no idea how to make something this simple happen. Any ideas?
View 7 Replies
View Related
Jul 6, 2006
I've got 20 checkboxes which i need to do the same thing but individually.
If IsNull(DLookup("[question 1]", "qryQuestions")) Then
chkQuestion1.Visible = False
Else
chkQuestion1.Visible = True
End If
I tried this:
Dim loopy As Integer
Dim tmpquest As String
For loopy = 1 To 20
tmpquest = "question " & loopy
tmpCheck = "chkQuestion" & loopy
If IsNull(DLookup(tmpquest, "qryQuestions")) Then
tmpCheck.Visible = False
Else
tmpCheck.Visible = True
End If
Next loopy
tmpquest works.
tmpcheck doesn't.
I tried dimming tmpcheck as lots of things but no luck.
Any help?
View 6 Replies
View Related
May 9, 2007
I really need to learn how to code in VBA for access. Can someone direct me to a good VBA Book?
View 1 Replies
View Related
Aug 23, 2007
Hello Everyone
I am looking to build and Overtime tracking form and have been pondering on the design of it. Here is my idea and not sure how I should go about doing it (straight forms and tables or queries). I would like to select my employees in a combobox and have their information autofill the remaining fields and/or add new ones. Additionally have fields that I can input any overtime occurred which would be stored in a seperate table but displayed in a sub-form in datasheet view. These fields that were just filled out with the overtime information would clear everytime the add record button is hit.
I know that sounds like alot and sure I can muddle my way through that part of it, the big question I have is do I need a seperate table for every employees overtime? Or is there code/query that can select the records of the selected employee and display the information that pertains just to them?
Has anyone come across or posess a sample database similar to this? If not can someone point me in the right direction for example code and tutorials?
I look forward to hearing from everyone on this.
Thank You
Jaz
View 2 Replies
View Related
Feb 13, 2007
Hi! I have a client who wants a training tracking software built that will allow for simultaneous use by up to 850 users. Is Access a good idea, or should I use SQL, and if yes to SQL, can you point me to some great documentation supporting this? Thank you, thank you, thank you!
KellyJo
View 3 Replies
View Related
Dec 1, 2004
I would like to add a textbox to my main form so that users can enter in some extra data regarding the job they are working on. This text box should tie to the current record of the main database, tableJobLog.
Is it best to keep this textbox as a field in the main database, tableJobLog? Or should I create a separate table (perhaps tableJobNotes) with just this text field and link the two tables?
I would think that having it in the main table would make the table grow considerably in size after some time.
If creating a separate table is better, I would need some guidance on how to do this.
Thank you very much.
View 2 Replies
View Related
May 8, 2006
Hi:
I'm working with MS access only in very basic things.
Rigth now I need to look some information in a Table that was created in MS Access 2000.I don't know if this is a problem with MS Access 2003, because i still have some ones.
1) The Zoom tool is not accessible.
2) The order of the items, change all the time and I need to sort them every time.
If someone could help me in this matter, I'll appreciate so much
Thanks
View 5 Replies
View Related
