Why is there a "Conversion Errors" tables in an MDB?
Why would there be a "Conversion Errors" table in an MDB? Does this mean there was an attempt to convert the MDB to a different (newer) version of Access? ...
ms-access
Weird Excel Formatting
Recently a new co-op was hired at our company and has been tasked to run a report. The report queries the database and returns a resultset and from there procedes to create the spreadsheets. Depending on the number of days selected a different number of reports are generated but I do not believe that is relavent to the question. Basicall...
How to compare 2 similar strings letter by letter and highlight the differences?
We have 2 databases that should have matching tables. I have an (In-Production) report that compares these fields and displays them to the user in an MS-Access form (continuous form style) for correction. This is all well and good except it can be difficult to find the differences. How can I format these fields to bold/italicize/colo...
Will existing DAO code work against a SQL Server?
If I transfer data from a Access MDB into a SQL Server, will DAO code in a VB app work against the SQL Server. I realise there will need to be changes to the initial connection calls but will anything else need to change? ...
Find and replace table/field names in Access?
I've been handed a rather large, old, and crusty Access 2000/2003 database to clean up. I'll need to rename a number of tables and fields, but need to do so in a way that doesn't break existing queries. (Fortunately, there are no macros, forms, or reports to worry about.) I've heard there are some commercial tools to make this job easie...
Delphi & Access
How can I use MS Access as a back-end database for a Delphi program? ...
WPF application with MS Access database as a data source
I have a Microsoft Access 2010 database(*). Now, using Visual Studio 2010, I want to create a WPF application and add the database as a data source. The app will have a window with a frame that provides navigation through pages. No problem so far. But: -What is the right way to set up the database in this scenario? Tables only? Or must ...
Date Picker Control Not Displaying Proper Date (Access 2003)
Hi everyone, I just have a quick question. I am maintaining an app for my summer co-op position, and a new requirement came down today where the user requested to have a date control added to a form to mark the date of when an employee is "laid off". This control is enabled/disabled by a toggle button, and has its control source bound t...
Updating access 2000 database through code in VB6
I have an application that uses an access 2000 database currently in distribution. I need to update one of the recordsets with additional fields on my customer's computers. My data controls work fine as I have them set to connect in access 2000 format but when I try to open the database in code, I get an unrecognized data format error. W...
SQL Query syntax, I want to use INNER JOIN
Hi . I'm working on a windows application project using front end "vb.net" & back end "Ms Access" I have problem in wrinting sql query Actually there are 5 tables Transaction,items,itemtitle,itemtype & userinfo. check the following query & with this referance if u get idea then plz change in correct query Thanking You SELECT TRANSACTI...
Dropdown in Access 2007 parameter query
Hello, I want a Access parameter query to ask an user for a value (a location in this case). When I type [Enter location] in the Criteria field it works fine: I get a dialog box (Enter Parameter Value) with a textbox and my text (Enter Location). So far, so good. This works (the result also). But now I want a dropdown/combobox (instead ...
Update query (access & vb.net)
Hi: QUESTION 1 I have to update some fields of a table of access according to the value of parameter. If this paramter is "true" I need to update. Table idInvoice price percentageTax1 tax1 percentageTax2 tax2 total Example values: idinvoice: 12300 price: 100 € percentageTax1: ...
MS access refusing to combine two tables?
I have an Access 2007 database where I have two tables, exp_cash and exp_cheque. Both are linked to exp_cat, where exp_cat contains categories list, and exp_cash and exp_cheque contain id, cat_id, exp_date, exp_amount, and exp_note. When I tried to combine them nothing appears in the result unless I remove the cat_name from my query. I...
multiple currency formats in one column - Access 2007
Hi there, Is it possible to have multiple currency denominations in a field? I have a field that will have a currency value that will be either euro's or sterling dependent on whether or not the applicable record is in the currency zone. Is this possible in Access or will i need to have seperate fields for euro/sterling? Thanks in ad...
Filtering a Listbox based on Combobox selection
I have two tables: Person and Shift Person has as lookup field which is a one to many relationship with Shift. I would like to create a form in which a listbox displaying records from Person is filtered based on the selection of a combobox containing the records from Shift. in other words, i want to select "days" (value 1) in the comb...
Compare date from database using parameters
string queryString = "SELECT SUM(skupaj_kalorij)as Skupaj_Kalorij " + "FROM (obroki_save LEFT JOIN users ON obroki_save.ID_uporabnika=users.ID)" + "WHERE (users.ID= " + a.ToString() + ") AND (obroki_save.datum= @datum)"; using (OleDbCommand cmd = new OleDbCommand(queryString,database)) ...
Strip OLE header information (MS Access / SQL Server)
I have a C++ application that needs to support binary database content (images, etc). When using MS Access or MS SQL Server this data is wrapped inside an OLE object. How do I strip this OLE header information? Note that I can't just look for the beginning of a specific tag as the content can be png, jpg and a whole heap of other formats...
"Special" characters in ms access regarding search
Does the . (period) have any special meaning in ms access when search? For example, I have a table with 2 columns. (FETT Elements and FETT search) One of the FETT elements is called "Essa T4" and FETT search is "Essa*HT4", I would like to make the "Essa*HT4" as "Essa*.HT4" however my searching doesn't come up as expected. Does the dot...
Hosting an Access DB
Hey, So I'm inexperienced in hosting DB's and I've always had the luxury of someone else getting the db setup. I was going to help a friend out with getting a webpage setup, I've got experience in Asp.Net MVC so I'm going with that. They want to setup a search page to query a db and display the results. My question I have is in gettin...
ADO Access Tab button
Hello I moved my access apllication from DAO into ADO connection. It works better but I am encountering a problem when I enter a value in a form's field then I push the tab button the screen takes me to the first fields of the form and I lose my activecontrol which is the control of the field in which i enter the value. N.B.: If I clic...