I'm enrolling medical centers in a new multi-center database. There are a number of steps that must be completed before the center is enrolled in the project. I have a form that serves as a checklist. I want the textbox at the bottom of the form to display the percentage of steps completed. I guess you would have to count the number of fields on the form that are filled in, but I don't know how to do it.
View RepliesI need to open form1 from form2 and display in unbound textbox a definite title for the form.
According to the title i want to hide some fields and unhide others.
I have a form that a user fills out and the record is not uploaded to the database until the user hits the submit button. In other words, if the user closes the form without saving, the record is not inserted.
My end goal is to have the user click the button and have 3 things happen:
1) Record inserted into the database
2) A PDF of the record is saved to a per-identified directory
3) An outlook new message window opens with recipients pre-entered and the newly created PDF included as an attachment.
I can achieve steps 1 and 2 no problem. However, the way I get the PDF is by having the VBA simply print and the user selects the Adobe PDF. This does not let the VBA dictate the directory (or file name) and then makes me completely stumped for step 3.
I have created an access database to track orders through out production. I have also created a form labeled "orders" with a subform where it has all the orders information, customer info and product info. Along with this there are 3 check boxes for each order they are labeled, "Routed", "Pressed" "Finished". I am looking for a macro for when I click the "finished" check box that order is moved to another form to reduce the amount of clutter on the orders form. Is there anyway to do this?
View 1 Replies View RelatedI am working with several reports between Access and Excel and I feel like there must be an easier way to do what I need. Hoping someone can help.
I have 4 Excel files, A.xls and B.xls and C.xls. Each with different fields that I will use to join and extract data to make D.xls.
A is the master file that I need to compare B and C to. I need to create a 4th file that will contain all the records on A and only those on B & C that match A. I am using email and ID as the join fields. A has email, B has email and ID, C has ID. I am joining A & B by email to make query A_B which contains all A records and only those on B that have same email. A_B now has fields email and ID. Then I need to use query A_B to join to C. The problem here is that I cannot use the query A_B to do this. I get an error message and have to export the query to Excel then bring it back into Access as another table to use for the last join. This is where I feel like I am doing an extra step. Is there a way to use this last query for the next join so I can end up with a final file that has all A records that contain B data and C data?
I know this sounds confusing but I hope someone can understand and provide guidance. Thanks!
I currently have two froms, "add record" and "add record cont." The reason I have two seperate forms is because when clients create a new record information needs to be saved to two different tables and when creating one from with fields from both tables I ran into many problems. The two tables are named : tblMain, tblFileLoc Currently there is a textbox on both forms named "fileID" the FileID in the first form is from tblMain and is the primary key for that table, the FileID on the second form "Add Record Cont." is just a normal field. When clients enter in the new FileID in the first form "Add Record" and then move onto the next form "Add Record Cont." i need access to bring the entered FileID from the first form and Fill it in the FileID field in the second form. Currently I have tried making the control source for the textbox on the second form = the textbox on the first form but it brought up an error.
View 1 Replies View RelatedI am trying to display the sum of a query into a form textbox and i am not having any luck.
Here is my code that i am currently using:
Private Sub Client_Id_AfterUpdate()
Dim db As Database
Dim rs2 As DAO.Recordset
[Code]....
Me.TxtNotAllowed.Visible = True
dtTimer1 = Now
dtTimer2 = Now + TimeValue("00:00:10")
Me.TxtNotAllowed.Value = "You do not have permission to use this database !"
Do Until dtTimer1 >= dtTimer2
dtTimer1 = Now()
Loop
Me.TxtNotAllowed.Value = ""
DoCmd.Quit
The above code will run definitely for the 10 seconds however the textbox and contents do not display HOWEVER if stepped through with breakpoints line by line and the form checked each time the textbox DOES display and its contents.
I am working in Access 2007. I have a form with 3 text boxes of which I need the Textbox3 to calculate a SUM of the input values from Textbox1 and Textbox2. These text fields will compute ONLY when the record is saved OR if there is a prepopulated value in the text field. EX. When textbox1 is populated with a value when I Openform, then as I input a value into textbox2 I immediately see the SUM in textbox3. Works great in this scenario. However, if both textboxes 1&2 are null, and I input a value into each, then I won't see the SUM in textbox3 UNTIL I save record.
How can I get the SUM to display after inputting the value of my textbox1&2?
How to set combo box for example doctor name with 2 field which display doctor name and department.
Lets say if i select doctor name : Eric and automatically display doctor department as: Surgery in text box. Then I can save patient record on appointment table.
Here is my sample db ...
Hi,
I have a table wherein only new data is provided by the user, and fields that have not changed from the previous record are left Null:
Date Field1 Field2
1 B (Null)
2 A 1
3 (Null) 2
Is there a simple way to produce the following results from an aggregate query:
Date Field1 Field2
3 A 2
(Where [Date] is a parameter.)
Right now my process is pretty clumsy, requiring multiple steps to get the MaxOfDate for each Field, then each Field's value corresponding to its MaxOfDate. Not pretty. :(
Hi,
This is my first post here and I seem to like the activity on this forums. Now to my issue.
I have a table with schedules: Event and it's schedule in actual date:
Ex.
Event1 1/1/2007
Event2 5/1/2007
Event3 7/1/2007 (MM/DD/YYYY)
and I have another table which has the event name, time steps and numbers:
Ex.
Event1 1 1000
Event1 2 1500
Event1 3 1500
Event1 4 2000
Event1 5 1500
Event2 1 1000
Event2 2 1500
Event2 3 1500
Event2 4 2000
Event2 5 1500
Event3 1 1000
Event3 2 1500
Event3 3 1500
Event3 4 2000
Event3 5 1500 (I kept the numbers same for all, time steps are monthly)
Now, I can't think of away to write a query to link the dates and the time steps, eventually reaching to some output as this:
Event1 1/1/2007 1000
Event1 2/1/2007 1500
Event1 3/1/2007 1500
Event1 4/1/2007 2000
Event1 5/1/2007 1500
Event2 5/1/2007 1000
Event2 6/1/2007 1500
Event2 7/1/2007 1500
Event2 8/1/2007 2000
Event2 9/1/2007 1500
Event3 7/1/2007 1000
Event3 8/1/2007 1500
Event3 9/1/2007 1500
Event3 10/1/2007 2000
Event3 11/1/2007 1500
Thanks, let me know if there is anything not clear. Pointing me to the right direction to do this helps a lot since I am kinda lost.
Is there a way to make a query that has several steps that have to be run in sequence, rather than all at the same time?
For example, I want to create a table that is created from 3 other tables that I download.
The first step would be to append all titles from the first downloaded table, not allowing duplicates.
The second step would be to append all titles from the second downloaded table, not allowing duplicates.
And the same with the third step.
It would be nice to be able to do this with one query, but since it gives me an error because I am trying to do the same thing three times to the same field, I can't. I would really like to avoid having to save this as three different queries, like I've had to do with other multi-step queries.
If there's a way to do this, I'll be able to apply it to several other multi-step queries I have.
Also, if that is possible, is it also possible to have several types of queries in one? Like an append query with several update queries, performed in sequence?
(Note: I'm creating these queries in Design View--I don't know enough to write my own queries in sql, except for my one union query--which I had help with--from here, I think. I can, and often do, alter sql queries that others have written for my own purposes, though.)
Thanks,
Siena
Here's the situation.
I have a calculated value in an unbound textbox (avghcppmw). I want to run a query (qinsphistory) in which one of the fields is the value of the textbox (avghcppmw).
Is there any way to pull the value from the form and display it in the query. I'm assuming not.
I also assume the only way to do this would be to create a query that would calculate the textbox value and base (qinsphistory) on the newly made query.
Is this correct?
Table1 has field (% Completed this Period) that may contain a value, or may be NULL for each entry, depending on how much work was performed that period. The records are sorted by date.
Form1 has a textbox that basically keeps a running tally of "% Completed to Date" by summing the "% Completed this Period" for the current period and all previous periods. So, my Control Source for the textbox is the DSum(...) function.
The problem is this: If I am looking at the first record and there is a 0 (null) value for "% Completed this Period," (i.e. No work was completed that period), I want to display 0 on Form1. However, Access just displays nothing - a blank textbox. I tried making a default value, but nothing will show up since I already have a Control Source set for that field. If I take the DSum function out of the Control Source, then the 0 will show up. But, obviously that defeats the whole purpose of the textbox. I guess I'm trying to figure out how to display the DSum value IF it is something other than 0, BUT IF IT IS 0, then I want 0 to be displayed. Any help would be appreciated.
Hi,
I have a query with 3 fields - PaymentAmount and PaymentTotal. The third field is a percentage of the two e.g:
PaymentAmount = 10000
PaymentTotal = 12000
PaymentPercentage = 83.333333333333
In my form I would like a text box to display the two combined i.e. £10.000.00 (83.33%).
At the moment it displays 10000 83.3333333333333. I can use £#,##0.00 to format the current half, but how can I then format the percentage to display 83.33%?
Thanks
I also have a query that displays a date, I would like this date to be displayed within the textbox, not sure how to do this?
View 4 Replies View RelatedI'm trying to use ghudson's browse button in a form on MS Access. It works well, but I'm running into a tiny bug after implementing it into my database.
[URL] ....
I am able to browse, I am able to select a file, and am also able to have it display into the hyperlink textbox.
However, when I try to click on the hyperlink in the textbox, it does not take me to the file.
To fix the bug, and to get the hyperlink working again, I have to modify the hyperlink within the textbox, then bring it back as it was. (generally, I hit backspace, and replace the letter I removed.)
I'm new to access programing and have been working on a handover form for shift workers, as part of the handover we have to include call volumes forcast and actual calls received over a period.
I have a form which links to my table (Handover) the two fields are named, "239 Forcast 18:30-00:00" & "239 Actual 18:30-00:00" I then want to add a third column with percentage variance to show wether the percentage of calls is higher or lower than forcast.
I manually input the data into the forcast and actual fields and want this to then populate a textbox for the variance percentage next to this.
So far I have tried:
=Sum(100-[239 Forcast 18:30-00:00]/[239 Actual 18:30-00:00]*100)
The above sum seems to be a little unstable and when switching to view different handovers the value in the variance stays the same, regardless of the figures in the mentioned fields.
I need a textbox to display the first/earliest date from a table.
RThe table is called tblIncidents and the textbox is txtFirstDate
I've considered a variable and tried with querys etc.
How to update unbound textbox on main form from unbound textbox in subform afterupdate.
that is when amount paid is updated it automatically updates total paid, balance etc.
I have a form that has 3 combo boxes and a text box that I want to be a lookup. I have a little experience with DLookUp, but I do not think that will work here. The three combo boxes are linked to queries, and Tables. The first combo box is for choosing "Precious" or "Base" metals. The second combo box is filtered from the first and displays the "Metal Names". The third combo box is to choose a "Metal Market". There are currently four options for that. I want the text box to display the "Metal Market Price" based on the second and third combo box selections.
Here is a screenshot of the table with all of the metals and their market prices filled in with dummy values for now:
metals screenshot 1.PNG
Metals screenshot 2.PNG
Here is a screenshot of the relevant Form: Metals form screenshot.PNG
Here is a screenshot of the Table that relates to the relevant form: Metals table design.PNG
Here is a screenshot of the Metal Market table that the Query is based on: Metal Market Table.PNG
I have a textbox in a form. What I want it to do is to display the following weeks Monday date. Sounds simple but requires you to know the Monday dates in advance ...
View 14 Replies View RelatedMS Office 2003..I have 7 queries that I use to export data to one excel workbook. Inside the workbook are 7 worksheets, one for each query. I have it working but I dont know how to save the exports steps like I did in AC2010.
I export the data by right clicking on each query and select export , then I browse to the workbook and because each query is named differently , it names the worksheet. I have to run these 7 queries each month , so I would like to save the steps and then build a macro that would run all seven steps at the push of a button.
I have saved the steps on a PC running MS office 2010 and the macro works great. The problem is this resides on a PC that cant be upgraded and I need to make it work on Access 2003 .
I am working on a change control database where the users can enter a new version for the software they just released and send out a notification to the appropriate persons. I have a form where the user can select a combobox to pick the software version, which is bound to my "Releases" table. From the software version I use a DLookup in VBA to change the value of a another unbound text box using:
Me.Release_Type = DLookup("[Release_Type_ID_FK]", "Releases", "Release_ID_PK = " & Me.Release_ID)
This all works fine when I'm entering data in the form, but if I want to print the form, the unbound text box on each page is only calculated from the first record. The same thing happens if I build a report with the same fields and code.
For example: In print preview the text box on page 1 should say "Cat" based on the current record and the text box on page 2 should say "Dog". However, they both say "Cat"
How do I get the text box to display the new value on each page?
I have a form, with a tab control on it. Each tab has a subform to display data. One tab is meant to be a summary tab of the rest, so I want to pull data from certain controls on each of the other tabs to display on the Summary tab.
If I set the ControlSource to Forms!subfrmLABOUR!txtTotalHours.Value the control just displays #Name?
I assume that means it can't reference the ControlSource. Is it just a syntax thing? I've tried various methods, but no luck.