Search results

Sorry about this. I have done what you suggested, and it still comes up with the same error. RTP_ID is an autonumber field (so numeric, yes). I have changed it to "' & Me.RTP_ID & '" but still no luck.

Hi I will give you an overview of what I have. I have a database that records sites in Blackburn and each site has a unique ID (RTP_ID). Each site has 10 objectives with 25 Measures in which the sites are scored against. Objective 1 has 2 measures Objective 2 has 8 measures Objective 3...

An error message now appears - "Run-time error '3464': Data type mismatch in criteria expression" and when I click Debug, it highlights the intcount = line. This is my code, I have done exactly what you asked (RTP_ID is the name of the field and text box, Tab 1: Factual is the name of the...

I think it would work, but stupid me has a table name with spaces in it, and I know you shouldn't have spaces in the name, but I don't know whether I can change that now, I have done so much and most of this database works... The table name for the second argument in the DCount is "Tab 1...

I have a search button on my menu form that, when clicked, asks the user to enter a desired Reference number they wish to search for. This works fine when it is a Reference number that is stored within the database. I have tested it to see if it works with reference numbers that do not exist...

Ruralguy: I have posted it up as two threads, but it hasn't been resolved in the fact that if I want to change some data on the first subform, the error message pops up. I have found, however, that if the fields in the main form are completed before entering data into the subform, the error...

Thank you! I found other things wrong with the form too, and it now works (in some sort of way). I have something else that needs help with - my search button. I have no idea how to create one, please help! I want to be able to search by ID number or postcode.

I tried that, but it then states this for some reason: "You can't assign a value to this object * The object may be a control on a read-only form * The object may be on a form that is open in design view * The value may be too large for this field" I have also made the stLinkCriteria the 4th...

This has been posted before, but I need to get an answer to it as it is for a tight deadline project at work. I have a Add New Record button, and code in an OnClick() event, as shown below. The thing is, when I click the button, it doesn't execute the DoCmd.GoToRecord , , acNewRec line, and I...

Yeah, that is what is so weird! I can't see what it is that I am doing wrong... Here is my code in the OnClick event: Private Sub cmdNewSite_Click() On Error GoTo Err_cmdNewSite_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "FRM_PRIMARY"...

Type Mismatch I have tried the code that you gave me, but when I click the button to add a new record, it pops up an error message of Type Mismatch and wont open the form to add a new record. It gets stuck at the bold code line above (third line) Can you help me?!

Oh, how do I do the search button? I'm not sure about that one... Can't seem to find anything in the forum about it in a simple view.

Ah right, didn't know that existed - very new to doing databases in Access and such on my own. I have had a little fiddle around with it, and it works. Thank you very much for your help - no doubt I will be posting something else up on the forums soon enough (next thing to do with it is...

Jonathan Rhys Meyers - Mission Impossible III

I would like to know how to write code to open up my main form (FRM_PRIMARY) on a new record so that the user can add a new site without clicking another add record button. Also, I have a button that will search for a certain record (using either the ID or Postcode of a site). How can this be...

aymanmb: How do you open a form when someone clicks the 'add' button so that it doesn't show the other records? missinglinq: To disable editing, does that code need to go with the 'View reocrds' type button? I'm new to writing code, so not too sure where this would lie, but it would really...

Oh yeah, totally forgot which forum I was in - sorry. And thanks for the help, I was trying to put an 'and' into the If Statement. It works now. Thanks

Hi, I have another problem with my Access database now... I am trying to disable fields when a certain value is chosen. I can do it for one field with this code: If ALLOCATION_LP = "Other" Then OTHER_ALLOCATION_LP.Enabled = True Else OTHER_ALLOCATION_LP.Enabled = False End If That one works...

Thank you for the help :) It works now, had a little help from someone in person, but they basically said what you did neileg. I know, I had totally forgotten the 'no spaces' rule for access, but i have redone this database so many times now that i just dont want to mess it up even more...

Hi. I am new to this site, and fairly new to Access itself. I am currently designing a database for work that allows people to store information about sites around Blackburn. There is one main form and 3 subforms inside of it. On Subform Yield Assessment, I would like the database to...