Search results

No problem. Im not very good with vb but Im beginning to think that just like windows, there seems to always be atleast two ways of doing something.

Try put the calc in code instead like this: Me.BalDue =Me.[INVC_AMTDUE] - Me.[INVC_AMTPAID] - Me.[INVC_AMTWO]

I got this to make the 1st folder but cant figure out how to make sub folders to the one I just created. I'll post the sample db if anyone cant lend a hand...

Have you tried: Me.Address.ColumnHidden =True

On the reports OnActivate use DoCmb.Maximize

Are you trying to delete an entire record? Do you have enforce referential integrity & cascading delete set in your relationships?

Are both reports open at the same time? I believe they would need to be in order to get the data from one to another....

You are missing that field in your query I believe.... or you have reference name wrong. You should not use "/" in a field name, if anything use SN or S_N and change the label for that field to whatever you wish the user to see!

Has anyone used Access to create folders on a drive? I have a db where if someone creates a new project I was hoping to have Access create a new project folder on the drive and give it the location to create it and a name based on one field from the form the user just created!

Try something in the after update of the one that your changing, the vbNullString clears out the old data... Private Sub YourCombo_AfterUpdate() Me.YourCombo2 = vbNullString Me.YourCombo2.Requery End Sub

I gave it a try but it only returns a blank record. Is there a different method to do this?

I have this code on a popup form. The user selects from the Combo2 then clicks find. This code works but it returns all records having data in either CatCode or CatCode2 fields or my Main form. I want it to search those 2 fields and return only records that match the value of Combo2 on my popup...

post your sql statement here for a look...

That was just step one of 16 queries to get to the final data!

Glad you got it.... Usally it something simple if it runs....One can get blinded by the amount of text in big queries!

Right off I see you have this: TBL_Contacts.Contact_First_Name, TBL_Contacts.Contact_Last_Name And this: [TBL_Contacts.Contact_First_Name] & " " & [TBL_Contacts.Contact_Last_Name] AS FullName If all you want is "FullName" you should be able to remove the 1st part I'm assuming thats what...

Post your sql qry for the sub report and I will look...

I have 3 tables. 1 has a field "itemNumber" only. The other "tblGovEst" has 8-9 fields, one of which has a cbo based on the tbl "itemNumber". It also has a field called "ID". The 3rd "tblMain" has many fields, one of which has a PK called "ID" When I use my main form, (source=tblMain), I link...

If your subfrm is based on a query and the tbl or source has a date field, then, add MAX to the date fields group by in the query.... now if these contractor invoice records can have the same date more than once you'll have to do the query differently.....

I have a simular situation where I have a db that can assign tasks to a project. Ive seen threads about sending out emails but cant figure out how to do this..... Im posting a striped down sample of my main form w/ a subfrm that users enter the tasks..... There is 2 cbo's that the user...