How To Create MDB-bank Without Access ?

Aug 25, 2006

Is it possible to create MDB-bank without Access ?

Thank you very much!

Aleksandra

:)

View Replies


ADVERTISEMENT

Access Calender, Ignore Weekends And Bank Holidays

Apr 2, 2008

I'm using access 2007 and have some date fields in my forms, i'd like to be able to blank out weekends and public holidays from the calender/date selector in these fields so theres no way those dates can be selected. Is this possible? Thanks.

View 1 Replies View Related

Odd File Format For Import By Bank

Jun 19, 2007

Hi:

Working with a bank that wants a file from us so they can import into their check reconciliation program. Got the export from the accounting program working for the info they need, but the bank guy says he needs a file structure like this:

(first row is header..don't worry about what the stuff means for now)
1234578990000000000000000
(rest of rows are details)
1234589000807091234
1234589000807093456

notice the line breaks between header and rows? Wouldn't this call for a line break and mess up an import program? Bank guy isn't a database person and is clueless

Thanks......

View 2 Replies View Related

Bank Holidays: Advice Needed

Mar 31, 2008

hi

i'm trying to build something that knows when to notify someone that they can call a trade, given 1) a callable date 2) a notice period and 3) the relevant cities

e.g.

?NotificationDate(#28-jun-2008#,10,"LONY ")
16-06-08

the good news is, i've done it, with this code:-


'---------------------------------------------------------------------------------------
' Procedure : NoficationDate
' Date : 28/03/08
' Purpose : to calculate the date of notification for an EMTN, given the call date & notice period & cities
'---------------------------------------------------------------------------------------
'
Public Function NotificationDate(dtCall As Date, intPeriod As Integer, strSixDigitCities As String) As Date

Dim intWorkingDaysBefore As Integer
Dim strCities(2) As String
Dim dtLoop As Date

strCities(0) = Left(strSixDigitCities, 2)
strCities(1) = Mid(strSixDigitCities, 3, 2)
strCities(2) = Mid(strSixDigitCities, 5, 2)

dtLoop = dtCall
intWorkingDaysBefore = 0

Do
dtLoop = dtLoop - 1
If Left(Format(dtLoop, "ddd"), 1) <> "s" And IsBankHoliday(dtLoop, strCities(0)) = False _
And IsBankHoliday(dtLoop, strCities(1)) = False And IsBankHoliday(dtLoop, strCities(0)) = False Then
intWorkingDaysBefore = intWorkingDaysBefore + 1
End If

Loop Until intWorkingDaysBefore = intPeriod

NotificationDate = dtLoop

End Function


'---------------------------------------------------------------------------------------
' Procedure : IsBankHoliday
' Date : 28/03/08
' Purpose : to see if it's a bank holiday
'---------------------------------------------------------------------------------------
'
Public Function IsBankHoliday(dtInput As Date, strCity As String) As Boolean
Dim rs As DAO.Recordset

Set rs = CurrentDb.OpenRecordset("SELECT * FROM qry_Tass_All_Hols WHERE CITY = '" & strCity & "' AND HDATE=#" & Format(dtInput, "mm/dd/yyyy") & "#", dbReadOnly)
If rs.RecordCount > 0 Then
IsBankHoliday = True
Else
IsBankHoliday = False
End If
rs.Close
Set rs = Nothing

End Function



BUT it runs like arthritic toad, it makes a minute per execution and i was hoping to scale it up to 4000 records => 2 days of run time :eek:

any ideas on how to attack this problem...even guesses appreciated, i can try things out and see if they work


thanks in advance

View 8 Replies View Related

Queries :: Bank Holiday Date - Multiple IIF Statements

Jun 1, 2015

I've a nice formula which work the majority of the time, the only time this doesn't work is Bank Holidays. Is there a way to build on this:

>=Date()-IIf(Weekday(Date(),2)<2,4,2) And <=Date()-1

The above simply runs a report for the last working day, expect if today is a Monday then it runs Fri-Sun.

Im assuming if I know the dates of the Bank Holidays I could hardcode them into the beginning with multiple IIF statement followed by the one above??

View 1 Replies View Related

Forms :: Bank User Form - Recording Deposits And Withdrawals

Apr 8, 2014

I want to create a form where i can be recording the deposits and withdrawals of my bank account!

Let's say I don't have any deposit. If I want to add then i would click on the "+Deposit money" button to open a form to add let's say 10$.

so my total would be 10$.

Next record would to add 30$

so my new total would be 40$ (10$ + 30$)

NOW if i make a withdrawal from my account i would like to click on the "- withdraw money" and so my total would change!

so if i withdraw 5$ the new total would be

35$ (total 40$ - 5$)

how can i do that?!!!

View 2 Replies View Related

Tables :: Suitable Table Structure To Distribute Payments Among Different Bank Accounts

Aug 17, 2015

Looking for efficient table structure for this. Let's say I have a list of contractors who will get paid a certain amount of money each week. The amount of money changes each week by measuring the amount of work done, giving it a price and calculating it. The fields are these:

[pk]WeeklyWorkID
WorkID
Quantity
UnitPrice
Total=Qty*UnitPrice (not stored in this table)
EmployeeID
WeekID

So far, it's all good, but we wish to pay the contractors in an unusual way. Let's say he makes $16,000 of work this week, and we want to pay him using cash AND/OR either one or multiple debit cards. For example:

Cash: $1,500
Debit card 45: $7,500
Debit card 71: $4,000
Debit card 13: $3,000
Total = $ 16,000

We can only deposit $7,500 max in each card. But it's even worse... two or more contractors can SHARE the card and it's not always the same card. Sounds pretty funky, but it's what the company wants to do. So, what would you recommend me in this case?

I'm guessing I'm gonna need these tables: tbWeeks to hold the week number, tbCards to store the cards' info, and an extra table to make a many to many relationship between the cards and the employees.

View 2 Replies View Related

Query To Give Daily Balance Across Bank Accounts? (Then Plot In A Graph)

Feb 22, 2015

How to build query to give daily balance across bank accounts? (to then plot in a graph)

Assumptions:

* There is a table TRANSACTIONS which includes columns TRANS_DATE, AMOUNT and BANK_ID. It does NOT include a column for balance. So current balance for a bank account is the sum of the AMOUNTs for that BANK_ID for example. Balance on date XX will be the sum of all AMOUNTS for that BANK_ID for all TRANS_DATE's prior and including the date XX.
* Table BANKS which has BANK_ID and TITLE

Would like a query that gives: Supply StartDate and EndDate for the query:

Date Bank1Balance Bank2Balance Bank3Balance TotalBalance
1/1/15 $100 $200 $100 $400
1/2/15 $200 $200 $100 $500
.
.
.

etc

View 1 Replies View Related

Modules & VBA :: Find Previous Date Taking Into Account Weekends / Bank Holidays

Mar 25, 2015

I want VbA code to find a date 1 less than todays date taking into account weekends/Bank Holidays.

View 8 Replies View Related

Create A 97' Db Using Access 2003

Feb 18, 2007

Guys,

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

View 3 Replies View Related

How To Create A Dashboard With MS Access?

Feb 27, 2008

Hi,

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.

View 14 Replies View Related

Create E-mail From Access

Aug 23, 2004

I 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

View 6 Replies View Related

How To Create Synonyms In MS Access

Nov 22, 2006

Hi,

I want to create Synonym for a Table in MS Access.
Please tell me solution ASAP.


Thanks,
Nitin

View 1 Replies View Related

How To Create Dashboards In Access

Jun 13, 2012

how to create dashboards in access?

View 1 Replies View Related

How To Create Forms That Others Can Use WITHOUT Access

Mar 11, 2015

Everyone 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?

View 2 Replies View Related

How To Create Log File In Access

Jun 11, 2012

How I can create a log file in Access?

This file will record all processing on access file

View 6 Replies View Related

Using Access To Create A Perpetual Schedule

Aug 10, 2005

I 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 Related

Create Help File Inside Of Access

Oct 6, 2005

I 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.

View 2 Replies View Related

Is It Possible To Create Self Calculating Hyperlinks In Access?

Feb 27, 2007

I 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.

View 9 Replies View Related

Create A Ms Access Report Index

Jun 13, 2007

I 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

View 1 Replies View Related

Can I Create This Excel Chart In Access?

Aug 9, 2007

Dear 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.

View 1 Replies View Related

Create VIEWS For Access Tables

Jan 20, 2005

Hi Pals,
Is it possible to create VIEWS for access Tables....
If its possible... How its pls ? :confused:

View 3 Replies View Related

Create And Edit Image In Access

Mar 28, 2005

Hello! 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..

View 2 Replies View Related

Create Outlook Appointment From Access

Oct 22, 2004

How do I create an Outlook appointment from an Access database?

Thanks for the help!!

View 3 Replies View Related

How To Create Tool Bar Menue In Access

Jun 17, 2005

Hi 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

View 1 Replies View Related

Noob With Access - I Need To Create A Relationship?

May 20, 2007

Hi

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!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved