ms-access: is it possible to change a combo box to text box using vba?
is it possible to change a combo box to text box using vba? ...
ms-access
MS Access 2003 - Automatically show last records in list box on a form rather than first
So I have a form that has a listbox that shows like a ledger. My question is how can I make it display the last records (or have the scroll bar default to the bottom instead of the top), instead of the first few as the default. Now I don't mean reversing the order from bottom to top instead of top to bottom (though that would be a cool ...
How do I store the results of my select statement in a variable?
My code so far is this. The last line gives me a compile error: "expected end of statement". Dim strSql As String Dim groupId As String strSql = "Select ID from RevenueGroup where description = '" & ListO.Value & "'" groupId = CurrentProject.Connection.Execute strSql ...
MS Access 2003 - Radio button : click one, unselects another
So what VBA can i use to make sure that is radYes is clicked, radNo is unselected? Just a measure to make sure that if one is clicked then other cannot be Thanks! ...
Is there a way to profile MS access database to find out what SQL run against it?
Is there a way to profile MS access database to find out what SQL run against it? ...
MS Access 2003 - Combine last record of multiple tables into one query or table??
I have a couple of tables that are transaction tables, and I would like to make a simple pivot chart for comparative balances....which happen to be the last record of each of these tables in a field called "balance". so i know how to populate this on a form using a SQL statement, rs.movelast, but i do not know how to get to the pivot ch...
Generating Jpegs from MS Access data
I run a pub, and we create a graphic for each football game, music event or rugby match that we have on, and it's piped in to all of our screens to market the event. What I'm looking for is a way to automate this graphic creation within Access, so a Jpeg of a certain size is created and dumped in a folder, containing text that's been siz...
MS Access 2003 - Simple question about chart within a subform, not populating on a form unless clicked
SO I have a form that has a little subform window, the subform is just a chart on it. One question I have is why the chart will not show up in the subform window unless I click the sub form window area... something I did not do?? thanks ...
how do i combine and sum two results in sql ?
hello all, i have one table, let's call it 'TBL'. i have one column that have only 3 values available.(let's say 'AAA', 'BBB', 'CCC') the values can return multiple times. for example: TBL --- Column1 ------- AAA AAA BBB CCC BBB CCC BBB CCC AAA i want to create a table result that looks like this: TBL-RESULT ---------- AAA+BBB 60% C...
Migrate Access to ASP.NET
The current application is a kind of CRM application built upon MS Access. The application is for internal use. My job is to migrate it to ASP.NET web-based application. Now boss requires to keep Access as database and develop ASP.NET code against it. My question is, is there any disadvantages of using Access as database in ASP.NET appl...
How do I not commit a record on MS-Access?
I have a bound form in microsoft access that allows a user to add data to a table. I want to place a "cancel" button on the form, that if clicked, will stop the record commitment. What is the command I need to cancel the record commitment? ...
VFPODBC very slow
I'm using an MS Access 2003 front end to access the data on a network drive owned by a Visual Foxpro 9 application via odbc, and it seems to be unbelievably slow - there's about 1400 records in one particular table, and it takes a good minute to load up on the Access interface, although when using a basic DBF viewer, or the application t...
Looking for a SQL-based RDBMS with a Windows GUI
I have an application I developed 20 years ago with INFORMIX-SQL version 2.10 for MS-DOS 5.0. I have it working on MS-DOS 6.22, within Microsoft Virtual PC 2007, under Windows Vista, but I would like to re-write this application with a WINDOWS-based RDBMS. I'm looking for a product, similar in functionality to informix-sql, but for wind...
how to delete every alternate row in access table
i have a huge access table containing about 400000 rows . what sql query can i give to delete every alternate row in the table. ? I do have a column in the table which has values from 1 , 2, 3 ,4 .... about 400000 . ...
how to insert a collumn with value row number in an access table
i have a large access table . i need to have a column which will have value as row number how can i write an sql query fill an empty column inserted by me with row numbers ...
Error in sql query - Operation must use an updateable query
when i give this sql query in my msaccess database table called warehouse1 it gives this error "operation must use an updateable query?" UPDATE warehouse1 SET STD_MOU = "?" WHERE warehouse1.[STD_MOU]="null"; what could be the reason ? ...
MS Access - SQL exclude data query
Original question was unclear, so attempting to simplify and rephrase. In MS Access I have a Query that is supposed to find all records which: Have a PhaseID (entered by user) of X, for simplicity take 3. Only show the records where the priority field is set to greater or equal then 2. Below is the query shown that is currently in e...
MS-Access: Replace "bracket"
Hi, In one of the ms-access table I work with we have a text field with a set size. At the end of this field there is some extra code that varies depending on the situation. I'm looking for a way to remove one of these code but even when the last part is truncated by the field maximum size. Let's call the field "field" and the code I'm...
MS Access Import from Text File problems
I'm trying to import a text file into an access database. It's not one I've written myself but the spec for the delimited text file is set up properly and the file imports properly using the wizard. When I try to use the import functions of the app itself, the ImportError table tells "Field Truncation" for one of the fields. Any help wou...
MSAccess and ODBC. Filter dialog doesn't show
Hi All. I have problem with Microsoft Access Database connected via ODBC to Postgresql database. Filter dialog - for filtering data using multiple selectable checkboxes: doesnt work. EDIT: Doesn't work: I'mean there is no checkboxes to select. There is only options for sorting A-Z and Z-A. How to fix this? I can sort data, I can fi...