Search results

Thanks Rich - my first instinct was to create a form, but I wasn't sure how I'd do it. -Sean

Good idea cstahlberg - thanks! -Sean

Hello, In my main report, I have 2 subreports that run the exact same query (they just display different data). The query prompts the user for a year. This works great except that the user is prompted twice (because the query runs twice - once for each subreport). Does anyone have any...

Does this help? http://www.mcse.ms/archive153-2004-7-895030.html Basically, the advice is to use "Force new page" settings rather than page breaks. Let us know! -Sean

Have you tried File - Page Setup... - Page (the tab) - and then selecting Landscape? If you really want to keep it in portrait, you're going to have to change your subreport. Open it, and keep working with it until it looks right in print preview (and try to leave some extra room). Then when...

You can follow the procedure posted here to enable/disable the shift key bypass http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51479 You can also create a seperate workgroup file (.mdw) and adding a shortcut to it (you should be able to find it doing a search). Hope that...

Thank you Graham - this works great! Cheers! -Sean

Hello, I can use the TransferSpreadsheet method to get my query output into Excel - but is it possible to use a dynamic query? For example, rather than: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryMyQuery", "C:\My Documents\myQueryInExcel" Could I do something like?: Dim...

How about something like: SELECT tblDates.* FROM tblDates WHERE (tblDates.date>=Format(Now(),"dd mm yyyy")) And (tblDates.date<DateAdd("d",14,Now())); I'm sure you could improve on how to get the current date - but this should be a good start. -Sean

Thank you both for your help on this! I ended up going with Matty's suggestion because the Tag property was easier for me to use. Once the OpenArgs property is set, you cannot (or at least I couldn't) change it, so I would have to close the form completely and reopen it. Thanks again! -Sean

Thanks for the reply dcx, but I am still having problems trying to implement your suggestion (mostly because I've never used the "OpenArgs" before and my help file doesn't have much on it). I don't think I understand how it works really. Could you tell me how close I am please? In the target...

Hello all, I have a small problem with pre-loaded forms. In my switchboard form, I pre-load another form using the following code: DoCmd.OpenForm "myForm", , , , , acHidden This would work perfectly except for one thing - all of my forms have either "DoCmd.Maximize" or "DoCmd.Restore" in...

Yes, that makes sense - thanks dcx! -Sean

Hello, Currently, I have 3 modules each with only 1 function. I don't think that the names of the modules have any impact on the database at all so I'm just wondering if there are any pros and/or cons to having everything in 1 module? Would there be a performance difference one way or the...

Try putting the DoCmd.Maximize statement in the Report_Activate() section of the report instead. (you can place "DoCmd.Restore" in the Report_Deactivate() section if you need to). Hope that helps! -Sean

Hey Garyj, could you narrow it down for us? Did the error highlight any particular part of the code? Try compiling first - it should be under "Debug" in VBA mode (haven't used 97 in ages!) and let us know what error message reads and where it's highlighted. -Sean

Thanks for the reply Pat. I did notice that subqueries are much slower in Access than in other dbs I've used, but at least they used to work. I'm not sure exactly when they stoped working, so I thought I'd ask to see if one of the latest Office updates might be the culprit ...? Thanks again...

Hello, I don't like to have have too many queries in my dbs, so I write nested queries whenever I can. For some reason though Access fails every time I try. It will run the query fine and even display properly in design mode after I've written it, but as soon as I try to save it an error...

Hey Groundrush, in a union query, the columns must match so in your example here: SELECT [ResourceName],[HolidayHalfDayCount] FROM [qryHolidayHalfDayCount] UNION ALL SELECT [ResourceName],[HolidayCount] FROM [qryHolidayFullDayCount]; you would need to make your second column have the same...

Thanks for sharing Pat - MS doesn't seem to hold seminars like that here in Canada and I've been wondering about them since your post awhile back. About the firewall in XP, it is configured automatically when you run the Network Setup Wizard. To manually start it, go to Control Panel - Network...