Search results

How do you guys handle having an error in a nested sub? What I usually do is have each sub have their own error handling that way I can have a variable that tells me where the error happened and use a global error handling routine, which when it's done running it closes access. My current...

I'm having some issues with conditional formatting on a form in datasheet view. The control in question is an unbound textbox. I have the following formatting set up: If field value between 25 and 29 turn the backcolor yellow if field value greater than or equal to 30 turn the backcolor red...

I have a question about a form/table setup. Table layout is as follows: tblEmployee ID FirstName LastName HireDate departmentID tblDepartment ID Department The relationship is a one (tblDepartment) to many (tblEmployee) for the life of me I can't remember how I'd go about showing the Name...

Won't be around tomorrow/sat so I figured I'd get it in early! And yes, at 28 I still believe in the man in the big red suit.:D

Hey guys, need some help with a DB that I believe is corrupt. Here's the details: DB - Access 97 vb.net front end DB size - 15mb I can write to the database, and I can read back most data from the database, however, I'm starting to have fields that can't be read from. I know that there's a...

Using visual studio .net 2002, specifically VB .net I'm connecting to a database made in Access 2000. I have Access 2003 installed on my development machine. I've done the following: created a simple form (1 listbox) using the toolbox I've drug over and configured an oledb data adapter. From...

Hey guys, If you've got some time, check out Marissa's Bunny it's a site for a little girl's family to raise awareness about a condition called infant spasms (much worse than it sounds). The little girl looks a lot like my little one and it really hit me hard about how lucky a lot of us have it.

I'm currently using PHP to pull data from a MySQL database and then display on a webpage using HTML. I've been reading about instead of displaying it using HTML, actually creating an XML document using PHP and displaying that instead. Where I'm having the problem at is the question "Why?" Why...

i'm updating an app written by the guy before me, and having a heck of a time. I used to develop in VB, but never done anything in VB.net i've updated the table with the new columns we needed updated the xsd with the new column headings updated his code adding lines for the datarows i need to...

Hello, I've developed a database for my lab technician, and was reading about all the virtualization that goes on in Windows Vista. I thought I had figured it all out, but I've obviously missed something. When I've updated my application all updates to forms, etc are being placed in the...

I'm trying to use the snapshot viewer control in VB .net 2003. I right clicked the toolbar selected customize checked snapshot viewer control (snapview.ocx) the snapshot viewer control shows up under the toolbox, but when I try to drag it to my windows form I get the following error: "Library...

Changing this to provide a bit more information, in a bit better way. I'm using Microsoft Access to use Excel Automation. What I'm doing is creating an instance of Excel, then showing the "Open" Dialog with the following code (may not be exact) Dim xlApp as Excel.Application Set xlApp =...

I have a database that automatically emails people based on different events etc. currently I have the email addresses hard coded, and have the following question. Is there a way that I can put a flag in a table to specify wether or not someone gets an email for a specific category? for...

so...I'm coming up on my subscription running out on norton and was wondering what some of you recommended for anti-virus software. I know I'm going to be avoiding norton 06 and norton 07 like it's the plague. I've been looking at AVG and Avast! and don't know how those stack up to a product...

got a question, and couldn't find the answer :mad: I have a combo box on a form, with some drop down values listed. however, when a preson clicks into the box they can type whatever they want, I don't want the combo box to do that. I don't want it to do anything at all if someone types into...

ok, I'm trying to programatically update a front end. I have a database that checks it's version, if it is out of date, it should open a utility database to copy the new front end down to the user, that's where I start to run into problems. I can never get the utlity database to open. when it...

I have a db that I have split out into a front end and a back end. The back end is on a network drive, and I have a copy of the front end on each user's computer. The issue that I'm having is that 2 people can open the front end and 2 cannot. When the database opens I have a form that loads...

I have a weird issue going on...I'm running a "Find Duplicates" query on one of my tables, I'm only checking for duplicate values in 2 fields and outputting a third. now this runs fine, unless I use the total's button to group them. When I group them that access instance stops responding. The...

I'm using access 2000, and have built a long form. My users would like to be able to use their mouse wheel to scroll down the length of the form rather than having to click the scrollbar. is there a way to do this? (I'm sorry if I missed this being answered in another thread, I looked but did...

Hi guys, I have a question I've been trying to figure out with no luck. I have 2 fields, companyname and zip, these 2 fields may have duplicate values or they may be uniquei.e. companyname zip billybobs 68135 dilberts 68137 billybobs 68135 what I...