Search results

Wiz, It is always good to recognize and aknowledge the help we get on this board (and elsewhere in life). Well done and thanks to all the many talllented posters who help us all.

Thanks RG. The time spent is very much appreciated and the comments will be useful. It may be that the structure of my form is clumsy in the it uses 5 comboboxes with some degree of cascading along with a frame select group. This give the form a high degree flexibility for quickly getting to...

Hi Catthi, Interesting. I like the lab idea and had in mind getting a mongrel with lab in him/her but from what you say, it might be an idea to go for a breed if buying in Perth. Out of curiosity, what problems could you find from a non Perth bred lab? Also, do you have any opinions as to the...

referencing still giving errors Hi RG, I have given the referencing a go and still have problems. I checked the spelling of my subforms and the code lines I pasted in yet the 2 versions of referencing both threw up the same error: Is it significant that the DB appears to be looking for a...

Lagbolt, That sounds like a cracking tip. I think this could have saved me many hours and reduced the number of circles I ran round in the development of my db. I will be saving this for later. :) Cheers.

Exporting the relevant bits to a new db was easier than I thought it would be and after striping out enough c*** to drop the size, I am, sort of, gratified that the problem persists :rolleyes: BTW, the DB throws an error when opening that it cannot change to the H drive. There is nothing on...

Thanks RG. the referencing looks like the answer I need to that problem. One day I promise to understand all this sort of thing but it is hard when you are in the middle of a redevelopment and 1 change cascades mayhem throughout the db - well it seems that way anyway! :) BTW, in your code...

It's probably a typo, but your code is missing the final quotation I think ("). Without thinking about this too much, I suggest you open tblhistory and attempt to add the a record exactly as it would be generated from your insert SQL. My guess is that you would get the same error suggesting...

Subform Blues - Data Entry setting itself to 'No' & Requerying 1 subform from another 2 Subform problems I have a data entry subform that is only supposed to show an empty record ready to be populated, and a display records subform that is supposed to show all the records. The subforms are...

I hadn't thought of that but I am hoping to get a dog with little or no aggression. Having said that, they are desceded from wolves and I have seen even the nicest of pets start barking furiously when another canine is within reach. Thanks for the tip.

Thanks Bob, works a treat For those that follow, here is the code I created based on Bob's pointer: Dim SectID, DptOrd As String 'Get criteria from column of combobox SectID = cboAssignPersonnel.Column(6) 'Prepare SQL to get DeptOrder from tblDeptSection SQLText = "SELECT...

Hi Rene, I think I see your problem and I was not answering it the first time round. The combo box can give you the field headings, as I described, but you can't select these as they are not data. What I think you want is to have a combo box with 2 selectable items which then go on to be used...

Hi Ubgu3, Not sure if this is what you are looking for but you can set a combobox to show the column heads. Thus when you click it, the Field value(s) are shown with the field name or whatever you call the field in the query the box is populated by. In this case, you would use the same name as...

Hi Travismp, Short answer, yes. :) I think the obvious route is to use comboboxes to filter a subform. Basically, you have unbound comboboxes populated by queries and the subform is filtered and requeried using the criteria from the combobox in the after update event. It get's more...

problem solved - thanks again RG. Tip for new(ish) players such as myself: I saved the document word version of the reference sheet RG's link goes to and used the find and replace on the instructions at the top: to substitute my form & subforms names for Mainform, Subform1 etc. This makes...

thanks folks. Some good food for thought. :) I like the idea of a mongrel from the shelter. The puppy walking and continued education sounds like good advice and a way to meet new people, not that that is an issue when you have small children. There is a dog walking club round the lake I live...

My children are 2 and 3 years old. Pretty soon (when we return to Perth Australia in the new year) I would like to get them a pet dog. The children will be too small to take any of the responsibility of looking after/exercising the dog so it will all be down to me and my lovely wife. That being...

I have a less foolproof solution to this than offered by the other gents that may be suitable to your needs. Various comment recording tables in my database have a 'CommentBy' field which is required. When the user makes a new comment via the subform, he/she must select an identifier (their...

Hi Peter, Thanks for responding. I haven't used ADO or DAO (other than when blindy cppying code). Could you give me a pointer as to what you are suggesting I try i.e. what sort of structure would my code take? Thaks in advance for any tips etc.

Thanks for the responses guys. MStef, I haven't made my situation clear - sorry. I am trying to run an SQL query in VBA. Bat17, The variable I want is not simply a value in a table. I am trying to pull the values from 2 fields in one table using an inner join and where clauses etc. I don't...