Search results

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.

I am opening a text file, counting the number of lines, then processing it. I am sure there must be a simple way to get back to the first line after counting, but I cant find it so I just close the file and open it again... Open "M:\Mining\Unibis\oe404v3.txt" For Input As #1 'count number of...

Ok I finally found it! Not sure why this references the Switchboard, but it works... ' Minimize the database window. DoCmd.SelectObject acForm, "Switchboard", True DoCmd.Minimize I put it in the "Form_Open" sub of the Switchboard. It minimizes the database window and the Switchboard opens...

I have been searching. All I can find is ways to hide it. Can I use DoCmd.SelectObject to select the database window? (the one you can access all of the Tables, Queries, Forms etc right?) If so what is the name I use for it?

Hi, I have seen many posts about hiding the Database Window (the one you can access all of the Tables, Queries, Forms etc right?) But is it possible to just minimize it using VBA instead? I have some more advanced users who may want to use it, while hiding it from most people. I would...

I have been trying to figure out how to get my Access frontend to connect to my SQL server backend (linked tables), without having to manually setup peoples ODBC's. I believe this can be done with a connection string but I am having great difficulty understanding it all. I have tried...