I have a Maintenance work order form I would like to filter out completed records so when the form is open it will only show workorders that need to be copleted and also a way to view all the workorders that are complete
Thanks
I love all the email post information that is available, but I haven't been able to find exactly what I am looking for...
Suppose a customer enters a computer workorder request. Then upon completing the form, your boss wants it to automatically send your office an email "your.office@here.com" and the requester's email (which it would get from email field the customer just entered their request into). The boss wants it to also include in the subject line "Workorder #" and then the workorder autonumber that was assigned to that workorder request. The boss also wants certain information inside the body of the email... ProblemType, Description, Remarks & LastName.
This should be sent automatically without the "customer" knowing or having to interact with outlook in anyway (if possible).
Thanks!
I have a table called customers and subtables are linked to this table. for example contacts, etc..;
I would like to make a search form where i have criteria fields like street, id code, customername, customername, etc....
I would like to have one Search button so when I enter criteria like the name or the street I just have to click one button. And I would like to have 1 reset button to delete the criteria in the fields so I do not need to clear each time all fields.
also I would like to see in that screen a subform where i can see the found criteria so I can click one button to open customer details.
can someone help me on that issue or does someone have such a form allready?
:rolleyes:
Im tinkering with a new form for data input..
We use 2 different forms for employees based on status. Pending, and active. Staff members should not be able to be set to active unless all the fields on the Pending form are completed. Is there anyway I can check to make sure the form is completely filled in before allowing a status change to Active?
I have created 2 tables, one for direct customers and one for indirect customers. (I consider indirect a customers customer). The 2nd table has a field that links every indirect customer to a direct one. I also have a table for inserting credit notes. The credit note is either for a direct or an indirect customer. I am using a form for this one. So the form has 2 fields, one for each kind of customer. If the customer is direct, i only insert the direct customer field. If its an indirect customer i insert the indirect customer field. What i want is to create a combo box that when choosing an indirect customer, to display the linked direct customer and to save it to the direct customer field.
View 2 Replies View RelatedI have an old access database (written with 2003 but running under 2010) that creates workorders and I need to change a couple of the reports to print three copies with each copy having different text in the footer. I'm converting the reports from a old DOT Metrix special form printer to a laser printer. I have already modified the reports as far as the titleing and cosmetics are concerned and they print and look great on the laser printer. I have also added a TxT box that I want to contain the information on the report.
The reports are generated in a couple of different ways off different screens in the system off buttons, but I figured if I can get one of them to work I can replicate it to the others.
I have gone through the reports forum and have found a couple of solutions but can't get them to work. This is what I have found:
On the on button to print a range of workorders (it drives a query that asks for a starting workorder number and a ending workorder number) click from the from the switchboard:
DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "1"
DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "2"
DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "3"
Then I have this code but I'm not sure where it goes. On the report in the "on open" expression? not sure..
Select Case Me.OpenArgs
Case "1"
txtBox62 = "Shop Copy"
txtFld1 = [qryField1]
[Code] .....
I am trying to auto populate a form from a table containing CustomerID, CustomerName and PCCID_FK
Now in the form I want to auto populate the field cmbPCC when I update the cmbCustomer
using dlookup I've managed to show it manually
=DLookUp("PCCID_FK","tblCustomer","CustomerName='T est'")
It gives the ID of PCCID_FK which is what I want. how do it I modify the expression to replace the TEST part with a value in a combo box.
or is there a better way of accomplishing this.
It's me again... :(
After getting (with a lot of help from ansentry) my database doing exactly what I wanted. I realised I wanted more... by my tiny mind can't see how to approach it - despite on the face of it looking like the simplest thing to do.
So here goes:
I have a table of customers. I also have a table of jobs, or workorders assigned to each customer. Each customer can have multiple jobs added at any time. All this works perfectly.
Now I want to assign parts (i.e. cables, tools, software) to each job. So each Job (sorted by WorkorderID) can have multiple parts added to it.
I'm using control tabs as well and would prefer it if I could use some kind of button on the Customers' Job summary view to "Add a Part".
Here's a link to my previous questions, complete with pictures....
http://www.access-programmers.co.uk/forums/showthread.php?t=108706
Ideally, it would be great if the Job Summary view I have made could also have a column saying how many parts have been used in the job. (This is very much a nice-to-have!)
I tried a search on the forums for clues, but I reckon I'm either not searching the right way or this is so easy no one else has asked it. Apologies in either case. Any help would be great... :D
hi, i would like to be able to prevent a user from being able to change a field (lock a field) in a main form if a field in a subform is complete. (the field in the subform is named: "new_weekly_base" if this is complete then i would like the field: "weekly base" to be locked on the main form. is this possible?, please help.
the main form is named: "SCREEN-MAIN"
the subform is named: "SCREEN-SUBFORM"
(the main form has a button on it which loads the subform.)
ive tried the below code but it doesnt work, any help would be excellent.
-------------------------------------------------------
Private Sub Form_BeforeUpdate(Cancel As Integer)
If [NEW_WEEKLY_BASE] >= 0 Then
With Me.WEEKLY_BASE
.Visible = True
.Enabled = False
End With
End If
End Sub
------------------------------------------------
For a graph i have the below code sql to define the chart results
SELECT [Load],[Displacement] FROM [try];
try is a text box containing a table name within the access DB. how do i change the FROM sql statement to look at the name in the text box and use it as to draw the graph?
options in the text box are for example
TABLE1
TABLE2
etc....
If i use
SELECT [Load],[Displacement] FROM [TABLE1];
SELECT [Load],[Displacement] FROM [TABLE2];
all is well, i need to get it to look at the text box, well a combo box
For a graph i have the below code sql to define the chart results
SELECT [Load],[Displacement] FROM [try];
try is a text box containing a table name within the access DB. how do i change the FROM sql statement to look at the name in the text box and use it as to draw the graph?
options in the text box are for example
TABLE1
TABLE2
etc....
If i use
SELECT [Load],[Displacement] FROM [TABLE1];
SELECT [Load],[Displacement] FROM [TABLE2];
all is well, i need to get it to look at the text box, well a combo box
Hello Everyone,
I just migrated a back end to a network server. Now when more than one tries to use the database they get a file in use error.
Any ides?
I am new to Access, I know I couold do this easily in other DBs using a dependant relationship... but I can't get a handle on it here.
I have Client, a State and Coutry tables. What I want to do is assign a Country to a State (in the State table?) and then when I choose a State in the Client table, the Coutry field is completed automatically.
Any ideas?
Greetings to all, :)
i have a database with a few tables, but i need a special one that stores initial date and final date for a particular ID, but like this... :confused:
The table has the folowing fields; ID,STAGE,INITIALDATE,FINALDATE
New record:
ID1 - STAGE - INITIAL DATE - FINALDATE( leave blank )
New record:
ID2 - STAGE - INITIAL DATE - FINALDATE( leave blank )
When ID1 is repeated it must detect the blank field ( FINALDATE) , fill with the now date ( to finalize the record ) and also add a new record ( ID1 - STAGE - INITIALDATE - FINALDATE ( leave blank again ).
It also can have other records of other IDs in between.
I think i need a VBA code to detect the last record for ID#, detect FINALDATE field, write the date on it, save, and add a new record again.
Can this be done? :rolleyes:
Many thanks in advance
I have a table which contains:-
Employee ID Full name
AD Alison Doody
AM Ape Monkey
PT Pet Tepee
etc
etc
In a form i want to be able to select the Employee ID and then next to it in another box the full name appears.
I've looked at other auto complete post, but nothing seems to match what i want to do.
Can anyone help? :confused:
I have a table which contains:-
EmployeeID-----Full name
AD------------- --Alison Doody
AM---------------Ape Monkey
PT----------------Pet Tepee
etc
etc
In a form i want to be able to select the Employee ID and then next to it in another box the full name appears.
I've looked at other auto complete post, but nothing seems to match what i want to do.
Can anyone help?
[for those of you who read the extremely BIG writing in the last post of the same as above, i apologise!! My PC decided to have a hissy fit just as i hit the submit button :mad: :o ]
I have a table witch hold a reference number in one field, house number in another and street in another field. I need to create a form that when the refernce number is entered by the operator the house number and street are automatically entered in the other fields. I'm not sure how to go about it can any one help.
Steve
Hi
Does anyone know if it is possable to get access to complete some fields based on data you have already entered? For example, if there were 2 fields 'title' and 'sex', is it possable to set the database up so that when you select Mr, the next field automaticly enters male?
I'm using cascading combo boxes with sql in each subsequent combo similar to:
SELECT DISTINCT [incidentnavigation].[type] FROM incidentnavigation WHERE [incidentnavigation].[involved]=cboincidentinvolved And [incidentnavigation].[person]=cbowho ORDER BY [Type];
If the result of the query is one line, i.e. click arrow and there's only one choice, can I get access to auto-fill in the box?
I tried an excel kind of if(count(query=1) then etc and it doesn't like it.
K,
I'm new here and I have a question:
In my db I have a yes/no tick, now I want to create a button that clears out all the ticks in that specific column, possible?
To clarify:
I have an address db with an gift table (tbl_gift) and a yes/no parameter for, lets say, 'did they gave me a present with christmas?' (col_gift).
Naturally I want to clear their records before next christmas, now instead of going through all the records and remove the tick, is there a fast-one-button-click solution for this?
Thanks in advance!
Paul
(btw: sorry for my English, I'm Dutch and damn proud of it!)
I'm trying to get a complete list of folders within a given Folder but can only get it down to the level of the main folders sub folders but should a sub folder also contain folders it misses these.
My code below builds a list like:
c:fld1fld2fld3
This function is used to fill a combo box
Function ShowFolderList() As String
Dim fs, F, f1, S, sf, All, AF, FC, sb, sb1, sbf, sbc
Dim Lst As String
Lst = ""
Set fs = CreateObject("Scripting.FileSystemObject")
Set F = fs.GetFolder(Me![FoldersRoot] & Me![StartInFolder])
Set sf = F.SubFolders
For Each f1 In sf
Lst = Lst & f1 & ";"
Set sb = f1.SubFolders
For Each sb1 In sb
Lst = Lst & sb1 & ";"
Next
Next
'Now Remove The Last ; If Their
If Right(Lst, Len(Lst)) = ";" Then
ShowFolderList = Left(Lst, Len(Lst) - 1)
Else
ShowFolderList = Lst
End If
End Function
Hello,
I have finally completed my database project. It is a split database. Back End on a network server.
I want to distribute the front end to all users however I want to limit to the best I can what they can do to it. Can someone please advise me on the best way to wrap up and send out my front ends?
All security has been established. I am talking about the availability to see the tables, macros, control bars etc..
Any suggestions would be greatly appreciated.
Fen How
Access 2003.
Auto complete was working with a combo box. After adding much functionality
to a database I find that auto complete does not work on any combobox in any
form. So I create a blank database and a simple test shows that auto complete
works. When a form from the faulty database is imported in the test database,
auto complete stops working on the test form. Even if the imported faulty
form is removed, auto complete still does not work.
I tried creating a new database and importing the faulty form after removing
all controls and events from the form except for the combo box. Auto complete
still stops working. Not only on the imported form but also on the existing
form which works prior to the import.
I checked auto expand and it is 'Yes' in all conditions.
What ever is causing the problem on the faulty form seems to cause some
property of the database to change.
Is there some database option or property setting that controls auto complete?
Is is possible that importing a form will cause a database property to change?
--
RobGMiller
Hi,
I'm trying to create a table which needs some feilds to be automatically filled up when the control goes to it. Say my table has feilds, "size" and "result". In each row, the result cell should be filled up corresponding to the size value of that row. This needs to be looked up from an existing table.
Would appreciate any solutions!
I'm trying to setup a process of opening a form, saving to a location, emailing it as a PDF, killing the PDF, move onto the next form - rinse wash repeat until done.The below works fine on a single click, however if I try to set it as an event timer of loop, I get an error saying: This action cannot be carried out whilst processing a form or report event.
Do
Dim outputFileName, Ref As String
Ref = Vici_URN
outputFileName = CurrentProject.Path & "Claim PackagesCICA" & Ref & " - " & Format(Date, "yyyyMMdd") & ".pdf"
[code]..
I have 2 tables:
-tblServices
-tblPricesPeriods
Each of the tables has fields for:
-StartDate
-EndDate
The logic behind the database is that each service is contracted for certain period, from StartDate until EndDate (if EndDate is not given - null - it means it is a permanent contract). For each service, we need to input prices. As prices may change during time, we may have different prices records for a service - we need to have the service period broken down into subperiods with different prices. So we need StartDate and EndDate for each period for which particular prices are valid (again, if EndDate is not given - null - it means the prices are valid "forever" into the future from the StartDate).
My problem is: I want to have a check that would return the number of services which period (tblServices) is not fully reflected in the prices periods (tblPricesPeriods). Those would be for example:
-gaps between subperiods (subperiod1 finishing 30.09.2014 and subperiod 2 starting 3.10.2014)
-service period (tblServices) limited by EndDate (not null), while prices period for this service (tblPricesPeriods) having null as EndDate
-start date for service (tblServices) earlier than earliest start date for prices periods for this service (tblPricesPeriods)
-...
Preferably, I'd like to use a normal query for that (or set of queries), but I'm opened to other options.