Hello
I am creating a form that displays a select query in a sub form, and I wish to display the current record of the sub form, matching fields with corresponding text boxes or labels that...
I have a popup modal form that incorporates a subform used to search records. Once a record is clicked on the subform, the subform filters a form called frm_LoanClosing. Then the code in the s...
I have a form named "SysAcs". On the form, I have a button (Cmd21), and on the buttons onClick event, I'd like to have the form (with the current record) printed to a PDF.
I'm trying to ma...
I have a piece of code for Access databases form that kind of works. The code is supposed to put the user name & time that users put comments in a comment box. It put the correct time, however...
Hi
I have created a form which links to a table and shows the records via a combo box. I did this by creating the form in design view and using the wizard. I particulary want the user to ...
Hi,
Access is not my strong point. Especially as I haven't used it since college. I must say that Access was much easier to use prior to 2007. Finding something was ten times simpler.
...
I'm having an issue with an MS Access (2003) front-end to a MySql database.
Under certain circumstances, I will get the errors
Write Conflict- The record has been changed...
Microsoft ...
I have a form ("Sales by Buyer") with a subform (Subform_Sort). I have a date range filter on my form so that a user can see the sales by buyer within a certain date. Subform displays in data...
I just finished my project in ms access, now i need to set up users and password, how can i set up which objects can users use, acording to a permission level, and how can i hide all the objec...
Hi
I have a table which has a custom form attached to it for data entry. The spec has changed and I have now had to add subdata into my table. I don't know how to create and attach a form...
How can I format an image in a form that will not show the border and background? The image is already this way outside Access form, is I insert the (is a logo) picture in Excel, Word it looks...
I am creating an Access 2007 solution to enter information about Inventors and Patents. One Inventor can have multiple Patents. One Patent can belong to multiple Inventors.
I have set up th...
Hi There, I would like to create a form that displays the time for the three time Zones: Central, Mountain and Eastern.
My Regional Clock settings is set to the Central Time Zone. I can g...
Hi. I have been searching posts here for a while now. The client would like me to set focus on fields using two letters. For example, if the user presses F & S, set focus on the From Ship f...
Good Morning,
I have a table with rows in it that I would like to make data entry columns in a query, form, and report.
For instance,
I have a project table with the following colum...
I have a form that is launched from another form. The first thing it does when it comes up is bring up a file browser so that the user can select an Excel workbook. The user is then supposed...
I created a dataentry form consisting of 3 tabs and 2 tables linked together and everything worked fine. I proceeded to add a third table, linking it to the master table and a 4th tab on my f...
Hello,
I would like to create a button on my form which:
1) When pressed would prevent edits being made to information on the form. The label would change to 'locked'
2) When pressed ...
In DAO code the following code finds the record and displays the fields selected on the form..
I have ADO code that I think is almost working but it doesn't fill out the fields like I expect....
I have a form (Form #1) which remains open when another form (Form #2) is then opened from a subform on Form #1. When the second form (Form #2) is about to be closed, I want to be able to call...
Hi
I just finished a database, now i would like to install it in a network, how is the process.(multiuser)
Can i disable some objects regarding the user.
How can i hide all sensitive object...
I have a table wirth current stock levels. i.e. the level of stock beforme the implementation of a new system of adjusting stock daily.
I want to:
a) Replenish the stock, by adding, via ...
How can i add an input mask on an inputbox
I am entering a password, and i would like to show *
i do not want to do a form, i am using InputBox
thanks
I am building an order system in which there are customers, products, orders, and order details. To search for orders, I create a form "frmOrder" in which there are unbound combo and text boxe...
I have tried both FindFirst and Seek to perform what should be a pretty simple task but continue to get errors on any attempt.
I want the user to key in a phone number in a subform and t...
