Hi there all, I tried the search option on this board but maybe its just that i dont know how to ask the question.
I have a text box on my form with and afterupdate event that inputs todays date in to another text box on the same form, can this be set so that once that date is apperas in the text box that no further updates to the date can take place.
Thanks in advance for any help.
TIDMAN.....:confused:
I am a new Access user. I have created a database to track and inventory animals brought to a local animal shelter. The database includes information such as when the animal was brought in, who dropped it off, when it was adopted (Hopefully!), etc. The database is being used by people who have limited computer experience and the challenge has been to automate it and simplify it as much as possible. I have created several Switchboard pages to try and accomplish this.
I have done research through Google and MS support and have found little help with a solution to this problem:
When an animal comes to the shelter, it is held for three days before it becomes available for adoption. I have created seperate fields for Date In Day, Date In Month and Date In Year. There is also a field detailing the animals adoptability status. This field is left blank in the intake process, and is then manually updated to Adoptable, Biter, etc., after the three day period. Is there a way to automate the Adoptability Assessment Field (which is a Lookup Table Field) so that it changes from blank to Adoptable after the three day period? (We have very few animals come in that are marked as Biters, so I just need the field to change over to Adoptable after three days have passed. Unless a solution can be presented to filter animals with Biter status out of the solution.)
I truly appreciate any help that can be offered.
I would like to create a memo field which automatically enters the date prior to any text input from the user.
Also allow dated updates in the same field
Many thanks
Please find attached a mdb (2000) which includes 2 tables and 2 querys
If you open "QryProductsComboSelections" You will see that some product ID's have duplicate entries.
what I am trying to do is allow for contract pricing updates to be added with an affective date so they will not display until the affective date but also those old contract prices that have a date less than the current affective date will also be hidden thereby always limiting it to one record even if the product only has one pricing entry.
I can do this with a boolean "PriceClosed" but it would only be a last resort as I would like to automate this so it requires no user intervention other than adding the new price for A given date.
I have spent hours playing with this so rather than through the comp out the window Thought I would do the sensible thing and come and ask the experts.
Hope somebody can help as done a search and got loads of unrelated results.
Best wishes
Mick
Hi
I use the Date and Time Picker. i know that i can get many other calendars, however, my theory is that i would rather use something that is directly supported by microsoft. but as i found out now that may not be the case.
on of my users updated his Office 2003 after he was having problems using my database (created on 2002 sp3). i know that the same database works on 2003 sp1. however, now microsoft is serving 2003 sp2. so after the update he he can't use the database.
so my questions:
1. how do i generally prevent users from getting update errors. i would like to atleast alert them with a meaningful message that their version of Office needs to be updated.
2. is this true that the Date and Time Picker doesn't work anymore? and if so, why isn't backwards compatible? and how do i prevent this from happening with other controls or scripts?
thanks,
sam
Working in Access 2007 - I would like to have an updatable calendar in the header section of a form, and when this is changed by the user I would like the subforms (there are several) in the details section to be updated with various appointments with dates corresponding to the date selected in the header.
View 3 Replies View RelatedHello
I'm currently doing a query, when a report is received, we enter a date, i would like a query which would show records where the received date has not been entered. i have tried putting in isnull() but does not work.
Can anyone help?
Thanks
Hi guys,
I have a text box, which requires a 8-digit number entry. I have wrote the code to check that the length is 8 and if it isn't a label will turn visible next to the field telling the user entry must be 8 digits.
This works for when i enter a number less than 8-digits but when i input a number with more digits as it does not fit into the text box it turns it to a scientific format value and when the code runs it shows the length is actually 8! And therefore the entry is valid!
I.e. when i input 123456789 the text box shows 1.23E+08 which is 8 charecters!
I dont want any error messages to pop up as i handle them by code and use labels to show the error message next to the problem field and i would like to keep this consistent. Is there any way i can do this by a function or a property in the table or form?
I appreciate any help/advice
cheers
Hi all,I'm working on a library database for a small collection.I have two fields, 'Date Out' and 'Date IN'. Is it possible that whatever date is written for the date taken out, I can set the 'Date IN' to be 7 days later than that date?Thanks in advance.
View 4 Replies View RelatedI have a log in screen called frmLogIn and on there i have Unbound Combo Box cboUser and Unbound Text Box txtPWord. I also have cmdOK.
IF the user sucesfully enters his password it takes him to frmMainMenu.
On that form i have a lable called lblYouAreCurrentlyLoggedInAs and a unbound text box called txtUserName.
How do i update that txtUserName to whatever was entered in the previous form's cboUser.
I have a form with some vertical unbound text boxes, they are table headings for my data, but they need to be editable. I can enter data in them perfectly but once you close the form the data is lost. I would like the data to be saved on the form. I have tried turning them to labels but then they are not editable. What should I try next?
View 5 Replies View Related"The value you entered isn't valid for the field 'ID'.
For example, you may have entered text in a numeric field or a number that is greater than the FieldSize setting permits.
This error happens when i try to filter my results and select the topic I wanna search for. The field size is almost double what my longest field is. I am trying to do is from a table i used a lookup wizard to search that table for all the topics under that table.
Hi again
I've done some searching on this question and it seem everyone is pointing to the DateAdd function, so here is my current problem.
I have a date/time field called SponsorshipContractDate. When a contract is signed the date is entered. I need the system to calulate the renewal date for the contract which is alway 1 year ahead.
The DateAdd function works only if I hard code at date into it e.g.
DateAdd ("yyyy", 1, "01-Jan-08")
But as contracts are signed throughout the year this just doesn't work so I tried this:
DateAdd ("yyyy", 1, "SponsorshipContractDate") but the table won't save and this is abviously not right. In my head it makes sense but I don't understand how to get the formula to look at another field during it's calculations
Am I using the wrong function?
I will keep looking around.
Thanks heaps
I'm having trouble converting text to proper text in Access 2010 using Windows 8.1 as OS.
The message I keep getting is:
The expression you entered contains invalid syntax. You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks.
The formula I use is:
strconv([field],3)
I'm trying to turn any period entered into a certain textfield on my form into a comma (to prevent access from turning 1.1 into 11 for example).
I have the on dirty event set to me.fieldname = replace(me.fieldname,".",",").
Everything works fine as long as I use the period key on the numpad. However, when I use the regular period key on the keyboard, it does not convert it.
I have a table with a huge master list (some hundred thousand) of unique bar code tags, which either have 8 or 12 digits. (Valid characters are "012 345 678 9ACEFHJKLMNPRYXW"). I created a form, which is automatically looking up valid records as the string is entered position by position from left to right. This is working fine and sufficient in 99% of the cases.
Sometimes characters are not readable on the original document, so I need a tool/form, were I can enter only the readable positions of the code and the tag list is then filtered accordingly. For that, I created a separate form with 12 text boxes for each possible position of the bar code and a listbox. This list box should be filtered as the readable characters are entered in their respective positions/textbox.
Hello everyone. I am wanting to store the date the record was entered into the table. But I don't want the users to have to type this in; I thought that Access could grab the date from the system date.
I am new to this and I looked at the Date function but I am thinking it will just always update to the current system date.
Thank you very much if anyone could point me in the right direction.
Hello, all;
I think this is probably a simple solution for some of you.
I have a database containing records for which I need to set dates to follow up on.
I would like to ensure that the date that is entered is a business day (So that when I run my follow up report for the day - I don't end up missing items that were inadvertantly entered for a weekend!)
I have hunted around for a similar thread - but have not found anything.
I am thinking that a simple bit of validation could be entered for the field properties.
Any ideas?
Your help is greatly appreciated.
How do i save a record as soon as text is entered into the textbox in a form?I need it to save without moving on to the next form without having to click a button
Code:
If Me.Dirty Then Me.Dirty = False
but it doesnt seem to work
I have created 3 forms, 1 of which will update the sum of 5 text boxes immediately after numbers are entered in, while on the other 2 forms I had to create a refresh button so that the numbers will add up. The properties in all of the forms and the text boxes seem to be the exact same.
View 6 Replies View RelatedI have a form where users fill in a date resolved and click complete in the Option Group, it's default value is incomplete. I have a problem with the users forgetting to change it to complete when the enter the date resolved. Is there a way to change the option group value when the date resolved is entered?
View 6 Replies View RelatedI have a form where users fill in a date resolved and click complete in the Option Group, it's default value is incomplete. I have a problem with the users forgetting to change it to complete when the enter the date resolved. Is there a way to change the option group value when the date resolved is entered?
--- OR ---
Can it notify the user that they need to change the Option Group?
I want a default value to equal the first 2 characters of field [first name] and first 3 characters of field [last name] and the numeric datevalue of [DOB] 'date of birth'.
In excel its easy,
C D E resultformula
AndrewTester12/12/1980AnTes-29567
Formula LEFT(c9,2)&LEFT(d9,3)&"-"&e9
How do I get same result in Access?
tried
Field 'PRN', a text field set as default =""""& left([first name],2}+LEFT(Last name],3), date()&""""
Access accepted the above statement but when I input user details the default doesn't work.
I am looking to (on the mainform) have the user enter into a text box whatever date they would like to enter and have that value become the current date of the system. So that all operations are based off of this newly entered date.
View 4 Replies View RelatedMy friend is looking for the database to auto populate a date, based on information already entered.
A Learner Starts his/her private tuition lessons on dd/mm/yyyy and pays for 6 weeks, the next lot of payments is due on dd/mm/yyyy...
how can i to save the values entered into unbound text boxes to fields in table
View 2 Replies View Related