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...

I have the Link Child Fields and Link Master Fields as the same value, is this correct? Or is it one or the other

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...

The expression you entered refers to an object that is closed or doesn't exist. On the line with the Me.subfrmHazardRAMS.Form.count on. Thanks

The subreport is part of the form i am adding the code to, still getting an error. Please see attached

The Recordset code has also given me an error on this line : (Attached)

The If line with the code you gave me have the error

still the same error :(

Thanks for the reply, getting this error.. Image Attached

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

Thanks for the reply They are unbound, im running an SQL INSERT using their values. Do they need to be bound?

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

Perfect, thankyou :)

I have a button that when clicked populates with listbox with everything that it ticked

Yes that sounds sensible, where in my code should I put it? which event? That is all im struggling with :) cheers

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, thanks for the reply The Server Filter is created with VBA after if statements, and example of one is below : If Me.lblStatus.Caption = "Un-Assigned Items" Then strServerFilter = "CompanyID = " & Me.CompanyID & " AND ULN IS NULL AND LocationID IS NULL" btnAddItem.Visible =...

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 :)