Search results

Thnx, now I see what You had in mind. Thank You

Could You post links to posts where the IFF examples can be seen? Thank You

[SOLVED] Changing SQL of the Query on the 'fly' Yes, I tried that, it works just as filtering the report with VBA, but the problem was with parenthesis in SQL. I just wanted to say that for future reference if someone has the same problem as I did ... Thank You

I'm using Access 2007 and VBA to build desktp application with accdb back end databases. What is the difference between two versions of the VB language? What things would I need to keep in mind if I would start to build programs in Visual Studio (desktop applications with Visual Studio)? Could...

[SOLVED] Changing SQL of the Query on the 'fly' No because this query ... : ...,and this query: ... don't return the same result. The second query returns R00 - R07 results for the 802 group. It returns correct results for the 801 group, but for 802 those (R00 - R07) I don't want.

Thank You guys for Your advices, but I found out what was the problem. Apparently the Access makes difference when You create SQL in queries with and without ")" sign, which is put there by default when You use query builder. The query that worked before my problem had ")" because it was...

The reason I need to change the query SQL is because: I have report which source is table. When I create filter in the reports on load event the data is not displayed as I want it to. The query with the same filter as report extracts data properly. When I say filter I mainly mean in the WHERE...

Thank You guys, will try it :)

Can I change the SQL of the query, which is record source, with VBA? Thank You

Anyone? ... Was my question clear enough? ...

No, I'm searching the way to open another access database with the click of the button on form.

When I say "modules" I mean several Access 07 database files that act as separate programs and can work each on its own, but also You can use them all together, they ware all connected to the same back end database. So to simplify the question, I'm asking should I create separate database with...

I've split my main application in several different program modules. Now, I need to connect it together. I'm asking for advice what is more better to do. The way I'm thinking right now is, because I have several modules (access 07 databases), to create one more which will serve as main menu...

I'm using Access 2007. Can I, and how, create picture uploading in database functionality, and to display the uploaded image for each record in table? Thank You

Thanks guys, will search there :D One last thing I wanted to ask here to hear Your opinion: If I use Access as MySQL front end, and the database is hosted to online web host, can I connect and how to that database (through internet), and will the performance suffer? Thank You

Thanks, You gave me the answer. I forgot access has append query, because I've never used it :D Yes, I could link to MySQL database and use access as front end. Could someone give me some tool I could manipulate the MySQL database (create tables without typing SQL code). Thank You

If I populate access database with some data, what would be the best and easiest way to transfer that data to MySQL database? Is there some software or automated way, or I need to do some web programming to create this myself? Thank You.

Thank You guys for last couple of answers, they clarify a lot

Here's what I've tried to explain, the scenario: ... Option Explicit Dim txtVar as string txtVar = "Z00" private_sub btn1_click() ... & "WHERE tbl1.txt1 = '" & txtVar "';" ... private_sub btn2_click() ... & "WHERE tbl1.txt1 = '" & txtVar "';" ... When I put it this way I think my real...

I've tried what You suggested, but I still don't have the answer can I, and how achieve this what I have in mind. Is it possible to do this and what is the way? Thank You