Search results

Hello again Le, I have put a right join from PersonnelNo to OccProfileID now. However, when I run the query it list everyone but strips out the Business and Business unit for some reason. If you remove the link and run it with no link it lists everyone with all details as normal. Still...

Hello, I have been trying to produce a front end for a multi criteria search. I have used one of the sample databases from the site and amended the code as necessary, but obviously not correctly. I can't get it to show me the records based on my search criteria. I would be grateful if...

Ken, Sorry, yes I tried the column thing, but no luck. I have tried a text box as well but I get the same result - blank query. Maybe there's a problem with a link or something somewhere. I don't know. I'm trying some of the smaple databases just now to see I can get any results from them...

I have just followed this: http://support.microsoft.com/kb/209261/EN-US It is supposed to be able to show all records including null in a parameter query. I have followed it by substituting my forms names etc and my query still comes up with no records despite selecting a location. This is...

I have them all set up as two columns, but the first column width is 0" to hide it. The row source for each combo relates to their parent table i.e. business, business unit and location. All are two column tables Auto ID and Business etc. F

Just tried and I get nothing for each one. Blank results. Still don't know why.

I have set up a query to give me details of employees names, the business they work for and where they work. If I run it without criteria I get all of my records, as you would expect. However, I want to be able to select parameters from combo boxes and then run a specific report of employees...

I'm on a roll now. Everything is working as I want, thanks to you all for your help. Much appreciated. Time to figure out more advanced reporting. I'm sure I'll be asking you other questions shortly.

Me again. I just worked out what it is - it's the numerical value at the end of the line: MySQL = "Insert Into tblToolGroup(Tool_Group, ID) " & _ "Values(""" & NewData & """,66)" I didn't realise the number was the actual value this line added to my ID (autoinumber) line. As...

John, Your right, I did appreciate a quick answer. Very much so, and it is 'he', except on weekends or special occasions. Only kidding, ok I changed that line to: On Error Resume Next As you requested. I also tried taking it right out but either way I now get know get - Error no 3022...

Hello again, I have modified my code to the following: Private Sub cboToolGroup_NotInList(NewData As String, Response As Integer) On Error GoTo Err_cboToolGroup_NotInList '-- We may need to add another tool Response = MsgBox("[" & NewData & "] is not listed as a tool type..." & vbCr &...

Problem solved. I have lumped all of the calculations together into one query and it runs fine. Thanks for narrowing it down to the query, I couldn't see why the query didn't allow it at first. I've checked it and allows me to add new data so it's all good. Thanks for all your help.

OK, I'll try and explain what these queries do and see if I there is a work around. qryTestData was the main query. Values for measurements of vibration X, Y and Z are enetered directly into these fields. I had to set a query as I wanted something to calculate the sum of these squares, called...

Ok, here we go. Followed your instructions and managed it this time. Thanks for being so patient and helping me out here. Fraser

I would love to but I just can't get it below 380K. I can't get it under 850k at the moment without stripping out essential parts to this particular problem. I think it must be something to do with my relationships. When I was cutting it down it wasn't deleting the sub records related to the...

Thanks, I have checked 'Data Entry' on the form properties and it is already set to 'No'. I'm stumped here and I can't move on until I find out what I've done. I never changed any properties of any of the forms. I had only made a couple of new queries with calculations then used one query to...

Hi, I have checked the properties for my subform and cannot find the 'Add Allow' line you mentioned. I can see 'Allow Filters', 'Allow Edits', etc, all of these are currently set to yes. Don't know if that makes any difference. I'm using Access 2000. Could it be called anything else?

Thanks for this, this is superb. I'll add this in to my DB, thanks again. F

Thanks very much for all your help, very much appreciated. Particularly my first proper guidance on coding anything. I'll give that a bash shortly, hopefully it will all go according to plan. Thanks again.

I'm back. Here's my code: Private Sub cboToolGroup_NotInList(NewData As String, Response As Integer) On Error GoTo Err_cboToolGroup_NotInList '-- We may need to add another tool Response = MsgBox("[" & NewData & "] is not listed as a tool type..." & vbCr & vbCr & _...