Search results

Did anyone pick up a Nintendo Wii yesterday or are planning on getting one? We got ours yesterday (after waiting in line at the store for 1.5 hours) and it's really fun! My arm is sore this morning from playing tennis for a while last night. :D

While I’m asking questions, I may as well see if anyone can help me with a problem that I still haven’t solved… In a class library, I’ve created a Find form that works like the search you’d find in Access (form pops up, you choose the field you want to search and it finds the next record)...

Hi, I’m a VB.NET newbie, so bear with me. I’m building a class library that I’m designing my re-usable forms in, and then inheriting them into my projects. The first base form I’m trying to make is one that will pop up when the user clicks Edit List next to a combobox (to obviously add/edit...

I've downloaded a custom control (a nullable datetimepicker) and it comes packaged as a VB project. I've added the project to my solution, but I don't know where to go from there. I've never used custom controls before, so how would I go about getting this custom control in my toolbox?

Is it just me, or is the whole house hunting/purchasing process really bad for your health? My girlfriend and I are looking for our first house and we just put in an offer on one an hour ago. I've been literally sick to my stomach all day (nervousness really gets to me) and my mind has been a...

Is there any way to keep me from being subscribed to threads that I reply to? Every time I reply to a thread, I get email replies unless I explicity unsubscribe to it under Control Panel. Am I missing an option in Control Panel?

I'm making my first data-bound form in Visual Studio.NET 2005 and I have my main table made in SQL Server 2000. I have a bit field named Inactive in my table, set to not allow nulls and have a default value of zero. I've then made my dataset in VS, and the default value does not pull through to...

Hi, I've been creating database apps for a while now with SQL Server back-ends and Access 2000 front-ends. We've just recently purchased Visual Studio 2005 and I'm looking to try using an ASP front-end instead of Access. The idea was to have the ASP app on our company intranet and thereby...

Hi, Our office (a medical clinic) is currently using a web-based calendar system (data hosted off-site). We're looking to change to a calendar system where we can store the data locally. Ideally we want to have a database on one of our servers and have a front-end on each client computer to...

Hi, I have a continuous subform with a checkbox and a textbox. If the checkbox is checked, I would like the textbox to enable. Since using code will enable the textbox for ALL the records, I'm assuming I need to use conditional formatting. The problem is that I'd like to set the Locked...

Hi, I'm having some problems with a simple query and it's driving me nuts. The invoice numbers in our system have hyphens in them, and I'm trying to find invoice numbers whose part before the hyphen matches a number I enter. Here's my SQL: SELECT dbo_NIHB_ClaimLog.InvoiceNum...

Hi, I have a question about counting the number of months between two dates. The user enters a Start Date and Expiry Date, and I need to make sure those dates are exactly whole months. For example January 1, 2005 to March 31, 2005 gives me exactly 3 months. But January 1, 2005 to April 1...

Hey All, I have two tables -- tblClient and tblAuthorization. I've made a form with tblClient as the recordsource, with a subform using tblAuthorization. Since only clients with a certain code (N-02) can have authorizations, I've added that as WHERE criteria on my main form (WHERE Code =...

Hi, I'm trying to run a query with serveral left joins and I'm getting #deleted in some of my results. Here's what I'm trying to do: I have a table called dbo_RA (PK named RAID). There are 4 other tables -- tblCheckIn, dbo_Quote, dbo_WorkOrder, and dbo_RACancellation (All with RAID as a...

Hi, On my form, I have a set of three comboboxes -- Manufacturer, EquipType and Model. Model is dependent on the two previous combos, so I've made it a cascading combobox. Here's the rowsource of cboModelID: SELECT [dbo_Models].[ModelID], [dbo_Models].[Model] FROM dbo_Models WHERE...

Hi, I've made a form in my database that's supposed to store scanned paper referrals we receive for patients. Its recordsource is an ODBC linked SQL Server table, with the ReferralScan field being of Image datatype (OLE Object when viewed in Access). The images are scanned using the scan...

I'm running into a weird problem and I was wondering if anyone else has come across it. I load my larger forms at startup, so when the user clicks the Exit button on a form, I just make it invisible. In that click event, I also check to see if there are unsaved changes. If there are (and the...

I'm trying to speed up my database a bit my loading all the forms at startup and making them just visible/invisible instead of opening and closing forms all the time. So when my splash screen opens, I'm opening all the forms with a WindowMode of acHidden. When the splash screen closes, I open...

Hi, I have a form that displays information about a patient. It includes a listbox showing all their interactions with us (their referral, calls we made to them, etc.). When I double-click on a row in the listbox I have the appropriate form come up based on the description field of the row...

Hey there, I have a table full of data, containing date segments for therapy data over several nights for each patient. I'm trying to figure out the total number of days of usage (they could choose not to use the device for a night or two), but doing a simple DateDiff won't work because there...