Search results for query: *

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...

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!

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...

How would I use the following statement to fill a textbox on a form with the result. The form is &quot;switchboard&quot; and the textbox is &quot;text1&quot; SQL = &quot;SELECT Sum(IIf(([cl]<>'y'),1,0)) FROM master;&quot; Thanks

I would like to have the current database filename show up in a textbox on a form. Any ideas? Thanks.

I'm trying to use RunCommand acCmdOpenDatabase from a button on a form. When I click on it I get the message, The command or acion &quot;opendatabase&quot; is not available now. Any ideas, Thanks!

Seems like it should be easy but I can't seem to figure it out. I have a database I would like to use as a master to create new databases with new names. With the master open I have the code to make a copy of the master with the user entering the new name. What I would then like to do is close...

I am using the transfertext to import text files. These files always have the file extention .fan. Currently I am changing the extention to .txt manually before I import them. Is there a better way to do this Thanks for Your Time!

I am having trouble with the following code. I have a form to search for records based on two combo boxes, one for the field &quot; & field & &quot; and the other for the operand &quot;&_ operand &&quot; with a text box for criteria &quot;& criteria &&quot;. The fields are both numeric and...

I'm using the following code to do searches with numeric and text fields. Private Sub Command12_Click() If &quot; & field & &quot; = TUBE_NO Then strSQL = &quot; Select * from master WHERE &quot; & field & &quot;&quot; &_ operand & &quot;&quot; & criteria & &quot;;&quot; Else strSQL = &quot...

I need some help. I have the following code on the on click event of a button on a form. Me.RecordSource = &quot; Select * from master WHERE &quot; & field & &quot;&quot; & operand & &quot;&quot; & criteria & &quot;;&quot; How do I display the results in a text box with the field headers on...

I am using the following code to run a query from a form with user input from a textbox for criteria. Dim dbMyDB As Database Dim qdMyQuery As QueryDef Dim rsMyRS As Recordset Dim strMySQL As String strMySQL = &quot; Select * from master WHERE [wl] = &quot; &...

I can't seem to figure this one out. Seems simple but I have tried everything. On a form I am using the contoll source expression =Count([cl]) which returns the total number of records for that field. I would like the result to be the the number of occurances of &quot;nd&quot; in that field...

Need some help with this one. I have the following query: SELECT Format([section] & [Row_no] & &quot;-&quot; & [Tube_no]) AS MyNum FROM master WHERE ((([master].[CL])=&quot;C9&quot;)); Which I export to a text file with the following Tranfertext command: DoCmd.TransferText acExportDelim...

I need some help with this one. I have a find duplicates query named &quot;DupRecords&quot;. I would like to leave the first record as is but update the duplicates field5 to=&quot;Y&quot;. Some kind of loop? Please Help Thanks

I am trying to run a Query with code to return duplicates which do not include the duplicate with the highest value in a specific field. For example if I have 3 dupicate records with values in Field3 of 40,30 and 20, I want the query to return only the records with the lower values (30 and 20)...