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!

  • Congratulations strongm 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. Pigster14

    Attachments sent from MSApplications through GroupWise are Blank

    We started having an issue where attachments being sent from Microsoft Access and Microsoft Excel are blank when they reach the end user. Both applications send the e-mail behind the scenes, with no user interaction. However, in Access I was able to change the setting in DoCmd.SendObject to...
  2. Pigster14

    Licensing? Music? Where do I start?

    Well thank you for the information.
  3. Pigster14

    Licensing? Music? Where do I start?

    That is a neat idea. Thanks....I know a few musicians.
  4. Pigster14

    Licensing? Music? Where do I start?

    Thank you for the information it was very helpful.
  5. Pigster14

    Licensing? Music? Where do I start?

    I have something I would like to start on the side. I would like to take home photos and combine it with music to make slide shows, memory book on cd, basically. However, curious how buying the music clips and then putting them on the cd/dvd and re-selling it as a package works. Especially if I...
  6. Pigster14

    Qry criteria - FilterBySelection? or Subform link by FilterBySelection

    Actually if that field is always populated, that should work. Because in your query using the line I had it will put in criteria for either the field on the form if it is not null or if it is null, it will look for anything in the field that is not null. Which will pull all records in your...
  7. Pigster14

    Link Excel with Access

    Well, you can link the spreadsheet from Excel into Access, but then you have to know what to search on to update the certain fields from the spreadsheet to the Access table. However, here would be my suggestion. Can these people truly not work in Access? Or is it they are not willing to work in...
  8. Pigster14

    Qry criteria - FilterBySelection? or Subform link by FilterBySelection

    Well, here is a thought. From what I understand you have a main form with a subform and on the main form the user can click a button to filter on such things as Geography, etc. This is based on what is in the Geography box or the Product Category box. Currently, the filter works on the main...
  9. Pigster14

    Importing of Excel Files

    Hi, Guv. To answer 1) I have never seen such a message, but when you right click in the Database Window to select import and you browse to the worksheet that you are importing and click ok or import does it give you the import wizard? Or do you get the error message before this? If you get the...
  10. Pigster14

    Store Count of Records in a Variable

    Nevermind, I figured the error out....but if you can answer about the various answers that would be great. Thanks for all of your help.
  11. Pigster14

    Store Count of Records in a Variable

    I appreciate the quick responses. I do have one question. I notice that some replies have Select Count(*) = @CountNew and some have Select @CountNew = Count(*) Can you do this either way? I have tried both and get errors, but I think because of my own mistake. If I do the following...
  12. Pigster14

    Store Count of Records in a Variable

    Working in a stored procedure for the first time... I have a variable.... Declare @CountNew as varchar(3) I don't think this is right, but I have next.... Set @CountNew = "Select Count(*) as NewAccounts from server.db.dbo.table where SGMTNUMB = 3 and SGMNTID Not In (Select SGMNTID from...
  13. Pigster14

    Charges for Web Development

    Can anyone give me some ideas for how much you charge for doing Web Development or point me to a site that would have this information? Thank you for your help.
  14. Pigster14

    Calculation has unusual result

    I am doing a calculation with three fields. Seems pretty simple, but I keep getting these weird results. (PCLAMT_D + PCFAMT)-PRSAMT_D Here are the numbers that fit with that.... (300650 + 0) - 300650 = (should be 0) But instead I get this 5.82076609134674E-11. I had several that were...
  15. Pigster14

    Get Started in Web Development

    Thank you for the responses. Actually I don't currently do web design I am more into building databases at my work. I work with Access and SQL Server, but very interested in learning about web design. Thinking of taking a class, just wondering what is all involved before taking classes.
  16. Pigster14

    Get Started in Web Development

    Any suggestions on how I could get started on doing some web development on the side from home? Any special licenses? What kind of tools do I need at home? Getting a customer base? etc.... Thanks in Advance.
  17. Pigster14

    Checking status of SQL Server Proc through Access

    Two ideas: 1. You can put a sleep line in that will cause a pause in the program for whatever you set it to. For example, Sleep 30000 will cause the program to stop for 30 seconds. But, that does not guarantee the procedure is done. 2. What is the procedure doing? Is there a loop you could put...
  18. Pigster14

    Update Join Without Null

    What if in the Where Statement you added "AND Updates.Code Is Not Null" That way, it would not include the codes that are null in the Updates table and update Customers. Good Luck!
  19. Pigster14

    Could not drop login as the user is currently logged in.

    Is the user actually still logged in? If so, have them log out and try again. If not, maybe see if they are locked up, unlock them and then try again. I don't think you can drop a user if they are logged in though. Good Luck!
  20. Pigster14

    Can each Excel cell have its own SQL statement?

    I understand your issue with Accounting not wanting to change. I have gone through this and my suggestion is they are going to have to change their ways or manually do the work. We do still have some spreadsheets that our Accounting uses and they maintain them manually by choice. But there are...

Part and Inventory Search

Back
Top