Saving New Fonts In The MDB File..

Aug 23, 2005

Hi,

I've recently started working on a new database and already have most of my forms, queries and reports ready. However, I've been using a special font that is not available on most PCs. I was wondering whether it was possible to save the font inside the MDB file so that it can be viewed properly on other systems as well ? (Sort of like in Powerpoint).

Another thing (I guess it's impossible but I'll ask anyway) : Is it possible to save the whole Windows Style design (Scroll Bars, Arrows, Icons, Menu colors, etc..) in my database file ?


Thanks for your help,

Daniel.

View Replies


ADVERTISEMENT

Saving An MDB File As MDE

Nov 28, 2006

I seem to be having problems saving my database files (.MDB) as .MDE files.

I have a database that only contains data (tables).

A second database is used as the interface to this data (it contains forms, reports, and uses linked tables to the data database).

This secong database file is then copied and used my a few users, so that everyone is accessing the same set of data.

I am trying to save the second database as an .MDE file, but under the Tools, Database Utilities option... 'save Database as an MDE' is never highlighted as a viable option. Is there some trick (or conditions) to enable this option?

I am basically doing this so that I can distribute the MDE version of the interface so that users will have limited / no access to be able to modify the code (or get into the table?).

Thank you for any advice or directions you may be able to pass on.

-arm1

View 4 Replies View Related

Saving A Named File

Nov 7, 2006

what is the correct syntax to string in a variable date?

here is my current coding

[CODE]

Set rsDate = CurrentDb.OpenRecordset("qry_Actual_Costs_Thru")

strSOPCDate = rsDate.Fields("Fiscal Week")

'need to string the file name with the date

ActiveWorkbook.SaveAs Filename:= _
"C:my folder locationCombined SOPC THIS IS WHERE I NEED THE strSOPCDate.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

CODE]

my overall goal is to save a weekly file named "Combined SOPC m/dd/yy" where the m/dd/yy is being pull form strSOPC Date whick pulls from my qry.

thanks
Tuk

View 14 Replies View Related

Automatically Saving A Report As An Excel File

Jul 7, 2006

Hi,
I was wondering if there was a way for a report to be automatically saved as an excel file. Also, the Access database is stored on the company's server so would you be able to choose the path where the excel file would be stored?

Cheers,
Ben

View 1 Replies View Related

Suppress Warnings When Saving Text File?

Oct 12, 2004

How can I suppress the warnings that Excel displays when saving the text file?

These are the messages displayed when saving the file as text:

"The file already exists. Do you want to replace the existing file?" RESPONSE: Yes

"myfile.xls may contain features not compatible with Text..." RESPONSE: Yes

These are the messages displayed when closing the file:

"Do you want to save the changes you made?" RESPONSE: Yes or No - can enter either as no further changes have been made

"The file already exists. Do you want to replace the existing file?" RESPONSE: Yes or No - can enter either as no further changes have been made

View 1 Replies View Related

General :: Lock Down Application By Saving As ACCDE File

Sep 29, 2012

Trying to lock down an application by saving as ACCDE file. Saves OK but when you load application none of the controls work. I.e. button clicks do not launch "Open Form" or " Print Report" commands.But in ACCDB format application works flawlessly.

When I tried on a different machine I get an error message that says too many Table IDs. Odd since I only have 3 forms, 3 tables and 3 reports. Lots of DoCmd's and switching between the 3 forms but not sure why this would create "too many Table IDs"?

View 2 Replies View Related

Modules & VBA :: Send Pdf With Outlook Without Saving Actual File

Oct 13, 2014

I want to send an e-mail with a report as attachment.On the internet i have found two options, and both are not the best solutions.

1. option

Code:
DoCmd.SendObject acSendReport, sReport, acFormatPDF, sMailAdres

With this construction I don't have enough control over the mail, and worse, I get an Outlook message when the mail is sending which I have to answer.

2. option

