Search results for query: *

I declare the recordset with the following line: Dim rsCurr As New ADODB.Recordset I did put in your suggestion of testing the editmode of the recordset. Hopefully this helps (heck, it can't hurt). Like I said, this is a sporadic error, and therefore is difficult to test. For now I'll see...

Oops, sorry....disregard the previous post; I forgot to include the code that finds the current record. Here you go. '-- Open the ADO connection sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" sConnect = sConnect & rsDBPath!be_db_location & ";" conBE.Open sConnect rsCurr.Open...

Here's the code I'm using for the ADO recordset. Basically, the code cycles through all the controls on the form, and since the names of the controls are the same as the corresponding fields in the table, an update can be made to the recordset based on a reference to the control name. After...

Thanks for the reply! As I stated in my original post, the .Edit method appears to be available with DAO recordsets, not ADO recordsets which is what I'm using. The .AddNew appears to be available with ADO recordsets, but this error occurs when I'm editing a record, not adding one. Any other...

OK, this error has been SUCH a beat down. I'm using Access 2000, and manipulating the contents of an ADO recordset on an unbound form. Sometimes when I get to this line: rsCurr.Update I receive the error in the title of this post. The few solutions I've seen don't apply to my situation...

Hi all, There is a folder on our network drive that I'm reading into a Folders object (through the use of a FileSystemObject). There are 5000 files in the folder, and I'm only looking for the latest set of them based on the date created/modified property of the file, which is how the folder...

I just wanted to thank everybody for the code postings on this thread. I've been trying to figure out how to email Notes emails through access for awhile now. The code on this thread will enable me to move forward with my project, so kudos to everybody! Thanks so much! jender624

Excel is a good tool for calculation analysis and format to make the data look "pretty", but I don't think I would suggest using it for long term data retention. Here are a couple reasons: 1. If this is a multi-user database, excel wouldn't be a good bet because a worksheet can only be...

That did the job. Thanks! jender624

I have a field that I have a custom input mask on, like this: __-____ There are two basic types of formats that it can hold: 123-4567 9W-1234 As you can see, the string before the hyphen can be 2 or 3 characters. I want to right fill the field when data is entered, instead of left filling...

I've seen it - haven't played around with it yet. I was thinking that I could somehow create a field with the query that I'm feeding the subreport with, and set the value to a 1 for the first 16 records, a 2 for the next 16, a 3 for the next 16, etc... Then I assume that I could include the...

This one has been driving me crazy. I have a subreport on a main report that lists identification codes (data type text). I need the subreport to force the main report to print a new page per increments of 16 codes. I.E. there can be a maximum of 16 codes on a page. So, 1 - 16 would be on Page...

I'm using 2000. I think I can use the information provided on the web page you listed. Thanks, this was just was I was looking for! jender624

How do I get the printer that my machine is connected to through vba code? Thanks, jender624

I think I found a way to do this. As opposed to directly trying to set the event procedure to call a function, I'm setting it to call a macro which in turn calls the function I need. This seems to work. Thanks again. jender624

Thanks for replying! Maybe I'm not being clear. I'm trying to do something like this: For Each ctl in Me ctl."MouseMoveEvent" = "FunctionName" next ctl I'm just not sure of the syntax to do something like this. Is it possible? Thanks, jender624

I'm trying to loop through all the controls on my forms, and set the mousemove event to call a function through code. I don't know if/how I can set the mousemove event to call a function, however. Is there a way to do this? Thanks, jender624

Awesome! Thanks so much for all your valuable feedback. I'll start getting myself smarter on the linking situation per your suggestions. Have a star! jender624

Thanks for all your input, Richard! I did originally check out an Oracle solution, but the manager I'm creating this app for didn't want to pay the support costs within the organization if he could get by this way. I did like your suggestion about only connecting to one table to check the...

I have an Access application (frontend and backend) that I'm developing for a target user group of approx. 130 people. I know, I know, access can't handle that kind of load. The compromise that I'm using is limiting the number of people who are logged into the application at any given time...