Search:

As I understand it I first need a Sybase ODBC driver
where can I get this?

Any other help/hints/pointer welcome. Totally lost.

Thanks, DaveBo

BEGIN CATCH
INSERT INTO AA_ErrorLog (
ErrSource, ErrLine, ErrNum, ErrMsg, Az_ID, Last_Name, First_Name)
VALUES(
ERROR_PROCEDURE(), ERROR_LINE(), ERROR_NUMBER(), ERROR_MESSAGE(),
...

I'm running a stored procedure (SQL Server 2005) that's doing an Insert Into a table.

The table has a trigger that is using RaiseError because a value is invalid.

The problem:
When I run the...

Thanks, that's helpful. The CodePage field from that "Character Recognition" table seems to be what the specification FileType wants in it.

Somehow, when doing a manual import and creating a spec...

I'm trying to generate specifications files in Access automatically (in code) to handle different formats of CSV files.

i.e. I read in the 1st line containing the column names and then create a...

Si_the_geek, Thanks!
That will work even better. And I think you're right that it will be faster.

DaveBo

We're using regular expressions quite a bit here on SQL 2000

I'm not sure where we originally got the functions from, but
see http://www.ecodebank.com/details/?catid=16&catsubid=0&nid=142
or ...

No, I'm looking for a "regular expression" for this,
so I can incorporate it in a SQL query, etc.

Thanks, DaveBo

Brucevde, excellent. Just what I always wanted (sort of)

I'm going to have some fun, and maybe even do something useful, with this.

Thanks, DaveBo

Is it possible to Exec a dsql statement and return a simple value to a local var? e.g

Set @RecCnt = Exec('Select Count(ID) from tblContacts Where FirstName=''David''')

This doesn't work, and...

Actually, for an Access form I think it's .Repaint that does the graphical redrawing of the form

Could someone clarify the difference between the me.refresh & me.requery methods on an Access form that's got fields bound to a table?

What's the difference?
Should they both be used? and when?...

Got it using Dynamic SQL and COL_NAME() OBJECT_ID() functions

Declare @sql VarChar(4000) -- storage for dynamic SQL string
Declare @tbl VarChar(100) -- opt. var for table name...

Any regular expression gurus out there that know how to identify if a string contains all the same character?

e.g. "11111"
or "xxxxxxxxxxxxxxx"
or "a"

without having to specify the actual...

Anyone know if there's a way to import an OpenOffice OOo ?
Calc spreadsheet .ODS file into MS Access?

Thanks, DaveBo

When I import spreadsheets from Excel into Access that contain telephone numbers they sometimes come through as Scientific notation or as a resolved equation.
e.g. 123-456-7890 might come through as...

Yes, you're right.

My major problem was that I automatically import files, e.g. from CSVs and XLSs using the TransferText & TransferSpreadsheet methods in VBA, but always to the same temporary...

I've written many queries in the Access QBE that reference linked tables.
Often, when I reopen a query many of the fieldnames are suddenly replaced with Expr1: OldName, Expr2: OldName2 etc.

Any...

I have a datasheet subform on an Access form, unfortunately, it's got more than 100 fields/columns so I had to cheat a bit to make it, i.e. the "wizard" couldn't handle it (some wizard!).

I have...

I have an Access table in a subform datasheet that I want to apply combobox style dropdown/lookup lists to.
But, as each field is set to an item from the dropdown list I want to remove that option...

In Access VBA, is there a way to determine what column/field of a subform datasheet has the focus?

Something like: Me.Child0.Form.Recordset.Fields.Name ?

Thanks, DaveBo

Is there a way, in an SQL select statement, to refer to a column/field by other than its name?

e.g. in the Order by clause you can use "2,1" to refer to the 2nd & 1st columns.

The problem is...

Is there an API method for sending the contents of the clipboard to the default printer?

I'm actually trying to do this in MS Access VBA.
I've captured a screen-shot to the clipboard and now want...

Any ideas how I can send the contents of the clipboard to the printer
from within Access VBA?

There must be an API??

Thanks, DaveBo

Maybe this should be telling me something, but, a workaround I've just found is

when I load the textbox values in VBA if I simultaneously load the defaultvalue
then it prints fine.
e.g.
...

Printing the form as:
- While the form is displayed and active
- File - Print ...

The Print Preview shows the data there fine, it just won't print.

I just added another textbox to the main...

I've tried reenacting the crime from scratch.

Totally new Access DB file
Form1 with nothing but a Textbox on it - saved
Form2 with nothing but Form1 as a subform - saved

I open the form, type...

In Access 2002 I've just tried placing a simple tab control onto a new form.
It shows up fine and seems to work as advertised on screen,
but, the tabctl outline and tab headings don't print.

Any...

I have a form in an MS Access project file (.adp) that has a subform on a tab control. On screen it looks fine, but when I send it to the printer the textboxes and checkboxes on the subform are...

Anyone know what the expected impedance is for the mic vs audio/line-in connectors on a typical PC?

Thanks, DaveBo

Thanks jcis,

For now I simply put a 5-second fudge factor in the file comparison logic.
i.e. to consider a file older or newer I insist on at least a 5 sec diff.
The 5 seconds is an arbitrary...

Forgot to add my little code snippet

Private Sub Command1_Click()
Const File1 = "C:\Junk.doc"
Const File2 = "E:\Junk.doc"

FileCopy File1, File2
Debug.Print File1 & " ";...

I've done this jumper trick with a PSU, (pretty sure it was an ATX)
and it works fine. So what's all the fuss?

I've just been bitten by an annoying quirk, experienced on 2 different WindowsXP systems.

When copying a file from an NTFS partition to a FAT32 device, the new file's modified date is sometimes...

Just a thought...
does your niece have a large magnet?
Have you tried degaussing? (assuming this is a CRT)

I find this just a bit hard to believe. Sounds like a "WOM", Write-Only Memory, (which incidentally do exist, I've worked on them).

I can't imagine any virus doing physical damage to a system,...

I've been playing with my Win98, HP laptop's power meter and a VB app using the sysinfo control to monitor battery charge/discharge.

The info seems to be updating every 2 minutes, but with > 4...

Anyone have any experience with PC printers handling 11x17" sheets?

I often printout sections of topo maps and nautical charts, but the 8.5x11 is just a bit too small usually.

Thanks, DaveBo

I found one brief thread on registry cleaning
http://www.vbforums.com/showthread.php?t=268489

Anyone have any suggestions for general, routine PC tune-ups?
e.g. empty recycle bin
clean out cache file areas
do defrags
put HD in washing machine on delicate cycle ...

I know I've seen...