Good day, In ms access, I created a form with a combo box that list all products, a subform(datasheet) that list all companies that sell that product.(the data) I want the company names(data) to become (in datasheet-subform) the actual field names, in the datasheet, so i can have other details for that company in that column. Like How ...
I am creating a Crosstab query at runtime with the option of using a summary type of "SUM" or "COUNT". If I set Sum, then I want an output format of "$#,##0.00", and if it is Count, then I want an output format of "#,##0". There are lots of discussion questions setting a tableDef Field property to format output, but there is nothing th...
Hi, Im a little stuck and I dont know what im doing wrong. I want to insert the current date into a MS Access database in VB. The part of the code im having trouble with is: SQLString = "INSERT INTO Sales(DateSold) VALUES (" SQLString += Date.Today & ")" The type in the database is date and is dd/mm/year. Thanks in advance for the...
I created a form, displaying company. created combo-box in the form to list all products of that company with a check-box next to each item*(IN THE COMBO BOX). how do I create a report on only the items that were checked, OR soloution2, I tried showing all products of that company on that form in sub-data-sheet, with a checked box field...
Background: I have one Access database (.mdb) file, with half a dozen tables in it. This file is ~300MB large, so not huge, but big enough that I want to be efficient. In it, there is one major table, a client table. The other tables store data like consultations made, a few extra many-to-one to one fields, that sort of thing. Task: I...
Very simple problem: I have a Public Sub (in a module) that I want to call from a button on a form. The name of the function I want to call from the module is GenerateKML. I've read this post: http://stackoverflow.com/questions/1072075/ms-access-03-how-do-i-call-a-vb-function-into-a-sub-procedure/1072200#1072200 And tried all of the s...
I just got a lovely access database, so the first thing I want to do is to move it over to a normal database management system (sqlexpress), but the only solutions I've found sounds like craziness. Isn't there a "export database to .sql" button somewhere? I have around 50 tables and this export might run more than once so it would be g...
Is there any way populate an Access Form's text feild's value using SQL? I have read that it is not possible to simply enter SQL as the Control Source. Is this true? thanks for any halp :) --edit-- I need to perform this query; SELECT tblCaseIssues.IssueDesc FROM tblCaseIssues INNER JOIN tblCaseNewHS_Issues ON tblCaseIssues.ID = tbl...
Hey guys, I am converting an Access Jet-SQL query into T-SQL and I came upon the Int() function. Now, I would like to convert it into T-SQL, and this is what I have so far: --Works for Positive Select CONVERT(INT, 1.2) --Answer = 1 --Not the same as Access SELECT CONVERT(INT, -1.2) --Answer = -1 Now, according to this, I need it to...
Hello: I developed an ASP.NET web application that reads an MS Access database with ADO.NET. This application will have to be run on Linux with Mono. Unfortunately, I am having problems getting Mono to work with the ADO.NET database connection. With the connection string enabled on an onLoad event, the web app will not render; howe...
Currently I am trying to execute a macro in Microsoft Access through Perl OLE I am wondering how to properly make the call to run a macro. I have tried 1) $oDatabase -> DoCmd.RunMacro("Macro1"); 2) $oDatabase -> DoCmd -> RunMacro("Macro1"); But they throw me "Can't call method "DoCmd" on an undefined value" or "useless use of concaten...
Good day Created Tables = Suppliers, Products I created a form.I created a combo-box that displays all products of a particular company. I need that combo-box that displays all products to have a check-box or any other control next to each product SO that I will be able to select more than one product. Then how do i create a report of...
I have two databases on the same server with the same name and different port number. The tnxnames.ora entry looks like (actually one database is a clone of the other one.) AAAA.FSA.GOV.UK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = SERVERNAME)(Port = 1530))) (CONNECT_DATA = (SID = AAAA))) AAAA.FSA.GOV.UK = (DE...
During my work on this database application, I've apparently managed to corrupt a form in the application - attempting to save any edit to any field on the form will cause Access to crash, and for the database file to report corrupted when Access attempts to re-open it. I've tried exporting the entire form + controls as text, then re-im...
Good Day tables: authors, books, chapters; I have created a form(form_A), with a combo-box listing all authors. Created a sub-form that is binded to the combo-box, it list all books by that author, and within that, I created another sub-form displaying all chapters within that book. The info is from 3 different tables. when I manuall...
Good Day newbie to reports in ms-access 2007. created form and a combo-box listing names. a sub-data-sheet with minor details to the item selected in combo-box. just needed to know, How to create a report based on this from... When I create a report all information is displayed, I only need selected info from that form Thanks A mil. ...
My client has an old Access application written in Access 2003. It's fairly large and complex, but well established and works well functionally, so redeveloping is not an option. We'd like to give this a visual makeover to make it look more 'modern'. No changes in functionality here, simply eye candy. Can anyone recommend an efficien...
I have to refresh link tables in a MDB file. However MS Access in not installed in the server where the MDB file resides. I have copied the same MDB file into the local machine and try to refresh the link tables. Now it is asking for DSN name. Now I created a new DSN, in the same name what is there in the link table descriptions. But...
is there a way to tell ms access (2003) to not put joins into parentheses. or at least to understand them without (every other database does) i want something like: SELECT * FROM a INNER JOIN b ON a.a = b.a INNER JOIN c ON b.c = c.c but access tells me that the query is wrong. IT’S NOT, and it’s driving me c...
I want to develop a customized sales order and inventory soft for a 5 user environment. I know VB but I am more comfortable with MS-Access. But user login, policy based restriction, good looking UI is a bit difficult with Access (imo, I might be wrong... maybe). Can anyone suggest good rad tools that can help me in building software v...