I have a HUGE system which presently restricts updating a "Final Action" date to today's date only. However, I want to change it so users can input dates for only the present working week. The present coding is as follows...
Private Sub dteActioned_AfterUpdate()
Dim strTime As String
strTime = "07:30"
gintChanged = gintChanged + 1
If Not IsNull(Me![dteActioned]) Then
If Me![dteActioned] > Now Then
gintReply = MsgBox("Your actioned date is later than today !!", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
Else
If Format(Me![dteActioned], "dd/mm/yyyy") < Format(Date, "dd/mm/yyyy") Then ' final action earlier than today
If Weekday(Now) = 2 And Format(Now, "hh:mm") > strTime Then
' If Weekday(Now) = 6 And Format(Now, "hh:mm") > strTime Then
' Not acceptable to enter a previous date
' older than 7 days is not acceptable
gintReply = MsgBox("Now too late to accept this 'Final Action' date !", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
Else
' Previous date is acceptable but only as far back as 7 days
If CVDate(Me![dteActioned]) < CVDate(Now) Then
' older than 7 days is not acceptable
gintReply = MsgBox("Now too late to accept this 'Final Action' date !", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
End If
End If
Else
' Actioned date is acceptable since it is today's date
DoEvents
End If
End If
End If
' if today is a Monday Only accept final action dates which fall within the previous week if today
Exit_dteActioned_AfterUpdate:
End Sub
Probably very simple but I just can't get it to work. Help please! Time is short.
I have several list combo boxes on my form that I want to prevent users from adding data to. How can I do this? For example, there is a list box for insurance carrier, etc. :confused:
How to restric forms entry to be restricted from second edits .. means if some one posted single entry one time and wanted to post second edited entry i need form to ask passoword. or not to be updated if not available the password option.
I am trying to write code for a form. When the user enters the "Number of Payments" and the "1st payment date" it will fill the amount of the payment into a specific month.
For example: 1st payment date would be 10/24 the payments would be bi-weekly and the amount would be $50.00. The number of payments would be 4. I would need it to put $50.00 into a field called "October" $100.00 into a field called "November" and $50.00 into a field called "December". In excel I would do this simply by using a (date)+14 formula. I am sure that I need to do this with loops but where to even begin.
I need to be able to restrict users enter a value in the text box (on Form B) called "FTE Assigned" if Dsum of a field called "FTE Allocated" in another form A is less than what is going to be sum of FTE Assigned after the value is entered.
Both these forms are used by users to enter data in the 2 separate tables which are linked together through a join.
Master table - having FTE Allocated values and secondary table having FTE Assigned values.
Basically a message box would do if Dsum (of FTE used) is coming out higher than FTE allocated.
On my form, we can enter time off for employees. This is working pretty well, but we have some employees that have flex days every other week or even once a month.
What I would like to make possible on my form, when the user is inputing the data, He makes the initial entry, and then he has an option (checkbox?) that they can select to make this same entry every (week, other week, or 1 month from the date). Have it repeat for a year out maybe, so if the user has every other friday off. It will make an entry for every other friday for the next year.
I've been searching the forum, and I've been reading on the dateadd function. But I'm not sure how to implement it on this form, not sure if there is a way to make it repeat for a year? Also not sure if it's possible (or if that's the best choice) to have checkbox for choices using it?
I have a master table which shows all transactions per record (person) over a financial year.
Each record person has a seperate package period over which their spend needs to be measured. Therefore although I have all their transactions for the year, I only want to sum their transactions between their given [start date] and [end date] which are in columns.
I need to be able to create a field which sums all expenditure per record between the start and end dates
Name Start Date End Date Invoice Date Amount
Matt 15/5/11 15/9/11 1/11/11 £100 Matt 15/5/11 15/9/11 7/7/11 £200 Matt 15/5/11 15/9/11 12/12/11 £200
In this case I would only want to sum 7/7/11 as this is between the start and end dates
I want to write something like sumif([Invoice Date] is between [start date] and [end date] - not sure where or how exactly
(The start date and end date will always be the same per person)
First I would like to give thanks to all the knowledgeable folks here who have helped me with my DB to date. It is working and every one is very happy and I have learned a lot.
So now I would like to add some more functionality to this existing project.
My DB is for data input of customers for a drawing. It has the following fields: Id, account number, first name, last name, date/time, score1, score2.
I t is taking a great deal of time for the users to enter in hundreds of entries a day. Most of the entries are customers who are already in the DB. I would like to get the fields to auto fill the data for existing customers say after the account number is entered. So after you put in the account the name and any other pertinent data would shows up saving users from typing it in again.
The first problem I am having is that this is still a data entry form and I can’t figure out how to be able to see the account information and still add new data to the record? The new data is a daily score they get.
Second I haven’t figured out how to call up the customers information from just the account field.
I’ve googled this and haven’t found anything terribly helpful.
I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)
I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.
I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.
I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.
My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.
My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....
As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.
My question is this: I have a table where I'm entering employees' hours worked. Basically, it's something like this:
ID WorkerNumberDateworkedTimeStartTimeEnded 121/2/201310:00:00 AM3:00:00 PM 221/3/20132:00:00 AM11:00:00 AM 321/4/201312:15:00 AM11:30:00 AM 421/5/201310:25:00 PM11:00:00 AM 531/2/201311:00:00 AM3:30:00 PM 631/3/201312:00:00 PM10:00:00 PM 731/10/20137:00:00 AM4:00:00 PM
I have a query that (easily) determines how many hours an employee has worked on any given day. What I can't figure out at all, is how to write a query that can figure out how much time an employee had off in between shifts.
Thus far I'm able to run a query that separates this main table into individual workers by their id numbers, but can't figure out how to determine time off between shifts - as the last hour worked one day, and the first hour worked the next day are on two different lines (they are two different table entries).
My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated.
i.e., Initial design data is entered first, when drilling is complete more data is added to a linked table, when drilling is surveyed yet more data is added to the second table.
What I want to be able to do is to query for a particular set of existing design data, display this on a form and on the same line enable data entry to other fields from other tables which are linked to the existing design data.
I have a shared db where there is a requirement for more than 1 user to enter data in the same form and hence the same table. Up till now there has only been 1 data entry clerk so there has not been a problem.
Would accessing the same form by different users cause a problem, assumming they are inputting different records?
This has most definitely been asked before but I really cant find anything on the forum! Ive created a data entry form which has a save button which the user must click each time to save the record. However how do I refresh the form i.e. empty all data from the previous record without exiting the form. Ive tried to combine the undo macro but that simply deletes the previous record. Any help please!!!
How do I make data entry required, I've sent it to be in the table but it doesnt seem to work in the formI've tried the below with no luck Private Sub Command14_Click() If tbName = Null Or tbTelephone = Null Or tbAddress = Null Then MsgBox "Please complete all details.", vbExclamation Else DoCmd.Close DoCmd.OpenForm "frmInvoice" DoCmd.MoveSize , , 5100End IfEnd SubCheers
I'm looking for opinions on how people like to enter information into a many to many relationship.I understand how a many to many works as well as a Main Form/Sub Form.
Subforms is what I currently use. Would you do anything different? Below is a sample of fields I currently have. Any advice? I keep wondering if there is a better way. I'm not a huge fan of sub forms. I also build lookups from the Junction. Is this correct?
I've got two tables, Properties and Valuations. Every six months the properties are revalued. I want to have a datasheet list of all the properties with a blank field for the new valuation so that the user can just go down the list and enter the new amount without having to select every property individually. Can I do this?
I have a relationship between Market data table and Trade table which is One to Many. Market on the One and Trade on the Many. However I just found out that I am unable to enter information into the Trade Form without entering information into the Market Form first. I would like to enter info. into Trade Form/tables independent of whether I enter info. into the Market Form/table, but I still need to have the relationship of One Market data to Many Trade date.
I want to have my records in my form show the latest entry, not a completely new form. The user will click on the new record button to create a new record but I want the user to be able to see the last record. Anybody know how to do this?
Sales information can be added against a customer record. What I would like to achieve is for users to still be able to record new sales information, but historical sales information (e.g. before 2007) can be viewed but not be able to be edited or changed. Is there a way of achieving this. Thanks in advance...Paul
i have a data access page, which as a querry in it.
When i set dataentry true, none of the recrods are visible.
but, when i set dataentry false all the records are visible, here i have to change a value (ex; change a value in drop down ) which should get saved into the data base,
I am new to Access and I am trying to update our existing database. Presently our database is used to report incidents that have multiple subjects per incident. Is there a way to have a field recognize the data ie. the last name of an individual, and automatically fill in the remaining fields for that individual without having to fill in each field over and over again?
Im copying information from Excel to Acces. As I enter the information in fields in Access, this goes just fine. The problem is that sometimes I have to change the information I put in. So for example I first copied 10 record(cells), but now I discover that I have 20 records/cells. But Access refuses to let me enter more than ten. Does anywbody know why it does this and how I can fix it? Thank u, Stacey
