Hiding The Important Bits

May 9, 2005

Hi,

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.

Cheers

amx

View Replies


ADVERTISEMENT

Modules & VBA :: Function To Clear Out Unwanted Bits Before Exporting As CSV

Sep 20, 2013

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

[Code] .....

View 4 Replies View Related

BE/FE Security *Important*

Mar 12, 2006

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?

View 12 Replies View Related

2 Important Questions

Nov 13, 2005

Hello,

>> 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?

Thanks in advance,
Kobee

View 3 Replies View Related

IMPORTANT - Help With Access

Jan 16, 2005

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!!!

View 2 Replies View Related

Simple Yet Important PROBLEM

Jun 10, 2005

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?

View 1 Replies View Related

Disabling And Enabling A Button. PLEASE HELP, VERY IMPORTANT

Mar 14, 2007

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.

Please help me ASAP

Thanx in Advance

View 4 Replies View Related

Important Notice To Vista Users!

May 28, 2007

Important notice from Micro$oft's Knowledge Base:

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:

http://support.microsoft.com/?kbid=935370

View 9 Replies View Related

Text Color For Urgent Or Important Items

Jul 2, 2012

How do I set the text color in one field as Black for regular records & a different color for Special records?

View 1 Replies View Related

Need Some Important Help To Get Added/modified Rows From Access Tables.

May 23, 2007

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.

Thanks and Best Regards,
Anz

View 1 Replies View Related

Hiding Access

Apr 13, 2006

I'm trying to hide access(i.e. toolbars etc.), and only view a form. Is this possible?

View 5 Replies View Related

Hiding Fields

Aug 12, 2005

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?

View 1 Replies View Related

Hiding Decimals

Aug 31, 2005

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.

View 3 Replies View Related

Hiding Access

Aug 26, 2006

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

View 4 Replies View Related

Hiding Prompts

Apr 26, 2007

How do I hide prompts asking the user are they sure they want to update fields, etc?

View 2 Replies View Related

Hiding Values

Aug 16, 2005

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?

View 2 Replies View Related

Hiding A Row In A Table

Oct 19, 2005

Hello all,

I was wondering if anyone know how to hide a row from a table so that 1: viewers can't see it from a web site 2: i don't have to delete it...

I can't figure it out, but there must be a way...

ARW

View 1 Replies View Related

Hiding Fields

Apr 15, 2005

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

View 3 Replies View Related

Hiding Buttons

Mar 1, 2006

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!

View 3 Replies View Related

Hiding Forms

May 15, 2006

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.)

Could someone tell me what's wrong with the code?

Thank you.

View 4 Replies View Related

Hiding Controls

Jan 22, 2005

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.

Any ideas would be a total help. Thanks all.

View 5 Replies View Related

Hiding The Menu Bar

Jul 17, 2005

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?

View 3 Replies View Related

Hiding Data

Mar 9, 2008

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?

Answers appreciated.

View 9 Replies View Related

Hiding Command Buttons...

Jun 22, 2005

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.

tritonvt

View 1 Replies View Related

Hiding Records From Users

Sep 8, 2005

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?


Thanks a lot in advance!!
BM.

View 3 Replies View Related

Hiding Access Environment

May 30, 2006

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.

any suggestion?
thx max

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved