Search results

Hello, I have a form "article" with a button "place an order". Click on the button opens another form ("order") where I should fill the order for the current article. The problem : how can I tell to "order" form that I want to order the article I was on in my "article" form, and not another...

Hello, I'm working on VBA to fill a Word document with Access data. I need to kow the current character (cursor) position in my Word document to define a range (from the current position to current position + n characters) where I want to insert my data dynamically. Since Range parameters are...

Thank you to both of you.

Hello, I woul like to programatically (with VBA code) hide and unhide the database window. In Access 97, this can be done with Tools > Startup > Display database window box (check/uncheck). But I would like my program does that himself : when the user launches the application, the database...

Hello, I would like to get the current character (cursor) position in a Word document. Could you tell me which VBA code I could use to get it ? The current position should be an integer. I want to use it to define a range from the current position until (current position + x characters) Thanks

Hi, I would like to create an application with a left side tree menu. Each leaf of the tree should open a form or launch a procedure. The branches could expand or collapse. Nodes could have pics. There must be a couple of VAB examples. Would you recommend me some of the best ones ? Thanks

Hi, I want to fill a Word document with data comming from 2 Access tables. The context : There are two tables linked with ont-to-many relation : one table for the orders (master table) and one table for order lines (detail table). I have one Word document with tags (xxx...xxx) saved as...

Hello, I have a table on which i must work at row level, one by one. I put the table into a recordset and i scroll the table row by row from the top until the bottom. The work process - a test - is executed for each row and returns an integer. I would like to put the process into a function and...

Thank you. I tried to do it so but I have some difficulties because I have no experience in Excel programming. My exeprience is Access VBA. Could you recommend me some information source in relation with this thread ? Thanks again.

Hi I have a dropdown list in an Excel Worksheet and I would like to use it to select and retreive data comming directly from an Access table or query. I believe it is possible and I would spare a lot of time if someone could you put me directly on the best way to do it. Thanks.

Thank you Paul. Yes, in certain cases your ideas could definitely simplify the code. But I hoped I coul avoid to use a recordset in any case. Here is my code : Dim mydb As Database Dim mySQL As String Dim myQryTemp As QueryDef Dim myRecSet As Recordset Set mydb = CurrentDb() mySQL =...

Thanks Paul, it might help for simple sum queries. :) However I am looking for a generalized solution where sql queries are usualy more complex than my example and may return text values. :( Let's say the query returns only a single value. What's the simplest way to show it in a textbox ...

I have a SQL query in a string of a VBA procedure (e.g. MyQuery = "select sum(Amount) from Investment") and I want the result to be shown in a TextBox of my form Me. I know several ways to run the query and to send the result into the TextBox (e.g. with QueryDef and RecordSet). However I guess...

Many thanks. The code looks fine. However, when I have both linked tables and "normal" tables in my database, the code should try to link only the tables who are linked, not the other ones. Is there any mean to distinguish linked tables from "normal" tables ?

Yes, it's a good idea. But imagine you have a 50+ lines union query, it would be very useful to let comments in the middle of the SQL. I'm sure everybody agrees on that. But how to do it ? :confused:

Yes, it works with VBA code in a VB editor window. But it doesn't work with SQL code in a SQL view window ...

Lets say an employee form withs the name, the position, the birthdate, ... and a picture of the person. There are several ways to store pictures in a database, each having pros and cons. Experienced developpers in dealing with pictures would be kind to tell me the way they recommend to store...

I'm looking for a form to be filled by the user and then run a search in a table to find matching records. The idea is : the user fills what he can and the program searches all matching records. The form should contain several fields so the search would run on multiple criteria. Filled values...

I would like to insert comments into my sql code (select query > sql view window). I tried with usual sequences such as /* ... */ but it doesn't work. Does anyone knows the right sequence ? Thanks.

To update the links to tables (e.g. on a server), I use the linked table manager. I would like to update the links otherwise : with a procedure. So I could execute it when opening the main form of my client. Code gives as an example would be the welcome ! Thanks.