I have recently began using Access, and i have created a database that has what i call user "Profiles" or contact information for around 63 people. What i'd like to do is set up a form or a Report that has buttons with maybe pictures or just a persons name, when its clicked it opens up their "Profile" which shows a picture and all their information. is this possible?
View RepliesI have a list of people in a list box. In the list box I only have the people names listed. (example below)
1. John
2. Frank
3. Tim
4. Jessica
I want to click on one of the names and have a form pop up on the same screen that lists the persons contact info. If I had a table like listed below, could the info auto populate on a separate form.
[ID] [Name] [Number] [Address]
1. John 456-4567 123 Elm Rd.
2.
I want the Form to pop up and show...
Name: John
Number: 456-4567
Address: 123 Elm Rd.
I want to create a text box within a form that automatically populates a contact number based on a selection from a combo box, also in the same form.
For example, I have a Bidders Table (tblTenders), this form includes information regarding the Tendor like the company name and a main contact within that company and a phone number for that contact.
I've created a separate table for all the contacts called tblContacts. This table holds all the contact information for each contact. I have a simple form called frmTenders that asks the user to input the Customer (which is the company who are bidding) and the Main Contact, which is a combo box to select the main contact from tblContacts. Below that combo box is a text box called 'Contact Number' - I want this box to display the contact number for the main contact automatically when a main contact is selected from the combo box.
The contact number text box isn't storing that information in any tables etc. It's just for viewing purposes when we need to make a call to that specific tender.
I am doing a worksheet for college and have been asked to create option groups on a form, but I cannot work out how to do this.
The screenshot shows what I have to do but I cannot get the option group wizard to open.
When creating my form based on the design in the screenshot I dragged the Rate field onto the design view sheet but it has only one option button connected to it, I need to add another one that will be connected to the same field and am not sure how to do it. I did try adding another option button from the control bar but I am not sure if is connected to the same field with the correct yes/no properties.
I can add record successfully... but can't view it accordingly when I press navigate buttons in the form...
Database is attached ....
Hi,
I want to create a view of two tables. However, my two tables are very similar in the data they have; there are differences though. I don't want it to paste all the similar data twice though I want it to merge the similar data.. Is this what a view does anyway???
Thanks in advance!
Hello everybody,
I’m new here and I have a question for you..
Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?
Greets,
Tom
Hi! I'm working in Access 2007, and am having difficulty figuring out how to do the following.
I purchased some pretty .ocx buttons that I want to use in my db. I can't figure out how to import them for use. No, I don't want to just copy and paste them in. Any ideas? I hate the ugly, unprofessional looking command buttons in Access. Thank you!
KellyJo
While creating table in design view is it possible to set the value of a field as sum of two other field?
for example:
I have a table with field a and b.
I want to have one move field c in the table such that c=a+b.
Please advise on the above
Thanks
Badri
Im creating a database that we can enter jobs into.A job will consist of 3 seperate parts, Called "Trusses", "Walls", "Posis". They will each have a different delivery date and possibly a delivery time.
I am having trouble creating a report that gives me a week view, Monday to Friday, that shows what deliveries are on each day.The main thing here is there is one job entry, with the 3 parts. So there will need to be 3 seperate entries on the report for each part of that job.
I need to figure out how to display my excel file name in my cbProjectList
I place all my excel sheets in my drive D:
with the following file names
09th of July Project List.xlsx
10th of July Project List.xlsx
11th of July Project List.xlsx
12th of July Project List.xlsx
can this be possible....
In my access project i used Gohypelink as defined in this website [URL] well, but i want it to pop up in a reduced view?..At the movement it fills whole screen, and the user have to click on buttons to reduce the size. I want the file to pop up in a smaller view.
View 1 Replies View Relatedhi all. i am creating a form by the name of ISSUES. i will have a field by the name of ISSUE# where user will be able to type the issue#. i was wondering if it is possible for the user to add an attachment of the issue file. in other ways to make it easier i am asking if it is possible to attach a file in a form and to view it also. any help will be really great.
Thanks
There aren't too many threads on this subject folks. I am looking to understand this a bit more. From what I know, complete security of a database can only be accomplished by making an MDE file. But, the downside there is that MDE's cannot be edited by anyone, so any backups or changes that need to made must be done with an MDB.So, what I want to know is, if I want complete security of a database (as in, no changes allowed to be made, except by me), my only option is to make an MDE file and then transfer all the data back and forth between that and an MDB file whenever I need to make any design changes.Am I right?Thanks!
View 2 Replies View RelatedI'm trying to view a pdf in a form if the file exists. My search has brought me to trying the WebBrowser control. I have it loading the file but it launches Adobe instead of just showing the PDF in the window on the form.
View 13 Replies View RelatedI have a table with 4 Fields:
Drawing Number
File Link
Attachments
Description
I basically want to have a live preview window of the "File Link" attachment in that current record. I have heard it's best to use a Web Browser Control when doing this, but I cannot get it to display the currently attached pdf file in that field of that record.
Is there a way to edit the link properties of the Web Browser Control so that it dynamically detects. The file location of the attached file in that field? There will only ever be one attachment in that field, as this will be a live pdf view of the drawing to which that drawing number was assigned
I am trying to create an MDE file from my .mdb, but receive an error "Unable to create MDE file".
Can anyone suggest how I can find out why this cannot be created?
Thanks
Does anyone have sample code or a sample mdb that shows how to create an INI file and then also be able to import an INI file back in to a table in the mdb?
Thanks
is there any way to create an exe file from access project ?
View 2 Replies View RelatedHow do you create an .exe file for your access system??
View 4 Replies View RelatedThe file was converted from excel. It is in Datasheet view. I select the first column and clip on the Ascending choice under the Home Tab. It works but leaves a large gab of blank rows. I go to the Database Tools tab and check Compact and Repair Database. The file returns to the original unorganized list.
View 1 Replies View Relatedhi There
I Have A Database Trying To Convert It To MDE I Get The Following Message
--------------------------------------------------------------------------
This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
Any Help Please
Thank You In Advance
I had almost complete my project in Access. How i will produce the executable file of my Project.
View 1 Replies View RelatedAll..
I have an access 2003 application I have front end and back end separately. When I click "Make MDE File" from tools menu, nothing happens.
When checked the Windows Task manager(Windows 2000), CPU usage is 100% and MS ACCESS is not responding. There are no messages.
Anyone experienced this problem ?
Thanks
Bosch
I am stuck with a problem where I need to create a new table from an excel file. In detail my problem is;
The excel file contains an order from a customer, like below,
BOM Component Qty
123 abc 2
123 def 2
234 ert 1
234 qwe 1
234 uio 1
I need to create a table from this data like;
Qty Partno
1 123
4 abc
4 def
1 234
2 ert
2 qwe
2 uio
NB! In reality the components are numbers not letters.
The qty for BOM is always 1 and the component 2xqty.
It is important that the BOM number is listed first and thereafter its components.
So I need to somehow associate the BOM number with its components and list them together as a group.
I just cannot figure out how to do this.
ANy help is greatly appreciated.
I have a form, and on that form I have a textbox called RefDwgNo (user not allowed to make changes...just for viewing). Displayed in this textbox is the name of a file (without the .pdf extension). I changed the textbox to 'is hyperlink' and added to OnClick- this code:
Private Sub RefDwgNo_Click()
FollowHyperlink "***private***engineering_data***Private***Des ignFitoutLabel Plate\_LATEST REV"
End Sub
The user needs to actually open the .pdf file, not the folder its located in. How do I add the file name from this textbox to the code above?