Search results

I modified the line as you said, and it works perfectly now. It was just a syntax problem. Someday, Ill catch on to all these crazy syntax's :) Thanks! Ben

Hi there, I don't know what I'm doing wrong. Pat Hartman gave me some great code to take a value from a listbox and apply to a where statment of a report. The code works fine untill I try to tweak with it a little. Private Sub TheList_DblClick(Cancel As Integer) Dim stWhere As String Dim...

Pat, you never cease to amaze me. I honestly tried to figure that out for hours and you did it in just three lines of code. Bravo! Thanks! Ben

Hi everyone! I'm having some trouble with a form/report I'm working on. My form is called "Order Check" and right now it has a combobox that's rowsource is the dueorders querie. I want to be able to double-click on any item in the list and have just that item's info sent to a report. I'm not...

I really should have known that. I think I need some more coffee this morning. Thanks for the help! :)

Thanks for the reply. That didn't work though. I got a compile error saying it expected then or goto? Any other ideas? Thanks! Ben

Hello, I get stuck on the simplest things. I need to write an If-Then statment for a report Im working on that establishes a basic data range from .25 to .5 For Example: If Efficiency < .5 and > .25 then blahblah End If I've tried so many combinations, including Between but I just can't...

Thank you Rich! You're a great person! That was a perfect example, I got everything I needed and more. I'll send some good karma your way today ;)

If someone helps me out with this, I'll say " Thank you, You're a great person!" and that would probably make you feel good about yourself. See, it would definatly be worth it ;)

That sounds like a good idea. But what would I type in the Tag Property Field? Also, I couldn't find any mention of the PrevRecVal function in any help files. Thanks for your help!!

Hi everyone! I'm having problems with the Dlookup function. I've searched the archives and tried to make my own code but it isn't working. Here's the code I've made so far (Don't laugh) =DLookUp("Total","Tracking","Item =" & Reports!Main_Report!Item & "'") I'll explain what I'm trying to...

Would that create new records in the Transaction table for every item in the Item table? Hmmm that gives me something to play around with. Thanks for the idea!

Hi Everyone! I'm working on a new project for my ever-growing company database. I'd like to implement a new data-entry system that seems like it should be simple enough, but I lack the raw technical knowledge to do so. So that's why I'm turning to you wonderful access experts for help! Ok...

Maximum Attributes- Microsoft Access database (.mdb) file size 2 gigabytes minus the space needed for system objects. Number of objects in a database: 32,768 Modules (including forms and reports with the HasModule property set to True)...

I have a large amount of corperate data and objects in my database. (About .5GB) Up untill I read your post, I wasn't even aware of a 2GB limit. Now I'm a little concerned myself as to the scalability of the program. I'm hoping someone can offer more information about this. Thanks, Ben Bolduc

:D

The ID# and the Acetator# both get thier values directly from the [Main] table, which is the only table I have for this DB. I know I can re-create all the calculations in the query, and thats what I intend on doing. But my only obstacle is this Dlookup feild. It's the only one that I cant seem...

Now if I could only figure out how to put =DLookUp("[Vouttotal]","Main","[ID#]= " & Reports![Acetator Report- First Draft]![Id#] & " AND [Acetator#] = '" & Reports![Acetator Report- First Draft]![Acetator#] & "'") into a query, I'd be all set. Anyone have any ideas?

But if the feild that I want to run the graph on is a calculated one, how would it be mentioned in a query if I didnt put it there? I'm sorry, I'm a little dense when it comes to Access Graphs. Thanks Again -Ben

Thanks for responding, This report has a lot of feilds, and unfortunatly the most important one is a calculated feild. I need to set up a graph with this feild, but I can't because all graphable feilds have to be in a query. I figured i would just recreate all the calculations from the report...