Recent content by InQuery2004

Hi, To add another level of complexity to this post, I have the following problem. While I too would like to eliminate leading zeros from a text field. Not all of my records in that field are numeric. Some values for instance are "0123A" or "0054B". If I am to use the Val function or Cdbl...

Hi Gromit, Thanks for the posted solution, although it seems pretty straightforward, the same approach doesn't work with my Tables. Actually, I wasn't very clear in my initial requirements in that my issue is the exact same one that you solved (ie matching column A to column A in a reference...

Hi all, This is quite a basic question and I'm sure that it has been posted here some time ago, although I couldn't find it on using the search. I want to update a field in one table "FieldA" using an update query. I want the update to be based on matching Field B in the updated table, and...

Actually, Rich's solution worked fine (Me.Graph19.Refresh). I mistakingly kept a macro in the event "click" rather than chaning it to the VBA code. The Graph object now refreshes quite nicely. Thanks for all those who responded. Regards, Mike J.

Hi Richary, Thanks for the suggestion. I tried your recommended solution, unfortunatley it failed to update/refresh the graph for the new selected data in the combo box. Do you have any other suggestions for me to try?

Now trying to Refresh the Graphs... Pat, Thanks for the response. I fully acknowledge your first point. Normally, this is not my practise either. However, desperate times called for desperate measures, as none of the regulars or guests replied to my original post (Titled along the same...

Hi Pat, I'm not sure whether you'll be able to help me out with this problem, but given your seniority on this forum, not to mention your expertise with most things Access, you're as good a person to hassle as any. I was wondering wherther you're familiar with MS Graphs and programmatically...

GHudson, Has my question on recreating a single graph based on different X-axis fields been discussed before? If so, under what forum? If you can't recall, do you have any suggestions on how to go about resolving this problems. Thanks for your help.

Come on Folks, I need to create the aformentioned graph ASAP (I have a deadline coming up with my supervisor). If my aim cannot be done, please say so, and present and alternative solution, if possible. If my original post is too ambiguous, then I'll clarify my original requirement...I just...

I noticed that although my post has had some views, no one has yet replied. Perhaps I'm being too impatient, but I am curious to know. Is my issue too complicated to resolve with/ cannot be solved or is it that most of you don't understand my original post. Or is the underlying issue...

Hello, Would anyone know whether it's possible to create a Chart for a form in ACCESS whose X-axes varies depending on the value selected in a Combo Box. The Combo Box shall contain entries that represent fields in the query that serves as the RowSource for that Graph. So for example, suppose...

Just to let you know, I took your suggestion and implemented the data entry form with a combo box. It works quite well actually. Thanks for the help Pat.

One thing I completely overlooked that makes a combo box impractical: this database will be holding thousands of records of employees, making a combo box cumbersome. Given this information, what can I do to the EMP_ID textbox event procedure to make it run correctly. Here's my most recent...

Thanks for the swift response Pat. Acutally, I also realized this error with the field name. Unfortunatley for me, the field name in the table is EMP_ID# and not EMP_ID which is the name of the texbox control. What can I say? this is my first database project (and I'm actually doing this...

very well Phil. I shall take your advice. Hey People! Check out this awesome post, it is well worth the time! http://www.access-programmers.co.uk/forums/showthread.php?t=76722 Say Phil, you are quite a sharp individual in MS Access and VB and would probably be able to help me out. Why...