General :: Make Accdr File Out Of Accde File?
Sep 10, 2012How do I make an accdr file out of an accde file?
View Replies
ADVERTISEMENT
General :: Opening ACCDR File
Nov 8, 2012A colleague sent me an .accdr file, and since I don't have Access, I was told to download Access Runtime. From other forums I see that I'm just supposed to be able to double-click the file to get it to open, but I cannot. The file is associated with .7s, and since I can't locate the Access Runtime program, I can't change the association.
View 1 Replies View RelatedForms :: Converting Accde File To A Normal File
Apr 22, 2013I saved my database as ACCDE file which is executable now the problem i am facing is i can't edit my database since i can not view it into design view.
How can i change it to its normal file format
General :: Lock Down Application By Saving As ACCDE File
Sep 29, 2012Trying 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"?
General :: Form Controls Running ACCDE File
Nov 21, 2013I've Saved an Access 2010 File as an .accde version that opens Ok however none of the buttons (eg; delete record, go to first record, next record) that I placed on the form work at all (the standard record selectors at the bottom of the form still work). All the buttons work fine in the .accdb version - only the .accde version that doesnt work...
View 1 Replies View RelatedGeneral :: Command Button Not Working In ACCDE File
Oct 19, 2014I have created an accdb file and saved as an accde file. The accde file opens with a form with command buttons. But the commands buttons do not work with the accde file (they do work with the accdb file). How do I get them working.
View 7 Replies View RelatedGeneral :: How To Make New Changes To A File
Apr 25, 2014I have created a copy of an access file to make some changes to tables, forms and etc. Some of them are deleted, new ones created or the codes are changed.
Is there a way that I can apply all the changes to the original file?
General :: Do Not See Make ACCDE Button
Mar 1, 2013I do not see the Make ACCDE button. I'm using Access 2010 32 bit. Have an ACCDB FE file which I'm trying to create the ACCDE. I've compiled and fixed the VB errors. I've review trusted sources and insured the folders are trusted. For whatever reason, the button is not showing.
View 2 Replies View RelatedGeneral :: Make File Name Part Of A Field Value
Jun 13, 2013I'm trying to split up the filename into four separate fields. Here's an example of the filename:
123112 427900 55261 1156833.jpg
A 12312
B 427900
C 55261
D 1156833
The values A, B and C are always the same number of characters. The last value, D, changes in size. It can be anywhere from four characters to twenty. But it always starts at position "20" as with "1" in the case of the 1156833. The extension, jpg, is of no value.I might also add my programming ability is close to nonexistent.
How To Make Setup File From Access File
Dec 7, 2006i have develop an application in Ms Access, now i want to have setup file for that, how a setup file can be created.
View 3 Replies View RelatedGeneral :: Split Database - Modify Backend File And Make A New Front End
Jun 12, 2012So a while back I created a database which I use to keep track of my companies large list of products. It is very simple only 3 tables, 1 query and 1 form. After running into a problem with copying and pasting updates on each computer in the office I decided to split the database on a network drive. This worked for a bit, however I had to add new fields and modify the form, which corrupted the file. Luckily I had a backup before the split.
As far as I could tell all I had to do was modify the backend file and make a new front end. However it seems like it is not as easy as I thought it would be. How do you modify a split database without corrupting the files or using a non-split copy?
General :: Make A Copy Of BE File Rather Than To Make A Copy Via Code
Nov 26, 2012Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?The user can then just paste over the original if it becomes corrupt.
View 4 Replies View RelatedGeneral :: Mail Merge Word File (using Data From Access File)
Mar 11, 2014I 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.
General :: Forms And Queries In One ACCDB File - Path Setting To Linked Table File
Oct 5, 2014I'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?
General :: Follow Hyperlink To A File Without Using File Extension?
Sep 6, 2012Is it possible to follow a hyperlink to a file without using a file extension?
I have links being created based on the name of a file, but because I haven't used a file extension it crashes.
I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's an extra step, and another place for someone to make a mistake.
I'm potentially using 3 different file types, Word, Excel and PDF's.
The hyperlink works if I just reference a drive/folder, or if I add the file extension.
General :: Batch File To Check (version) Of A File?
Aug 28, 2012I use a batch file to distribute the front end of a database application. Currently, everytime the user clicks the shortcut on her desktop, the batch file executes and copies the front end from a network location to user's local machine. The FE is updated like every couple of days. The users run the database more frequently.
I would like to modify the batch file so that it checks some attribute of the FE file to decide whether it needs to be updated. I can't rely on file size, since the FE includes temporary tables. I essentially need something like the "tag" property of form controls, only for files. It would be ideal if it was me who sets this property, like "version number". Except it has read without opening the file itself.
General :: Open Save File Dialog - Select File From Text Box And Save To Selected Location
Aug 8, 2013I need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !
View 1 Replies View Related'Make MDE File' - Gone..
Jun 8, 2005Hey guys.. I am trying to make my DB into an MDE file however that option which is in Tools > Database Utilities is not highlighted on this particular database. Anyone know why? Thanks!
EDIT - This features seems to be inactive on all atabases on my computer (I haven't tried another computer yet). I am using Access 2000 and running Win XP Hme. SP1.
Make MDE File
Oct 1, 2006I created an Access/VBA database with a number of forms, reports, tables etc and I want to make it an MDE file.
I split the database into a front end and back end, relinked the two and tested it fine. Then I read I had to convert to 2002-2003 format. Again I did that and relinked and retested, so far so good.
However, when I go into the front end and try to make an MDE file I have a problem. It asks me to select the database, so I point it at the front end (Dry Clean) and then it asks for the name of the MDE to create (Dry Clean1) after that if I look in the folder it immediately creates a db1 and then sits there eating up cycles until I cancel it.
I have let it run for over an hour and it is just a blank screen with 'Make MDE/ADE' down in the lower left. I look in task manager and it says it is not responding, but it is eating up most of the CPU and doing some IO (thus I let it run for an hour once). If I cancel it and go into db1 (which is not the name I specified) it says that the VBA files don't exist and just keeps popping up errors.
Is this a bug? Did I miss a step? Am I just doing this wrong?
I need to make this last step to 'blackbox' the code from the users to complete this project.
Any help would be greatly appreciated! :-) Thanks.
Unable To Make Mde File
Dec 5, 2006Hi,
I'm using A2003 to try and create an mde file but it is not playing ball. The mdb is compiling fine with no errors but when I click on "make mde file" and supply the path/filename, Access appears to try to open the mdb again and prompts me with a security warning saying that 'opening this type of file may be harmful.....etc'. The mde does not get created. Any ideas?
How To Make A Save File Dialog Box
Jul 16, 2007I have a problem. This problem is that when I generate the report, I want to show a save file dialog box. How can I do this and and retrict the files show to only "*.pdf" files. I tried it as follow:
Private Sub SaveFile_Click()
Set FDialog = Application.FileDialog(msoFileDialogSaveAs)
With FDialog
.Filters.Add "Acrobat Files", "*.pdf" .Show
End With
End Sub
error is araised when executing .Filters.Add "Acrobat Files", "*.pdf": Object doesnt support property or method.
ALSO How can I pick the path the user selected?
Thanks
Forms :: Make PDF File From A Report
Apr 1, 2015i have the following code to make the PDF form a report. but i want to make the PDF in landscape mode and also each time with a new name.
If Me.Combo3.Value = "" Or IsNull(Me.Combo3.Value) Then
MsgBox "Please enter order number!", vbExclamation, "Order number required"
' ElseIf Me.cmb_AuftragNummer.Value Like "*[a-z]*" Or Len(Me.cmb_AuftragNummer.Value) <> 6 Then
'MsgBox "Invalid order number!", vbExclamation, "Invalid order number"
Else
DoCmd.OpenReport "rep_CQAReport", acViewPreview, , "[Fehlercode] = '" & [Combo3] & "'"
DoCmd.Close acForm, "frm_rep_cqaReport_filter"
DoCmd.OutputTo acOutputReport, "rep_CQAReport", acFormatPDF, "O:ApplicationsCQA ReportingPDFTest01.pdf", False
End If
Make A File On Harddrive The Constant Datasource
Jul 29, 2006Can anyone help me with setting up a Visual Basic project to where the datasource I use is a Access database on my harddrive. This Access database isn't linked to a server or anything. It's just a database I created and would like for my project to open this file everytime it's attempting to pull data. How can I make this connection? If I am able to use ADO, how do I go about doing this? I would think ADO wouldn't be necessary though.
View 1 Replies View RelatedQueries :: Make Table Query In Different File
Aug 30, 2013I need to put together a make table query, already got all the fields sorted the way i want the problem is that query is located in my databases Front End and i need the table to be made in the Back End (giggity), the filepath for the back end is actually stored in a "Master Control" table if this makes the process easier...
View 3 Replies View RelatedModules & VBA :: How To Make Excel File And Export It To Mail
Aug 18, 2015i want to make an excel file from a query and then export it to mail. i want to make an excel and then send it as an attachhment. also i want to insert the mail address to manually because each time it is sent to a different person.
View 2 Replies View RelatedGeneral :: Stop User Renaming ACCDR To ACCDB
Oct 14, 2013I have a database that is saved as an accdr so it can be compiled for distribution as an exe..I have just found the accdr the exe installed and renamed to accrb and was then able to open it and view all the tables, forms etc.Obviously I cant stop someone renaming but if there was a way to stop the forms, tables etc opening.
View 8 Replies View Related