Search results

I have the following code and have highlighted the issue part in red. Basically the code works but when using the highlighted string I get a data type mismatch error. If I replace the string with a reference to the txt box then Access pops up and asks for the ID at which point if i enter it then...

I keep getting "Data Type Mismatch" Error on this code. If I reference the txtbox directly Access always prompts me for the value. If I reference the value as a string I get the datatype mismatch error. Apart form that it works! Been trying to solve for a few hours so any advice greatfully...

I keep getting "Data Type Mismatch" Error on this code. If I reference the txtbox directly Access always prompts me for the value. If I reference the value as a string I get the datatype mismatch error. Apart form that it works! Been trying to solve for a few hours so any advice greatfully...

I've attached an updated Db which I'm rebuilding but trying to be more careful and simple in approch.

Thanks Bob, AS I'm getting deeper into it I consider it a step forward to be answering these sort of issues. As I understand it, normalization is primarily about doing away with replicated data in numerous tables and conforming to various standards of normalization - I think to some extent is...

Thanks Guy's for your answers. I've been working on this Db solidly for a week now day and night so its all getting a bit gray! I've rebuilt it normalizing it as far as I can see possible. The code works but seems to delete all the data from the tbl so will have to look at my code a bit more...

Hi All, I'm using the following code which throws up a WHERE error. Am a bit stuck and wonder ifd anyone can point me in the right direction? Thanks? Dim strSql As String strSql = "DELETE FROM TblPrimaryDataCorCoursesLink WHERE (TblPrimaryDataCorCoursesLink.PrimaryDataIDFK =...

Thanks for the comments. And yes if comments (and reasons) are suggested then am happy to take it form the experts who know better than me. Which would be grat and then one will be able to pass it on. However, I'm not into normalization for the sake of it. Tables, Columns and Rows are free of...

That could well be the case. Since my post used the following systax which works. Debug.Print Me.LbEnquiryDesk DoCmd.OpenForm "FrmContactForm", , , "[EnquiryID] = " & Me.LbEnquiryDesk, , acWindowNormal Thanks, I'll have to compare the two in detail.

Thanks Guys. I've tested the code and it is correct: DoCmd.OpenForm "FrmContactForm", , , "[EnquiryID]" = " & Me.LbEnquiryDesk, , acWindowNormal" This produces the right value in the immediate window but still the form doesnt open to the correct filter Thanks for the adjustments but they...

I have a form "FrmEnquiryDesk" There is a double click event which should open form (which it does) FrmContactForm. When I created the listbox on FrmEnquiryDesk I set it to store the EnquiryID so that on a DblClk event it would open the contact form to that ID. The issue I cant seem to find...

I fixed it. I was using 1 and 0 where should have been using True or False. Now it works. 'Level One Interest If Me.chkL2 = True Then Dim VarLevel As String VarLevel = DLookup("[CourseNameID]", "TblCourses", "[DbDescription] = 1") Dim strSQLChkLevel As String strSQLChkLevel = "INSERT INTO...

Thanks for looking and your reply. I think it may have something do with the Vba code where using If and a number relaqting to whether a tick box is on or off using 0 or 1, i think that may be an issue. The code worked before albeit inserting into the link table irrespective of whether the...

I'm using some Vba to record enquiries. Each enquiry may have one or more courses associated with an enquiry so I have a many to many relationship setup with associated code but when using some code to see of a course checkbox is actually cheked since then the code does not insert into the link...

Yeah, It sure was! Thanks guy's.

I've attached a copy of my Db. I'm trying to setup an enquiry system where I'm recording enquiries against courses. Many enquiries can be linked to many courses. The issue I am having is that when I try and create a one to many relationship between the CourseID and the CourseIDFK in the link...

That worked! Great and thanks will have a look into that and also post a copy of the Db which might be of use to other users.

Hi Nidge, thanks for that and have ran some tests. the msg box shows that the select statement is trying to call the correct data but its just not showing up in the listbox.

Hi and thanks for replying. Id already try that but it made no difference. Interestingly, if I remove strCriteria from the end of the line of code the listbox shows all customers. (strSql = "SELECT CustID, CustName FROM TblCust" & strCriteria) Its only not working with that strCriteria. No...

I'm using the following code to allow users to populate a list box. It works and performs as expressed when the txt box in blank but doesnt populate the list box when it should be. Any advice? Much appriciated. Private Sub cmdSearchCust_Click() Dim strSql As String Dim strCriteria As String...