I've developed my little database and it works a treat... now I want other people to be able to access it input info via forms (add data), and see reports and run searchs etc... all of which is done through a central switchboard menu.
What I dont want is other users getting into the setup of it all - basically i just want to hide the background workings, relationships, queries etc so nothing can be messed up...
What can i do, and how?!
bear in mind, i still want to be able to have full access myself.
I've put the following Function together to clear out unwanted bits before exporting as csv. I was just wondering if there's a way of holding the table names together with a total count of each item replaced? I wasn't sure if these were stored and could be returned?
Code: Public Function ClearCommas() On Error GoTo ClearErr Dim db As DAO.Database Dim tb As DAO.TableDef Dim fld As DAO.Field
i have an access application in fe/be environment. I have put the BE in a shared forlder on the network.
Now the problem is that the shared folder where the BE is stored, has full read/write access. And this folder is visible to all users on the network from their network neighbourhood or through the mapped metwork drive.
So the problems are: 1) The shared folder has read/write access, so anyone can delete the BE mdb file. <<<<< main problem >>>>>
2) As this folder is visible to even those users who do not use this softaware, anyone can see the data.
We are using winxp and win98 on our network. What can i do to secure the BE mdb file?
>> How can i get all the results if no input parameter is put in the query e.g. if i have A,B,C and need to get all results, only A, only B and only C?
>> How can i block 1 cell and only acess it if the last cell have a correct value?
I was wondering if anyone could help me. I am designing a database for a bowling alley as a project and I am wanting to know if there is a way of doing a search which will bring up all lanes which are unbooked. I have got a search which brings up all lanes booked in ascending order but need a more detailed search. Hope someone can help and if this does not make muc sense please contact me. Thanks!!!
I currently have a database and I would like to add in page numbers. I tried the built in functions but they did not work and they are not exactly what I am looking for. I want my page number to look like this: "1 out of 12 records for MICROSOFT" So I need the counter to know how many records exist for a specific client and keep track of which one of those records are being viewed. Can anyone help?
Hi, I have a form called Product Details Display Form, which is for Product Details Display table. This form contains a button "Done" which saves everything into the table, or in other words, bounds the unbounded textboxes to the table. Basically, I want this button to be disabled at the begining, when the form loads, and when the user enters ALL the fields, it becomes enabled. Here is the code I have at the moment: Private Sub Form_DataChange(ByVal Reason As Long) If Me.Product_Brand = Null Or Me.Product_Code = Null Or Me.Product_Name = Null Or Me.List34 = Null Or Me.Price = Null Or Me.Details = Null Or Me.Discount = Null Or Me.Combo0 = Null Or Me.Combo2 = Null Then Me.Command36.Enabled = False Else Me.Command36.Enabled = True End If End Sub
I also have Me.Command36.Enabled = False in the Form-Load. I dont really know if it has to be in Private Sub Form_DataChange or not.
When you open or are using a Microsoft Office Access database on a computer that is running Windows Vista, you may encounter one or more of the following issues: • Access appears to stop responding. • Access responds very slowly. • Access exits unexpectedly or crashes.
For the complete article and possible work arounds goto:
Hi, I have a 3rd party desktop application to manage inventory. The data will be stored in local MS Access database. I want to sync any changes (insert, update or delete) made to this database to remote MS Sql server immediately or in batches using a scheduler.
Is there any method to know the changed rows in an MS Access table after x time. I mean I want to get all the rows in an Access table that have been added or modified after a particular date and time (say "05-23-2007 10:15:00") without using a user defined date time column in that table.
If i can do the above operation, i will write queries to get the added or modified rows and update remote server in batches.
On a form, what is the best way to hide a label or text box? I'm guessing that I can do a checkbox which would work for me and just write a macro to hide on a false value?
Hello,I was wondering if anybody knew if it was posslble to show an aproximated value of a field with decimal records. I would like to see only integer values on my form.
Here's another one on this subject... But can't seem to find the answer in the "Search" Currently I am using the "Call fSetAccessWindow(0)" method.... Well, all works fine until I start getting into reports. I have read in some post of other methods to hide Access. But I have yet to find any examples of the "easier way"..... Can anyone direct me to a post or link?? Thanks Curtis
Hi, I'm haven't much experience working with Access and I'm hoping someone out there can help me :)
I have a list of products with technical data in tables, however sometimes not all the products have the complete set of data. Is it possible to hide the cells where there is no data present when linked to a page?
Hi can you help. I am developing an access database for an alarm installation company. The database will consist of five tables (stock, supplier, customer, stocksupplier) all with forms.
The customer table holds data for three customer types business, private, caravan. Each customer type has different data stored for it for example the business customer has more than one contact address whereas the private has one.
The problems is on the form I do not want all the fields present as this would look a mess. Is there a way of clicking a radio button or choosing from a drop down list that would make the fields relevant to that customer type appear or grey out the fields that are not needed.
I would appreciate any help as the only alternative I can come up with is have them all on one form. I do not want separate tables as this would complicate the design. I hope this makes sense and thank you in anticipation Kind Regards :) :) Peter
I have a database where people are entering data into in constantly. Now I was told that someone else needs to go into the database and check integrity of data entered. There are a few buttons that I don’t want a “data verifiers” to click on, but “data entry folks” should be able to. Is there any way to may be password protect certain buttons and only be visible if a password is typed or something like that? I know how to password protect a form, but that’s not really exactly what I need and want to do. Any ideas would be greatly appreciated! Thank you!
Having trouble getting the code right to hide and unhide forms.
I have a main menu from which users can open other forms. When another form is opened, I want the Main Menu to be hidden, so it doesn't appear in the task bar.
For example, from the Main Menu Me.Visible = False DoCmd.OpenForm "Review frm", acNormal
However, from Review frm, I can't get the Main Menu to be visible again. I've tried Forms!Main_Menu.Visible = True but it says it doesn't exist. (Note the name of the form, Main Menu, has spaces, which is why it has the underscore between the two words. Don't know if this is relevant or not.)
I know this was mentioned and dealt with in another post, but I can't seem to find it. Basically, I have a couple of text boxes that I would like to hide, unless told to be visible by a command button.
I'm trying to do this to save space on the form.
Someone a while back had mentioned setting the height of the control to zero and also setting the control to canGrow. I tried this on a particular field and it didn't seem to work.
I have created a custom toolbar but the default (access) menu bar still appears every time I open the database. I can uncheck it under toolbars but this doesn't hold on re-opening. How do I do it?
Hi there (first posting on site - and an access newby too!)
I have managed to generate a report which shows me how many students undertook courses throughout the year. I have been able to put totals to my report for each intake and for each campus, and have hidden the student data on the report. However the report is many pages long as although the student data is hidden it still takes space on the page.
How can I get the report to just give me the totals of each intake and a total for each campus?
I have a form listing clients. Each has a command button linking to another form with client details and other option. One the bottom of the form is an Add Client button. I want the user to only be able to add a max of 6 clients, and the buttons to these clients be invisible until the Add Client button is pressed and the information about the client is filled out. Then back on main form listing clients, the client name will appear with a command button that will link to client details. How can this be done? I've seen it done, but can't figure it out.
I am somewhat lost and would really appreciate your help!
I am using a database to classify newspaper articles. There are several users - and they need to be trained to the classification rules. Waht I would like to do have is a way to let different users classify the same sources. However, the "trainee-user" should not be able to see the data already in the database. Also I would like to flag all "trainee-user" records to compare them to the original results. My questions are thus:
How Do I hide records from a user and yet allow him to use the database (and see the stuff he entered himself) How can I save information on a user in a table?
Hi guys, i read about this before but it did not work.
i am trying to hide the access environment but i couldnt. i read in this forum that if i have a bmp with then same name than the db, the picture would replace the access environment. I have done this but the only thing that i achieved was to see the picter before access env. comes and then it desapears and the access env. shows up.
