If memory serves me right, I've seen code or maybe a shortcut somewhere for inputting a date value in a form along the following lines.
To input today's date, input "0"
Yesterday = "-1"
A week ago = "-7"
and so on.
I'm fairly new to access and have been tasked with fixing a database that to my knowledge is built incorrectly but due to budget constraints and the time it would take to build a new one, we have to stick with this one. Here's my problem, in the database is a form that we use to create new entries in a table but when I try to create a new entry through the form, it creates multiple entries in the table with the rest of the data split between all the new table entries. Is this something that is caused by us moving over to the most current version of Access? Is there a way to fix this problem given the software we are using? At one point I had recreated this table because we had been having issues with other aspects of the database (security deposits were not being updated when entered through this form).
View 14 Replies View RelatedI am running Access 2010. I have added the following to the "On Open" event on my main form:
Code:
Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
Me.ShortcutMenu = False
End Sub
My main form (frmMain) is displayed when the database opens. As you can see, I am hiding the ribbon and the navigation pane from users. I also want to prevent users from right clicking on the form and opening it in Design view - trying to prevent any monkey business. However, the line:Me. ShortcutMenu = False
is not preventing users from right clicking on the form and getting the shortcut menu and going into Design view.If I go to Options and uncheck: "Allow Default Shortcut Menus" then I lose the ability to print reports because I have the ribbon hidden and this will not allow right click on reports.Converting to .accde is not an option at this time.
I'm making a large database. There are over 100 questions per "chapter" of the data I need to enter. The forms aren't large enough to accept everything at once so I broke up the chapters into a few smaller forms. The problem I'm having now is it saying "you can't go to the specified record" whenever I enter the same company name in two of the forms for the same chapter. The company name is the primary key. How can I make it so the techs can go from page to page without breaking up my tables?
Thanks in advance.
Sean Sturts (USMC)
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?
I have a question about for combobox. I have a field from my tables that a text only then I make in the look up property field to become combobox then row "source type is a value list" then,"Allow value list edits, I make it Yes". then in the form its possible for me now to add value list in the combobox. but I want that what ever I input to become a value list, that's all they can select for the value of that field. if they can type or add not listed in the value list I input, it will not possible & there's a msgbox will appear mentioning the "the value you input is not in the list..
View 2 Replies View RelatedHow do you prevent access from adding a new record when u input data in the current record or tab to the next field? My database is set up to open with a form where the user picks his name and then a week ending date once that is complete u open a new form where the name and date auto populate along with other fields to fill out such as job charge, charge type , times charged for each day of the week. But I don't want access to create a new record everytime the person inputs or tabs..... .
I have attached my database for better clarity!
I am very new to access, any way that I can have a popup box appear when I ask to produce a report and I can type in a parameter of my choice and it will produce a report based around that parameter?
I have a table that is directly linked to an excel spread sheet that is updated each week external to the database. I have to produce reports on the data contained in that table.
I have already produced reports that look for specific number and those reports are produced automatically.
I was wondering if there was some way I could open a form and type a number into a text box and it would produce a report around that number. e.g. "list all engines below X margin" and I can type any number in representing X and a report would be produced.
Is there any way to add parameters to a .maf shortcut?
I'm thinking, I may be able to email the link to a form to someone, with the correct ID. But I'm assuming this isn't an easy thing to do?
Hi there, this maybe very simple but I can't seem to sort it out... I have a created a shortcut to my form database on my desktop but I want to know if there is a way in which I can make it so whenever I use the shortcut my database will open as a maximized screen as opposed to opening in a small window which it keeps doing, meaning I always have to maxmise (it may seem like something small but it gets quite annoying after a while) Can this be done? Or even better can I make it so that JUST the form opens and not the whole access program, as the other people using the database don't need to see and use anything else but the form. Any help would be much appreciated. Thanks
View 1 Replies View RelatedI would like to disable the shortcut, CTRL - which allows a user to delete a record. A user accidentally deleted a record while typing in an email address that had an underscore in the email address. While trying to type it she must have hit the CTRL key instead of the Shift key follow by the -. She noticed the delete confirmation, but not thinking, pressed enter and thus confirmed the deletion of the record.
Other than telling her to pay more attention, how can I disable the shortcut in Access 2013?I tried using the Application.OnKey "^-", "" but I continue getting the error method or data member can not be found
I am using Access 2003 and have a custom shortcut menu. I wish to add some entries to this shortcut menu dynamically.
Background : I am displaying a list of customer orders and wish to offer the user the facility to filter the search for one item instead of the default of ALL.
The dynamic entries would be the unique order item reference nos. retrived for that particular customer retrieved via recordset . So the menu would show :
ALL
------
Model 1
Model 2
Model 3
etc.
...
How am I able to add these entries to the menu, the selection text will be the filter text I use to report upon.
Is there a keyboard shortcut that simulates the double click.
In my Sectionfrm I have a command button that opens my Ordersfrm. Because I use the Ordersfrm for reasons not always associated with the Sectionfrm I do not automatically populate the SectionID (textbox) in the Ordersfrm with the SectionID from the Sectionfrm.
When I want to link an order to a (building) section I double click the SectionID field in the Ordersfrm which in turn runs VBA code that copies the SectionID from the Sectionfrm to the Ordersfrm.
As I tab through my form I find it annoying to move away from my keyboard to the mouse to double click the SectionID, so the question is:
Is there a keyboard shortcut that simulates the double click to run the VBA code?
I am currently in the process of creating a pop-up menu to allow my users to do some simple text formatting.I have used the following code to do so:
Code:
Dim cmbShortcutMenu As Office.CommandBar
' Create the new pop-up menu instance
Set cmbShortcutMenu = CommandBars.Add("popupFormatMenu", msoBarPopup, False, True)
' Add the bold button
[code]....
The problem is that I now want to add the FontColor picker control and I keep getting an error.I think the problem lies in the type of control I want to add. According to the Microsoft support files I downloaded the fontColor control is of type Gallery and ID = 11949, so the code should look something like this:
Code:
cmbShortcutMenu.Controls.Add Type:=msoControlButton, id:=11949
I need to replace msoControlButton with something else.
As the title says, ctrl-W works on all my other forms but not on the one which has Pop-up set to "Yes".
View 1 Replies View RelatedWe use access to enter our service tickets in at work.What we have are three date fields.
Call Date
Start Date
End Date
We are 24/7 operation.Currently all 3 just autopopulate with the current date.What i would like to do is ADD a CHECKBOX next to each Date Field.And make it work like this.
1. let them autopopulate as they are currently
2. if you end the call AFTER MIDNIGHT (the next day). CHECKING the box would automatically populate yesterdays date in each of the fields that has the check box CHECKED
i gt this prob here
i gt one main table...taking in a text...
I gt like 4 sub table...which i will have to take in the text from the main one...then sort them into the different table...currently trying to do this via forms...can someone tell me if it is possible...?
Example...
There is this index which user input A123456
I am supposed to put this text into the table which is supposed to contain AXXXXXX text...hw am i supposed to do that?
Hello,
I am creating a database for a user that has a health & safety report form on paper that he would like replicated on screen on a form that he could fill in. Is there a way to do this? If not any ideas of which way to go from here would be much appeciated.
Thanks in advance for any help
Craig
Hi there
I have a database that has two tables.
Table 1 is called applications and table 2 is called contacts.
Table 1 has two fields that relate (not through the relationships) to table 2.
These fields are named thus: Officer and ContactTelephone
Through a form I wish to be able to do the following.
When I choose the Officer from the drop down box (combo box tied into Table2) it will then automatically put in to ContactTelephone the necesary number.
It MUST drag the info from Table 2 and place in to Table 1.
Any ideas :confused:
Thanks :D
Jools
I have a form where it is necessary for the user to input number of tanker loads, however I would ideally like the table to store the information in m3 which means multiplying whatever the user inputs by 11.3.
My plan was to use an unbound textbox for the user to input the "number of loads" into, then use a query to calculate the value and then a Dlookup to update the value of a control which will be hidden somewhere on the form. I got as far as making the query however then realised that it won't let me add an unbound textbox to a query in order to form an expression. I'd like to stay away from the inbuilt "calculated field" option just in case i need to downgrade to an earlier version than 2013 at some point.
I am trying to link the textboxes on a form so that their values are stored in 2 seperate tables.
Setting the Record Source of the Form to TableA and the various Text boxes etc are set to the Fields in that table works fine, however I want some other text boxes to be linked to another set of table fields, so that when I enter values into those text boxes the data ends up in a different table.
Has anyone any ideas on how text boxes on one form can be linked to different tables.
dave
I have a database where on the form we are just put in total deductions. We want to make sure that the total deductions is correct so while we are entering this number we want to do an excel thing by hitting = 1 + 1. Anytime we do that we are getting an error message. I really didn't want to have to set up a table to store these different amounts because we really only need the total. Is there a way to do that? I changed the format from currency to general but I'm still getting the error.
View 2 Replies View RelatedI my form i have a textbox into which the user can enter a value that will serve as criteria in a query.
In the beforeupdate of this textbox there is a check about the validity of the input. If this input is wrong, a message tells the user what's wrong .
In such a case i like to cancel the event but in the same time clearing the textbox.
Canceling isn't a problem, but automatically clearing the wrong input seems not to be so evident.
How can i do that ?
I am having a problem getting any results from a query written with a msgbox parameter in the criteria. My query is supposed to look up a project number, and then report various information regarding that number. Here is my problem.
If I type the project number directly in to the "Criteria" cell in Design View it pulls the appropriate results. However, when I put [Enter Project Number] in the "Criteria" cell and insert the same number into the msgbox when I run the query I get no results at all. Any ideas?
I have a form (frmHourEnter) with textbox (Week_Ending) to select a date, and a command button (cmdStaffReport) to open another form (frmStaffReport) with textbox (txtDate). The Week_Ending is not related to any table, it is just a date on a form.The first form code is:
Code:
Public sDate As Date
Private Sub Week_Ending_Exit(Cancel As Integer)
sDate = Week_Ending.Value
End Sub
The second form (frmStaffReport) code is:
Code:
Private Sub Form_Load()
txtDate.Value = frmHourEnter.sDate.Value
End Sub
On opening this form I get Variable not defined relating to frmHourEnter portion of frmHourEnter.sDate.Value.
i have just started to use access and i know how to insert the current date into a field using date() but i am not sure will this change the date everytime i open the form ? i want to create a form for invoices that shows the date the invoice was created and doesnt change if i re open for editing,
Ads: Technewonline is a website that specializes in introducing the latest technologies such as Best Tablet Android Have Price Under $200 and Best tablet of Apple in 2014 and The Best Midrange Smart Phone In 2014 and Top Best Ultrabook Of 2014 and The Best Phones 4G Valued At Under 300 USD is also a website for sharing your tips about computers, mobile phones and tablets, products are available from leading supermarkets will surely satisfy you.