Search results

I can do this in like 5 seconds in SQL Server but I can't get the query to even ALLOW me to update records. Table1 - Columns Query1 - ColumnDesc SELECT DISTINCT C.Column FROM Columns C INNER JOIN ( SELECT Cols.Column, Count(Cols.DataType) FROM (SELECT DISTINCT Columns.Column...

Okay, Not to be picky or critical of Access (well maybe a little) but I am having a problem in meeting the customer's desires within the design of my applicaiton. I have several forms which have command buttons that spawn reports in a "Preview" window. Initially I had these reports show as...

So, There are listboxes, and buttons, and all sorts of controls. No imagine a method: DoSomething(byval lb as ListBox) in this method we do some affects, add some values to the underlying datasource, and execute a lb.Requery. that part works fine, however, some of these listboxes have their...

Okay, So my system is one that has a MDB database file that is linked into the MDE application at run time. part of the system is to allow me to update the "app" side of things while leaving the data separated. However, at boot up I want to verify that all of the table links are refreshed and...

Ahh, Well I do thank you all for the help you've given me on this project, because I was definitely a little behind on my Access skills. I've come across a minor glitch that appears to be hindering the overall project at its completion. I am developing in and using Access 2003. I've compiled...

Okay, I sort of need this very quick here, i'm on a deadline, and when there was data in the tables, it all worked fine. However, that data was 'fictional' for the purposes of testing. The client will be entering the real data once the product is delivered. So i have a report that is based...

Okay, So, I tried listening to the advice about using DAO as opposed to sql and it just doesn't work. I simply need to execute an UPDATE query statement on a table in my database. So, I Open the database into a Database object. I then format my SQL into a string, and then Create a QueryDef...

I really need to know quick, if I assign the reference Microsoft Excel 11.0 Object Library to the vb side of the access application, what will happen if the access database is opened on a system that only has Office 2007 installed? See I know that version 11.0 is office 2003, so Excel 11.0 is...

I was wondering if there is a way to do a section (like detail) that prints multiple sections left to right instead of top to bottom. more like grid format. I've got some contact information, and I like formatting in a: Name Phone Email set up, each on their own line, but i can fit 3...

Okay, There is the "Keep Together" flag which works on a specific group, basically making sure all of a singular group stays on a page, like, the Detail section may be 2 or 3 lines long, and if only one or two lines can be printed on a page, it moves the whole section to the next page. I want...

Alright, this just doesn't make any sense. I have two MDBs, one is the front end application, the other is the actual table database. Some modifications have arisen that basically require me to add a few things to the "table" database, so the MDE application will perform according to client...

I'm running a simple update to my application, where on boot it tests to see if the back end database is up to date. if it isn't, i add a new table and a few columns to other tables so it is the most recent version of the database. I am simply performing an "OpenDatabase" on the file, and...

Well, I've never before desired the option to compile to an MDE since previously I'd never done a professional level Access Application. Usually just little ditties for myself that are quick and simple. Now I've rather gone all out, designing a corporate database for a small business in...

is there any even for the ListBox/ComboBox that will ALWAYS trigger when the value changes. whether that change is programmatic or user. basically, If I click on an entry i know the onclick() event triggers and the After_Update event triggers. but if in my code i do a search for a value in...

I'm trying to do a computed column that bases its value off of a current value and subtracting a previous value. I can be assured there is only 1 entry per Item/Person/month. so basically if i'm looking at 1/feb/2010 wanted to subtract Amount column from the 1/jan/2010 record for the same...

Okay, There are things that are true about programming, one primary facet is Minimalistic Code. Basic concept: never write the same thing twice. Now, I have several list boxes on different forms, and I want to provide a command bar (pop up menu, or context menu as it is called in other...

Okay, Far be it for me to comment on the "intelligence" of this in Access, but if you create a form that references a table, it loads that current record. You then are allowed to modify that record through the form and proceed as normal. Access, when you drop a command button onto that form...

Alright, Now, I have Office 2003 pro, with Access, with which I am developing a project. Now, I have had much experience with databases, and have created many other Access mdb files as well. mostly for something simple, like creating a database of all my movies, or books, or something silly...

Yes, This is probably not the kind of question most would expect, but recently I have come back to need Access for a contract, (been doing most of my db work as of late in SQL Server). So, I have not used access since it was installed on my machine, and upon opening up the Table Designer (to...

Two Formulas: First: Works Just Fine (and yes it uses some VB Macro Functions to Calculate) Balance($A88, CurBalance(VLOOKUP($B88, $B$19:$F$24, 4, TRUE),INDEX($B$25:$F$119,IF(ISNA(MATCH(INDEX($B$19:$B$24, MATCH($B88, $B$19:$B$24, 1), 1)-1,$B$25:$B$119,1)),1,MATCH(INDEX($B$19:$B$24, MATCH($B88...