Windows 8.1, Access 2013, Microsoft Office 2007 , Access 2007 uninstalled When I try to open Options from File, I get the Windows Installer box open up, Preparing to install.......wait while windows configures Microsoft Office professional 2007. File Options was working before!
View RepliesA 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 RelatedIs there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed.
(The reason for this is so that the Database can refresh itself from Sharepoint on another users machine so that the excel reports on his machine are up to date).
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.
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.
How I can create a Multivalued Lookup however with an add values option?
View 8 Replies View RelatedI want to use information supplied to me by suppliers as spreadsheets to create a database that i can navigate through by selecting from drop down options.
Example;
Imagine a product being broken down by its features, such as a washing machine.
Here is a list of what i would need to sort on,
Manufacture
Model
Type
Size
Price
Colour...and so on
So, if a customer asked "what 8kg 1200rpm washing machines do you supply for under £300 and in black" i would like to able to find all that info by drilling down a few selections.
Id like to create a search field on a form, with a similar function to the standard Access 'find and replace' function. Only id like it to be alot more simple than the Access find and replace form.What i have is a Asset DB for the IT assets in the company i work for. We have a lot of phones, printers, computers and about 120 Laptops. The laptops are quite often reconfigured and given to new users, so the laptop details dont change but the user and software config does. I need to keep track of what software is installed where, for licensing reasons.
What i have is a simple form with the laptop name, serial number, operating system, software, location etc etc. What i would like to be able to do is, type a laptop name into a Txt field, hit a search button, then have the fields of the form populated with the laptops current config and then be able to edit the details from inside the form. ive tried using a combo box but i have more than 20 fields that need filling, so anybody whos used the 'me.txtboxname.value = me.combobox.column (1)' may know that you can only use 20 columns.
The default Access 'Find and Replace' system works fine but i dont want users to have to use it. I also dont want them to have to navigate through records using record selectors.
I have a drop down list to select a committee, but my list is only showing half of the list. There's no scroll bar, and when I try typing in one of the others, it tells me it's not on the list and asks if I would like to edit the list. When I select edit the list, it shows all of them.
View 2 Replies View RelatedI have a Access 2010 database running in runtime. What options do I have for spell check? I can bind to a 2010 Word spell check (if it is installed), but could I do a late bind to utilise any other office spell check? Tried to use a .net spell checker dll and get access to call out the text and get returned the errors? Not sure what options I have really...
View 1 Replies View RelatedWhat I am trying to do is create a master table which references the every other table.But the primary key references another primary key.I can get the combo box to display all the options, buy shows options already selected for other records.in other words...
I have 4 reference IDs from table A.
(ID1, ID2, ID3, ID4)
Master_Table has a combobox to select between the IDs.
if record 1 has ID_1
Record 2's combobox will show all 4 IDs
If I only have 1 ID that can be put into record 4, it's combobox still
displays all 4 IDs.
What I want is: If ID3 is selected for record 1, it wont be displayed in the comboboxes for the other records.
I am new to MS Access. So I am making a database for an automobile warehouse. When a new car arrives at the warehouse, it is allocated a specific parking slot (using a combo box available on the 'New Arriving Car' form).
However, once a specific slot has been allotted, the end-user should not be able to allot the same parking slot to other arriving cars, until the original car has left the warehouse so that the parking slot becomes available once again. Currently, the parking slot combo box shows all parking slots whereas it is supposed to display only unoccupied parking slots. How can I enforce this? (Note that there is a separate form called 'Exiting Car', which is filled when a car is leaving the warehouse).
Fyi, each car is referred to by a unique 17 digit code - so this is the primary key. Also, there are 120 parking slots available in all, with the slot identifiers ranging from A1, A2...A12 to J1, J2..J12 (10 x 12 = 120).
Is it possible to open a Microsoft Word FILE using a macro(or even a query??)? I know how to open Word itself using a Macro by Selecting the Run App Command and typing in my Word address e.g C:Word.exe . I have tried opening a word file using C:filename.doc but no success, the address is correct as I've successfully opened it using Start, Run
Any help would be superb
Cheers All
Is it possible to open an Excel FILE using a macro, if so could someone shed some light on this? I know how to open Excel itself using RunApp but it doesnt work with files.
Any help would be appreciated
Cheers all
Bikeboardsurf
Hi All
I'm not sure if this is even possible but I have a table which has a list of Categories(text) and another field named filepath(also text) which contains a file path which points to specific pdfs. So my question is Can I create a report which then prints the categories with a button next to them which if clicked on opens the coresponding pdf ?
Any help will really be apreciated I am a database novice but am really good at following instructions and copying code :)
Thanks in advance
Mel
Access 2000
WinXp Pro
Greetings:
I have a small access database that I keep on my thumb drive, the last time I closed it I removed my thumb drive before it finished saving and I got the windows was “unable to save” dialog box. Well, the next time I tried to open it, it would not open; when I click on it, it asks for the password (password protected) but when I enter the correct password “Nothing”. I tried to compact and repair but all I get is the option to browse as though there is no file open.
I have researched but can find no solution. Any help will be greatly appreciated.
thanks
Mickey
I created an Excel file using:
DoCmd.OutputTo acOutputQuery, _
"Compile_Query", acFormatXLS, _
"G:ServiceCompanySanDiegoWarehouseLCDLine_Summa riesDaily" _
& DateMonth & DateDay & DateYear & ".XLS", False
However, after creating this excel file, i want it to automatically open.
Is there any way to do this in 97?
Hi
I am having trouble opening a file I created like 6 years ago. The verison has changed and I have changed computers. When I try to open the file I am receiving an error. That the current user account doesn't have permission to convert or enable this database. Is there a way to correct this? Thanks
Is there a way to stop users from opening the front end file twice (stop from having two sessions of the same FE at the same time)?
I've been searching the forum and found this
http://www.access-programmers.co.uk/forums/archive/index.php/t-67724.html
but since im not using an .exe updater is not my case t.t
I have a database application that I have to get to display some external PDF files.
I thought that I would create a command buttone and use that to open the files, but that doesn't want to work. Can anyone provide some thoughts on how to open a Word document or PDF file from within an access form? I only need to display it and then close the file so it doesn't have to be anything fancy.
Help
I wish to open a specific MS Word file using a button on an Access form. Word opens OK, but how do I get it to open the particular file please?
Thanks
I seem to be having a problem opening a file if there happens to be any spaces in the file name. If I open a .pdf no problem acro reader opens it but if it is in word or excell or any other tells me that the file can not be found and seems that only the first part of the file name before a space in the name and the file extention.
example: "Test it.doc" would appear as "Test.doc". somewhere it seems to be trimming the file name.
I've got a table with field define as hyperlink which stores link to a external pdf.
Then i create a form including this field and add a unbound field which has got intermet browser format (as a type).
What code I have to put in onclick event in a hyperlink property sheet to open PDF inside the form?
Hi,
I wonder if anyone here might be able to help me out here. I've been pondering this issue for so long and i was almost giving up.
I've been getting this warning everytime i open up an Access file (.MDB) especially, when trying to open up a file that's sitting on another computers. i have a few computers and they are set up in a peer to peer environment.
I took a printscreen of the warning message and attached it to this post. Please take a look at it. It's called "access.jpg"
Is there any way of turning it off? is it to do with the peer to peer networking?
Thank you in advance
I'm sure most people use Windows shortcuts to open their secured databases, but I found that it didn't always work (depending on which computer I used). Editing a shortcut is pretty confusing since the command is all on one line. I decided to make a batch file to open my secured databases instead. Here's a batch file I use to open a database of mine:@ECHO OFFREM - Set variables to be used in the batch file.SET BACK=Z:BobManager Listdb_be.mdbSET FRONT=Z:BobManager Listdb_fe.mdbSET WRKGRP=Z:BobManager ListSecured.mdwSET OFFICE=C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXEIF EXIST "%OFFICE%" GOTO PROMPTSET OFFICE=C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXEGOTO PROMPTREM - Ask the user which end to open.:PROMPTCLSSET /P dbChoice=Do you wish to open the frontend(1) or the backend(2)? if "%dbChoice%" == "1" ( "%OFFICE%" "%FRONT%" /wrkgrp "%WRKGRP%" GOTO END)if "%dbChoice%" == "2" ( "%OFFICE%" "%BACK%" /wrkgrp "%WRKGRP%" GOTO END):ENDThis isn't the simplest batch file ever, but if you want to use this you just need to change the paths to your frontend, backend, workgroup file, and your version of Access. If Office was installed in the default location you shouldn't need to change those lines, unless you know you'll always be using the same version of Access.
View 1 Replies View RelatedI have an mde database originally created in Access 2003. Will I be able to open it in Access 2007?
(I ask because this mde file was originally created in Access 2002, and wouldn't open in A03. We had to track down the creator and get her to resend a new mde file that was 03 compatible. Are we going to run into the same problem after the next upgrade?)