Search results for query: *

So, this is driving me up a wall. This is a SQL Server 2005 database using Access via ODBC as a front end for some very simple data entry forms for an extremely short term project of limited scope. The relevant tables (or, really, an abstraction of them) are: TblRelations: RelID (PK...

I've never really had cause to use SQL queries in Excel before. Having made my first, I noticed that when I viewed the SQL, instead of the inner joins I'm used to seeing, there is a series of "where" statements that perform that function instead. If I edit the SQL to use inner joins, the query...

Apologies for the crosspost, but I was informed that this would be a more appropriate locale for this topic: Not entirely certain this is the best topic for this, but it seemed close enough. I'm fairly new to SQL Server, and I'm trying to migrate an Access (2000, though I doubt it matters for...

Not entirely certain this is the best topic for this, but it seemed close enough. I'm fairly new to SQL Server, and I'm trying to migrate an Access (2000, though I doubt it matters for this particular question) database. For the most part, I haven't had many issues thus far, but one fairly big...

I've tried Googling this, and I have seen several other people ask the same question, but I've yet to see a worthwhile answer (most people go, "hurf durf it doesn't work that way!" and they're demonstrably wrong, as I will explain in a moment). I have 3 PCs - Two desktops running XP Pro, and a...

Just wondering if there is a modulus function available for use in a basic select query in Access. For instance, if I wanted to pull out only my employee IDs that are evenly divisible by 4, would there be a quick way to do that?

I have a fairly simple script that prints some paperwork to pdf and then attaches it to an email to whatever address is on file for our customer. For the most part, it works quite while, except on one machine in our office. That machine returns a "library not registered" error on the first...

I have a form that is essentially printable paperwork. At present, it gets automatically faxed to customers, but I'd like to add email as an option. I have the scripting handled for pulling the email address and passing it through to Outlook, including the attachment. The only problem is...

It's actually XP home, but this looked like the closest I was going to get. My understanding is that this began immediately after some software was installed (user isn't sure exactly what, I think an image viewer of some kind). System makes it through POST fine and loads windows. The green...

I'm looking for a way (currently working on something in Access) to place part of a string into a variable. The string in question is a filename, and the format is going to be: TextThatIWant - MoreTextThatIWant - DateAndTimeInfo.txt I want to put the two seperate "text that I want" blocks...

Think I've posted about this before with no luck. Googling hasn't returned much either, at least with relation to Access. One of the machines in the office gets random application hangs while using access. Event viewer shows: Hanging application , version 0.0.0.0, hang module hungapp...

One of the machines in the office gets this seemingly random application hang with Access. It's an XP pro (sp1a) machine. Even viewer turns up approximately nothing - just that there was an application hang - the details (version number, memory address, etc.) are all returned as zeros, or...

Getting a rather aggravating error with some, but not all, reports and forms in an access database. The error(s): The instruction at "0x77f83905" referenced memory at "0x00000000". The memory could not be "written". Which is followed by... "The instruction at "0x77f58dc5" reference memory...

Is there an easy way to do this? It's annoying when, at the top of a page, I have a footer that belongs with a record on the previous page.

I was wondering if there was a way to do the following... I have a combo box using tblorders.description as the control source. The row source is a seperate table. Typically speaking, there are only a few standard things going into the field this combo box is used for. Every now and then...

I'm having some trouble doing anything with a field that wasn't used when initially creating the form. I remember this being not only possible, but relatively easy to do. I recall using table.field as the control source working just fine, although I could be mistaken. I have several controls...

In short, is this possible? For instance, in access, if I have three seperate forms that I want to print to a single print job (for the purposes of faxing) can this be done using vbscript?

I've more or less gotten all of my faxing from access issues sorted out - this seems to be the last hurdle I need to overcome. A little background to help clarify this question... When we send a fax (which we do manually right now), it consists of several documents that we print out of access...

Quick question... I took a look at that Access Archon fax demo, and it's nice and all, and I'll use that method if I have to, but I'd like to do something else. The form I want faxed, I want to be faxed literally (the access archon one more or less faxes the information, but not really the...

Is it possible to take a standard access print button and tweak it a bit so that it will print to a seperate printer, while leaving everything else still printing to the default printer for the PC? If so, is there an easy way to do this?