Search results

What can you see in design view? form headers/footers/detail is all your form in the detail section? have you "sized" your form accordingly? Not everthing is taken care of when you design a form in access it is up to you to make the form "as you want people to see it" so have a play with...

Just to get this straight you are trying to open a form containing the data you wish to display from a form that has a combo box to select the SrvID? If so then the correct syntax would be: Private Sub Completed_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As...

Edit: Didn't read the question properly just spotted the use of stLinkCriteria.... Try: Private Sub Completed_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stLinkCriteria = "[SrvId]=" & Me![SrvID] stDocName = "frmSurveyResponses"...

Without seeing what you have actually done to modify the sample database its hard to advise as I suspect its in the structure of your new forms and/or tables/queries that is causing the problem and not how it "refreshes" How exactly have you added another "page" (assume you mean form) what is...

This might sound harsh but you have a forum full of answers and this is for an exam you are presumable taking to end up with a qualification in this subject. So it would be I believe unethical for anyone here to "do your work for you" if you run into a specific problem I am sure many will be...

Say you had 2 related tables one was part the other shape, You have PartID and ShapeID with ShapeID being a foriegn key in Part table. So you could have 3 defined shapes square ID 1, Circle ID 2, Triangle ID 3 but many parts using this table. So you get: Part 1 Shape 2 = Circle Part 2 Shape 1...

Personally unless the form (opened from the orginated form) is going to returned to after entering data I would close it not just because of performance but why keep it open? You may want to enter subset data then refresh/requery a "main" form after closing but anything else is just something...

Because it is no longer a "normalised" database and in my view should not be an option at table level it causes many problems later down the line...

If you want to demonstrate it on machines without access then download the Packakging wizard and Access 2007 Runtime from MSN. http://www.microsoft.com/downloads/details.aspx?FamilyID=d9ae78d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en (Runtime)...

I had similar problems with a Server 2003 installation and found that setting the database up in its own root directory solved the problem of record locking (obviously setting the permissions on the directory as required) Regards John

From the start "globe" you should see a button at the bottom for access options click that then goto the advanced tab scroll down to the advanced sub heading and you have the default open mode, shared or exclusive. Hope it helps John :)

Sounds like a network problem and not an access problem assuming that the settings in the database are to open as shared and not exclusive. Is the backend stored on a network drive that is mapped on all the local machines connecting to it? Have the relevant permissions for people connecting to...

The select query or Dcount would be in your before update event..

You need a select query or Dcount to check your table first but would need to know more about your table structures etc.. before offering specific advise

Why not have another control on the form that shows who the record was created by that way your combo is restricted to current list but you can still display historic data?

Front and back end just refer to "splitting" the tables that contain the data from the rest of the database. There are several reasons for this a few being easier deploymet over networks (you give everyone a copy of the front end containing forms, reports etc..) and point their copy via linked...

Just an idea but I suppose you could use grouping by the store ID in the report to "force a new report for each store" this would create one long report with all your stores in. and use between dates to limit the information in the query. Still with 300 stores going to take a while to shunt...

^^^^ Was just about to edit again and say that thanks RG :)

What type of field is "Fitting" yes/no or text? Also where have you put this, have you created that using an expresion builder as you have an = sign before the if? Would be better in the afterupdate event procedure of the [Fitting] control might look something like: If Me.Fitting = True Then...

You need to create an event procedure you will see a button with 3 dots ... click that and select event procedure then type in something similar to; DoCmd.OpenTable "your table name here" Alternatively look at the event procedure of the command button/hyperlink that you want to emulate and...