Search results

Hi, This seems like a deceptively simple thing to have to be asking. I have the following code that opens a form at the record selected in another form. The form opens fine showing the correct record but the user can then scroll to an empty record. This isn't a huge problem but I assume...

Yep, that's the thread I was after. thanks

I know I saw how to do this a month or so again, but for the life of me I can't find it again. I am in the prcess of developing my database so noone else should be using it, but quite regularly I get messages telling me I do not have exclusive access or that something has been changed. How...

You've probably got this sorted now, but if not the way that I have done this is my queries (substituting with your field names) is as follows IIf([AccountingStateID] & "" = "", "", DLookUp ("StateAbbreviation","tblStates", "StateID = " & [AccountingStateID])) AS AccountingState Hope...

Thanks so much, I will give that a try, it will certainly make things much nicer

I hadn't thought of using Windings font, I had thought about using images but that seemed like it wouldn't be worth the effort. Both of those would still require at least 2 controls probably 3. I have done it with using three lines so it looks like |--------| which is fine for my needs...

Thanks for the responces. I am definately going to have the export to Excel option but would like to have something else as well. What I currently have is a table that contins the field names and a column to define the data types (since for example the fields containing IDs are actually...

I have a form that is used to populate a table with user defined options which are selected fomr two list boxes and a combo box (the combo box is just used to filter the second list) Behind the form are lots of sections of repeated code so I wanted to put the repeated code samples into their...

Ha typical after spending all that time writing the post I finally figured out the syntac it should be: strLookUpSubRptQry = "DLookup('[CodeNameShort]', 'tblCodeValues', '[CodeID]=' & " & Me.lsSubCriteria.Column(1, varCategory) & ") AS Field" & k Still if anyone has found some glaring issues...

HI, I've put this in general as the way I am doing things seems very long winded and so I was wondering if anyone had any better ideas. This is also the reason for the long explanation. For people with less time my current specific issue is the bit in bold at the end. I was hoping someone...

Hi, This is probably really simple, but is there a way to draw a line with arrows at the end of it in a report? I'm making a timeline report and so I have lines that change length depending on project dates, I would like one of these to end is arrows or similar. I know I can fudge this by...

Hi, I'm using Access 2003. I can't really post the database as it's got a lot of company data in it, but everything seems to be working now. I deleted the old form with all the VBA missing and renamed the new one (the one that took the caption as its name) and everything seems to be behaving...

Hi, My database contains a lot of information on projects that users may want to compare. To predict every comparism that the users might want and design reports for all of these is impractical and so what I am trying to do is create a series of simple reports that work for certain data type...

Hi something I was not expecting has just happened I have two form which both have a filter by form functionality. There are two of them as one is quite limited as it was my first attempt and the other is has much graeter flexibility. I originally thought of just idscarding the practice one...

Hi, Just thought I would add to Bobs point in advising against having the look-ups directly in the table. I did that when I started my database and then a while down the line realised it was making everything so much harder as the values the table displays are not the same as the values it is...

Hi Again Pat, Just wanted to say your table of tables and code values is awesome. Am really liking it now, it makes everything so much more streamlined and easily understandable. Thanks so much, Robyn

Don't worry. I still don't know how I did it, but I pressed Escape a few times and that cleared it.

Hi again, I don't know what I've done but when whenever I select any text, be it a label a line of text in a properties field or anywhere, I can't get the cursor to allow me to start typing half way though (or anywhere except the end). If I try and select somewhere that isn't the end it just...

Hi Pat, That is certainly a very appealing option as I currently have about 12 small tables that could easily fit that format. A couple of questions and possible concerns though. for the sake of these questions I'll use my table name. Basically most of these little lookups relate to field...

OKay, I think I will go with the second method, which is what I currently am doing for the majority of the fields. Don't confuse look-up tables with look-up fields in a table. In my minds I don't think I am, hope the post wasn't too confusing. Thanks for the help. I really wish I'd...