In my access project i used Gohypelink as defined in this website [URL] well, but i want it to pop up in a reduced view?..At the movement it fills whole screen, and the user have to click on buttons to reduce the size. I want the file to pop up in a smaller view.
View RepliesProblem:
Visual Basic run-time error 7792: You can't open a subform when it is also open in Design view.
I have a subform with properties for SourceObject, LinkMasterFields, LinkChildFields changing according to objects and events in the master form.
The subform was bound to a query before which meant that the subform load event was happening as soon as the master form is loaded. I needed to restrict the subform loading until a certain point so I removed the SourceObject property for the masterform's subform. The subform on the master form is now Unbound.
(This is because I'm now running some code on the FormLoad event for the subform which needs to be restricted until the LinkMasterFields and LinkChild Fields properties have been assigned correctly otherwise it takes ages to load.)
Now I'm getting the above error. Obviously, i do not have the subform open anywhere in design view. No Visual Basic windows are open. I've closed the db, closed access, reopened it and clicked on nothing except the masterform. The error occurs when I raise the event in the master form which assigns the sourceobject property to the subform, i.e.
Me.sfmQryAllOV.SourceObject = "sfmQryAllOV"
Can anyone help me? I've googled this but finding no answers.
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.
Here's my code and a screenshot is attached.
Private Sub Command35_Click()
Dim dd As Integer
Dim fileDump As FileDialog
Set fileDump = Application.FileDialog(msoFileDialogOpen)
dd = fileDump.Show
[Code] ....
I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?
I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.
I need to open and process the data from a text file on the network.
The first 7 characters of the file name will be the same every day.
The rest of the file name will change from day to day.
There will only be one file in the folder that has those first 7 characters.
There are a total of about 120 text files in the folder every day - give or take - including the one I need to open and read.
Hi,
I have a form that has a button, when user presses that button another form is supposed to open in minium view. The problem is that: If my main form is maximized, the other form opens as max or the other form makes main form minimized.
I wonder if it's possible for the main form to remain maximized when the smaller form opens?
Regards,
B
Stupid question, but I have forgotten how to .MDB and go directly to form view. Help, please.
TIA
Hello All!
I think this will be a difficult question but im going to ask it anyway. Ive tried several ways to open 2 forms. Ok, ive achieved this one by letting a code to open up the Main menu (like where you can press buttons) and the second one is to open a field with the open incidents of the person that is logged in.
First question:
How can i achieve that the form will open with the employee name and its incidents?
So what i mean if i login with the name Michiel and a password of it that the main menu will start up but ALSO the form start up with MY open incidents and ofcourse when i login underneath someone else that their open incidents will open.
Second question:
How can i create actually this kind of of good form with the open incidents in it? Do i need to create lets say 5 special forms with all of his own name in it? Or can i create query's that are looking to the login form and that the right query will be loaded?
Can someone help me out please? :) Im getting desperate...
I will update the first post because i think more people will like this idea!?
Hey all, Having small issue with forms opening in form view eventhough I have them set to datasheet default.
If I open them from the database window they will open in datasheet view but when I use a command button that I created on a main menu to open the form the always open in Form View.
Any help would be appreciated
Is it possible to automatically open a subform in form view as opposed to datasheet view?
If so would someone very kindly advise me on which code to use and where to implement it?
Many thanks folks.
Paul.
I 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 RelatedI bet there is a simple explanation for this.
I have a form which opens automatically when the database is opened, but I want it to open in the maximised view so it takes up the whole screen.
Well, I couldn't find this using the search, so here it goes:I have a form in which I enter data to create a new client. Within that form I have a subform in datasheetview which is based on a query which holds/retrieves certain (important) fields from a table that holds case info. So in that one view the client data is displayed on the form and all cases and the most important data from those cases is displayed nicely in one screen.Now, when a client calls I navigate to that client and see all previous and all current cases that are open and/or closed for this customer. So the customer says case this and that number is the case I need to discuss with you. Now, what I would like is to be able to click or double click anywhere on the line that, for instance, says case nr 55, so that the form(s) belonging to case nr 55 pop up and all info concerning that case is displayed and can be edited as needed. My problem is: I'm still a newbie and if it was a simple thing like using the on_click event to open the form that's needed, I would not have to post this question. But that can't be done (as far as I know) since the subform is based on a query which is displayed in dataview.Am I overlooking a very simple solution to this problem or is it really going to be as difficult as I think it's going to be?For clarification of the idea I have included a screenshot of the form in question. I assume there are tons of databases out there which use such a layout or idea as this one. Please, never mind the buttons etc. It is still a work in progress. ;)
View 12 Replies View RelatedHi
I have a text filed on a tab control on a form. What I want to do is when the record is opened for viewing I am it changed the contents of that field. The reason that I am doing this is that I am auditing the changes in the database and any changes to any of the fields are recorded on the in this table along with the users windows username.
This would put an entry in the audit table for everytime a record was opened, even if no changes were made to the record and I want to use this information to create a last ten records form for the users to view there last ten records.
Does anybody know how I can do this.
Thanks
i have the following code and i want that the form opens in datasheet view but i don't know how.
On Error GoTo Err_Befehl14_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Copy Of frm_logistik_zeitfehlerein"
[code]...
I have a form for data entry into my main table. Some records are correct, but some I need to come back to later and correct.
So I have a button on the form to run the Query which works fine. But it opens in a new "Data Sheet View".
Can I make it open in the original form so I can edit the queried data?
In fact, I have one principal d/b running on my access, ad/b which I had imported from my iPad... The import went smoothly enough but I face this problem. I usually scroll the table in order to locate a patient's name.
I can't find a way to select this line and have it switched to a card view in order to update it. I need to move to card view, search from there in order to locate this person in card view. I am sure there is a way to select a line ( a record) in table view and jump from there directly into this record in card view.
With a form in design view, I click on the DESIGN tab on the ribbon and then under TOOLS, I click on PROPERTY SHEET, whick opens on the form. Now I do that and nothing happens. It is the same with ADD EXISTING FIELDS. Neither one appears. Everything else seems to work ok.
View 1 Replies View RelatedI need to figure out how to display my excel file name in my cbProjectList
I place all my excel sheets in my drive D:
with the following file names
09th of July Project List.xlsx
10th of July Project List.xlsx
11th of July Project List.xlsx
12th of July Project List.xlsx
can this be possible....
I like to open a report as a pivot chart from my query. How to open a report by making the default view of report as pivot chart?.
I am able to manually create a pivot chart by clicking pivot chart view from the sql view in a report. Then I pull in the required columns to the x axis and y axis and a graph is generated. I do not know how to save it and open the report by default in pivot chart view every time I click a button.
Without having made any changes to my setup, Access now crashes when I try to open a Macro in design view. I have checked the Trust Center and the folder where my database is stored is trusted (including sub-folders).
I am running Office Pro 2013 with Windows 8.1.
hi all. i am creating a form by the name of ISSUES. i will have a field by the name of ISSUE# where user will be able to type the issue#. i was wondering if it is possible for the user to add an attachment of the issue file. in other ways to make it easier i am asking if it is possible to attach a file in a form and to view it also. any help will be really great.
Thanks
There aren't too many threads on this subject folks. I am looking to understand this a bit more. From what I know, complete security of a database can only be accomplished by making an MDE file. But, the downside there is that MDE's cannot be edited by anyone, so any backups or changes that need to made must be done with an MDB.So, what I want to know is, if I want complete security of a database (as in, no changes allowed to be made, except by me), my only option is to make an MDE file and then transfer all the data back and forth between that and an MDB file whenever I need to make any design changes.Am I right?Thanks!
View 2 Replies View RelatedI'm trying to view a pdf in a form if the file exists. My search has brought me to trying the WebBrowser control. I have it loading the file but it launches Adobe instead of just showing the PDF in the window on the form.
View 13 Replies View RelatedI have a table with 4 Fields:
Drawing Number
File Link
Attachments
Description
I basically want to have a live preview window of the "File Link" attachment in that current record. I have heard it's best to use a Web Browser Control when doing this, but I cannot get it to display the currently attached pdf file in that field of that record.
Is there a way to edit the link properties of the Web Browser Control so that it dynamically detects. The file location of the attached file in that field? There will only ever be one attachment in that field, as this will be a live pdf view of the drawing to which that drawing number was assigned
I have recently began using Access, and i have created a database that has what i call user "Profiles" or contact information for around 63 people. What i'd like to do is set up a form or a Report that has buttons with maybe pictures or just a persons name, when its clicked it opens up their "Profile" which shows a picture and all their information. is this possible?
View 14 Replies View Related