Search results

Hi There, We are getting a database developed in Access 2010 and have been plagued with "ghosting " issues from the main menu command buttons. The developer cannot replicate this in his sytem and can't explain why it is happening or seem to come up with a definite fix. As he refines the code...

Hi All, We have some code in a Access2010 DB that runs query, creates a pivot table and then exports this to Excel. It works fine if the host PC is using Excel2007 or better but most of the PC's here at work are using Excel 2002/2003 and it just won't work. The query runs but excel will not...

Thanks for the answers - I can't beleive that there is not a simple fix for this in Access2010. There must be thousands of databases getting designed in Access that have this same flicker, refresh issue that end up looking budget because of this. One bad example is if you use the mouse to...

Guys, We are working on a complex database, based on continuous forms that seems to have issues with screen flickers and form refreshs when ever something needs processing, is changed or relates to code. The functionality is fine but it looks less professional than you would expect because...

Hi Guys, Can anyone advise if this is possible? We have a standard order form/subform with customer and delivery details in the main form and specific order details in the subform. I want the developer to include a command button that opens an EXCEL spreadsheet template and auto enters...

Thanks for the reply. As I mentioned the database never closes or opens? Can you elaborate on how to do it with a form? To be honest I have no idea. Thanks JohnG

Guys, We have a very simple, one table, access database attached to the backend of a peice of scanning equipment. We make thousands and thousands of scans every day and the database fill ups very fast and gets slow. We transfer this data into another program each day for reporting and...

Guys, I have a query that list records under the following three simple feilds Date Required, Currency, Total Price I want to get another query to sum these records into: Month Required Currency (grouped togeather under each month) Total Price (Summed in each month above) I am stuck on...

Got it going guys, was a modal pop up issue. JG

Anyone want to have a crack at this?

Nope, same result. The report is there sitting on the taskbar at the bottom of the screen but it does not / you cannot view it? Any other ideas JohnG

Hi Bob, Just the standard stuff that happened in the background with the command button wizard: Private Sub Command31_Click() On Error GoTo Err_Command31_Click Dim stDocName As String stDocName = "StockTakeQueryReport" DoCmd.OpenReport stDocName, acPreview Exit_Command31_Click...

I have setup a command button on a form to open and preview a report. The report runs and opens fine if clicked from the design page. But, when I click it from the form the report runs but then minimizes to the taskbar rather than filling the screen. I have checked the properties of this...

Populating a feild from other feilds to produce an "invoice product code" I have a manufacturing plant that combines ten individual component groups to make a finished product. I have a table setup for each "component group" with an index number, a short description and the full description...

Thanks guys, Finally got it working using: "C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe" "C:\Documents and Settings\Rotorua\My Documents\Database\DatabaseFrontEnd\Mactim.mdb" Good thing about this method for databases is that when the file is closed the session is auto...

Bob, How do you open a Remote Access session? Is there a better way to do this? If not can anyone else help? JohnG

Hi Bob, Sorry, I am new to this, so you saying that I type in exactly this into the connection area as attached photo: Shell "C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe C:\Documents and Settings\Rotorua\MyDocuments\Database\DatabaseFrontEnd\Mactim.mdb" If so, I still get an...

Hi Bob, Thanks for your reply. Still no go using: "C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe C:\Documents and Settings\Rotorua\MyDocuments\Database\DatabaseFrontEnd\MacTim.mdb" Here is the error message - different one this time: Its seems bizarre that I can get Access...

Thanks for the reply, I tried the following this morning but still get an error message as attached below. I have double checked the path and all seems to be correct. "C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe"...

As a side note I can get it to automatically open a blank access file using the following path: C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe But I can't get it to open an actual database file using: C:\Documents and Settings\JohnG\DatbaseFrontend\Stock.mdb Any ideas? Thanks...