Search results for query: *

Hi Tigerlili3, hneal98, lesw1433, Thanks a lot guys ! Tigerlili3.. I use a text box in the FORM. Lesw..I guess you are correct. I have it as a text field and thats the problem. I have to work with whatever data format, I have been given. Thats frustating but, adding "1" to it solves the...

Lupin, Thanks for showing me the light! [yinyang] Thanks, villsthearcher

Hi, I intend to make my database a read only file. What I mean is that the User will not be able to change the Design or modify the forms, reports or queries respectively. So what I did was I first converted the .mdb file into .mde file. Then I replicated this file. Now, I was successful in...

Hi, I intend to make my database a read only file. What I mean is that the User will not be able to change the Design or modify the forms, reports or queries respectively. So what I did was I first converted the .mdb file into .mde file. Then I replicated this file. Now, I was successful in...

Hi, I intend to make my database a read only file. What I mean is that the User will not be able to change the Design or modify the forms, reports or queries respectively. So what I did was I first converted the .mdb file into .mde file. Then I replicated this file. Now, I was successful in...

Hi, I am passing date as a Parameter to the query. I am using a date range by using the function BETWEEN. Note: I have used actual values in the Square brackets just for understanding purposes. The problem I was having with the query was that, if I run a query with the parameter value...

Cool....TheAceMan1 !! Thanks, villsthearcher

olaaaaaaaaaah!!!!! works like magic, Roy. You are a life saver [bigsmile] Thanks, villsthearcher

yes Lilliabeth..You were right! No probs with the form..thingie [peace] Thanks, villsthearcher

Hello, I am able to open a Form, enter a parameter and then Run the Report. But if I again enter a new parameter value, when the Report for the previous parameter value is OPEN, it doenot show a Report for the new value. But when I CLOSE the report for the previous parameter value, and run...

Thanks ROY! Thanks, villsthearcher

Lilliabeth, I was looking at the Porperties for Report. I found the NO DATA event there. I was also going through some other websites and like you had mentioned, this event is available in the FORMS properties. But in mine (i am using access 2003) this event is found in the Report Properties...

Lilliabeth, I was searching for this event on the Properties window for the Form. But surprisingly it does not have that ON NO DATA event! It has events like ON ERROR, so on but not the one that you specified. I even tried to simply copy and paste Triplejhjo's code in the VB code window, but...

Hello, I have 4 reports and I open these reports from 4 different coressponding forms. What I intend to do is, Create one FORM and then have Radio buttons / check boxes in it. On selecting a Radio button/ check box, another Form is opened, through which I will open the corresponding Report...

TripleJHJO, Where and how do I create this "No_Data Event" ? Please help me, I am new to VBA. Can you give me an example of creating this "No_Data Event" ? Like for which object should I create this event? Sorry and Thanks again. Thanks, villsthearcher

Hello, I want to show a message, instead of opening a Report in Preview mode, with no data in it. What I want is that if the Query returns No data/values then do not open Report instead show message, "There is no data available for the values provided, in the database". Thanks, Vijay...

Thanks, PHV. It worked like magic :) Thanks, villsthearcher

Hello, I have a Query1 that uses 3 Tables (A, B, C) involving Left Outer Joins. When I RUN the query, it lists all the common records in the database. It works fine! I created a similar Query2 like the one above, but instead of having 3 Tables, I used a QUERYA and 2 Tables. Basically the...

Hello, I am using a FORM to pass values to the Query which is used by a Report. To force the user to enter a parameter value, I added a conditional statement for a textbox in the FORM. if Nz(textbox1)=0 then goto XYZ XYZ: Msgbox "Enter a value" Now this works fine, but there is a...

supeerrrrrr!! I took a self crash course on vba coding! I realized that your first response with the code was adequate enough for solving my problem. Thanks, villsthearcher