Code:
Dim oMail As MailItem
Dim oAtt As Attachment

Set oApp = CreateObject("Outlook.application")
Set oMail = oApp.CreateItem(olMailItem)
DoCmd.OpenReport ReportName:=sReport, View:=acViewPreview, WindowMode:=acHidden
Set rpt = Reports(sReport)

[code]...

with this construction I have to enter an existing report.pdf on my filesystem (bold line), but I want to pass the rpt object straight to the mail as an attachment.

View 2 Replies View Related

Modules & VBA :: Remove Special Characters From File Name (when Saving)

Feb 20, 2014

I use the below code as part of a database which creates documents and then saves them using data from the form fields.

Every now and again one of the form fields contains a "special" character such as /,@,& and this prevents the file from saving.

Is there a simple addition to the below code to remove special characters from the file name if there is one present?

It causes all sorts of issues as many people don't realise that there has been a problem until it is too late.

Code:
objWord.ActiveDocument.SaveAs2 FileName:="C:UsersPublic" & Forms![Front Page]![Site 2 Name] _
& " " & Forms![Front Page]![Combo79] & " " & "O2" & ".doc"
objWord.ActiveDocument.Close

View 9 Replies View Related

Reports :: PDF Generating And Saving But Returns Blank File

Apr 18, 2013

PDF was generating and saving to the correct location, but when I open the PDF file ... it's blank =P am using access 2003 and acrobat standard 9

Code:

Private Sub cmdPDFByAssetNo_Click()
Dim MyFilter As String
Dim MyPath As String
Dim MyFilename As String

[code]...

View 2 Replies View Related

Modules & VBA :: Exporting To Excel Template And Saving As New File

Jun 25, 2014

Any definitive way of exporting a query to an Excel file and then saving it as a new file without saving over the original.

I've tried to remove any confidential info from the code below so it's not exactly the same.

Code:
Dim XLApp As Excel.Application
Dim XLSheet As Excel.Worksheet
Dim tmpRS As DAO.Recordset
Dim strFolder as String
strFolder = ("C:Profiles"& [Name] & "")

[Code] ....

The error seems to be with the SQL statement although that may just be the first error that it got to. I read that you can't refer to a Query if it has a criteria and that you have to write the SQL directly into the code.

View 13 Replies View Related

Forms :: Open A Form For Saving Results Of Query To A Text File On Desktop

May 6, 2015

I have a BE database, that when opened, opens a form for saving the results of a query to a text file on the desktop. It works fine, if the full path is entered.

The problem is, I want this saved on any users' desktop. I did some digging and found the %userprofile% variable, which when used, gives me the error.

I understand this should work in both Windows XP and Windows 7, which are the environments the full DB will operate in. So far the "EXPORT" button on the form has the following for the code:

Code:
Private Sub BTN_Export_Click()
DoCmd.TransferText acExportDelim, , "QRY_ExportPublicComment", "C:UsersMark N. McAllisterDesktopPubComExp.txt"
End Sub

When I tried this:

Code:
Private Sub BTN_Export_Click()
Dim strPath As String
strPath ="%userprofile%desktopPubComExp.txt"
DoCmd.TransferText acExportDelim, , "QRY_ExportPublicComment", strPath
End Sub

the error occurs.

View 10 Replies View Related

Report Fonts

Aug 21, 2007

I developed a report using Courier New font. When I print to a HP4050 from my computer the report is correct. When I print to the same printer from a different computer fields are truncated as if it is using a proportional font.
Any idea as to whether this is a Windows or Access issue?
Thank you in advance for any help...

View 1 Replies View Related

Changing Command Bar Fonts

Jul 7, 2005

I want to change the font spec for certain controls on a command bar I've created but can't find out how, or even if, it can be done.

Does anyone know how to do this? There might be an API call somewhere but I don't have any details.

View 5 Replies View Related

Form Sizes And Fonts Change On Different PCs

