Search:

I'm having a strange error lately. A function that was working fine on my web app is now crashing for no apparent reason. It works fine on my local machine, but on my server I am getting this...

I am using VB/ASP.NET, and I just figured out how to install a Security Certificate and enforce the https: protocol.

I am confused about one thing, though. I have a login page which leads to a...

Hi guys!

I need a form that is created dynamically, and I was able to achieve what I wanted by using a DataList control containing some labels and textboxes.

Now I need a way to send, by...

Never mind this post--as it turned out, I stumbled upon the answer later in the day.

Once in blue moon I get a user reporting the following error: "Operation was canceled."

According to my app's debug info, the error occurs on this line:

rs.MoveFirst

I can't figure out why...

Thanks for the replies, guys. I bit the bullet on this one and just opened up a new recordset to query the Null values. Case closed! :)

Unfortunately, that returns error 3001: "Arguments are of the wrong type".

Any other ideas?

Does anyone know of a way to use the .filter method of an ADO recordset to filter on NULL values?

The usual syntax is:

rs.filter = "Value=10"

I want to do something like

rs.filter =...

Bumping this back up...

Thanks for the replies. I asked the user to double-check if he has permissions to access the file directory, and he said he did. As a test, he edited a text file on the remote PC (same file...

Hi guys,

I have a VB6/ADO/Access app and the situation is that a user is trying to access the database files on a networked PC. However, he is receiving the following error message:

Error...

Hi guys,

I have a VB6/ADO/Access app to which I'm now trying to add the feature to allow more than one user to share the DB.

I know Access is not really designed to be a multi-user database,...

Hi guys,

I can't figure this one out. I have an app, written in VB 6.0, using ADO, and connecting to an Access 2000 database. A user has been using the program successfully on his Win 98 system...

I see what you're driving at, but I think I should be OK in that area. What I did was set it up so that I have only one DB Connection, declared in a module. I then pass that connection by reference...

I have a follow-up question:

My current executable file is pretty big (a little over 3 MB in size).

Does anyone think I might fare better if I optimized for small code when compiling (instead...

Hey gang,

I released an app that's a real monster, with 30 forms and a ton of ADO recordsets going on. The problem is, some folks are experiencing system crashes when trying to use it, i.e....

Thanks for the tip mendhak! :)

Well here's a tricky one (for me anyways):

I have a line like this:

rs.Find "DESCRIPTION='" & strValue & "'", 0, adSearchForward

Straightforward code, works like a charm.
...

I've had this problem happen to me before as well, where I reached the ~1 gig limit and I could no longer add data. I think I kept getting an "out of memory error" or something like that.

Anyways,...

OK, after tooling around on the web for awhile, I think I finally figured this out. The problem occurs when performing calculations on decimal values stored in "floating decimal point" fields, such...

This problem is still annoying the heck out of me. I'm bumping this topic back up in case anyone has a solution.

Hallelujah! Thanks RobDog :)

Hi guys,

I have a project where I need to implement conditional compilation, but, since I have literally dozens of modules to work with, I'd like to declare the compiler constants globally.
...

I know normally the Now function returns time in the format

12/29/03 3:50:26 p.m. etc.

I also know I can return a number like this:

Cdbl(Now) = 37984.6608912037

I'm wondering about...

Hi all,

I am using MS Access for my db. I've got a simple table with some simple data like this:

RecordID, Field1, Field2, Field 3
1, 2.5, 14.9, 0.6
2, 6.7, 1.1, 2.7
3, 11.2, 0, 9.3...

First of all, thanks to everyone who helped explained the "Multiple-step OLE DB operation" error to me.

I have one more weird error I need help figuring out. It says:

"Consumer's event handler...

Well, it looks like you have a typo...

SET [# Of Detenetions]

should be:

SET [# Of Detentions]

hopefully this makes a difference?

What you're saying seems to make sense. The error usually occurs on some line like this:

rs![Field1] = Text1.Text

I'm pretty sure that the field types are appropriate; the weird thing is that...

Occasionally, some users of my db program receive the following error:

"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

I'm not...

Hi, I am using MS Access. Thanks!

Is there any way to modify a database field using ADOX? Or must I delete the field first, and then append it using the new parameters?

I don't know if this is world's stupidest question or what, but how does one add pictures to the menubar? I mean the small icons that appear next to menu items (like a little disk next to "Save" or...

Great :D Thanks for the help!

techgnome,

Your idea sounds like a brilliant solution to my problem. However, I am a little fuzzy on the implementation. I came up with this code to do what you suggest, but I was hoping you...

I know it's considered bad form to use a global object when you can get by with a privately declared one, but I have a tricky situation which has me wondering which way is better.

The app I'm...

Hey guys,

I am using ADO and I have a certain query contained in a recordset. I have a function for exporting the recordset to Excel, but before I pass the recordset to this function, I'd like to...

Can anyone reccommend a good 3rd party calendar control which can highlight dates using data from a database?

For example, say I have a recordset like this:

7/1/03
7/5/03
7/12/03

etc. I'd...

I believe the size limit for an .mdb file is just a little over 1 gigabyte. Keep in mind that the database does not shrink by itself when you delete records. I actually had an .mdb one time that...

Yep, Jackal's code was just what I needed after all! The other responses were also excellent (but were in response to a question I had misstated -- my bad!).

Thanks to Jackal and everyone else...

Thanks for the replies, but I actually made a mistake in asking the question! :rolleyes:

I meant to say round to the nearest multiple of 5, not "round up".

For example:

8 --> 10
6 --> 5...