Search results

Pat, I don't want to use a recordset, I just don't see how I can manipulate the subform records without one. I want capability from the Parent and sub form that comes with a recordset (e.g. MoveFirst, Move -2, FindFirst). If there is a way to do this without a recordset, I am delighted! But I...

Lynn, I go back and forth, right now the subform is tied to a query. The program is for a single user. There is a 'Backend' with the tables in the same folder as the program dB.

Lynn, I do not know what "dbo" is but it also returns an error 2467 The expression you entered refers to an object that is closed or doesn't exist. Does this "dbo" need to be declared and set? What is it for? XP VB Help is telling me nothing. I appreciate your help!

Hi! The SQL is to a linked table. I do not understand your syntax but XP is not recognizing it. I would have put this in a list box except for the fact that I must modify and delete these records. Most of this problem would go away if I could just manipulate records in the subform as it is...

I should add this point of context, as I could be way out in left field as to what I need. My only reason for wanting to create a recordset in the subform is a belief that I could then control the display of records. Before I began fiddling with the form, it worked fine except that the...

Pat, Thank you for your response. I am working in Access XP. I've read your response several times and looked at my form/subform. I've tried a variety of approaches but none very successful. At this point I am attempting to assign a recordset to the subform in the OnOpen event. The main form is...

Hello, This is a fairly lengthy post. My apologies. The context for my questions is a form that opens with a listbox full of some 60 room/household area names and a subform where a user can place names selected from the listbox in descending order of selection. Names are added to the subform...

Jack, There is not enough information in your message to help. Can it be assumed that: 1) This concerns the source for a combo box 2) You developed a program on it and migrated it to other PCs If so, then did the combo box work on your PC prior to migration? 3) Are the other PCs are...

I searched the other Access forums I have links to and Google newsgroups. This does not seem to have been a problem for anyone else. Interesting.

But it runs with MS Basic Visual Basic for Applications Extensibility which is in the Tools/References list. I removed the check on the 'missing' line and found the other.

I downloaded Steven's TabColors (link referenced above) and could not run it in A97. On opening the form received the following for both forms in the MDB: Compile Error: Can't Find Project or Library I find that I do not have in A97 the reference: MS Basic Visual Basic for Applications...

A LogiTech Marble Mouse is not a Wheel Mouse.... Here I am, closing in on the final scenes of this act in the development of a commercial application. Testing and debugging a form for the wheel mouse. Have I been successful in disabling it? I use a Logitech 4-button Marble Mouse (Model...

Ghudson thanks for your reply! Sorry to take so long. I got a compile error in the Private Function that was 'fixed' when I removed the 2nd ByValue in the arguments. I'm not sure this is right. But with this change and adding the two module sub-procedures, the code does run. But it returns the...

ghudson and Oldsoftboss, Thanks for your comments! I think I did not make myself clear enough. I am designing in resolution 1024x768 and 32-bit True Color. I did start in 800x600 but found, for me using the Litwin/Getz resizer, that the forms were too small in the highest resolutions. Since...

Standard Form Colors for All Windows PCs ??? Hi, I hope this turns out to be an interesting question for some of you. I am currently programming in WinXP/AccessXP. When developing a commercial application, it may end up on a win98 to WinXP O/S with monitor resolutions and RAM varying greatly...

Boy, I did not intend to let this hang open for so long! I solved the problem about 3 weeks ago. The form was corrupt. I created a new form, copied the objects from the old to the new. Copied the code behind them next. I then changed the form name to the production one and had no more problems.

I am developing in Access XP but keep A97 around for sanity. In this case, I changed the Application Title in XP Tools/Startup but when I open the dB, brackets ([]) are added at the end. Rooting around, I found VBA code to change the title. But this is also causing these []s to appear. The...

Well, the code in my previous post is working pretty well now. I do not know what made the key-presses I found not working to work. I did steal some code from ghudson for the CTRL + F4 as a separate If Statement: Select Case KeyCode Case vbKeyF4 If intAltDown Then KeyCode = 0...

This post relates to disabling special Access key actions from user control. Continuing to experiment and test, I came up with the code below. It is in the form's KeyDown event. The code on early inspection works for all but 3 of the case selections. I don't understand WHY it does not for CTRL...

Shift Argument & Bitwise Math Shift Argument & Bitwise Math I have a need to constrain the use of special keys in my program. The search for a proper approach has led me to the form's OnKeyDown and OnKeyUp events. Studying various types of code to handle keyboard combinations led me further...