Nov 19, 2006

I browsed a lot of posts related to fonts, and pored over my "Mastering Access 2000" and "Access 2000 Power Programming" books, but I couldn't find answers to my specific questions.

I have many years of experience with Access, but I've only recently become interested in making my forms look nice on a variety of user PC configurations. Now, like many others, I sometimes spend too much time formatting a form so it looks really nice on my PC, only to find formatting problems on the user's PC. For example, a label using Arial Rounded MT Bold looks great on my PC but is cut off on the user's PC. Similarly, Tahoma on buttons looks nice on my PC but looks bigger and bolder on the user's PC.

At first I thought this was probably a font problem. But then I realized that even with the same screen resolution, the forms themselves (not just the fonts) appeared bigger on the user's PC. Some forms didn't even fit inside a maximized Access window, whereas they certainly did on my PC - again, this is with the same screen resolution. So now I don't know if it's a font problem, some other problem, or perhaps multiple problems.

Which leads to my questions:

(1) If I set the size of a form on my PC, and the screen resolution is the same on my PC and the user's PC, then why does my form show up relatively bigger on some users' PCs? How can one control the look of a form if the form properties are not applied identically on different PCs?

(2) Why do all the fonts look bigger and fatter / bolder on some users' PCs?

(3) Is there a user-configurable Windows setting that overrides the font size settings I assign to controls?

(4) How can I determine in code if specific fonts are supported (if this is a necessary step)?

(5) What is the industry best practice for managing font selection, allowing for the possibility that the desired fonts may not be supported?

Thanks for your help...

View 1 Replies View Related

Different Fonts Styles In A Textbox For Report-HELP!

Jun 11, 2007

Hello All:

A database with Last_name, First_name, Midd_name and Suffix.

These textboxes are concatenated into another textbox called "full_name".

The font style chosen for the full_name textbox is "Old English".

The suffixes used are: II, III and IV.

When Old English is applied to Last_name, First_name, Midd_name, it looks great.

Unfortunately when Old English is applied to these suffixes, it looks terrible.

Is there a way to preserve the "II", "II" and "III"?

Is it possible to have more than one font style in a concantenated textbox?

This will be used for printing completion certificates, so the spacing of the names is important.(Report)

Any help is greatly appreciated.

Dee

View 11 Replies View Related

General :: Access Won't Show Specific Fonts

Aug 27, 2012

I'm using a certain font - Guttman Yad-Brush (Hebrew, comes as a part of windows in Hebrew) in some forms and reports. On the design view of the objects, everything is OK. But when I try to display the form, or a print-preview of the report, Access refuses to show me that font. The text is clearly visible, in Hebrew, but in another font (I think Times-New Roman, but not sure).

The font is well installed, and works fine on other Office applications. Couldn't reproduce this behaviour with other fonts (but obviously haven't tried them all).

View 3 Replies View Related

General :: Fonts Not Embedding Properly In PDF Exports

Jun 21, 2014

I'm using Access 2010's DoCmd.OutputTo in VBA to export reports to PDF. The "look and feel" of the PDFs are very important, as they will be distributed to clients of my company. I'm using special corporate fonts that are legally licensed for embedding as a subset. Two are .ttf (TrueType) and two are .otf (OpenType) fonts. The ttf fonts embed fine; the otf fonts do not, and the PDF viewer substitutes something it thinks is close (but really isn't). In the properties of the fonts in Windows Control Panel, the embedding properties are exactly the same for both.

Any way to force the fonts to embed? or any other workaround? Also, is there any way to edit-protect PDFs with VBA code? Or apply any other type of PDF security such as requiring a password to open?

View 3 Replies View Related

Reports :: Output To PDF With Distorted Letters - All Fonts Are Embedded

Aug 12, 2014

I have a report that i export to pdf from access 2010 using OutputTo. The report is about 10 pages long. Every time i run this report, at page 5 and beyond, random letters become distorted, sometimes with a box sometimes with a question mark. All fonts I've tested are embedded. Times New Roman, Calibri, Arial, Georgia and others.

