Microsoft Access / VBA Forum

I googled the Oracle groups on this and didn't find much. Anyone here know of any approximations to Jet Crosstab queries? I'm converting a Jet reporting application with loads of graphs using crosstab queries as sources. If worst comes to worst, I'll just use Oracle SQL to produce the records and perform Jet Transform SQL on the results...

Hi, I have a form that there is a combo box and an edit box. I have a table with Customer ID, Company Name and Country. I want to do that when my combo box chooses an item(eg McDonald in Company Name) in the form, the edit box can show another item (eg USA in Country) after the trigger. How can I do that? I've tried to do so, but the edit...

I'm a relative newbie to VBA and I am STUMPED. I'm trying to use vba in MS Access to compare two fields to see if the second string can be found somewhere in the first. For example, I would like the statement to return true if: StrOne = 00035A,00035B,2000,00103A StrTwo = 00035B

Hi I use the following to open a jpeg file Application.FollowHyperlink myURL, , True My problem is that it opens the picture and then it opens explorer over the picture. Is there another command that will only open the picture Thanks Alfred

I want to build a function having the name of the list box in brackets like Check(ListBoxInvoices).May i have some help as to how to do it ? In my form i have several list boxes.I have command buttons where the following code is written: If IsNull(Me!) Then DoCmd.Beep MsgBox " Please select Invoice first ! " Exit Sub

I have a table TBL_NAMES : IDNAME , Name_person , ETC..... (15 different labels) I have a second table TBL_POINTS : IDPOINTS , LINKNAME_PERSON , POINTS_ALGEBRA , POINTS_GYM , etc.... (25 courses) I have made a form where all the names are listed and when i click on a name another form is opened with that persons name on top and a number...

Help please I'm sure this simple but I'm new to Access. I have a table that needs a field updating from a calculated text box on an import form. How do get the record in the table to contain the same calculated data? Do I have to use an update query ? If so how? Thanks Geoff

I have a table Create Table Payments { paymentid int, customerid int, amount int, date datetime } What I want is the sum of the amounts of the last payments of all customers.

I have two tables one lists the names of committees and the other is a list of documents they generate. I have a form based on the documents table which gives details of the document including which committee generated it. On the form I also want to indicate which other committees are interested in that document, there could be 1 or say 8, it...

I have an app which sends emails by way of Outlook, which works fine but relies on Outlook being on the `puter. Is there a way to have the emailing bits all within Access ? (using A97) TIA David B Hexham UK

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

I'm using Stephen Lebans' RTF2 control in a report, and have discovered what may be a slight bug in it. I have a lot of non-Western language (Chinese) text in my RTF field, and such records get sized strangely using the .RTFHeight property of the control. Specifically, lines of text get cut off the bottom of the control when I use the code...

If I bring up a query, how can I refresh it? It seems if I update the data, I have to close and reopen the query before it will show the new data. Darcy

I am building a small database for our sales reps and each record has a repcode field (int) I would like to only allow a rep to see their own records and not those rows with other repcodes Any sugestions as to the best way to achieve this? Simon TIA

Greetings: I need to migrate data from one table into three new tables. In one of the new tables I need to combine two fields from the old table into one field. + ----> I have not so far been able to figure how to do this. Any suggestions/ideas would be gratefully appreciated!

My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary Access-tables. I have tried this: conn.Provider = "Microsoft.Jet.OLEDB.4.0" conn.ConnectionString = "data source=" & datafil & ";Jet OLEDB:Database...

1) Is there a way to copy the data file only from a database to a backup area without copying the entire db structure? Is there a file suffix I need to do this 2) I've copied a database to another machine and have problems running it there. Why does happen? What can I do to setup the structure on the second machine to execute. thanx ...

Hi, I have a fully functional MS-Access database. May I build such an "exe" file from a MS-Access "mdb" file which one who has not MS-Access installed on his/her system can take advantage of the database? is it possible to have an standalone MS-Access application with no need to use the MS-Access environment itself ? regds, a. nasseh

I am creating an Access database to monitor monthly performance figures for approximately 100 call center agents. Every month, each agent will have a total of about 15 different measurements (things like # of calls taken, % of quality of service, # of sick days, etc.) Based on those raw scores, a points system will assign a certain number of...

I'm a newbie and got this far by reading the posts here. I did a lot of searching but am stumped now and need 1 line of code. I have a tab control on a main form. ( 'Main', 'TabCtl71' ) There are 4 pages on the tab conrol. ( 'Page11', 'Page12', 'Page13', 'Page14' ) The form name on 'Page12' is called 'Siding'.

Hi My users are going to toggle back and forth between DataSheet and Form view. This eliminates the need for a pile of queries <g> Anyway, I would like my form to be viewed at the current size (I had removed the min max buttons). But when in Datasheet view I would like it to maximize. If I maximize the view while in DataSheet then when the...

I have been given an older database and asked to make upgrades and what not. One interesting thing I have come across with the database is that it was at one time set up so one of the tables would hold values that were calcuated using a form. I have looked at the code for all the text boxes on the assocatied forms and have yet to figure out...

I discovered a weird behaviour regarding a query and a combobox based on that query. 3 tables: Food: Food_ID number (autonumber - primary key) Number number Fruit_ID combobox

I have seen the following problem mentioned here before but have not as yet seen a fix that works. When a chart is opened in form view everything is OK. When a chart based on the same query is opened in a report, sometimes the chart shows the design view data and not the data from the query. If the report is closed then reopened, more often...

In forms it is possible to use different SQL strings as recordsource. In report this is not possible to do the same way. What I want to do is open a report from a button, and be able to give different sorting and where clausules in the record source SQL string.Could this be achieved with the "Open args" argument from the form or is there...