i want to know how to link 2 combobox in the access like id i chose a department in the other combobox show me the list under that department and the other think how i can create a search button to the date and to the department i want and how to create a button to calculate from many tables.
View RepliesWhat i need to be able to do is write vba to find the value inside the comboxbox and then either:-
1. Run a macro with the same value that is in the combobox
Or
2. Run a set of reports and print them off but are linked to the combobox value.
The combobox name is ODTyper
The combobox control source is ODType which is a field in TblType
The combobox row source is SELECT [TblType].Model FROM TblType;
The value inside the combobox are in the format of TE4700
The name of the macros are in the format of TE4700
The Main form is called FrmOrderDatabase.
Plus somehow i need to get the value of the combobox and link it to print off the correct reports.
I already try to create 2 combobox with 1 textbox where there are link each others.. i try follow and edit some tutorial from here still not working..
I have status combobox (combo0), analisis combobox(combo6) and price text box (text8). i don't know what wrong with my sql.
Here I attach the file (two table) with the code..
Note : Harga=Price
.................................................. ................................................
Option Compare Database
Private Sub Combo0_LostFocus()
'Check if curent record is a new adn that the states combo has not changed
'warn user and determine desired action
'Reset suburbs combo and text box if user wishes to change states
If Me.NewRecord = True Then
Me.Combo6.Requery
[Code] ....
I explain briefly what is my task, When the user selects a different name from the list, I would like to link it automatically with the current Date() . I want to do it for every single name of the field so that in case I need, it would be possible to track for how many days that particular name of the list has been clicked.
I explain it better…My DB aims to monitor some procedures that have 3 status, these are:
On Working,
Expired
Revoked
Given the above I would like to track when every single procedure starts is “on working” and when it ends it. I want to automatically link every name of the combobox with an event that update a field of a table that monitor the beginning and to another that monitor the end (when another status is selected). After that my aim would be to calculate the diff between the two in order to have a number of the days that every single procedure is stuck into a single status. Do you think is something feasible? I hope to have explain it well… If you need I can try to explain it better
Is there a way, in access db or in its VBA, to capture the two columns of data from the combo box so that can monitor them?
I have a suppliers table and a products table. Two forms, Stock form with combobox to list Suppliers and a sub form with combobox that lists Products.I want to select a supplier from the Stock form and then the combobox in the subform to only list products directly sold by the Supplier.Have dabbled in SQL as follows:
SELECT Products.ProductID, Products.ProductName
FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID = Products.SupplierID
WHERE ((Stocksubform.SupplierID=Stock.SupplierID))
ORDER BY Products.ProductName;
I need help with changing data source/which database my Access application connects to.
We got this application from overseas,it is a Access front with an SQL db, I have restored the database, so we have the database, however as soon as I click to do anything in the program I get an error because I need to change the database it looks for.
I was told to open the application and go Tools-Database Utility Manager and Linked Table Manager and get all the tables and select the tick box to "Prompt for a new location" however I have no tables to be selected once I open Linked Table Manager.
I have never done this before, if this sounds familiar to anybody I would appreciate any help.
Thanks all
Can anyone tell me if it is possible to link access to outlook so that access can send out reminders through outlook to people regarding different information??
View 1 Replies View RelatedIs it possible to retrieve table information from an external Access db. Then append chosen tables to the current access db by linking them?
View 8 Replies View RelatedHello
Im having trouble with access and im kinda new to it so ne nice ;)
Ive searched the forum and i havent found anything helpfull...
I want to link a single cell in excel, another file, to my access query... how can i do this?? Thank you in advance. :)
Hello,
Is there a way in Access to create a database that stores (a list of) Ms Outlook emails? And then, is there a way I could drag and drop an email from Outlook into the access database?
Thanks...
Willchum.
Hello..
Here is what I would like to do. I have a folder say with 100 pdf's. What I would like to do is from an access folder be able to point to the specific pdf and have it create a link within the access form to the pdf they point to... Does this make sense?
Is there a way from within an access form that you can have a button that lets the end user look in a folder and select the pdf... and then create and store the link in an access form???
Thanks
R~
I was hired to write some reports in Access 2000 for a small company (max of 6 users at a time). The database was created by someone else and he decided that moving to Oracle was the answer to some of their issues (losing data due to record locking). The guy did not know Access at all so that DB is screwed up (another issue all together). I had no problem creating the reports and they ran fine on my home and work computer. When I imported the reports into the Access DB at this company they ran fine (but VERY slow). I then got a call 3 days later from them saying the reports wouldnt run. The owner decided to upgrade to Access 2003 to see if that would help but that created another set of new error messages. When I try to run the report it gives two messages: "can not perform action/make changes in record primary key" and "record not found". These reports are based on simple select queries. Trying to run the reports freezes the application. I even tried to open the tables and it either freezes the app or takes about 15 minutes to open. These tables are linked to Oracle 8i. The newest OBDC drivers have been installed and the newest Oracle 8I edition has been installed. Since I can run the reports in Access I assume the issue is the link with Oracle. I have very little Oracle knowledge. From what I can tell the data is stored in Oracle and Access pulls the data via the links. Has anyone experienced this? Does anyone know how to fix the issue? Your help is very much appreciated!
I thought I new enought about access databases. I've used the Time & Billing database as a template for my sister to use, but her partner uses a MAC. How can I get the MAC to access the database? I believe the MAC can use Excel but how can I link these two, if at all.
View 4 Replies View Relatedi have a pc which doesn't have sql server installed. is it possible to link tables from .mdf file sitting on the pc into access database?
View 1 Replies View RelatedHello people,
Before I ask my questio I want to let you know that I have searched the forums for an anwser but I just couldnt find it. Or the code didnt work.
What I want is pretty simple for the most of you guys....but not for me. lol
I have a front-end and a back-end.
I want to perform a check if the back-end is still in the same place.
When its not it should promt the user for the new location.
Who can help me please?
Guys,
I have just been shown the delights of a Business Intelligence tool called Cognis Impromptu, a report building tool, reports are built up like tables, very similar to using SQL query builder in Excel.
Reports that I have built can be saved with a .IMR extension, so when they are opened the Impromtu tool refreshes them.
My question is threefold;
Can I link Access to these tables, so as to use them in a database?
If I can link them, when Access opens them, will they automatically refresh?
When I open the reports manually, they refresh, but I have to OK a security dialogue box, nothing really critical, just really a check box. If Access will refresh these reports when they are opened, how can I bypass the check dialogue box?
Hope you guys can help, as I feel that I have a potential to do some really good work by using Access in conjunction with Impromptu... :cool:
Hi,
How I can link to website MS Access database?
File->Link Tables doesn't understand http or ftp.
Provider doesn't support MS Access.
Thanks for your advice.
Hi,
Is it possible to link a query in access 2002? It gives me only tables in the menu. Thanks in advance.
Max
Hi,
I have a question.
Can MS Access table link to Outlook?
Suppose there are Tom and Sue persons:
Sue manage the acc.mdb database file, The database has one table which is called "input", Sue made the form, the form is come from "input" table info. and also Sue made one button to send the specific record to the Tom via outlook, once Sue send out, the mail has created a link, which link can open the document (NOT attached file). Once Tom receive the mail from Sue, Tom will click the link to open the document, and also fill out one signature inside the document, after filled it out, then the signature will automatically populate in the specific field of the "input" table in the acc.mdb database file.
Can MS Access and Outlook do above situation?
Please let me know, thanks a lot.
Hi all..
I am new to Access and currently implementing a small company database.
Is it possible to link Access to Word documents?
I wish to create a button on a form that when clicked it opens the word document according to what have been selected in the combo box in the form.
thanks :o
If I have a link setup from an access 2010 table to a word 2010 document, is there a way to export the hyperlink address in the table to word as an executable link. Rather than having to insert the link manually as a hyperlink.
View 1 Replies View RelatedI have a system automated that, when our warranty team receives a warranty part that somebody else has requested information for, will email that person letting them know it has been received.
I want to include a hyperlink in the email that points to the database, opens it with 2 argument containing 2 variables in which one of the forms can auto populate and the information be shown immediately.
So first, I would like to know how to create a hyperlink within the code that sends the email. Second, I would like to know how have the database check for arguments upon opening. I can do the rest.
For instance, John Smith requested part number 123456 on claim number 55555, serial number 7777777. The database is located at "S:SharedWarranty ReturnsWarranty Returns.accdb". Therefore, the hyperlink would aim at the location and carry the arguments 55555 and 7777777.
Current emailing code (obviously variables are passed into the function):
Code:
Function sendemail(msg As String, subj As String, recipients As String, ccrecipients As String, xclaim As Integer, claims() As Variant, serials() As Variant)Dim rsnote As Recordset
Set cdomsg = CreateObject("CDO.message")
If recipients <> "" Then
With cdomsg.Configuration.Fields
[code]....
I'm creating a contacts database in Access. My emails are saved on Novel's GroupWise (web-based, not a client application). My database is on my hard drive and contains the usual: name, address, preferences, etc.
Is there some way to link the actual text of a customer's email to the entry in my database that deals with that customer (for example, field 1= name, field 2= phone number, field 3= actual text of email)? If the web source is a problem, would there be a way to do it if I imported the emails to Outlook or Outlook express?
Is it possible in access to link to both oracle AND access tables in the same
access application?
Hi Di Hi
I am new to Microsoft Access and have a little problem. I have searched the forum and nearly found the fix but I didnt quite understand what to do, so im creating a new thread.
I have a Access Database and have a client page that stores all the information about that client. We produce reports (scanned word/pdf) for each client and we store the report files in a client folder using the Client ID taken from Access.
My question is can I somehow produce a link from the Client Form in Access to the Client Folder or Files in explorer. I have seen the Hyperlink option but that is only availabe in Design View.
Hope someone can help. Thanks in advance,.
I am using a networked database built by somebody else. I have added a networked DYMO labeller which runs via a simple report in Access 2003.
The probelm I am having is that the default label type I specified in the report (30321) keeps changing, it will change intermitantly and to any available Dymo label listed in the paper size. Nobody else has access to the reports to change it.
One day I come in and the label has changed to a Video Top (30326) label the next day it is a File Folder (30330) label.....the Dymo is having no probelm in any other applications and it doesnt seem to be a probelm in any of the databases I have built which are also networked.
Any ideas would be appreciated....getting sick of wasting labels and resetting the default all the time.:mad: :mad: :mad: :mad: :mad: :mad: :confused: