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...
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...
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.
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.
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...
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!
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!
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.