Recent content by laman

I need help. I cannot get my linksys nc100 v.2 card to work. Im running dragonlinux with what appears to be the latest tulip driver v.095 which fails with device busy on boot. PNP is disabled. ifconfig shows lo but no etho. The adapter shows irq 10 with I/O oxd800 [oxd801]. It does not appesr to...

Forgot to tell you to make sure you have the "Microsoft shell commands and automation" reference checked.

Copy this function to a new module. Function GetOpenFile(Optional varDirectory As Variant, _ Optional varTitleForDialog As Variant) As Variant ' Here's an example that gets an Access database name. Dim strFilter As String Dim lngFlags As Long Dim varfilename As Variant ' Specify that the...

The print options dialog box which opens is specific to your printer. If you did not see this option, your printer can not print in reverse order.

Instead of using the print icon on the toolbar, go to file/print which will bring up your printer options dialog box.

There are no differences! As I have already explained, this works in all of my reports except one and don't know why. It,s obviously not the code but something else.

I have used the following as a control source for a textbox in reports so the user is prompted to enter the Table No. which works for all my reports except for one. ="TABLE" & " " & [ENTER TABLE #] I get "jet database engine does not recognize [enter table #] as a...

I have a crosstab report set up with dynamic column headings. The code puts totals for each column in the footer section and works fine. I am trying to put the totals in the header but I get blank textboxes when report opens. If I then go into design view and back to layout they fill in...

Is there a way to force row headings (not column headings) in a crosstab query. I would like the same row headings to show each time even though some of them dont appear in the table. There are ten possible headings for the field in question. THANKS FOR ANY HELP!

Yored The Man! Worked great, Thanks. I never would have tried that but I did try everything else.

I get a syntax error on left paren after nz.

Need some help with the followig query. I need to return 0 when nulls occur. Ive tried NZ and IIF and can't seem to get it to work. TRANSFORM count([master].[ID]) AS CountOfID SELECT [master].[SECTION], count([master].[ID]) AS [Total Of ID] FROM master GROUP BY [master].[SECTION] PIVOT...

Need some help. I have a textbox on a form which displays items from a table for information only. The first item is always highlighted. Is there a way to not have any of the items highlighted. Thanks.

What's wrong with the following: DoCmd.TransferText acExportDelim, "sdf", "acc", "Forms![sdffiles]![txbfolder]acc1.sdf", False, "" I'm tring to get the destination path from a textbox on a form. The file transfers but always to A:\drive no matter what I...

I GET #ERROR in the textbox.