how can I get dates to show in last updated and last viewed fields..I did get last updated working but for some reason when I tried to do last viewed, last updated vanished :/
I did try writing code (but im a novice lol, I think that's why last updated vanished).I have got 2 unbound fields called HiddenLastViewed and HiddenLastUpdated thought I might need them.
Hello,
I have a database that has 5 linked excel files. From there I have a form that runs many different queries. I have a macro that updates the queries by running them and closing them. Occasionally I update the excel files and was wondering if there is a way to show which records were added to the linked excel files. In other words, I need to display the new records that were updated. Does anyone have any solutions? Thank you for your help in advance.
I have created a form with two subforms within it.
The TOP subform enables the user to view a specific record (not change it)
The BOTTOM subform enables users to view a datasheet form of all the records and amend them where necessary.
I want the TOP subform to automatically go to the last updated record, meaning that if the user changes the data of a record in the BOTTOM subform it will automatically display the last record on TOP that was updated in the table.
I've looked at the macros available and it only allows me to 'GoToRecord' to either Last, Previous, New etc... Is there any way to go to 'Last modified in the table'??
I now want to update one field (what I type into it is irrelevant) but if this field is updated, it means quite a few others become Not Applicable and I would like that to be populated once I updated this one field. After Update is what I am looking for.I know it is simple (but will mean entering each field name) but it would save me truckloads of time.
View 2 Replies View RelatedI use this
'WHERE ((OperationalRiskEventTable.DateReported)>=Forms!U pdateForm!UDateBegin And (OperationalRiskEventTable.DateReported)<=Forms!Up dateForm!UDateEnd)'
in a query by form.
The problem is that you have to enter a date in the between values for results to show. If I don't enter information into a different field such as Full Name but I enter in 40 into Age then everyone that is 40 years old will show. On the other hand if I enter 40 into the Age field but I leave the Date Reported fields empty then no results will show.
How can I change it so that I don't have to enter dates into the date reported fields for results to show?
I'm creating a form to count the number of employees with birthdays between 2 dates. There are 2 unbound date fields; Start_Date and End_Date. I have an Employee table with DOB field. I've been stuck on how to get the field to return the correct number of employees that fall within the 2 dates.
View 2 Replies View RelatedI need a (group by?) query that shows my items only by the last updated price by date.
Basically i need to show the last date. (MaxDate?)
I keep a database for my restaurant of my food items and change their price everyday. i now have a table that archives individual items by date, price and company in a subform.
Item_id, Item, date, cost , unit, Company
1 asparagus, medium8/12/2005$1.45poundEuro Gourmet
1 asparagus, medium8/13/2005$2.00 poundEuro Gourmet
55 oil, blended 8/12/2005 $4.99 gallon accardi
116 polenta 8/12/2005 $1.58 box accardi
I am trying to kick out an item or inventory sheet by creating this query but i cant seem to group by last date. i have all my items showing up multiple times (as many as i entered)
i have been easily able to create an inventory report off a query i used with only one date that i would change. but now i want to archive prices for charts.
i have tried max dates on item_id fields and date fields and nothing seems to work.
Thank you
I maintain a shared database that I would like other users to be able to see when the data was last updated when they open it so that they can see how up to date the information is from the switchboard.
Currently I am doing this manually by updating the date in a label on the switchboard header, but ideally I would like to add a final action to my update macro (that imports new data into the database) that would automatically do this for me on completion if possible.
I have a main form called "frmMain" and on it I have a text control named "txtBoatStatus". The control source for txtBoatStatus is determined by code that I have in the Form_Current event. The code is as follows:
(begin code sample)
Dim BoatStatus as Variant
BoatStatus = DCount("[BoatComplete]", "tblBoatOrders", "[BoatComplete] = -1 And [OrderPresent] = -1")
txtBoatStatus.Value = "There are " & BoatStatus & " boat orders that are complete."
(end code sample)
Now when I first open the frmMain everything works great and the control will say, "There are 5 boat orders that are complete." Perfect. However, In the instance if I open the form with my Boat Orders and mark off another order as complete (bringing my total to 6), the txtBoatStatus does not update when I reopen frmMain. It will only update and show, "There are 6 boat orders that are complete." if I manually hit SHIFT+F9.
How can I do this automatically? I've tried various things such adding "Me.Recalc" or "Me.Requery" to differnt events, controls, etc. but I still cant get it to show the updated number automatically. How can I get it to update without SHIFT+F9?
I would like to change the colour of field on a form if the date in that field is later than the date in another field.
View 9 Replies View RelatedI have created a database with other to log my clubs sports score by player etc. what I want to do is to create and email form that I can email out so other club captains can send me their scores and info to add to my database.
I do not want to use excel, I just want to know if this is possible using out look to send the email.
There are multiple tables that will need updating. Via the email form. Basicaly the main database entry form i need to create a query or vba code to allow all the fields in that form to be updated via email.
I have form that is tied to a query. When I enter criteria that matches what i have in the table, it returns the infromation on another form fine.
However, if there is no data for the criteria I am entering, I get a blank form. Is there anyway to have the fields of the form show even when there is no data?
1.) I need the formula to calculate 15% in a new field from an an existing field.
Something like: =([15%] of [price])
2.) How can I get some fields to show automatically on the next record?
I have done this in Excel before, but not Access. I do not know VBA. I figure this will have to be done in a query or a macro. I don't even know if all of this is possible in Access. I need to be able to split an Address field into:
Street Number
Street Name
Street Type
Street Direction
And the purpose of this is so that I can pull out the Street Type (Drive, Road, Lane, etc) and update the abbreviations (DR, RD, LN) to the Street Type spelled completely out.
I did this in Excel by creating a Named Range "Types" on a sheet that has the abbreviations in Column A and the spelled out versions in Column B so that I could convert the abbreviations to complete street types. I broke down the entire address into each part on another sheet. Then I did a VLOOKUP to look up the Street Type in Column B in the Types range. Works great! And the only way I knew at the time to do that.
But, by doing this, I have to get the data I need from a download into a spreadsheet, break the address fields down on a second sheet, do all kinds of field update conversions (to get the field names from the download to match the field names in my Access table). This takes extensive Excel programming. I just thought there might be a way to do it by simply importing the data from the download straight into Access. That is easily done, but the Street Types aren't consistent.
There may even be a better way to do this than splitting....something like if a field CONTAINS DR update it to Drive. This would be a long process to set up because there are so many different street types to consider.
This is basically for the purpose of finding duplicates. If there is one entry called 123 Main St and another called 123 Main Street, they are not going to show up as duplicates, rather as two separate records.
I have a form that I want to expand to show more fields depending on whether a user decides to or not.
Basically there will be 5 fields that a user always completes for this form, however depending on whether they answer yes or no on the final field I want it to expand the form and have some further fields that need completing.
If they select yes it should expand, if they select no then the form is complete.
What are some possible ways of achieving this?
I'm mid build on a commitments tracking (pseudo Purchase Order system) project, but seem to have run into an issue with a loop I'm building to allow users to edit commitments. The idea is that an edit form is launched, values amended and the submit button is clicked. A VB subroutine then validates the entries to ensure that the mandatory entries are included. It then writes a copy of the original values to the Archive table, before attempting to update the existing commitment with the new values..
This is working perfectly, apart from the fact that 3 fields that are "updated" are being updated to a blank value..
Code:
Private Sub CommitSubmit_Click()
Dim SQLStr, LastID, DOwner, DHeading As String
Dim ErrState, Dtype, DProperty, DTCA, DITD, DSD, DED, DSP, DRetention, DRA, DRPD, DSupplier, DDOW, DStatus, DUser, DShD As String
Dim Authcheck, Complete, ErrMsg As Boolean
Dim QDF1, QDF2 As QueryDef
[code]...
i want to be able to create an On Click Event when pushing a command button that will run an Update query to update a record and after it has been updated that specific record will pop up on a Form and be displayed. i know a different way is to run the Update query and then have it displayed in a Select query but i want it to be displayed on a Form instead. is it possible?
View 4 Replies View RelatedI have created a Production Tracking database for my company using
Access 2003. Everyone here uses Access 2000, so I have saved the file
as an access 2000 database. I am importing three tables from an ODBC
connection. These tables are being update by another department
constantly. I am using a centralized form for users to view the
information.
If the users are viewing the information and we try to update the
tables they are viewing, we get an error. My question is: Is there a
way around this problem?
This what I have done:
In the module I wrote, I am importing the tables, then renaming them
to the tables the users are viewing, and then altering the structure
of one of the tables. We cannot use linked tables, the reason is we
have only three licenses to access the software through the ODBC
connection. So as soon as three people open the access database they
take those three connections.
Any Ideas?
Thanks,
Phil
I am updating an old Access app. The first form, FORM_A, of the app displays in maximized window - as I want them all to display. I click on a button to open a new form, FORM_B, and do whatever I need to on that form, close that window to return to the first window, FORM_A. When I do, FORM_A is now displaying much smaller.
FORM_A's Has Modal property is =Yes.
When I try to change the "Has Modal" property to NO, it alerts me that all the module and macro code will be deleted - and it is. I made a copy before continuing so I still have a copy of it.
I have the OnLoad event set to a macro that short maximizes the window. I use the same macro for the On Focus event, but it does not change the display on focus.
I've tried changing it to Has Modal = No, then copying the old code back into the blank module for that form - doesn't change the display of FORM_A.
Any ideas? Thanks.
I want to populate a combo box on a form with the last 10 recently viewed records from a recordset.
I have got the last 10 most recently viewed items (records) in an array
MRUL_Buffer (1 to 10) As String
I can't figure out how to get the values in the array into a combo box on the same form.
Any ideas....
Cheers
Hi.. I am trying to add data to the table. Is there any way that if i add data to the table the forms associated with it get updated automatically.
It seems that when I update the form it works fine with table ,but if its the other way around it doesnt work.
Any solutions..
Regards
Rahul
What I would like to do is have a field in a given record increment itself every time that record is selected. For example, say you have a table that stores items in the inventory: each item has a times_search_for_field.
Now, lets say a user runs a search which results in the following SQL:
SELECT * FROM Inventory WHERE experation_date=Today();
Now I want to have every record returned by that SQL statement increment it's times_search_for_field incremented by one. I'm just looking for the most efficiant way to do this.
I know I chould just have my asp .net code loop through the results and call an SQL UPDATE statement for each record, but it seems there should be a more efficient way of doing this.
Mike.
Hey, I am trying to figure out how to update an unbound textbox on a form to reflect conditional data in other boxes when each record is viewed (pages works with reports but I cant find something similar with forms). such as if I had an unbound textbox that I want to = firstname+" "+lastname I would want for it to update it every time a user goes to the next record.. I can't seem to figure out a command or method that executes every time someone goes to the next record.. (and Im not too familiar with all the commands that come without a GUI).. thanks for your time
View 4 Replies View RelatedI need a query that lists each day of the month (or quarter) that is selected from a form. Meaning, if a user selects June 2005 on the form, the query will return to show every date from June 1, 2005 to June 30, 2005. Is this simple, tiny little thing possible?
The reason behind this is that on a report, I need to show data for every date. If there is not data entered for that date, it still needs to appear with the date listed, but with no entries represented.
Thanks!
Tess
I have created tables to capture information from a form (see attachment for relationship diagram).
I have created a form with a subform based directly on the tables. Entering data in the main form works fine but when I try to add a record on the subform I receive the error: "Field cannot be updated". Clearly I have made a mistake creating the table relationships.
I have 2 Linked forms :
frmINVOICE
frmINSURANCE
Several of the fields in frmINVOICE are supposed to be repeated in frmINSURANCE, example Field name such as [Invoice No], [Invoice Date], [Description] etc. are identical in both forms.
My problem : After update of the fields frmINVOICE, the linked record will not update in frmINSURANCE.
I have manipulated by adding the below controls/commands to the field event and/or current form of both forms but nothing works :
- DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
- Refresh macro
- Requery
- Me.Dirty = False
Nonetheless, I noticed following outcomes :
1) if I tap between the forms twice, the field record from frmINVOICE will be updated automatically in frmINSURANCE
2) when I close and open frmINSURANCE, no change occurs
3) after I manually save frmINVOICE, then the field record from frmINVOICE will be updated in frmINSURANCE
What should I do now ?