Several post in the recent past asked the question of how to package the db for distribution and how to run the Access db in computer not installed with Access. Before Access 2007, you must purchase another program for about one thousand dollar to do this. Microsoft now offer these two programs "Developer Extensions" and "Runtime" for free. The Developer Extension is a program that will package your db into an installation disk. You can package the Runtime program in the install disk for users that use computers without Access 2007. Here are the links to the MS website for the download.
Hi, I have created a database with Office developer 1.5 and I am having problems creating my runtime version. I have been told that the VBA included in this program wont do the job, that I must purchase a full version Visual Basic 6.0. Is this true? Thanks all
I have a text box and sometime the word in that text box is too long. So, is it possible to make the whole word appeared when the mouse is on the text box? I don't want to extented my text box.
I have just solved one problem concerning creating hyperlinks based on values in other fields: See Previous Thread (http://www.access-programmers.co.uk/forums/showthread.php?t=124590)
but now I have another, the hyperlink I have created links to a document, while for the majority of time it is a word document it is not always, occasionally .xls or .pdf
So I need a way of building into the hyperlink code the file extension, my thoughts are it would involve check boxes and if statements (one check box for each) but I am unsure of how to do this, can anyone help?
My code is currently:
Private Sub H_Enter() Form!H = "hyperlink#C:Documents and Settingscew1My DocumentsWORKSpecs" & Form!S & Form!PC & ".doc#" End Sub
I am new here and dont know much about access but I have to do some things.
I have a table filled in access. This table (dlb_tbl) contains serveral colums. One colum named "type". The records of this colum has to be changed like this:
one record: 0RD00S101 this has to be changed into: EDH01-RD00S101
So there has to come a new extension EDH01- and the 0 has to be deleted. This has to be done to the whole colum. How can I make a query to do this?:o
I have an old program with ade file extension and I would like to add some filters in one of the forms but I don't have design view or layout view option.
I have around a hundred tables all with exactly the same format and headings that i would like to combine into one long table, but the copy-paste append data to table function doesn't do what i had hoped. How can I join my tables together? And is there an easy way to do all 100 at once?
Greeting All, I am trying the beta version of Access 2007 and realize that when converting Access 97 to Access 2007, the new db in Access 2007 has an extension of .accdb. I rename the db file name to xxxxx.mdb and the VB app fails to recognize it.
Is there any way to convert the xxxx.accdb (Access 2007 beta) to xxxx.mdb so that I can try my app against the Access 2007 db?????
How would one go about scanning a hard drive for all mp3 files (i.e. *.mp3) and importing all of the titles into a database? I'm sure the dir function comes into play, but it seems to only handle "current" directory and not sub directories.
I was just curious is all..... haven't really dabbled that much in the file/directory functions.
I have a pretty basic TransferSpreadsheet module that works well except that if the Zip code has the four digit extension, it's not importing.
Option Compare Database
Dim myCheck Function MeridianLinkFileImport() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_MeridianLinkFileImport", "R:DEPT-BRCONSUMER LENDINGMarketing Campaigns2014 Auto Loan PrescreenReport from LoansPQ.xls", True, "Sheet1!A3:AO50000" End Function
If there is no extention, it is importing fine... 85086 works fine but 85018-4710 doesn't import.
What I need to do is remove the ".tif" part of the data. because of the way the path is output with regards to the tif image number, I'm having difficulty in targeting only that data that comes before the ".tif" extension.Is there a method I can use that will remove the right 4 characters and in conjunction with my expression above produce the following:
Hello. I have a mdb access file. When I open it, I can see lots of tables. How on earth do I open a form? Do I need another file, if so, what extension should I look for on my computer?? I really dont want to create a new form, since a person who did it has told me that its all have been already done. I just need to open the form and enter the data in. Thanks for any help!!!:)
I want to release an Access program to the production environment for users. I remember there being a file extention that can be used so the users cannot access the DB or Code.
We are looking for an Access Developer for a small business. You must be in the New York City area and willing to come in for an interview. I will check this board every 1-2 days.
I must say when I read stuff about access which is all in vb I get to thinking that I can`t call myself a database guy.
I create a lot of databases for my company which allow people to gain sales history data for customers, enter and view visits to agencies, enter data for phone calls, process product returns, access and display requested data from the main sql server, suffice to say there isn`t a department in the company which doesn`t use one of my databases.
However I have to admit that there is almost no vb code in these databases even though I`ve attended a vb course (I have forgotten all of it as I`ve not used it). It`s all done with queries and macros.
I like to think that these databases work well and fairly quickly. I find it fairly quick to work with queries and macros.
So what do people think is the big advantage of code? Am I just a lazy chuffer who should go hang my head in shame :o
I was wondering if there's an easier way to getting the "developer's extensions" so I can deploy my program as a PROGRAM rather than an .mdb file. I don't really feel like shelling out $600 for a "subscription" to MSDN. Or maybe there's an easier way to deploy the program than using developer's extensions? I'm using 2003. Thanks!
I have an Access application I need to package for redistribution. Following the instructions on MSDN, I purchased Visual Studio Tools for Office 2003 to acquire the Access Developer Extensions which include the Package Wizard.
After installing VSTO, I found that Access Developer Extensions are not included. Can anyone tell me where I can get a copy of Access Developer Extensions? Is the Package Wizard available for download anywhere? Perhaps someone with an MSDN subscription would be nice enough to make this available to me?
Are any instructions availalbe for creating an installation file for an Access MDE file and including the Access Runtime?
Im trying to use the developer extensions in Access 2003 to package my database with an installer, now when packaging the database you get the option to include an MDW security file however this then copies the MDW on to the users PC
and refernaces the MDW on the users C drive in the shortcut in creates. How can i get it to referance my MDW file on my server ? so when i need to make changes to group permissons ect these can be made in the MDW on the shared server
