I am in Microsoft 2013 and using an .accde file. The problem is that the File menu and Home ribbon are still accessible, and the File menu can be used to change settings that will let the user get into the linked tables (on SQL Server).
View RepliesI have a database that logs people in and out. Works great unless the user minimizes the navigation page and clicks the X on the main Access Page. I have to keep the minimize button active on my nav page.
Is it at all possible to disable the main access page for the user?
If not, is it at all possible to set a logout macro to the X button on the main page?
If not, is it at all possible to set a logout macro to activate on "Quit Access"?
i have created a login form that opens the home page when the correct credentials are entered. i would like to add an 'access level' so that when logging in the database checks the access level and opens the appropriate home page. (i.e. level one has selected options.. level three has admin)
i just need a code that checks what the users level is and then open home lvl#
(i.e. user level 1 - open 'home lvl1', user level 2 - open 'home lvl2 etc)...
I am currently developing a database to provide a friend with an auction tracking and ordering system.
I will have a number of questions the first is related to the Home Page/Dashboard/Summary form I am creating. I basically have a few sections, one of which is a combo box offering the user to select an auction to view in the summary section. This summary section contains the list of lots but I also hope to to expand on this and create multiple text boxes, each containing the answer to a number of queries (totals etc).
I have written all the queries and can see the results however as the form does not have a record source I would like to know how to make each text box populate with the result of different queries (ideally in vb - I am using ms access 2010)?
I have tried a few things, control source doesn't apply as I have no record source (i guess). I investigated Dlookup/Dcount but am unsure if these apply for the same reason. I understand I am likely to need a recordset etc in vb and have already tried a few things but unfortunately none of them work.
I have a number of drop down menus to select Building Name, Building Number and then Equipment Name and Equipment Number. I want the list to be linked so that when you select the building name the building number is picked up. Also I want the Equipment List's with to change so that once the building has been selected only the equipment available in that building is available to be selected. Is there a way I can do this?
View 3 Replies View RelatedHow I can create an MDE with all options disabled including shift key bypass.
I want to remove all options in Tools>Startup except for the status bar.
I have tried using this code but am not getting anywhere with it
CurrentDb.Properties("AllowByPassKey") = 0
:confused:
Hello I have a small DataBase with 4 forms (Access 2002)
1. frmMainMenu
2. frmAddEmployee
3. frmAddEmployeeRegion
4. frmEmployeeStatistic
The MainMenu calls the other 3, when I execute the mde file the only form opened is the frmAddEmployee! it should open the frmMainMenu because this one calls the others....! I've tried several times....the same result!
Any idea what I'm doing wrong?
Thank you
I am able to bypass the shift key so I can disable ribbon and all menus at startup.
But the issue I have is anytime someone makes a copy of the database or it is their first time opening it they get prompted with the security warning:
"Security Warning - some active content has been disabled, click here to enable"
and it gives them complete access to see the back end of the database because while that warning message is popped up ... before they click "enable" they can go do anything in the database including see tables, data, and vba.
Once they click "enable content" that first time the bypass takes effect and the ribbon and all menus disappear, but if they dont click it they can navigate all around the db
how can i stop that?
I,m trying to create mde file but a dreadful error mesage appeared :(
Here it is:
This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
My database is not AS LARGE. It has 1 table, 36 queries and forms.
Any idea how this could be avoided?
I have the following code. In the Else part of the code, after the wb.Activate line, what code can I place here that will assign wb.Name to the objExcelApp object ao that when the line .Visible = False kicks in, it will make the already opened MS Excel file invisible.
Code:
Dim strExcelFile As String
Dim wb As Workbook
Set objExcelApp = GetObject(, "Excel.Application")
If objExcelApp Is Nothing Then
Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.Workbooks.Open FileName:=strExcelFile
[code]...
I'm getting ready to deploy my database and I would like to Hide the "Home" tab and replace it with a custom tab with just the bare minimum of options. I have alreadyused the access options to hide the other tabs that re normally visible, but can't find how to hide the "Home" tab.
View 1 Replies View RelatedHi,
I had copied my MS Access database that I made from work and tried to open it from my home to work. And it said it is only Read_Only. Why is that? Can I change this from my home PC or Can I work with this only from work?
Another thing, then I tried to create another database and I could only do this by creating table from design view and entering data. But I was not able to create it using the table wizard. When I click on the table wizard, nothing happens.
My work's MS Access is 2000 professional version I think, and my home MS Access is 2000l.
Could someone give some advice???
thank you,
Carboncopy
Sometimes extensive updates have to be made to a table using an update query or loop through a record set.
In order to be able to undo changes in case of a mistake I am thinking about the following procedure:
In code:
1 - Make a copy of the table
2 - Make the changes in the original
3 - Check if updates are correct and if so: delete the copy and if not:
delete the default table and rename the copy so it will be the original.
Is that common practice or not?
If you make your database into a executable file to package it, does the other person you are sending it to have to have or own Access to use it. I was under the impression that I could create a database, package it as its own program and give it to someone that does not have access and it would still work? If not, how would I do such a thing.
View 4 Replies View Relatedhi there,
i'm thinking about upgrading my operating system from XP to Vista Home Basic, but curious if any users have have experianced any dramas running Access 2003 SP3 on the Vista platform? or shouldnt there be any mayjor problems.
regards
Colin
I am attempting to set up a saved import procedure in an Access database that will be run programmatically using docmd.RunSavedImportExport. The source document is an Excel file.My goal is to trap any import errors caused by inconsistencies in the source data. I'd also like to provide the user with some small amount of feedback on what is causing these errors.
My initial thought was to make use of the "File_ImportErrors" table that is generated following an unsuccessful import. *Not once* has this import procedure consistently generated an error table - sometimes the table is created, sometimes it isn't.
I have tried changing the file format of the import file to comma- and tab-delimited files, respectively. Both of these formats do consistently generate an error table, however none of the error values in the table are accurate - it reports a slew of type conversion errors for fields that are completely consistent and unproblematic, whilst completely overlooking conspicuous errors from text strings in date fields.
I have tried the same import, both procedurally and manually, using all available Excel and text-delimited formats, with the same respective results.I notice that nearly every thread on AWF pertaining to error tables discusses how to delete them, rather than make effective use of them. I suspect this is perhaps why?
I have a back-end db in access 2010, linked to a set of sharepoint tables on office365.
I want to make a completely unlinked copy of the db to store a "snapshot" of the data on a fixed date.
I have tried "save as" using the "Save as Local Database" option, but for some reason, it still saves as linked tables.
How to go about it?
there is a need to make access database (access 2007) accessible over net. I know Access Database is not web based application. So I want to know if there is any way of making it accessible via net.
View 1 Replies View RelatedI'm trying to enter data in an access datasheet view in sharepoint. I need to merge cells in the same Column but have the cells to the right in the other columns retain linked to that merged column. Any way to do this?
View 1 Replies View RelatedIs it possible to make a path or a shape in access? I'd like to do some graphical representation of some data and change colors of the shapes based on given values that would correlate to the shapes.
View 11 Replies View RelatedI have this table
Year AvgOfValue
2005 109.061690295772
2009 106.801581389669
I have to calculate the percentage of change of the values. I have very basic knowledge. How can I make a query to calculate the percentage of change?
I'd like to make noise to another computer, or start same sound file or simply to call another computer on lan or through vpn connected computer using vba...
That will be nice if I can press button on access form and user on another computer hear some noise or to loo like it is call
To start, I am going to generalize to a database of Cows. the fields are:
Name (enforced unique/"Primary Key" in access language?),
size,
color,
age.
The goal is to have a form with check boxes for the fields that the user selects. Scenario is one cow buyer cares about size, while another may care about color and be curious on age. So rather than guessing at what reports the users will want, have a form that allows them to select the fields they want then print a report. An intermediate step would be a query to filter the data.
See the picture below ....
Also, from my perspective, this is the basis of the best code i would write; if someone wanted to add a column for cow gender you wouldnt have to change all your forms/queries/reports:
Global import table.Cows
Form 2 in picture (form with check boxes):
for ( i=0, i<width(Cows), i++)
form.create.checkbox cb.append(i)
cb.append(i).label(Cows[i])
Then create the report based on cb0, cb1, cb2, etc. queries
I have got 3 forms, and at the time of running, I want to make one primarily one form to be showing up and the other 2 to be hidden or closed, and the primary form will have 2 buttons, and clickning respective buttons should be able to open another 2 respective forms.
At the moment am using, DoCmd.OpenForm "Form1", which works fine, but am confused in brining the form 1 only to be shown at the first most time.
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.
One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?