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"
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 ?
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!!!!
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
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
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"
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?
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.
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?
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:
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.
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.
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?
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?
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.
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.
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.
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.
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..
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!
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.
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.
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.
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!
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?