Attached is a sample of of the distorted pdf output.

View 7 Replies View Related

Modules & VBA :: Populate Combo Box With Names Of Installed Fonts On Computer

Jan 22, 2014

I need to give users the ability to change the font of a field in a report. The field shows a barcode.

I thought of using the CommonDlg class to show the Windows font-selecting dialog box, but installed barcode fonts show as a barcode. I need to show the font name.

So I need to populate a combo box with the names of all fonts installed on a computer.
The fonts reside in C:windowsfonts

I have searched Google for a solution but cannot find one.

How do I populate a combo box with the names of all fonts installed on a computer?

View 4 Replies View Related

Forms :: ControlType - Set Text Box Fonts In All Forms

Jul 17, 2013

I'm using the following code to set text box fonts in all my forms. Problem is a couple of my forms have a combo box which I need to reference here but not sure how. I want the Combo Box font to be the same as the text box's. Not sure how to check to see if the control is a combo box.

Code:
Public Function TextBoxProperties(frm As Form)
Dim ctl As Control
On Error GoTo TextBoxProperties_Error
For Each ctl In frm.Controls
If ctl.ControlType = acTextBox Then
ctl.FontName = "Calibri"

[Code] ....

View 8 Replies View Related

Forms :: (Upload File) Button Stopped Showing All File Types

Oct 7, 2013

I recently upgraded a DB from 2003 to 2013 and ran into the following problem.

I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.

In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.

Private Sub Command35_Click()
Dim dd As Integer
Dim fileDump As FileDialog
Set fileDump = Application.FileDialog(msoFileDialogOpen)
dd = fileDump.Show
Dim Yourroute As String
Dim yourrouteName
Yourroute = fileDump.SelectedItems(1)
yourrouteName = StrReverse(Yourroute)
yourrouteName = StrReverse(Mid(yourrouteName, 1, InStr(yourrouteName, "") - 1))
FileCopy Yourroute, "us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName
Me.Drawing_Link = yourrouteName & " # us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName
End Sub

View 1 Replies View Related

General :: Mail Merge Word File (using Data From Access File)

Mar 11, 2014

I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.

Please download the attached file !

If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.

Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.

Secondly, I click 'Insert Word Field' -> select 'Next Record'.

In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.

View 3 Replies View Related

General :: Forms And Queries In One ACCDB File - Path Setting To Linked Table File

Oct 5, 2014

I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.

One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.

Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?

View 4 Replies View Related

Text File To MS Excel Multiple File Import Application

Jul 20, 2006

hello,

I would like to automate something presently done on a one-by-one basis. Here: a number of text files(containing data) are to be exported into an MS Excel file, with each text file to occupy a different worksheet. Presently, the idea is to use the Data/import external data/import data feature of MS Excel for importing the text files one-by-one into newly created worksheets(within the same workbook).

I would appreciate some advice on how to go about creating a useful MS Access application to achieve the above. I have checked the available Macros in MS Access, but I could not find one to suit my purpose. can anyone pls assist, on how I can get started?

Tokunbo

View 3 Replies View Related

Modules & VBA :: Determine Excel File Type Without Opening The File?

Aug 14, 2015

Question: Is it possible, using VBA, to determine the actual Excel file type without opening the file?

I receive data files from other departments. Seems like every time someone changes their download structure, I end up with file types that do not match the download extension (example: xlm file with a xls extension). The files can't even be opened because of this. I think I can fix it if I could figure out how to determine what the file type really is.

I'm using Office 2010.

View 3 Replies View Related

Forms :: Storing File Location And Opening File From A Form

Dec 5, 2014

i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text

i made the mistake of not copying the files for safe keeping when i got a permanent position..i am now back self employed, i need to recreate the database.

View 4 Replies View Related







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