Launch Application
Apr 6, 2005
I have a command button on a form, and on its onClick event i have placed the following statement in order to open a specific word document:
Call Shell("C:Program FilesMicrosoft OfficeOffice 10Winword.exe C:TempTest.doc", vbMaximizedFocus)
This works fine, however I noticed that if the path for the specific document contains a space, it does not open up successfully but i get a msgbox saying "the document name or path are not valid"
Any suggestions please ?
Thank You
View Replies
ADVERTISEMENT
Jan 5, 2014
it is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?
View 4 Replies
View Related
Jun 11, 2007
We have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.
I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.
Please help...thanks in advance for any thoughts!!!!
View 2 Replies
View Related
May 22, 2007
Can I open an email to send filling in the To or the BCC field but maintain my outlook signature page???
Currently I open email, but my signiture is missing???
Thanks
View 3 Replies
View Related
Oct 26, 2005
Hello All,
I am new to this board and have a question about your opinion on creating an Access project that will be a project launch calendar for an organization. Basically, there are numerous projects with start and end dates and they need to be tracked every month and Gantt chart type reports are created that how their current status and if they have slipped or not. It is done in Excel now, where are set of people gather information about different sets of projects and at month's end compiles them into one Excel sheet which is then used as the basis for generating some reports through Mail merge and also manual Gantt charts in power point.
So, the idea is to port this system to Access where data is continuosly fed by the users through the month and then at month's end reports generated that are similar to what is produced manually now. My basic questions are:
1) What do you suggest regarding the process of having multiple users interact with Access to feed in data throughout the month, i.e. can this be done concurrently or is there a best practices process of having multiple users interact with the system without disturbing each others work?
2) Is there a sample project or technique someone can suggest that enables production of Gantt chart type or MS Project type visual timeline reports from the underlying data?
Will appreciate any pointers. Apologize to folks for whom all this is very basic.
Thank you
View 1 Replies
View Related
Jan 6, 2005
Hi
How do you launch a text file using a button in VBA?
I want to click on a button to open a log file - I would actually like to open a dialog box that starts up in a particular directory (eg C:logfile) - the user can then double click on any required txt file which then opens in notepad.
Thanks
View 1 Replies
View Related
Sep 26, 2006
What is the simplest (script) way of opening a .mdb file from a simple VB appliaction that I have made i.e by clicking a command button that says "Click this button to open XXX.mdb"
View 3 Replies
View Related
Aug 3, 2005
Hello all
I have fell into Data Access Pages (yes, it hurt :p ), and have absolutely no knowledge of HTML or Javascript (though fairly competent with vb), so please bear with me!
When you are using normal forms in Access, you can launch a separate form from a command button, and bring up a record based on a value in a combo box - for example, Form A has a combobox1, and when cmdbutton1 is pressed it launches Form B and displays the appropriate record, using the criteria of combobox1.
My question is, is there a way to duplicate this functionality when using DAP?
Cheers for any insight..................
View 2 Replies
View Related
Dec 29, 2007
Hi all! I am looking for some help in how to get a form to open just once on the first launch of the database. This information is the company information of the one using the software. I have a button that one can click if they want to edit or add this information later. Thanks for your help in advance.
:confused:
View 2 Replies
View Related
Jun 29, 2006
My goal is to have one form which will be used to launch any of my reports. I'd like to be able to group my reports (Customer Service, Accounting, etc.).
There used to be a great sample of this on the forum but I can't locate it...perhaps we lost it in the hack.
So my question is what is the best way to create a form that will allow the user to select from a list of all available reports?
Thanks everyone.
View 2 Replies
View Related
Mar 1, 2015
I have a fairly simple report which lists rows from one table with a little bit of logic. At the end of each row, I want an action button, which when you click it, goes to a form with the correct ItemID for that row.I tried the VBA code like this on the View button on click method:
DoCmd.OpenForm "CreateCAF", , , "[ItemID] = " & Me.ItemID
Of course, what happens is it opens the form CreateCAF with the first ItemID in the report, regardless of which row you click on. I want it to pick up the ItemId of that row.
View 13 Replies
View Related
Mar 7, 2014
Still working on an meeting registration app in Access. I have a Main menu which contains buttons that allow search by Name, Phone Number, or Account Number. We are using barcode scanners if they have a registration card.
Currently I have an account button which pops up a query prompt window and when they scan the code it fills the prompt with their account number and a carriage return, pulling up an account registration form with their info.
What I would like to do is from the main form, if a barcode is scanned, to automatically lauch the account form passing the scanned account number.
View 7 Replies
View Related
Apr 7, 2006
I would like to be able to have a button that my firm's legal assistants can click which will automatically popup the folder on the server where the client's documents are stored. What is the easiest way to write this?
View 3 Replies
View Related
Apr 29, 2015
I have 10 small databases. At present, I have another database which serves as a platform to launch the 10 databases. I have a graphic for each database and posted an Event Procedure for each graphic to launch the respective database. For example ...
Dim accapp As Access.Application
Set accapp = New Access.Application
accapp.OpenCurrentDatabase ("M:MPFMPF_Mgmt_Info_SystemSignInPlusSignInPlu s.accdb")
accapp.Visible = True
Is this the best way to centrally locate and launch multiple databases or is there are smarter way?
View 6 Replies
View Related
Jun 25, 2014
I have a 2007 back-end db on a network share and around 15 regular users who access it through their own front-end db/interface. One user on Windows 7 is able to launch and use his front-end copy fine except when he goes to launch one form for data entry.
This form clocks and freezes the entire application. I sat with him and was able to determine that the issue is that the form_load code is never running. He clicks on the button to launch the form (done in vba) and the code never runs. If he opens the form in design view first then changes to form view, the code runs fine and there are no issues. This is his present work-around, but I had to give him an unlocked FE copy to pull it off (not ideal!).
I tried this with him on different PCs, with different front-end copies, and even in the back-end copy. Same result each time. None of the other users have this issue, and he can replicate this issue on different PCs. I'm at a loss for what might be causing this since it really seems so user-specific.
View 6 Replies
View Related
Sep 5, 2013
I have been searching the web for a solution to this problem. I have created a scheduled task on Windows 7 to automatically run a macro from a command line, however, it seems to only run when the user is logged onto the machine. Is there a way to run Access without the interactive logon? I would rather not leave the machine logged in with this account, but if that is the only solution, so be it.
View 7 Replies
View Related
May 18, 2015
Currently running Access 2010.
I have a small database where we enter audit log data. In my add add screen from the switchboard, one of the fields is the user the audit is assigned to. So that our group wouldn't be typing their names a bunch of different ways I created a reference table called "Ref Data 005 - Contact Name". So i pre-populate the Contact Names such that they will be more consistent.
The add works perfectly. I built all my screens using the forms wizards.
Now for the modify routine. If the user wants to go in an modify one of the other data elements, I force them in the wizard to do this modify by choosing thier name. Therefore, when i built this screen using the wizard I reference the "ref table" mentioned above. I then throw open another form displaying all of the fields based on the records that it finds for that user when they choose the name from the Ref data 005 table. Hope that makes sense. Ie.. they choose the records they want to possibly modify by first choosing their name from the ref table.
It correctly pulls the records for whatever user you choose. However, when you make the update and save, it is changing the Ref table name as well.
So for example if three users were in my ref as :
bill
joe
john
And you launch the form, lets say joe shows up in the list, when i change it to bill to retrieve bill's records , it will do that but when i make the change, then Joe is changed to bill in the reference table.
View 4 Replies
View Related
Feb 5, 2014
I tried to dynamically set image OnClick property to function with couple of attributes. Everything works well, but... it launches the function automatically without any mouse click! What is causing this? I want to execute the function only on the result of mouse click.
Piece of code:
Forms!Form1.Controls("Image" & i).OnClick = fclick(PiltID)
Private Function fclick(u)
DoCmd.OpenForm "Form2"
Forms!Form2.Image0.Picture = u
End Function
View 6 Replies
View Related
Jun 26, 2015
VBA Code to go in the on double_click event of a name field in a Subform bound to a table. The subform is just a copy of a data table and within the subform view, When the field "employee name" which contains e.g. John is double clicked, I would like access to Lookup and get John's email in the employee table under field "Email" and launch outlook application and insert it into the To field.
I assume hyperlinking the field can also achieve this similar to what excel does but I am fast learning that what is standard functionality in excel is a whole another story in Access..
View 3 Replies
View Related
Jul 10, 2006
Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!
View 2 Replies
View Related
Feb 25, 2014
I am working on an access database that is a meeting registration database.You can search by Name, Phone, or Account Number and then mark the person as registered.
What I am trying to create is an enhanced search by name. I have created a simple form in datasheet format so that if I search by last name I will probably get a list of names with that last name.I want to be able to select the name I want, either by double click or highlite and press a button, and then it launches my form that I created for the account lookup / registration.The account form runs a query that prompts for an account number and displays that account.
how to launch the second form passing the selected record's account number.
View 7 Replies
View Related
Aug 9, 2005
When putting together the final application, you don't want the user to see all the usual default menu options.
1) Which access items should I hide?
2)Let's say I make some modifications after we go live. How can I get the new forms, modules or whatever to the .mdb in use? Would I just delete the tables in the modified .mdb and then import (File/Get External Date/import) the tables with the live data?. It's not a split db, btw.
3) Are there any other options or procedures I should think about for maintainence? For instance, right now I use the compact on close option which has proved to be very useful.
Thanks,
scratch
View 10 Replies
View Related
Aug 4, 2005
Can anyone point me in the right direction to produce an application diagram.
Sort of a map of an app, what data it hold in laymans terms rathers than table and field definitions. What forms do what, and how the whole application fits together.
Thanks for any assistance you can offer.
View 9 Replies
View Related
Sep 21, 2005
This seems like a very silly question but I wondered if someone could tell me how I open up another mdb file from a form?
I've tried the following
On Error GoTo Err_Command976_Click
DoCmd.Quit
Dim stAppName As String
stAppName = "S:updateUpdateMDEUtility.mdb"
Call Shell(stAppName, 1)
Exit_Command976_Click:
Exit Sub
Err_Command976_Click:
MsgBox Err.Description
Resume Exit_Command976_Click
End Sub
But I just keep getting "Invalid Call Procedure or Argument"
Many Thanks
Andy
View 1 Replies
View Related
Jan 3, 2006
Hi, I have a large database containing information that people all over the country want to access. I've designed a main form that contains 3 subforms that queries information from raw data. Now that the database is complete, i'm looking for the best way to distribute it. I've tried to put it on the network drive, but it has been rediculoursly slow. Could somebody tell me what would be the best way to do this? Thanks!
View 1 Replies
View Related
Apr 26, 2006
Hello,
I do not want any menu bar in some application I have made using a switchboard. In the start-up function I unchecked all the checkboxes but some menu functions keep coming back. How can I overrule this?
View 5 Replies
View Related
