Advertisement

635 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

 
TechSoEasy

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Top Access Coding/Macros Solutions: 576 - 596 of 596
 
small help on duplicates check
Hi, Please find the attached access.In which our code follows.It just do correctly but innsert all the records to the table student.But i want to remove the duplicates w.r.t. student id.Als...
My Access app's spell checker works under XP but not Vista
As the title says. I built in the MS spell-checker into my Access app to check large text fields. This appears to work OK when the app runs under XP but not Vista. Any glimmers of understan...
(How) Can I pass a complex query constraint as a parameter?
I have a report that was set up to run off a query that was simply constrainted based on inputs on a form:   HAVING [Facility Product].[Issue_Work_Center]=[Forms]![Parameters for Rep3 - Rolli...
Update based on old value from updated field
I have considered a couple of different methods to accomplish this task. Hopefully, someone can come up with a better method than I. The database is an inventory db. Items in the inventory c...
Send Keys in MS Access
I am having mixed results with using SendKeys in MS Access.  I am trying to use it to change databases whereby from a command button on a form in a given database my code is: SendKeys "%fo"...
How do you  get a date field in a Oracle table into a SQL table
I am running a SQL Stored Procedure  that has a link to a Oracle server. I am try to create a table in SQL from 3 fields from the Oracle table but keep getting error when trying  to insert th...
Using Application.FileSearch and Application.FollowHyperlink... how can it open two or more files in same folder with same keyword in filename
Hi Experts, Using the following code to link from a MS Access form to the related file in a network folder and open it.  The code works great for it successfully opens the correct folder base...
On a continuous form, how can I prevent data entry, but only into the fields of records with bound CheckBox controls equal to 'TRUE'
My continuous form displays rows of fields of the table to which it's bound, in a one-row-per-record layout. Each row displays a CheckBox control bound to a Binary type field in the underlyin...
Access changes connect string on new Tabledefs
I have a little routine that creates a DSN less Tabledef in my Access 2000 database. My problem is that Access immediately changes the .Connect property. Here is the Connect String that I supp...
select query in access
I have created a query as follows. SELECT * FROM (Department INNER JOIN Employee ON Department.DepartmentID=Employee.DepartmentID) INNER JOIN Elmo ON Employee.EmployeeID=Elmo.EmployeeID ...
I have a data in Access, each record has a url field, when I select the record, I want to display the web page
I have a data in Access, each record has a url field. When I select the record, I want to display the web page for that record.  I have put a web bowser control on my form, but I can not figur...
Macro to add new record when user selects "<All>" from combo box
This is a follow-up question to a previously answered question:  http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23851911.html#a22816104 I have added "All" as a selected o...
How do you add an N/A to a combobox if the results come from a VBA rowsource?
I have a code that if there is a work order, then produce a picklist of POs pertaining to that wo.  If there is no wo, produce a list of all POs.  I need to add that if there is a WO, but ther...
Calling a function/sub from the name in a database
I want to be able to store in a table a function name, then be able to call that function. I have been looking around but cannot see how to do that, even if it is possible. Was also havi...
How to link telephone systems to MS Access and use VBA to manipulate incoming and outgoing calls
I have a client who wants to use MS Access to show up details of a customer on the monitor/screen when the customer calls. Possibly also to make a call just by clikcing on the number. Can s...
Searching ACROSS a recordset in access 2007
Hi All, I have the following tabke in Access to act as a traveltime matrix for an appt database...                         Bangor              Antrim           Carrowdore Bangor          ...
Find the date of this week's Sunday
I am trying to find the date of this week's Sunday.  I know this is the first day of the week but i dont know how to find that date programmitcally.   So for instance.. today is thursday 9/16/...
Shredding files from Access VBA
Is there a facility in Access (or available from Access VBA) for shredding/erasing/obliterating/annihilating a file? I have to do this because my app works on highly sensitive data and delet...
500 POINTS! How to do a fuzzy search on a table using a form to enter search string & bring up a TABLE & allow user to select one of the results
Hello: I am slowly building this microsoft access database with 3 tables. I am new to forms but I already got it working where I can search for a record in the table and bring it up using a fo...
Manipulating the registry from VBA in Acces
Is this possible? If so where do I find the functions to do it? The reason is that I want to uninstall my packaged Access app myself and there are a few registry entries to wipe to make the u...
Validation Rule for table field
I have created an Access table for contracts that has two fields identifying the (contract) start date and the (contract) end date.  I thought I could have a validation in the table design for...