Search results

I am trying to go to a specific record in a recordset (on a form). In the past I as using the typical open the form and use the filter to go to the specific record: strLinkCriteria = "Where ID = 5" Docmd.openform "frmName", , strLinkCriteria This takes me to the correct record, but filters...

I have a report that previews and prints correctly for myself. When one of my users previews the report and prints it, it prints out just over the page width. So the 2nd page is blank (except the very edge of the line) and the 4th page, etc. This is from the same database, and the same...

Never mind, I was in the wrong section, and searched the "Forms" section and found what I was looking for. My bad. Mods you can delete this thread. Sorry to all.

I have a form that is too large for the screen (the users wanted this design). The problem is the users instictively use the mouse scroller to try and scroll down the form. Which in MS Access actually just moves to the next record with each mouse scroll click. Is there anyway to turn off this...

Thank you for the response. Hmmm, I will ask the users which they would perfer of the two (explaining the advantages/disadvantages of both). Do you not believe it to be possible through the list box?

I have an MS Access DB, that uses a list box to give users a view of the possible selections to choose among. It works great, but the database has grown to the point there are nearly 3,000 items in the list box. I found that if you type in the first letter, it will take you to the first...

Thank you very much, this worked perfectly. How very convenient. :cool:

I have searched and not found a way to do this. What the users want is basically: 1. Mr. Adams 2. Mr. Bradley 3. Mrs. Johnson 4. Mrs. Smith I am not sure how to the the number on the left to appear on an MS Access report. I will keep searching and trying different things, if I come up...

There is a database, which I did not create, but is giving some users errros and I am trying to trouble shoot. It is using some nicely designed Bound Frame Objects to displayed the Adobe file Icons, then once double clicking on them, the file opens in Adobe. For some reason the Adobe "Package"...

I just wanted to post another follow up problem with MS Access 2003. I have the same database file that displays the record number and record count of the form in a text box. This works perfectly in MS Access 2000, but when the same file (or a 2003 converted file) opens the database it no...

I have also found the "RecordsetClone" method does not appear to work in MS Access 2003. I have a text box that displays the record count of a form. The code for the text box is... ="Record " & [CurrentRecord] & " of " & [RecordsetClone].[RecordCount] It works just fine in MS Access 2000...

Ran into a major issue today with MS Access 2003, or at least the .ADP projects. I have a .ADP database that has a Stored Procedure as its record source. Once the user selects from the first drop down list box, many of the fields on the form are automatically filled out, and then the record is...

Perfect, and thank you!!! Thanks to all the help on this message board, an ADO beginner was able to build a small ADO only MS Access database to proto-type for my boss. It is his decision if we move forward this way, now he can see what this offers for him. Thank you again!

Thank you again. I played with it, and got the records to append from the recordset into the table I built. The only problem I have left to resolve is supressing the message that says "You are about to append 1 row(s).". If I can supress this message I am finished with what I needed. The...

Thank you very much! You were correct, I changed the rs.RecordCount to rs.Fields(0) and it showed the correct results in a message box. I am estatic!! I got one more question (and I hope this is it). I have been able to connect to my database and correctly bring back the results I wanted...

Thank you for your help. I tried what you recommended, and it gave me the same results (which I completely forgot to include in my first message). After running this code, a Message Box opens up and is to display the recordset record count. Before I changed the connection string, and now...

I am working on an MS Access database that will connect to an MS SQL db back-end through ADO code only (no constant connection), so I am using connection strings when it is needed to pull back data, other wise it is not connect to the back-end database. I am trying to get the code correct, and...

I wasn't sure where to post this, so I thought I would try under the general section. I have an MS Access .adp project that I have different users working against. A user called me this morning and said she could not get into any of the forms that displayed data. I went to the very same file...

Thank you The_Doc_Man I found a website listing the .dll's files required. My machine has all the .dll files. One of the machines that works has 2 of the 3 .dll files (but works just fine). The machine that does not work has the very same set-up, with 2 of the 3 .dll files, and it is missing...

I have created some Crystal Reports to open out of MS Access. Everything works great for me and all the users, except one. The one user when they try to open the report gets nothing (no error, no lock-up, nothing). It is only on their machine (we have tested them logged into other machines...