Search results

Thanks for getting back to me Rich! The reason (I believe) a subreport wouldn't work is that I have to take dates from the many side ( the installments table) for criteria against the report. These are Schedule dates that the money would be disbursed. If I create a subreport with the...

Thanks folks for getting back to me on this one. I'll have a look at the Dcount and see how that would work. I take it RuralGuy, when you say Disable, you're refering to the Enable in properties. I tried that and used: Forms!frmYear!sfrmApproved.Enabled = True within sfrmYear but was...

Thanks folks for getting back to me on this one. I'll have a look at the Dcount and see how that would work. I take it RuralGuy, when you say Disable, you're refering to the Enable in properties. I tried that and used: Forms!frmYear!sfrmApproved.Enabled = True within sfrmYear but was...

Hi all I’m trying to write a little code and keep coming up against barriers. I have a main form with a sub form named sfrmYear. Also, on the main form I have another sub form named sfrmApproved. SfrmApproved is actually linked to sfrmyear via a txtLink (=sfrmYear.Form!YearID) the txtLink...

Hi all I know the heading makes out it's a Query problem, however, it's definitely a Report problem. I have a report and the underlying record source, which is a query, spans 4 tables. I'm concered with two of the tables... If I look at the query I can see the one side duplicated to...

Thanks RuraGuy for your help on this matter, worked like a charm

Hi there. I've implimented error handling and Access is not catching the errors and I'm getting the standard debug window. I've double/triple checked my code and it IS fine. I'm,quite certain it's something to do with the settings in Access, however, I can't remember what it is. Does anyone...

Thanks AjeTrumpet! that was the code I was going to try out! plus, in the record source of the Contact form I was going to add the ProjectID from tblContact and add =forms!frmMain!ProjectID I wouldn't think this was essential, however, it does no harm. Cheers

First of all, Id like to thankyou Ajetrumpet for taking the time to help me with this one. I'd like to state that I'm aware of how relationships work and this is not a relationship/field problem, this is an MS-access wizard problem; to be more precise, the wizard doesn't help me on doing what I...

thanks for replying folks. There is already a record created within the main form. With the code above (apart from the form toggle code) used. none of them works. So I'm obviously missing something. I believe the most effecient way for me is a command button that opens a form that is linked...

I've already tried using the wizard and the code for that is: Private Sub cmdOpen2_Click() On Error GoTo Err_cmdOpen2_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmContacts" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_cmdOpen2_Click...

Hi folks I have a frmMain that is used to add details about projects. I have another form (subform if you will) frmContacts (the backend tables are linked to each other) and this will be related contact details. I don't have anymore room on the main form and I can't use a Tab control. So...

Thanks for replying Ken I was thinking of using Nz but then I wouldn't get anything showing. It would probably be better if I was able to list a "0" to instead of a blank. Any thoughts on this? thanks

sorry, I really should know this by now. I want to total the amount on a report with the IIF IsError statement. I'm just not sure of the syntax, How would I add it to: =Sum([Sent]) so that I don't get the error# ? Thanks

Hello folks I've been trying to work this out but I'm a little wary incase I'm doing it incorrectly. The records that are displayed within a report have a many side and these will be shown within sub reports so as not to display duplicates within the one side. The problem I have is with the...

Thanks for replying DJKarl! The FK is Numeric as it's just a copy of the AutoNumber from tblCountrys' PK. While executing the mentioned code, I'm trying add code that will update the tblProjectMains CountryID field (the FK) Let me know if you want more info Cheers:)

Hi there The database I’m working on is Specific to storing info on Projects around the world. I’m using code that will create a new project record. Each project is identified with a country abbreviation (UGA which is Uganda) and a project number (002). The code will use the existing...

Thanks Folks, that was a great help!!:)

Thanks Bob! After having looked at three sets of code from the old database I came to the conclusion that this code wasn't supposed to be there and was left by mistake. There's code that does the job. Means that for seven years users have been getting this error for nothing. I just removed...

Hey there I'm redesigning a database and want to use some of the same code as the previous one. I'm having a problem with part of the code. The code is to enter a new record; taking fields from the last record within a table "tblProjectMain" (UGA 001) and creating a record to follow on from...