Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. startup

    Always give specified static internal IP to a certain client computer

    Just found my answer on this page: http://www.howtonetworking.com/Windows/vpnsetup.htm
  2. startup

    Always give specified static internal IP to a certain client computer

    We are running Windows Server 2003 VPN giving out IPs from a static address pool. Is there any way, either with the static address pool, or with DHCP to give a specified client computer the same internal address (ie 10.100.1.1) every single time it connects? Currently the client gets a different...
  3. startup

    Trouble Creating a Report with Memo Fields that are grouped

    Thanks Duane, The GROUP BY was exactly what I needed on the main report. The Subreports were still causing a problem when I used the subreport wizard tool to create them. But then I manually created them as separate reports by themselves and then dragged and dropped them onto the main report...
  4. startup

    Trouble Creating a Report with Memo Fields that are grouped

    Some more information: The closest I can get with the report is like this. It keeps repeating the Heading label again for each user, which I don't want. I have the CourseID in a header. Then in the Details section I have the Heading Label and a subreport underneath that displays the memo...
  5. startup

    Trouble Creating a Report with Memo Fields that are grouped

    Hello, I have a table that has a layout like this: CourseID(Text)|UserID(Text)|Paragraph1(Memo)|Paragraph2(Memo) What I want is to get a report in this format, but I'm not sure how: CourseID1 Heading Label for Paragraph1 User1 - Paragraph1 - blah, blah... User2 - Paragraph1 - blah...
  6. startup

    Couple Windows->Mac shortcut questions

    For a long time Windows user who is learning the Mac (Tiger) I have a couple questions: 1. On WinXP I can use the keyboard shortcut [WINDOWSKEY] + [L] to lock the screen in whatever application I am. I use this a lot, every day whenever I leave my computer. Is there some similar keyboard...
  7. startup

    Use Transfertext to export 2 queries and merge/append in 1 text file

    Thanks for the idea mp9. That looks like it would work. I did resolve the problem myself by creating a batch file that copied the two files into one with the statement "Copy C:\Temp\NewAdditions.txt + C:\Temp\NewDrops.txt C:\Temp\Merged.txt" I then call this from VB with the code: Shell...
  8. startup

    Use Transfertext to export 2 queries and merge/append in 1 text file

    A union query is nice, but in my case it won't work. The website listed states this: "all queries in a UNION operation must request the same number of fields; however, the fields don't have to be of the same size or data type." My two queries have a different number of fields.
  9. startup

    Use Transfertext to export 2 queries and merge/append in 1 text file

    I have two queries different queries which are currently exporting to two separate text files with Transfertext. Is there any way I can make the second query append its results to the end of of the text file created by the first query? There is not a way to combine all the results in a single...
  10. startup

    Modifying Export specification with VBA

    ...(ie comma delimited with no quotes). Then when I ran the export with my export specification it would rebuild the MSysIMEXColumns table with the current information. Beautiful! strSQL = "DELETE MSysIMEXColumns.* FROM MSysIMEXColumns;" DoCmd.RunSQL strSQL Again thank you very much. Rico
  11. startup

    Modifying Export specification with VBA

    Is there any way to modify an export specification from VBA? I have a certain table with X number of fields that change as I import a spreadsheet into it (it might be 2 fields or it might be 20). Then when I try to use a transfertext to export it in a different format, I need an export...
  12. startup

    Help renaming multiple table fields in VBA

    After posting I figured out a method that works for me. Here's the code I used: Dim MyDb As Database Set MyDb = CurrentDb Dim MyTdf As TableDef Set MyTdf = MyDb.TableDefs("ConvertTable") Dim counter As Integer For counter = 0 To MyTdf.Fields.Count - 1 MyTdf.Fields(counter).Name =...
  13. startup

    Help renaming multiple table fields in VBA

    I have a table which which is created from an Excel spreadsheet I import and has certain field names that come over from the spreadsheet. Can someone help me figure out how to change these multiple field names in VBA? This is what the field names are after I import: Quiz1, Quiz2, Quiz3...
  14. startup

    Substitution of one value for another in a SELECT query (how to do it)

    ...2 different columns. Maybe there is an easier way to do the Erating formula, but it works for me. Elevel: Choose(([Rating]\256),"Very Energetic","Lively","Fair","Lacking","None") Erating: Choose([Rating]-(256*(Format(Left(([Rating])/256,1))))+1,"Excellent","Very Good","Good","Average","Awful")
  15. startup

    Substitution of one value for another in a SELECT query (how to do it)

    I have a series of values in my table. Each record only has one value, but they fall in these number sets: 256-260 512-516 768-772 1024-1028 1280-1284 Now each of these sets has five values, and I figured out how to convert all the numbers into a value of 0-4 and display this in my SELECT...
  16. startup

    Can Complex SQL Query for Immunizations be done simply?

    foolio12, Thank you for the response, which is very helpful. I hadn't heard of UNION queries and it will definitely be helpful. I don't think it will work in my case because there are such complex formulas... (ie, if the kid is this age he has to have these shots, but if he's older he has to...
  17. startup

    Can Complex SQL Query for Immunizations be done simply?

    I need to open up a recordset for my report which only lists those students who have problems with their immunizations, (ie. they are missing one or the other immunization according to what age they are, etc). My frustration is, when I try to create the query to do this, it already has 10 huge...
  18. startup

    Is my graphics card toast?

    Last night I transferred my rig to a new case. I hooked everything back up and booted. Immediately the monitor displayed a random mess of blinking squares and flashing lines. Despite this, from what I could hear, the computer booted normally up to the point where it would bring up my Win2K login...
  19. startup

    Novell Client or Windows XP does not save local profile on exit

    Rjs, What you say sounds like it makes sense. I just don't know how to do it. I'm not the network admin, though I do have many administrative rights, some of which I don't really know about. If you could explain how I could look at or edit these settings that would be great. Or is this...
  20. startup

    Novell Client or Windows XP does not save local profile on exit

    I do not know much about Novell networks but I will try and describe the problem I'm having. First the background: I'm running Win XP SP1 with Novell Client 4.83 SP2. We were using roaming profiles and my profile saved fine whenever I logged off. I did have to insert a registry key mentioned on...

Part and Inventory Search

Back
Top