Search results

Neil - That's the route we're having to take now. He has been over-ruled Paul - To answer some of your questions, I myself am also a database designer and so can appreciate why he is dragging his heels. I am not taking over his role in any way but will be taking control of this particular...

Nice idea Wazz, I'll see what I can do but it's like getting blood from a stone in this place. From the companies point of view I would say it is a data issue although I am authorised to both use, update and view it. However, the problems are coming from the database designer throwing a paddy...

Me too. The reason I am being asked is because he did such an awful job in the first place. We need to go over his head but first I need to get the middle management onside Jason

I have been asked to take a database created last year and re-design it to make it more user-friendly. Not a problem, I thought when asked but I am running into a little problem...(the database designer) In my opinion, to make a system more user-friendly there is a necessity to access the code...

My company has finally bitten the bullet and decided to upgrade their systems before their software goes out of date for user support. However, this means that they are about tio upgrade from Office 97 to Office 2003 running on a Windows 2000 operating system. How much of an issue am I going to...

Sorry to bring this back to the top but I am really struggling. The issue is still the same, when a crosstab is generated, it displays multiple items but they are all the same and the figures are all wrong. Can someone please have a look at the coding for me and get back to me. I can't be far...

What I need to do (Final Push) Ok, I need to deliver this system on Monday morning, whether the crosstab works or not. FOr now I have created an Excel Output to show the data but I want this to only be a temporary fix. I have attached pics of what I recieve for both the report and the excel...

Sorry to bring this thread to the top again, but did anybody actually resolve the issue relating to the detail section. I have been working on this for quite some time now and thanks to SamDeMan with the code "me.controlsource = "myqueryName"" I can now see the correct amount of lines in my...

If (IsNull(textbox) then label.visible=false regards Jason

Doh, not awake this morning For the CompleteDate reverse the visible statements Sorry Regards Jason

Sorry, forgot the Complete Date If (Me.[Task.Target Date]) > (Date + 14) Then If (IsNull(Me.[Task.Target Date])) then Me.Image63.Visible = False else Me.Image63.Visible = True If (IsNull(Me.[Task.CompleteDate])) then Me.Image63.Visible = False else Me.Image63.Visible = True Regards Jason

If (Me.[Task.Target Date]) > (Date + 14) Then Me.Image63.Visible = False else If (IsNull(Me.[Task.Target Date])) then Me.Image63.Visible = False else Me.Image63.Visible = True Hope this helps Jason

Another day, another dollar? Well, I've spent the entire day trying to revise the code for this and cannot figure out where the issue is. I want to say that the problem lies with either a property in the detail section of the report or within one of the event procedures pertaining to it...

Nearly There I've finally created a working 'on the fly' report. Unfortunately the report only shows one line of the setail section and I cannot figure out why. Can someone please have a look at the code for me as I am starting to pull my hair out. I've got so far and then suddenly it fails at...

Good Afternoon All I have finally managed to create a report that builds on the fly to correlate all my data into a summary. However, for some reason, the detail section of my report only throws one line instead of moving on through the recordset. Also, (probably due to the above problem) the...

Firstly, a sorry to Pat. I got logged out whilst posting my initial post so I reposted only to find that the forum had in fact accepted it. Anyway, thanks for the reply RuralGuy. I appreciate that as data goes, the form I am creating will not seem very normalised. The issue however is more to do...

Hi Joe Thanks for the reply. I tried reversing the query as suggested to have all my issues (63 of them) across the top of the page. Unfortunately I cannot get all the issues to display. If there is no value for them, then they don't come up. I would prefer them to come up as a collection of...

Does anyone have any idea how to sync two forms so that I can create one record in a table from the pair of them. I have a form which is so big that I have had to place a continuation to a new form on it. However, when I move to the new form, the data is placed into a new record instead of...

I am creating a form based directly on some paperwork which needs to be logged electronically, Unfortunately this extends well over the 55" that Access allows for a form. Not a problem I thought, just create a second form and place a continuation button on the first...Obviously not. When I place...

Crosstab Issues Ok, it took me a while but I found a copy of the solutions.mdb for Access 97. However, after poring over it for a good few hours, I cannot figure out how to convert it for what I require. Maybe it's just me but the crosstab report they have created in solutions.mdb is full of...