Is there a way to disable the filter feature in MS Access? I have several users that use the filter to find a single record when I've repeatedly told them that using CTRL-F is faster and less of a strain on network traffic.
I'm trying to eliminate all possible causes of a massive slowdown that occurs everyday at roughly 10-noon. There are several ODBC timeouts (even after including some code to have it attempt to retrieve the data 3 times prior to it allowing the timeout message to pop-up).
I have removed all linked tables/queries that are not needed and the database has been rebuilt. Compressed the database is under 2 megs and the SQL Server backend is on it's own server where the same queries return instant results.
I have a form called frmSearch with an option group called grpSearch ,a combobox called comboNyaba and subform called subform_CasesSearch has a checkbox called CaseClosed
The combobox filter the subform based on option group choice and value in textbox called NyID ... it works fine except that if the combobox is empty it give me error the code in main form i put it on Load and on current
Code: Private Sub Form_Load() With Me.subform_CasesSearch.Form If Me.grpSearch.Value = 1 Then .Filter = "NyID = " & Me.ComboNyaba
Hi, it's me again, the guy who works with the Amusement ride industry. I'm trying to set up a way to ogranize all our saftey bulletins that we get.
I've already looked into indexing but the major problem is that the user will need to be able to search on multiple criteria (for example the Tilt A Whirl was made by three different manufacturers). Also I can't download that nifty google tool bar because we're running win 2000 without service pac 3.
Access seemed like a great alernative, but I have about 300 or so files I need to link. Is there a faster way of linking these files than going through and doing them one by one?
I have a pre-made index the guy before me made in exel. Most all the files are in PDF format if it helps at all. Thanks.
Hi, i'm new here and I know there's a lot going on but i was hoping someone could point me in the right direction or give me a few tips...
I've imported a very large (nearly 15000 records) set of data into an Access database as one big huge table storing various bits of information about coins. As far as I can tell, the data is in at least first normal form, in that no multiple values are stored in any columns (not yet sure of the technical term - field?)
Anyway, I've managed to use a make table query to separate out some of the content of the table into separate tables with relating entities.
One question is, and please bear with me - How do I add an autonumbered primary key to these newly separated out tables and then add these autonumbered items to the original tables as IDs so that I can set up relationships? Is there a "proper" way to go about describing this?
The following consists of ALL the fields in the original table and how i've split them up by table:
PERIODS PeriodName PeriodCode PeriodHeading PeriodStartYear PeriodEndYear
VARIETIES Variety
The Variety field in the Variety table is especially problematic. There were 1259 varieties stored in the original table which are now in a separate Varieties table which is great. But how do i now add an autoincrement number and call it, say, VarietyID, but then link each Variety back to the main list of coins but replace the full Variety description with the newly created VarietyID?
If any of that made sense, i'd REALLY appreciate some wisdom here.
I have created a database with a list of product codes, pricing, costs, and supplier name. Now I have about 100 product codes which I would like to look up for all those information. Is there an effective way to do it in Access? I know I could export the whole datasheet to Excel to do a vLookup, but it may be lots of waiting time if the data are massive.
We just started using Access 2007 in the past few weeks (upgraded from 2003). One of the functionalities that we are missing is the ability using the Alt+Tab to go directly to an open table or query under a specific Access Database that is already open. Now I can only switch between open Databases and then I have to use my mouse to Toggle between open queries/tables etc. Is there a setting that would allow this, or is this functionality just gone? (I am still using XP, but the functionality is not there on Vista either)
I am building a database for a client that tracks construction drawings. The client came today to check on progress. Just before he came, I changed the start-up properties to hide the database window, menus etc so it would look more like the finished product.
Problem was, I lost alot of the functionality and had to change it back to demonstrate:( . Is this common and can anyone explain why? much appreciated
I want to have a program where the balance of an account is always updated and stored in a column. In oracle I would use pl/sql, does Access have a similar capability?
Also I want to be able to add and subtract date types, for example, to get entries from the last month. Oracle date type can do this, does the Access date/time datatype do this?
I have a search box running the following code on After Update. I would like the search box to use a contains functionality instead of its exact nature currently.
Ex. "Address Number" could be found by typing "Num". Currently I have to type "Address Number" in full exactly as it appears in my table.
Code: Private Sub txtSearch_AfterUpdate() With Me.RecordsetClone .FindFirst "[QstnText]=""" & Me.txtSearch & """" If .NoMatch Then Beep Else Me.Bookmark = .Bookmark End If End With End Sub
I have a form that imports an excel spreadsheet and manipulates the data into a database friendly format. My issue is that I have hard coded the test file name in the DoCmd.TransferSpreadsheet command.
What I would like to do is to allow the end user to go and click on the file and then have access pick up the file name and run the process. Is there some Active X control that allows the user to go search for the file they want to import? If so, is there any functionality to such a tool whereas I can have the user click on the file and instead of opening it, I can simply capture the file name to use in my module?
OR… does anyone have a better idea of how I might go about what I am trying to accomplish? I hope I explained my situation clearly enough…
Our application can be broken into several modules, and we want to be able to shut off all modules, but then activate them by entering an Activation/Authorization code for each module.
The issue is that I'm fairly new to Access, and have never done this type of functionality. Is there anyone out there that has done this and can give me some guidance? I would greatly appreciate it.
Need to know if I can open a MS Access 2000 (large) mdb-file in MS Access 2003 Professional without loosing any functionality? Is there a working way around this behaviour of MS Access 2003? It seems now, when comparing from MS 2000 openings some functionality got loose when I open the same 2000 file in Access 2003. Working environment is MS XP professional and all security patches for Office 2003 Pro and XP are applied.
This being my first post, id like to thank everyone who contributes here.. ive been watching this site for a while, and its been a simply amazing source of knowledge.
Now that the sucking up is over, HELP! 8)
Im developing a database that is going to take over tracking point to point connections between servers and switches in our data center. The system that the users currently use now is a simple flat excel spreadsheet.
Im wondering if there is a way to allow users to enter data in a format that they are familiar with... Tables 'look' the same but unfortunately for the people that I work with they dont (seem to) have the mass editing capabilities that they current work with.
Im using access 2002 currently at work, shortly I will be on 2003. Ive tried to play with the excel add ins that are included with my version, but I havent seen any way to directly link the excel add in to a table in my database, and definately havent found a way to pick and choose information to be manipulated in the cells (via code) in the excel interface.
Id really prefer not to have to have users use excel outside of the database in any form. I am aware that I could probably achieve what I want via importing excel files in the background and what not, but this doesnt achieve the goal that i am after, which is migrating the users out of excel and into access.
I hope I have explained myself thoroughly enough. If anyone has any input on a direction that I should look it would be appreciated. Im not the best with access, however I would consider myself intermediate to expert with coding and whatnot.
Let's say I have a Table with many Product IDs records.. Product ID (Number) Hyperlink Field (with a Hyperlink to an external Excel file)
What I would like to do is to create a Hyperlink that not only will it open the Excel file but it will also search and select the Product ID (in Excel) of the record on which the Hyperlink was clicked in Access.
I have a number of combo boxes linked to respective individual tables, for example tool combo look up the tool table which is composed of ToolID and Tool Type.
I want to be able to add additional tools directly into the combo box on the form when I come across a tool type that isn't in there already. However, my current combo tells me that I can't as I am trying to enter an item that isn't in the list.
So, if I then change the option on the combo on 'Limit to List' to No from Yes, it then gives me an error about column widths that need changing.
I don't want to do that but I do want to enter directly - can somebody point me in the right direction please.
I've developing a little Project and have some issues after splitting a db.
I have some forms in wich I want to see some tables with the "+" sign on the rows so I can go to their linked tables. The problem that I have is that everything works perfect until I split the access file.
A client I am working for wants a calendar to interact with their database forms, I am thinking outlook would be the best bet, as a table and form to make my own in access would be overly complicated. Is there any way to embed a calendar from outlook within an access form?
I am trying to prevent any foolish behavior from taking place upon a form. I have textboxes and comboboxes that users need to input data into or make selections within.
I came up with a method to prevent Paste as follows:
Code: Private Sub ComboBox_KeyDown(KeyCode As Integer, Shift As Integer) Call PurgeClipBoard() End Sub
[Code].....
However if I remove the MsgBox logic then the Cut is not prevented.
Note you need to include the Declares for those api functions if you use them.
I'm using Allen Browne's search form in an application for demographic purposes.
The form is working fine, but the user is asking for a new functionality. He wants at lease 3 state combo boxes so he can filter that [State] field for at lease three choices and the way it is build now he can only have one. I tried the following code (with the corresponding text boxes in the form), but it didn't, the result was no search at all.
Code:
If Not IsNull(Me.txtState01) Then strWhere = strWhere & "([State] Like ""*" & Me.txtState01 & "*"") AND " End If If Not IsNull(Me.txtState02) Then strWhere = strWhere & "([State] Like ""*" & Me.txtState02 & "*"") AND " End If If Not IsNull(Me.txtState03) Then strWhere = strWhere & "([State] Like ""*" & Me.txtState03 & "*"") AND " End If
In the Allen Browne's documentation he explains about using the AND and OR's and I tried a few combinations, but the result this time was no record found at all.
I've build an Excel workbook that contains extensive use of VBA code for UserForms, Control Buttons, etc. and also contains several sheets that are formatted as Tables and function as databases. We've outgrown Excel's capabilities and need to move over to Access.
I have a couple of questions which are sort of related. They both revolve around Parameters with a Query/Report.
Here is a bit of background. The source Table is formatted in a way similar to this:
Code--Account#--Expense Description--Jan--Feb...
When running the Query, and associated Report, the user is prompted to input an Account# via a Parameter that I set up. The dialog box pops up with the word "Account#" and a box for the user to enter by what account that they want to restrict the Report. [Question 1] - Is there a way to make this dialog box contain a drop-down box with a list of predetermined accounts instead of the aforementioned entering of an account number? If not via this dialog box, is there another way?
Also, multiple accounts roll up into a single P&L line item. For example, let's say that accounts 1234 and 5678 both make up "Equipment". [Question 2] - Is there a way to run the Report in such a way to return all accounts which roll into a line item? I want to have the ability to run by either an individual account or the P&L line in total.
how to create file explorer like functionality in ms access.
1 -I need to be able to browse files within specified directory and only. I can't alow users to browse any other directories. 2- I also need to be able upload (copy/paste) folders and files in that directory
I looked at different solutions and found a solution which might work on this foum link below. ---access-programmers.co.uk/forums/showthread.php?t=102667----
The treeview working for browsing specific directory, but i need to enhance it to allow to copy files and folders in that directory.I use MS ACCESS 2010 and not very proficient in programming.
About a year ago I created a search form based on Allen Brownes Search model. Working fine, but the user wanted added functionality, see here, after a few tries the users didn't wanted the option anymore because they were in a hurry to deploy. But now their management is asking again for a wider scope in that state search.
I made an example model. It works fine, but only if I always have some value in the [State C] option, if left blank it won't work, a Run-time error 3075, will pop up.
I have tried many combinations of parenthesis, but, haven't got any luck.
I have added functionality that creates a report, saves it as a PDF, and then sends it to a customer via email as an attachment. The PDF file is saved to a folder and is named to include the Customer's unique customer number and the date and time the PDF was created.
For example, if the customer number is 09 and the date was 10th October 2013 and the time 09.00am, the file name is 0009101020130900.pdf.
What I want to be able to do from within the database is to have a button, that when clicked, will display all of the Pdf's for only customer number 09. The customer number will be based upon a field in the customer record.
I am a pretty novice user currently playing around with Access 2013 using Office 365.
I used to love the old style Memo field where people cut put in carriage returns to split up data. I am wondering if this function has been removed with this LONG TEXT FIELD or is there a way around it.
I like it because I tend to use it as a tracking field and like the newest "comments" at the top separated by a Carriage Return...
