Recent content by treva26

Perfect thanks Nigel! And no I wouldn't really use Name as a fieldname :)

*SORRY I MEANT LEFT JOIN * Probably a basic thing but I cant seem to think of the right keywords to search for it! I have lookup table I use to return names for various "Sales Class" codes. It all works good but if there is a code that isn't in the lookup table it leaves that field empty. I...

Well I realised all I needed to do was change the Left Joins to Right Joins.. Doh SELECT dbo_PR_Actions.PR_Action_ID, dbo_PR_Actions.Action_Date, dbo_PR_Actions.Action_DueDate, dbo_PR_Actions.Action_Completed, dbo_PR_Actions.Action, dbo_PR_Actions.Action_Status, dbo_PR_ElementTable.Element_Num...

I have a report that uses this query which lists the ACTIONS for each ELEMENT of each PROJECT. This works fine. I have attached an image of the query layout and its SQL is below. How can I get it to also include a row for any ELEMENTs or PROJECTS that dont have any ACTIONS associated with it...

Good thinking! I exported them to Rich Text files. I had to add a 1 second pause to give Access time to close the preview before trying to reopen it. Here is my code now: 'open/print reports For Each RepCode1 In lstRepCodes.ItemsSelected 'set parameters WHERE2 = WHERE1 & " AND [Bradken Sales...

I have a report that I want to run with various WHERE conditions. There is no problem if the user wants to print the resulting reports, it just prints one at a time and closes it. But what if the user wants to just view the reports? Can I have multiple versions of a report open in Print Preview...

OK thanks. Since there are loads of editable and only a few read only fields I will use the original query and have DLOOKUPs for the read only fields.

I have a form that runs off a Query, it all used to work fine. Then I added some fields to the query that are based on aggregates from another query. So those are read only, but I want the other fields to still be read/write. Is that possible? It causes an error and says "Recordset Not...

Has anyone got a function to convert twips/points to pixels? I cant seem to find one. I believe you need the screens dpi (both directions)..

It would be nice to be able to select an area with the mouse to crop... But I imagine that would be rather complicated!

This code uses the LaunchApp32 function to silently run an image manipulation program called IrfanView (freeware). A copy of this program must be available to the database. The attached database includes a form that allows you to do LOTS of cool things to images, without visibly leaving the...

Actually they both work fine, there was something else going on with my form that was screwing it up.

Cool thanks. I figured I would just replace the text and not bother telling the user in this case, and wrote this function to do it. Public Function myReplace(ByVal string1 As String, replace1 As String, with1 As String) As String Dim c1 As String, x As Integer For x = 1 To Len(string1) c1 =...

Hi, How can I prevent people from including quote marks when entering data? It messes things up when I try to use that field later in an SQL statement from VBA. For example, I have a field called [Comments1] and someone enters: This is a very boring "comment". Then later I run this from VBA...

I just need to know the number of lines so that I can display a progress bar as is goes through on the second run processing. There is no problem the way it is above, it just seems to me there should be a command that goes back to the top.