Search results

Numerical And text 1E... Thanks for replying Neileg. The "E" stands for emergency. there are other Letters as well; "D"-development. "A" advocacy. Unfortunately I can't change this system so that it's just numerical. Do you know if this mean that there's nothing I can do about this?

Hi I have a report with many headers with sorting and grouping. All groups are Acsending properly apart from one which is a field with project years. The numbers of years in each group will go as high 14. Even with Ascending order in "Sorting and Grouping" it goes like this: 1, 10, 11, 12...

Hi folks I hope someone can help me here. I designing a Query By Form so that I have multiple criteria for a report. part of the code will be for one date criteria which is in the short date format and the other date criteria that will be added will be just the month and year. I'm trying to...

Hi there! I have a form that has bank details. The bank details dont usually change that much so they have been linked to the Main table rather than being specifically linked to each Projects year records. This means that I'll have to use a combo box on a payment form within one of the tab...

Hi there I've looked for threads on this but can't find any I want to know if there's any way to use the Maximize function in one form to Maximize another form? So that when a dialog form closes it will maximize the switchboard. I know it's trivial, however, This one will help me out alot

Thanks Moniker! I actually used a different method. However, I'm going to keep this code and give it a try. I'm new to VBA so it's great for me to have all the methods I can get.:)

Hi folks I have just created an input form to collect the date criteria for a Monthly report. I've used DateSerial function as I only need to collect the Month and year. I'm working on a new report now and would like to ask for some help. This report will have multiple filters. For example...

Lagbolt wrote tblOne, tblTwo? What data do they contain? More likely you'd have a table called tblNumber that could store Ones, Twos, Threes AND Fours. If you were keeping track of people you wouldn't have a tblBob, tblJill, tblEd. Same issue. Thanks for replying Lagbolt. I was merely using...

You've Helped in the past and I appreciate ALL help. It's important when starting out to get as much help as possible. Thanks Neileg:D

Thanks for replying Neileg! Understandably the data is already present in the backend. I was just curious how to reference the records field info on an expression within a control on a form with a different table record source I hope this is the right response to your reply:)

Hi folks. I have been advised that I could have a linking problem with the database I am working on and that things are not linked the way they should be. So I'm going to attempt to explain how I've linked my forms and invite anyone to see if they think I've incorrectly linked anything...

Thanks to the help on this thread I have found the answer. This is the code for other peoples benifit. Forms![frmMain]![tblAppoval].Form![AmountApproved] The control resides on the subform with the container name "tblApproved" The subform resides on "frmMain" Unfortunately it's not...

Post by RuralGuy #Name still indicates a referencing issue. You know you are looking at the SubFormControl when the "Data" tab has the LinkChild/MasterFields properties. The actual name of the control is the 1st item on the "Other" tab. This part is clear. I think I know what might be causing...

Yes, In this instance the expression would be =tblApproved.form.AmountApproved the tblApporved is the Container name as apposed to the actual backend table name. would that be right? I mean, I've used similar expressions before i.e. =Forms!frmMain!Code & "/" & [Suffix] which the frmYear uses...

The container name for the subform is actually tblApproved. so I tried =tblApproved.form.ControlName. Still getting the problem, #Name?. :confused:

#Name? Thanks for the help I'm getting here, I've been given good support on this forum! I'm still having bother with this control even with trying the two methods desbribed. I don't know if this will make a difference. The subfrmApproval and frmYear are all subforms of frmMain. The...

hmm firstly, thanks for replying RuralGuy! Yes the form is open as it's the subform. however, I've tried that expression and it's not refrencing to that particular record. sure, what you suggest would perhaps work if it the target control was unbound. the target control is bound (which I...

Hi folks! I would like to display the results of an object in a form from a different form. There is the Main form (frmMain) which holds all other froms but all forms are linked to the sfrmYear subform. on one form (sfrmApproved), there is a currency amount. If it is £200, how would I go...

Thanks thanks BobLarson! I actually got to work on the form which was what I was going to do at the end and realised that I could link both report and subreport date criteria to the input form which worked nicely! :)

I have a report made up from a mutiple table query. I have duplicated the query for the subqry and used "Is Null" on one of the fields to display late payments. This has been made into a subreport which is a duplicate of the report. Only difference being the records. I am using the BETWEEN...