Search results

I have a report...the table it is based on has over 100 different fields full of data PER EACH RECORD...ugh! Well, I am designing my report, and as I go I want sections of fields to disappear based on ONE SPECIFIC field... If the record being viewed is a CITY project, I want all the...

I have tried everything and am going crazy now... I have created a form where users pull up various City Projects...There are 2 types of Projects, City and Contract...The field that stores the Type of Contract is named [PSRTYPE] and I am trying to call certain Subs whenever a user pulls up one...

Curious...could you help me figure out what code you would write that would grab the Computer Name automatically...? (I just happened to check out this post and find it fascinating...it would be great to grab everyone who is in the database and send them all a message, ie GET OUT OF THE...

Couldn't you export your tables to basic text files in CSV format and reference them using VB? I don't know...just a thought...

Well, if you want the users to be able to access the tables I can't help you... But if you are restricting the users to ONLY the forms/reports you have, then check out this: http://pub95.ezboard.com/fcodesmithguildfrm20.showMessage?topicID=2.topic I have compiled this from ALL THE HELP I...

Question: You said to write your expression like: Result = Val(Me.subReportName.Form.subtxtBoxName) - Val(Me.maintxtBoxName) What does the .Form. in there do? If you are pulling from a Report why do you use form...? I could use this answer.

I have a subreport on a main report. SubreportName:subrpt_ContractAmendments MainReportName:rpt_Green_Book The subreport has 4 fields. Field#1:[AMNDNO]- Amendment Number (ie 1,2,3,4...) Field#2:[AMDAMT]- Amendment Amount (Currency) Field#3:[AMDJSTCN]- Just a text description field...

If I have a group of fields that I want to alter in VB in a report... Could I group them, set their tags with something like "HAPPY" and another group to "SAD" and then if a certain record has a variable set to "HAPPY" make all the fields with the TAG:"HAPPY" turn visible and all the TAG:"SAD"...

Ok.. I have this report...there are maybe a hundred or more fields on it...and a couple subreports as well... There are sections on it, but not sections that can be seperated by a specific field... SO how do I create groups without selecting a field to define the group and thereby avoid...

Nevermind... I figured it out... I went into the subreport... Created a Group Header... Created an unbound text field that contained an expression to sum up the field I wanted summed... Then I put an unbound in the main report that used the sum field from the subreport as the control source...

I have a report of projects that the Engineers are responsible for. Some of the projects have Contract Amendments for them. I have created a report based on the project table. I have added a sub-report based on the Contract Amendment table. They are linked based on the Project ID, an autonumber...

I have a question...sorry to clutter up this post, but HOW ON EARTH DID YOU DROP A PIC ON YOUR POST? There are HUNDREDS of problems that could be clarified if I could have done that with some of my forms...? I have tried, but it always says that HTML is turned off... If someone could help me out...

Please send me the DB... I was wondering what [field] the code puts the OLE into... randomblink@yahoo.com

Question: You created the following subroutine: Option Compare Database Option Explicit Public picPath As String Private Sub Command8_Click() With cm1 ' Common Dialog Control .DialogTitle = "Choose Your Sketch (*.bmp) file to Import" .CancelError = False .Filter = "Bitmap Image (*.BMP)|*.BMP"...

I haven't gone and tried this so forgive me if it is brainless...but... Couldn't you create a rectangle, with a normal background...and then set the color through vb conditional to the data? If you put the controls on top of it...that should work...just format the box and SEND TO BACK... Just...

No, you could actually enter a variable and create a text field/combo-box to select the form you wanted to open from there... (altho, in retrospect, you could do the same in the other...the quotes threw me off...)

Mis-understandings...ahhhh... Gotta love em... Sorry man, I was having a horrible day when I saw that little number...and when I responded... I apologize...thanks for clearing that up... (meek look) Forgive me...sheesh! (Im an eeediot!) (glad I could help?)

Shorter...? Yes... More Professional...? What the heck does that mean...? You have no error handling on the shorter version...And you are limited to a set form that you are opening... Not sure why you would be semi-insulting to a reply that didn't fit your requirements...especially when you...

Here you go... http://pub95.ezboard.com/fcodesmithguildfrm20.showMessage?topicID=4.topic This has it laid out... Enjoy...

So can anyone help me...?