How To Create Synonyms In MS Access
Nov 22, 2006Hi,
I want to create Synonym for a Table in MS Access.
Please tell me solution ASAP.
Thanks,
Nitin
ADVERTISEMENT
How To Create MDB-bank Without Access ?
Aug 25, 2006Is it possible to create MDB-bank without Access ?
Thank you very much!
Aleksandra
:)
Create A 97' Db Using Access 2003
Feb 18, 2007Guys,
don't know if you can help me - I have been tasked with creating a simple DB but for use on systems that have access 97 installed, I use access 2003 (reasonable standard) is this possible and are there any pitfalls I should be aware of?
cheers
How To Create A Dashboard With MS Access?
Feb 27, 2008Hi,
I would like to get pro month and marketing campaign the values of about 12 KPIs. This dashboard will be used by different countries/marks.
My KPIS do not have the same entries. For example :
- the customer satisfaction is calculated on the number of customers "satisfied", "unsatisfied", "acceptable",
- the percentage of corrected and on-time reports is based on the number of reports "total", "late", "with failures", "late and with failures",
- the availability of the is based on the number of hours... etc.
Do you have an idea of the way to proceed?
I created the following tables :
-Tbcampaign (ID_Campaign, Campaign name)
-TbKPI (ID_KPI, KPI Name)
-TbRegion (ID_Region, Region Name)
-TbTime (ID_Time, Month, Year)
-TbFact (ID_KPI, ID_Campaign, ID_Region, ID_Time, Value)
... but how can I proceed with the KPIs?
Thanks a lot in advance!
Co.
Create E-mail From Access
Aug 23, 2004I have a field for E-mail addresses. Is there a way that when an email addresss
is entered that an e-mail can be generated using that e-mail address
How To Create Dashboards In Access
Jun 13, 2012how to create dashboards in access?
View 1 Replies View RelatedHow To Create Forms That Others Can Use WITHOUT Access
Mar 11, 2015Everyone who will be filling out the form has access to Word, Excel, Sharepoint, and other office-type applications. But not everyone will have Access installed, and it would not be prudent to ask everyone to install it in order to fill out a form.
Is there a method for a form created in Word, Excel, PDF, or any other generally available software to automatically fill an Access database?is there a way, by creating a web database in access to be used with a Sharepoint, to create some kind of web-based form that will automatically fill the database?
How To Create Log File In Access
Jun 11, 2012How I can create a log file in Access?
This file will record all processing on access file
Using Access To Create A Perpetual Schedule
Aug 10, 2005I am trying to create a database to schedule customer visits. I would like to enter a beginning date and a frequency (IE every week or every two weeks) and then be able to print a schedule by entering a date range. Very similar to how MS Outlook calendar performs. Any suggestions appreciated. Thanks Chad
View 2 Replies View RelatedCreate Help File Inside Of Access
Oct 6, 2005I created a help file in access that lets you have text mesasge up to 1024 chars. Just press F1 key on any control that you have setup to bring up help message.
Does any one see any problems with the way I did this?
Form
Help File: = ""
Help Context ID: = 0
For each control on the form where you would like to have a help message do the following.
Form
Control
Help Context ID: = Set to one of the help index numbers in the help table.
Add KeyDown Event to the control
Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer)
'Add this line
KeyCode = DisplayHelp(KeyCode, Me.ActiveControl.HelpContextId)
End Sub
module
Function DisplayHelp(KeyCode As Integer, HelpContextId As Integer) As Integer
Dim dbs As DAO.Database
Dim rstRecords As DAO.Recordset
If KeyCode = VBKeyF1 Then ' 112 = F1
Set dbs = CurrentDb
Set rstRecords = dbs.OpenRecordset("SELECT tlbHelp.Index, tlbHelp.HelpMessage " & _
"FROM tlbHelp WHERE (((tlbHelp.Index)=" & HelpContextId & "));")
With rstRecords
If .RecordCount > 0 Then
Call MsgBox(!HelpMessage, vbInformation, "Help")
End If
End With
DisplayHelp = 0 ' Clear KeyCode
rstRecords.Close
Set dbs = Nothing
Else
DisplayHelp = KeyCode
End If
End Function
Create Table and Fields
Table Name: tlbHelp
Field Name: Index as Number
Field Name: HelpMessage as Memo
Field Name: FieldName as Text
Field Name: FormName as Text
How type in custom number and message for each help message.
Is It Possible To Create Self Calculating Hyperlinks In Access?
Feb 27, 2007I am creating a database that basically holds product information. The different fields I have is Supplier, Product Code, Product Description.
For each product I have a product specification in a word document the names of these specifications follow this convention: [Supplier]&[Product Code] e.g. Coca Cola012345
I need a hyperlink to link to the relevant word document, but rather than going through and setting them up one by one I want the hyperlink to be self calculating depending on the information entered in the fields.
I tried typing in the following in the hyperlink address part in the properties:
=[Supplier]&[Product Code]&".doc"
but it seems to read it exactly as I type it in and obviously does not work.
Can anyone suggest a way round this or perhaps a completely different way of doing it which may be more effective???
Thanks in anticipation of your help.
Create A Ms Access Report Index
Jun 13, 2007I am using MS Access 2000 to handle a help desk system. Each job is given a task number and users are able to output a report of all of there tasks, with full notes.
What I would like to do is create a index front page or section which lists just the task numbers and the page number they appear on.
Can this be done or is there somewhere to perform a search on a report?
Any help most appreciated.
Dalien51
Can I Create This Excel Chart In Access?
Aug 9, 2007Dear Access Expert
I am trying to create the Excel chart see attachments (ExcelChart.jpg) in MS Access but I don't think it's possible with the Access Wizard because it doesn't allow me to use more than one data field (step 2 in the Chart Wizard)
I created the Excel Chart using a pivot table in Excel with two data fields and they are graphed simultaneously
For the Access Chart I only managed to get the "Total Delay Series" and not the "Arrival Delay Series."
Must I use Excel to make this complex chart and link it to my Access form and if so can the chart still be dynamic? My intention is to set parameters using combo boxes and then create the chart on the fly. For example currently the user sees the series for the years 2004- 2008. I want to enable the user to be to have a choice about what years (range) they want to view.
THank you so much.
Create VIEWS For Access Tables
Jan 20, 2005Hi Pals,
Is it possible to create VIEWS for access Tables....
If its possible... How its pls ? :confused:
Create And Edit Image In Access
Mar 28, 2005Hello! All,
I need to store a customer signature in the database so that we can take a print out at a later time.
I don't know how to go about doing this and thought that creating and editing an image within an access form should be a good option. But I don't know how to go about doing that either. So could anyone please help with this and also if you have a better idea, could you suggest that too. I have the application running on a tablet PC so there's something called Stickynotes too that comes with it. It would be great if someone could suggest a solution
Rishi..
Create Outlook Appointment From Access
Oct 22, 2004How do I create an Outlook appointment from an Access database?
Thanks for the help!!
How To Create Tool Bar Menue In Access
Jun 17, 2005Hi guys. I want create a tool bar menue in access 2000 that is linked to indvidule forms in my access but i do not know how i to do it. Just like internet explorer tool bar menue that has file edit view ... and u can click and a drop down list comes and u can select one and ....
I want make such menue in access that each drop down list item from menue is linked to form and once it is selected that a perticuler form loads. I be happy if some one show me how to make such tool bar menue.(i want it the menue loads once i click on the mdb file).Thanks
Noob With Access - I Need To Create A Relationship?
May 20, 2007Hi
Im building a web application to control the stock of a small company.
I already made the database with all the items and descriptions in one table.
This table would be the main warehouse. so now i have to create 3 different departments in different tables where i have to move stuff from the main warehouse.
So if i have 10 boxes in main, and i move 4 to department1. then i would get 6 boxes in main and 4 in dep1.
My web app would be constantly updating the stuff being sold in departments 1,2,3.... so here is my question.
how do i make the database to update the quantities by itself in the main warehouse table if department X sells anything...?
Like in Excel, when you work with different sheets that can update the other ones if you change a number. the rows can be linked... can i do this in access?
Otherwise i would have to write a lot of extra SQL code in the ASP scripts and im really out of shape cause i don't program in ASP sisnce very long time ago... years.
Thanks!
General :: Way To Create A Audit Log In Access?
Dec 14, 2012Is their a way to create a audit log in access?I have a log-in screen on my db and every time a user logs in i want it to be recorded. is their away to do it?
View 14 Replies View RelatedHow To Create Multiple Records In Access
Jan 5, 2012I am relatively new to Access and have a simple database which I use to generate Publication numbers for our new publications. I would like to have a text box and button on a form that will generate duplicate records of the current record the same number of times as specified in the text box.
E.g. If I need 6 copies of a record I would like to enter 6 in a text box, click a command button that will generate 6 duplicates of that record.
The code in order to do this 'on click'.
Table = Publications
Form = Publicationsfrm
Text Box = Lines
Command Button = Submit
Primary Key = PublicationNo
I have tried the following code but it is not working.....
Dim i as Long, myRS as Recordset
Set myRS = CurrentDB.OpenRecordset("Publications")
For i = 1 to Me![Lines]
With myRS
.AddNew
![PublicationNo] = Me![PublicationNo]
.Update
End With
Next
Alternatively if I have a duplicate record button that uses a macro is there a way to run that macro the specified number of times in the 'Lines' text box.
Create A Column Chart In Access
Jun 4, 2012I am trying to create a chart in Access but havent done it before.
1). I have the following data:
Code
CountOfType
Month
Q
3
3/1/2012
K
1
2/1/2012
CDSA
1
2/1/2012
[code]....
2). I dont to create a chart where I am showing the transaction count (countoftype) in the Y axis and the code and bill_date in the Y. I want the chart to show the transaction by code and show what month it occurred. Would this be a crosstab query?
Create A Linked Table In Access?
Jun 29, 2015I am trying to figure out how to create a table on Access that looks like the following:
Data1
Data 2
Data 3
Data 4
Data 5
A
123
123
41
41
A
123
41
41
41
I want the table to be linked to the Pivot Table Data and publish it as a report.
I know in excel it is simply using the = sign to the cell reference; however, what is the equivalent of this in Access?
- How to create a table as shown above?
- How to link the Pivot Table data to the table above?
How To Create If Field In Access 2013
Oct 26, 2013I have an Access 2013 database file with many fields. One of them, I'll call it Field 3, is a box which I would like to either leave blank or put a check mark in it. I would like to be able to create an Iif field for Field 3 where a check mark is automatically inserted in Field 3 IF Field 1 - Field 2 <or= 0, otherwise I'd like Field 3 to remain empty.
View 9 Replies View RelatedMicrosoft Access Was Unable To Create An MDE Database
Mar 31, 2006When trying to create an MDE using Access 2002 I get the message
"Microsoft Access was unable to create an MDE database"
The database is split and in Access 2002 format.
Could this be anything to do with References? I say this because I recently downloaded a dll for Redemption to make use of the SafeOutlook Library
Thanks
Oliver
Use Access To Create Email To Multiple Recipients
Dec 18, 2007Hi,
I'm not sure which Form topic this post should go under ...
I have an Access Database which contains contact information including email addresses in a number of tables. Each table is a reference group of individuals interested in a particular topic and has three fields (contactID, name and Email). All tables relate back to a master address list.
This allows me to have different (or multiple) people from within the same master address as contact persons for different reference groups. When I am doing labels, or printed reports for labelling I simply combine the address from the master list with the conact from the reference group list.
I would like to be able to replicate this approach for e-mail messages.
Ideally the databse would create distribution lists and export these to outlook global address list where they would be available to all users.
Alternately, I would write a module that automatically generates a new email message with all the Email Address entries from a user selected table in the To: field. The user would then edit the email message and press send.
It seems to me that eitehr way I will need to somehow concatenate all emails addresses in a table into a list separated by semi-colons.
How To Create A Access Table Having Autonumber Type With Sql?
May 20, 2005hi,
field type of autonumber can not be created with sql,why?is autonumber a data type like int,text ect.?but int or text field can be created