Search results

Hi Guys I have developed quite a large database within Access 2003, with alot of VBA. Having finally decided to move to Access 2010, I have opened the 2003 version on 2010, everything seems fine apart from some subforms having '#NAME' in the fields, but in the 2003 version they are fine. Any...

Hi Guys I've got a really long report that I need to print out, I've used the method of adding multiple reports onto a single report to that when it opens/print it does this for multiple pages, there first few were fine, now that I have around 9 subreports on the form, the subreports aren't...

Hi Guys, I am wondering if it is possible to have a button on a form which asks you to select an image from a location, it then takes that image and moves it to a location of my choice? Also, would be nice to have a preview of the image on the form, maybe asking a little too much! Any ideas...

Hi guys, been playing around with VBA on how to check if a subform has records displaying in it or now, i've tried things like if Me!subfrmHazardRAMS.Form!RecordSource = "" Then. Just getting error.. Thanks in advance

Hi, I have got a subform which has done data pulled in from a table, and the rest has text boxes for input. Whenever I put a value in one text box it changes the value for all of the other records. Show Below (attached), any ideas why? Thanks In Advance

Hi I have a listbox on a form which has text values put into it when a checkbox is ticked, I also have a save button underneath it that executes an SQL insert statement. I need the save button to not be visible/not work when there is nothing in the list box or where there has been nothing put...

Hi I have a form which contains two subforms, these forms are filtering from a big data source and when the form is loaded, the page flickers and the subforms flash visible and unvisible for a few seconds, after this the data loads fine. Any suggestions to reduce this? Thanks

Hi all I have just finished my Computing degree and started a trainee systems developer role for a company who extensively uses MS Access 2003 & SQL Server for in house Database needs :)

Hi could anyone give me some reasons why this error is occurring? see attached :) thanks

Hi Guys, I have a listbox on my form in access which holds strings, how do I insert these items into an SQL Database (Table)? Thanks :)

I have a table which has an ID and 45 other columns each referring to a module. I do not have the room to binid 45 objects onto the report and also there will only be around 15 NON NULL values which need to be printed on the report. How do i populate 15 text boxes with only NON NULL values and...