Recent content by Pigster14

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

Well thank you for the information.

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

Thank you for the information it was very helpful.

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

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

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

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

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

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.

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

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

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.

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

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.