Hi, how do i get a report to appear in front of a form that is set as Pop-Up? at the moment when the report is opened it appears behind the form.
I am using 2000 db for this,
I'm sure in 2003 you can select pop-up inside the reports, there must be a really straight forward way around this in 2000? (without changing the form)
thankyou in advance
I have rectangle object positioned 'behind' several fields on a report....
I wish to be able to hide these fields depending upon access rights....
In code am I able to bring the rectangle to the front and thus hide the fields in question... to save writing a routine to hide each control individually...?
Is it possible to add a front page to a report?
View 3 Replies View RelatedI recently split my Access 2000 database and lost the ability to filter by form in the front end. I have the "Don't display list" set well above the number of records I have (by about 1000), and the "Show list of values in" options are all checked. These are the same settings as are in the back end, where I am still able to filter by form. Any known solutions out there?
While I'm doing this, can someone tell me how to set permissions for the front end where other users cannot delete data?
Hello. Is there a VB command that brings a certain form to the front of the window?
View 1 Replies View RelatedI'd like to know how to programatically bring a form on top of another one
I have two forms: Menu and Notice
in the onOpen event of the form Menu, I open the form Notice
problem is that even if Notice is the active form, it still hides under the Menu form...that's just weird...
Could it have something to do with the startup option in Access in which I tell to open Menu first, it looks like the startup event comes after the onOpen event.
I am after a script to lock a userform to the front but still be able to work on other forms.
I have an excel userform in access which does this and better still it is like a sticky note as it stays on the screen even when going to another program, but as I am working in vba all day long, every time I change something the form closes, it works great when not using vba though.
I have a Form with a control button that opens a Table using VBA code.
I have made quite a few similar databases before and usually when the Table opens it opens "above' or in front of the Form.
This time the Table opens but behind the Form.
I would like the Table to open and appear in front of the Form.
Is there a setting or something to control which displays on top?
I have created a Login form in Access Database in which the users can log in to enter the work information like how much time and which job they worked on particular day , this data is stored in a table . How can make the users to use this form , I dont want to access to be installed on every machine..I want to give something like a URL so that the users can use it..
which software I can use for creation of website so that it can be compatible with ms access ...I basically need to create a front end application and connect ms access my project in the back end scenario..
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.
Hard to see the image but basically, I can't seem to bring the database behind the form to the front to view it when I click on it. I've never encountered this before.
View 5 Replies View RelatedI am trying to create a navigation form on a split database with front end and back end.But Access is not letting me drag forms or reports into the navigation form. Why?
View 1 Replies View RelatedI have a database that I've split and have deployed to 7 persons.
The thing is, I have three (3) forms:
Form 1
Form 2
Form 3
...that require changing a portion of a line in each form's respective VBA codes. I need to change the directories to where an excel workbook is stored after exporting, and another is where same excel is moved to after being uploaded.
At the moment, during deployment I have to manually change the directories.
I was thinking of maybe a pop-up form with four (4) fields that allows the user to select his/her name at the start-up of their frontend app, and paste the directories in the other text boxes provided.
This information will then be used to replace the directories in the VBA.
If I were to make changes and have to redeploy, I would have to do everything manually again.
Is there any particular reason I would choose to use
DoCmd.RunSQL "insert into...
Versus
CurrentDb.Execute "insert into.... ??
I am using an unbound form on the front end of my database to populate the backend tables (multiple tables). Some forms only have a few fields, while other forms have about 15 fields with 3-4 tables updating.
I am okay using the DoCmn.RunSQL , but I keeping reading on the forum that others chose CurrentDB.Execute and it has me thinking.
My database is stored on a network drive with only on front end.
I've looked for how to do but everywhere people asks how to bring a form in the front of all forms.I have a form emergent and modal. The program hides the access enviroment.But, when the form is loaded, it always appears under the window that I have active (whatever the window is, an excel sheet, internet explorer, etc).Is there any vba command to bring the form (or maybe the access application) to the front as the first visible window?
View 2 Replies View RelatedI'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "
how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error
Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work
Hello i want to use as a front end as i can create better forms etc... i want the end user to enter information into a form in Flash and then it automatically updates the access back end? is there a simple way of doing this??
View 2 Replies View RelatedI have read every post here on "distribution" and "deploying" the front end to the users but can't seem to get how to do it. I see many posts regarding updating the front end and using the runtime version to distribute but can't seem to understand how to initially get the database out to my users.
I have a split db and need to distribute it to about 20+ people. The back end will reside on a shared drive that is mapped the same on everyone's machine.
I also have the FE on the same drive and am currently using a batch file run from a link on our website to open it, therefore we are all using the same front end which is what I am trying to eliminate.
Can I just zip up my FE and email it to my users? Will that maintain the links to the back end when they unzip it to their desktop?
Also, I would like to get some feedback on some software I am thinking of buying for pushing out my updated databases in the future. It is called Access Frontend Loader
http://www.frontend-loader.com/
Has anyone used this before? Would appreciate any thoughts on it or any other program you may have used in the past.
Thanks
I am trying to create a Preventive Maintenance Program for my facility,
I will create maintenance tasks:
[ID],[Dept.],[Machine],[Task],[Frequency],[Completed Date],[Due Date]
Simple tasks,
Up front design help,
I will want the task to stay in the task table and the Due Date to be calculated combining the [completed date] & [Frequency]
Simple not a problem,
Here is my problem:
I will need to create a task history table that will contain the Task details and the Completed date each time I complete the task; therefore my thought is that i will need to send the task detail to a history table each time it is complete, so I thought Append Query; but the problem is that it appends all of the records in the task table each time you run it including the tasks that have been appended on previous query runs.
any thoughts on how to capture the task details for a specific record and send them to a history table ?
I have a split database, the front end is showing to be 20.5 megs in size but there are only 4 forms and about 6 querys. Can someone tell me how to find what is making it so large?
I did a compact and repair but it did not reduce the size??
Thanks..
Fen
Hi friends,
I think I am having some problem with my back end and frond end files. I have a mde file that anytime I enter new data or change some things in the old clients file, it does not update on the mdb file. Anytime I need to change forms or report or any thing at all, I am suppose to copy the BE file and the MDB file to my workstatio, remove the table link, make the changes I want to make on the design mode and then import the files back to the live copy of the mdb file then make another mde file to work with. But When I copy the BE and the MDB files, I don't have the updated client list or new client just added. So as not to affect other users, I can not make changes in the MDE file and even the MDE file will not even let me make any changes in design mode. I don't know If I am making sense but any help will be appreciated
thanks
I am having a trouble with a multiuser DB. I have split it using the Splitter Wizard and have put a copy of my FE to a second computer and relinking its tables. When I opening the bound form in computer 1, computer 2 can not open that form and sometimes computers lock and had to restart the machines. But if I open that form in computer 2 first and then the same form in computer 1 , it works fine. I have set full sharing to computer 1. I am using Access 2007 and Windows VISTA.
Both have FE, the BE is located in a shared folder with full permissions in C: in computer 1, the FE of computer 1 is in that same folder. Both computers are connected via a Cat5e Cable.
FE in computer1 table links to c:databaseBE and computer 2 links to computer1_IP_Addressc:/databaseBE
Can anyone help me please!!!
I'd appreciate it a lot
Thank you!!
I have a wonderful database I designed almost 2 years ago. Other than a few hiccups with corrupted data (http://www.access-programmers.co.uk/forums/showthread.php?t=135483), my employer is 100% satisfied with it.
I’m graduating this winter with an AS in computer programming and I would like to update the database to a VB/ADO .NET (VS 2003) front end before I leave. Being a VB developer, I have had my fair share of “quick fixes” when I could not work out a solution with VBA. VBA is the evil twin of VB lol.
Other than PHP w/ MySQL I have never used two separate entities for data management. It’s always been strictly MS Access as the database and front end.
So my question is what major differences should I expect that I took for granted with MS Access’s built in functionality? Such as subforms with master/child properties, navigation, printing reports etc. Will I have to write code for every little detail that MS Access handled for me?
What are your thoughts on using VB.NET as a front end? Did the pros out weigh any cons from your experience with this setup? Any thoughts on using Crystal Reports?
Hello
I'm looking for a web based front end to put on my access database. Due to the way our work site is set up and the people who will be entering some of the data my boss wants it to be accessed through a web browser. Infopath wont let me enter data into an access database through a web browser and with DAPs becoming a thing of the past we dont really want to use them either. Some of the forms will be used for raw data collection while others will be used to fill out spill reports (i work in an environmental department) so we can get the information quickly. We have tried just using access to run everthing but have meet alot of resistance as most of the people who enter the data hate it. I also had someone enter half a spill report into an SQL sequence once..dont even know how he got there. That is the main reason we are looking for a web based data entry system. I dont believe my boss wants to use anything but access for the storage. So basicly we are just looking for a way for people to use a web browser to enter data into an access database. Any advice would be greatly appreciated. Thanks
Hello,
I have a backend database and front end mdb file with forms. I established the necessary relationships in the back end, however when I open Relationships screen in the front end - it opens empty. Do I have to establish same relationships in the front end or can I leave it as it is and still have my relationships work as defined in the front end?
Maybe someone could help.
thanks
giedrius
Hi there, :cool:
I've one FE & BE related question here. Ok first of all I've BE in server and each user have copy of FE in local PC. But I've one problem with linked tables between FE & BE.
Is there a way that FE can programmatically create connection to BE linked tables or user is able to link those tables manually, if FE can't find/connect to linked tables in BE? Or do I just have to manually configure each users FE linked tables?
All replies are welcome and well approciated at all costs! :D