How To Convert From ACCCDB To Executable Files
Aug 29, 2012Is there anything way how to convert the file.
View Replies
ADVERTISEMENT
View Access Files/executable?
Jul 23, 2007I was asked to create an Access db with search functionality in a form and have done so, now I have come across a problem………..
The team I have created this for do not have Access installed on their pc’s and this is and archive search db that I have created so will only be using it very rarely!! As a result I wondered if there is a free viewer or anything I can do to get them to use this db that I have created without having to purchase 12 licenses for an application that will rarely be used!
Any suggestions ?
Modules & VBA :: Convert To Excel Files And Import Into Access Database
Aug 7, 2015I have files that have extension of TSV which are text files but viewable in exel. I figured out a way for the user to click on a button in Access which does the following
1. Run Macro in Excel: The macro prompts the user to select the TSV file. After selection, macro opens the employee.tsv file in the excel (with excel being invisible) and saves it as employee.xls
Code:
Sub SaveTSVtoXLS()
Dim myPath As String
Dim myString As Variant
Application.DisplayAlerts = False
With Application.FileDialog(msoFileDialogOpen)
[Code] .....
2. Imports the Excel file (employee.xls) into two tables: tblEmployee and tblDepartment using the following codes.
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "qryDepartment", selectFile, True - 1, "A1:C2"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "qryEmployee", selectFile, True - 1, "A1:AE2"
Everything is working flawless except that the user has to select the file three times:
1 time for the tsv
2 times for the xls file
Is there a way that the user can select the file only once (tsv file) or at least only twice one of the tsv file and the other for the xls file?
As Executable As Possible
Apr 5, 2006I am trying to make my database as secure as possible so I can sell the application I have written. Certian things are stored in a table to make the application unique to the buyer to hopefully stop free distribution.So I need to make sure that the user cannot acces the tables and make changes to them other than via the front end.I have a password protected backend but the users can still edit the contents of the table via the front end.Not sure if this is the easiest way but I am considering the following:I want to open the main form when the database is opened, and then close the whole access application when the main form is closed.Also, is there a way to change the text in the Top Bar that says Microsoft Access to something else plus change the Tab Name on the Windows Program selection bar at the bottom of the screen.Would using the Access Developer Extensions be the best answer to my problem??http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspxHas anyone used these?
View 4 Replies View RelatedBecome An Executable File ?
Sep 16, 20051.What is Access Runtime?
2.Is there any way (or is it possible) that can change mdb/ mde to executable file (.exe), and can be ran in Access Runtime? :confused:
Thanks
Stand-alone Executable
Sep 16, 2005I've made a few databases in the past for an engineering test facility with some (limited) success. Recently we purchased a time sheet program that works as a stand alone program, but uses Microsoft Access to operate. Everything is table driven and there are filters and all the good stuff from Access, but it's a seperate program - I don't have to open Access to run this program. This would be great if I could make database programs that could run on their own, so to speak. Any chance one of you could point me in the right direction on how to learn to do that kind of thing? Do you need stand-alone Visual Basic or can I make the program within the limitations of Access? I have both so it doesn't really matter, but outisde of VBA within Office products, I'm a programming noob. Thanks in advance.
View 1 Replies View RelatedHow To Create A Executable Application
Apr 25, 2007I am using MS Access to develop a DB application for one of my clients. Now I want to give it my client in a form of .exe file in which he can only use the menubar I have designed. I dont want him to see the MS Access toolbars
Kindly Guide
How To Create A Form As An Executable
Nov 1, 2006hi everyone i'm super new at access. i think it's neat for now.
i just made a form that people can use to insert information. we have a network drive here and it would be super cool to be able to convert the form into an Executeable file that way people can just click on the exe Icon and open up the form without having to go into access and then open the form.
please let me know
General :: Making Database Executable For Others
Mar 15, 2015If you make your database into a executable file to package it, does the other person you are sending it to have to have or own Access to use it. I was under the impression that I could create a database, package it as its own program and give it to someone that does not have access and it would still work? If not, how would I do such a thing.
View 4 Replies View RelatedHow To Turn DB Into Executable File Or Stand Alone
Nov 4, 2010How can I turn my DB into an Executable file, or "stand alone"...Id like to have the end users when opening the DB see only the forms and reports without the Access Background.
View 1 Replies View RelatedModules & VBA :: Loop Through Files And Then Compare With Files In Database Table
Nov 11, 2013I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not insert those files and insert the rest.For this i tried to write a code but i think i m unable to do that .
Code:
Loop through files in folder
folderspec = "O:QA FilesQC ReportingPending Review"
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(folderspec)
Set fc = f.files
[code]...
Using MDB Files Which Are Backed Up Hourly Into Zip Files
May 2, 2012Every hour a zip file is created in an FTP folder. The zip file contains an .mdb access database file with any changes to the data since the last hours file.
What is the best method to get access to connect to the content of the zip files and pick up the changes to the data?
Convert XLS To CSV
Oct 10, 2005Maybe someone could point me in the right direction:
What I am trying to do is convert a XLS file to CSV by the press of a button, how would I go about doing this?
Cheers
Will
Convert Db
Oct 15, 2005Ineed a Db converted to 97 can some one do it for me.
I only have 97 on my machine at home
Convert To Yes / No
Aug 7, 2006I have the following SQL Expression :
SELECT tblDeal.DealCode, UCase([HirerForename] & " " & [HirerSurname] & " " & [HirerBusinessName]) AS FullHirerName, UCase([DealerName] & " ( " & [DealerTownCity] & ")") AS FullDealerName, tblHirer.JointHirer, tblDeal.DateDealIn, UCase([CurrentStatus]) AS FullCurrentStatus, UCase([CurrentFinanceCo]) AS FullCurrFinCo, UCase([LastUser] & " / " & [LastUserDate]) AS FullLastUser, tblDeal.InUse, tblVehicles.VehicleRegNo, tblDeal.DealType, tblDealer.DealerName, tblDeal.LastUpdatedDate, tblDealer.DealerName, tblDeal.DateDealIn, tblRep.BrokerCode, tblHirer.HirerCurrPostcode, tblDealer.DealerTownCity, tblDealer.DealerFranchise1, tblDealer.DealerFranchise2, tblDealer.DealerFranchise3, tblDeal.LastUser, tblDeal.LastUserDate, tblHirer.HirerSurname, tblHirer.HirerBusinessName, tblHirer.HirerForename, tblHirer.ProposalType
FROM tblVehicles INNER JOIN (((tblBroker INNER JOIN ((tblRep INNER JOIN tblDealer ON tblRep.RepCode = tblDealer.RepCode) INNER JOIN tblDealerContacts ON tblDealer.DealerCode = tblDealerContacts.DealerCode) ON tblBroker.BrokerCode = tblRep.BrokerCode) INNER JOIN tblHirer ON tblDealerContacts.DealerContactCode = tblHirer.DealerContactCode) INNER JOIN tblDeal ON tblHirer.HirerCode = tblDeal.HirerCode) ON tblVehicles.VehicleCode = tblDeal.VehicleCode
WHERE (((tblDeal.DateDealIn)>=[Forms]![frmSearchCustomer]![Text110]) AND ((UCase([CurrentStatus]))<>"Deleted") AND ((tblVehicles.VehicleRegNo) Like "*" & [Forms]![frmSearchCustomer]![Combo96] & "*") AND ((tblDealer.DealerName) Like "*" & [Forms]![frmSearchCustomer]![Combo92] & "*") AND ((tblRep.BrokerCode)=[Forms]![frmIntro]![BrokerCode]) AND ((tblHirer.HirerCurrPostcode) Like "*" & [Forms]![frmSearchCustomer]![Combo100] & "*") AND ((tblHirer.HirerSurname) Like "*" & [Forms]![frmSearchCustomer]![Combo29] & "*"));
What I would really like to do is tell the query to dislpay YES or NO instead of 0 or -1 in the Joint Hirer field. Can anyone help please
Thanks
DO NOT Convert
Oct 26, 2006We have both Access 2003 and Access 97 users on our network and i have a database that is written in 97. But lately we've been getting unrecognized format when we open it. So my guess is someone out there is opening it in 2003 and converting it. Is there a way to tell the database to ONLY run on 97 and DO NOT convert to a different version?
Thanks,
Rick
Convert Hh:mm:ss To Seconds
Jun 1, 2005Hi
This is my 1st post so please be gentle
I am running an Access Database for a large uk companys call centre.. I use many diffrent systems which allow me to show our centres productivity...
I have hit a wall
When i first developed the DB i used the time formatting hh:mm:ss but later down the line i found if you *the time by 86400 it converts the hh:mm:ss into a workable seconds format....
One of my old extracts that i feedinto the DB are in the old format therefor i do this calculation within an access query which *the time by 86400
however i have found an probelm.. if the time is over 24hrs it seems to double the time there or there abouts in seeconds
example
01/01/1900 01:42:00 which is basically 25 hrs should be around 92520 seconds
when is do this calculation in an access query it is coming out 178920 all the other times are correct so this rules out how i link 2 querys ....
any ideas???
Splitting Db - Convert Or Not?
Aug 17, 2006Hi, hope someone here has experience with this issue.
Our system was recently converted to much tighter secured network environment and moved to Office 2003 (still Windows XP).
Within the next couple of weeks we expect to split/secure our new db for shared use across a network (approx. 6-8 users at any one time).
I want to keep the db in 2000 as long as possible because I'm doing lots of the work at home and that's what I have. After deployment there will be lots more changes but in managed releases. (sounds official, eh?...)
Does anyone know of any risks I'm running by keeping it in 2000 within Access2003?
Thanks very much,
Convert 0 (zero) To Null
Apr 23, 2007Hi.
I have a db with a numeric field called Eur_2.
This field is populated with data imported from an excel file.
When the Eur_2 excel field contain Null, in the correspondent Access Field the value inserted is 0 (zero).
I have necessity to put in the Access field Null value.
The VBA code that I use for import is:
Eur_2 = XL.Application.Cells(indriga, indcolonna + 10)
If Eur_2 = 0 Or _
Eur_2 = Empty Then
Eur_2 = Null
End If
but when i open the Access table, the value inserted is 0 (zero).
There's something to do for change 0 (zero) to Null?
Thanks
Luigi
Convert Access
Feb 16, 2008Hello
It been a while since i have been on the forum. I developed a database last year and since then i have moved to a MAC.
I would like to know if there is a quick and easy way of converting a database to application which works on any PC or MAC which does not have access?
How To Convert XLS To MDB And Add An Index?
Feb 21, 2008When I load a spreadsheet I can't add an index because it is a linked table, so I want to save it in MDB format so that I can add an index and then export it to SQL. However, when I save the file as an MDB file the data is all still linked as a spreadsheet and I still can't add an index. (I would add the index at the last step in SQL, but Pervasive SQL is very temperamental.)
Basically I just want to export an Excel spreadsheet into SQL and add an index.
Convert To Currency
Jun 3, 2005Hi All.
In my calculation in a query:
Cost: Sum([Cost]/12*(DateDiff("m",[StartDate],Now())))
Cost is Currency;
StartDate is Date.
The result look like Numeric format I would like to have Currency format. Is it possible?
Thanks.
Convert Date
Apr 4, 2006I have a query in which I am splitting a long integer into Month, Day, Year and then putting it back together using Date Serial in another query. When I originally set this up, the date was coming through as 5 numbers. Now it is coming through as six. However, Access will error out if I try to set it as a date.
So, how can I redo the fields below to get 2 digits for the month instead of one. The date now comes through as 041706
CInt(Mid([Field1],1,2)) AS iMo,
CInt(Mid([Field1],2,2)) AS iDay,
CInt(Mid([Field1],4,2)) AS iYear
Convert To Date
Nov 8, 2006Looked through DateSerial but possibly not the way to go. I have a text field, "Month", with the dates in this format: Jan-06, Feb-06. What do I use to convert these to date format? 1/1/06, 2/1/06.
Thanks
Toni
Convert To Datetime And Right()
Nov 14, 2006Hey Guys,
Having some trouble doing a couple of things using both Data Definition Language and a Right() Query.
What I am trying to do is convert this field:
August 17, 2006 3:56 PM
into this
15:56:00
Using this:
Right([Travel Date/Time To],InStr([Travel Date/Time To],",")-1)
Now because the time part in my first field can vary from being 3:56 PM to 12:56 PM Right() is only getting those where the time has two digits.
I tried to use DDL to convert my field to DATETIME but cannot convert two columns in one SQL statement.
Can anyone help me out with this? Sorry if the details are sketchy but I'm being kicked out of the office (after 5:00pm you see!).
Cheers.
Convert A Row To One Column.
Dec 16, 2006Hi,
I have a query that outputs results as follows:
Expr1 Expr2 Expr3 Expr4 Expr5
1 2 3 4 5
I want to write another query to output the above result as follows:
Expr
1
2
3
4
5
Does anyone know how to do this please? Thanks!