Search results

Thanks RuralGuy. I checked my demo project and that box was checked. The box in my dmb was not checked. Put a check in and it didn't seem to make any difference at first but after closing the project once or twice my debugger is back.:) Dale

Hello All, Has this happened to you? I'm pretty new here and was working my way thru some code (Using Access 2000) when I tried using breakpoints. When I ran the code it does not stop at the breakpoint and I am not able to get the variables' values by hovering the mouse. Closed that project...

I sure hope this is not one of those "well you can't get there from here" problems.;) D

Thanks edtab, that sounds like a plan, but I think there are a few steps in between that I still need guidenace on. The ID field is an AutoNumber data type and so I get a error message about value entered is not valid when I try to enter part of a city name. D

Is it possible to get a combo box control (in Access 2000) to accept a string of characters not on the list and then as a result to run a modified query employing that string of characters and displaying a reduced list from which to make ones selection? Column 1 in the record ID and column 2...

Thanks for the response RG. I only want the pcID value to be stored and written to a related table when the form is saved. But, your response did cause me to look at the help for the BoundColumn Property and at the very bottom of the remarks portion was the reference to the AutoExpand...

Is there a way around this occasional problem with and combo box using a select query in Access 2000? The query in Row Source is: SELECT [qryCSZ].[pcID], [qryCSZ].[pcCity], [qryCSZ].[pcStProv], [qryCSZ].[pcZip] FROM qryCSZ ORDER BY [qryCSZ].[pcCity], [qryCSZ].[pcStProv], [qryCSZ].[pcZip]; The...

Never Mind... Need help with DLookup Function While everyone was taking a few well deserved days off, I kept googling and found the solution : strMemberCode = DLookup("[tyMember]", "tblTypeCodes", "[tyTypeCodeID]=Forms!frmAddEditMemberListings![cboTypeCode]") Divit11 :confused: I am having no...

Thanks Pat for the reply. I was hoping to be able to have some realtime response when the user opened the word doc. Next best thing, I guess, is to provide the manual already printed. That will be almost as good. Divit11

Hello all, I am trying to create a users manual to be used with my newly designed database. I think it's pretty user freindly already but if one hasn't spent hours with Access manuals they may need some help. Anyway the Relationship Window is a handy way to understand what is in the database...

Thanks Doc for the reply. I had no clue as to where in a query that should go. So I clicked on the Help Menu and it wasn't long before I found the subject of Format and Input Mask properties and the topic "Should I use a data display or an input mask?" :o It says there in the fine print...

Still no idea? Is there another board or forum that might be able to answer this question? Divit11

Hello All, I am just beginning to work with Access 2000 and though my first address book database seems to be working well by itself it does not want to play nicely with MS Word 2000. The current problem is that data seems to be merging into my Word documents in lower case (yes, the data was...

Paul and Neil, thank you for your solutions. The SQL syntax was totally foreign to me but I was able to focus on adding that to an additional field in my select query. You could have told me all that but then I would not have had the benefit of finding further explanations and samples in one...

Hello All, I'm just beginning to work with Access 2000 and VBA. I've been reading a lot of your threads and have been able to incorporate some of your solutions into my first address book project. Do you remember those early successes? Well, I wanted to do a mail merge using MS Word 2000...