Search results for query: *

I'm in a new home and my 2.4 GHz D-Link Wireless Router (DI-614+) in the office does not provide enough signal strength to connect to the network from other area's of the house. Even rooms that are only @ 50 feet away. I was doing some research on different products available but being a...

Thank you! Does anyone know if there's a way to left justify some of the text in the print statement, but not all of it? Basically the left column should be left justified and then a tab and then another left justified column. Thanks! Jeanna

I tested the script with a simple file and here are the results. myFile.txt, tab delimited text file with one record Number Field 2 Requester Purpose User Type Req. status REQ029855 SMITH, MONICA TEST5 SMITH, MONICA E-Procurement Satisfied myTable that was created F1 F2 F3 "Number Field 2...

Hello Ken, I didn't catch this when I read your first post "Ensure the column names in the table match up with those you wish to appear in the output" Unfortunately, the two systems call the same fields by different names. Is there a way around this? Thanks, Jeanna

Bob, I don't see 'Fixed Width' as an option to save in. The 'Save Formatted' box is grayed out. Do you need a plug in for this? thanks, Jeanna

Ken, You wouldn't happen to have an example of this would you? Thanks, Jeanna

Hello Everyone, I need to convert a tab delimited file to field list format. I had a similar case where we went from a list to spreadsheet form in Access. But, I'm not sure if this can be reverse engineered. The data from one system will be extracted in Tab delimited format. The system it...

I was told that you needed to use COBOL or C++ to convert a tab delimited file format to Field list format. The data from one system will be extracted in Tab delimited format. The system it needs to go to will only except 'Field List Format', which looks like this: 00000000000000ZINVCD...

Hello Everyone, I had a similar case where we went from a list to spreadsheet form in Access. But, I'm not sure if this can be reverse engineered. I was told that you needed to use COBOL or C++ to do this :-/ but I wanted to check with the board first. The data from one system will be...

You deserve the star. This is great. You and I did work well together. Sometimes people reply kind of rude or you just can't understand what they wrote. I appreciate your patience and clear descriptions. Now I will just be working on cleaning up some formatting. I think they used every...

YAY IT WORKED IT WORKED!!!!!!!!!! It's funny, I'm a consultant... so unfortunately I don't get to do as much programming as I'd like to. I tend to do a lot of process work and requirements gathering. Only once in a while do I get to use my programming skills. And just like anything else...

By the way, I'm not sure I understand the "xxx" in the case statement. Can you explain that to me? Here's a sample of one single recordset, this one does not happen to have a second address line. If it did then there would be a blank column A a second address listed in column C and...

Hello Paul, Well, I really admire you helping me!!! I'm learning a lot and this is kind of fun. New error: Run-time error '3021': Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. It is doing this on the very first recordset...

Hey Paul, Unfortuntely these are not the only null spaces in the record set. There are actually spaces between each column. A B C Name: Jane Doe (space) Title: Manager...

OK, Paul... We have progress. I found one problem. I cleaned up the data as if it was perfect for two records. Found that I had forgotten :'s in two of the new table column names - DO! Then it worked fine on the sample set. I had one error on my first run with the real data that I was...

Paul, I saved the module under a new name and closed and reopened the db and havne't gotten that error again... strange. Pasting in that script helped but now I have a new error: Run-time error '3265': Item cannot be found in the collection corresponding to the requested name or ordinal. It's...

OK, new errors. Run-time error '3265': Item cannot be found in the collection corresponding to the requested name or ordinal. Getting this on this line: If rstIN.Fields("A") = "Name" Modified to: If rstIN.Fields("A") = "Name:" Get the same error...

This is not a trial DB is it?

I have successfully restored a db in cases where a backup file was not available utilizing attach database in enterprise manager.

Hello Tranman, I updated Access 2000 to sp3, created a new database and imported the NewTable and OldTable Tables. I created a new module and I get the following error: Run-time error '-2147467259 (80004005)': [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in...