Search results for query: *

I purchased a generic PC a couple of years ago with the intention of hooking up my DirecTV tuner to the video card included in the deal. Well... I've forgotten what I have and lost any information on what I bought. Here's 3 pictures of what I've got...

I want to transfer data out from a Access DB using a COM port. Currently I do this using HyperTerminal (Xmodem) using Transfer... Send File... to transfer a text file. (But not using Transfer... Send Text File..) I'd like to use the MSCOMM ActiveX control a loop through a recordset instead of...

I want to pass a text file to a couple of different subs (or functions) each will search for a sting using the File, or TextStream, object line by line. I can't figure out how to do this, I get either 'Object doesn't support this method' or a compile error 'Type mismatch'. As far as I can tell...

When I try to compact the backend of my database I get the following error message "Records can't be read; no read premission on \\..." There is no security on this db, when I use it I am recognized as the Admin, and I went through all the objects and set all of the permissions so...

I have an integer field in a table. Some of the records contain null values for this field. I want to filter the records by excluding a specific integer value. The filter excludes the correct records, but it also exludes all the records with null values as well. I've tried this as a select query...

I want to set the value of unbound text boxes on a form. The form is set up in a grid (Letters x Numbers). I want to loop through a few of the text boxes and place the required value in the correct text box. I thought I could concatenate the letter and number that corresponds to the grid to the...

I have a bound text box that is formatted to display the date as follows:<br>15-Aug-00-AM <br>using the format &quot;dd-mmm-yy-AM/PM&quot;<br>In the underlying field the data appears with the complete date and time.<br><br>Is there anyway to force the data to be recorded as is appears in the...

I'd like to export two tables in Access into one Excel workbook as two separate sheets.<br>Is it possible to do this? <br>I have VBA in Excel that is running VBA in Access, so I can either export or import on either end, which ever is easiest.

I am trying to Import an Excel 97 file into Access 97 using the Import Wizard.<br>The error message is:<br>&quot;An error occurred trying to import file 'C:\Book1.xls'. The file was not imported&quot;.<br>I've imported files many times before with success. This one Excel file will not import...

I am trying to export a series of records as individual delimited text files. I thought I could easily do this using a macro and not have to use VB (I'm still a novice at VB). <br><br>I have a query with 4 records that have to be exported as 4 individual text files. My macro opens the query...

Just when I thought I was getting good at this...<br>I want the average and standard deviation of values in a table. I set up a query that can calculate the average, but when I add StDev (from the combo box in the QBE grid) and run the query I get #Error as the result.<br><br>I created a simple...

I am starting a new database in a biochemistry lab. I need to count the number of times the letter 'a' or 'g' or 't' or 'c' occur in a sequence of these four letters. I need this information for each record, and then for all the records in the query.<br> <br> I've tried using the String function...