I am working with data imported from several spreadsheets, I ahve several columns which have manufacturer names etc, I want to convert all this data to all uppercase. Is there a simple way to...
Hi Experts,
I am having a problem with a loop statement that helps me build a table that shows the daily currency rates for currencies from the last day it was run. The problem I am having ...
Hi. I am trying to write an access report based on a query that will prompt the user for select criteria - area, and "priority >" a number they enter. My question is how do I set this up to al...
I am in Microsoft Access 2003 and am trying to make it so that everytime a user prints a query it will print in landscape view. I have tried creating a module and putting a command like this ...
I have a simple parent child table as follows:
Parent Child
Bob Bill
Bill Mark
Mark Jane
Bill Tim
Tim Joe
I am looking at how to populate the treeview co...
I have a series of combo boxes that are used to filter information in a subform. At this time I have a command button on the form to remove all filters, but I would also like to have a way of...
I'm distributing an Access application created the Access Developer Tools Package Wizard. I need to somehow create ODBC DSNs. What is the easiest way to accomplish this? I have created a .R...
tblCApos contains unique records (Cusip) with one financial model's opinion of YTM, Duration & Curr OAS...tblCAaudit contains multiple instances of CUSIP for each PORT (portfolio) it exists wi...
The question has two parts
1) Corrections for an update query
2) Advice on a delete query - Is it possible to delete records no longer relevant in the Files tbl
1)
I have two tables Fi...
hi
i have the follwoing sql in a query
SELECT CountryID, StateID, KindID
, NZ(Round(STR([M2S]),0),"No data") AS [M2 Start]
, NZ(Round(STR([M2E]),0),"No data") AS [M2 End]
, NZ(Round(STR(...
I wrote a select query in Access in the SQL viewer mode. My query contains the where clause:
WHERE ([Cases].[CloseCode]=[Forms]![devParam]![RsnCodes]);
*Note: I've also tried IN rather tha...
I have an access database that imports an excel spread sheet. I need to do the same thing for another appication but this time there are multiple worksheets in the spreadsheet. I need to kno...
When running queries that have inner joins I get the following error:
ODBC - call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'MS2' does no match with a table na...
This is a follow up question to a solution that was provided to me from Harfang (copied below for reference).
I have two field listed on the main form F0. These field names are Cust and Cu...
I have this code below that I'm trying to use to build a conditional/dymanic query of a table. It works great until I input a number to search by. Then I get "3464 Data type mismatch in criter...
OK. I know nothing about Access database, replication. But my searching today makes it look like it was an Access 97 thing that is now extinct?
I found a wizard tool on Microsoft's websit...
Does anyone have or know where to get example code specifically for Access 2000 on using distiller. Any good web tutorials or references. I was able to find an API reference for it and some ...
I put the routine that I have a question about in the code snippet window. I want to update two fields base donthe paramters passed to this routine. The first is 'StatusID' (Long) which is r...
We have a table which includes a field set to be a Multiselect dropdown box.
Problem is, when a form is created, it is possible to filter on all of the fields except for the multiselect f...
I'm writing an application in Access 2003 that prints customer-specific pricelists. I have a simple form that asks the user to enter the customer ID and select the product category or categor...
this code doesn't work
i'm guessing my if statement is missing some syntax
Public Function WhatCatComIsIt(ByVal comboCommodity As String, ByVal comboCategory As String) As String
If ...
Using Access, I want to append a new record to tblOrders. Here is the code
mySQL = "INSERT INTO tblOrders ( OrderID, CustomerID, ShipCity, OrderDate, ShipDate )" & _
"VALUES('NewOrderNumbe...
Hi,
How can I multiple select items in a ListBox without knowing the Index?
Any workaround?
I'm using MS Access 2002.
I have a form that I haven't been working on that I now have found out it is "unbound"& is there an easy way to make it "bound" or do I need to start all over? I have a number of subforms on i...
I've searched through all of the solutions so far and haven't found one for my particular situation.
I have a database that I'm using to scrape invoice information from a mainframe screen a...
