GJ, I had to give you a star!!! I have been having these issues with <CFFILE> not uploading for the past week and could not find a solution. Your recommendation (set the user account in services) resolved my issue. Thank you so much!!!!!!
Is there any way to retrieve the user's SMTP address? I am able to retrieve the domain and username information from the environments variables. I hate to use the word but, can I <font size=+1><b>assume</b></font> that combining these 2 field would equal the email address of the user?
When I try to open an Microsoft Access 2000 Action Query in Design View, the entire application closes. The Action Query is a Make-Table Query that used Linked Tables. The queries is part of several queries that make a report. If you run the all the queries, the report is produced, we just...
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q235340&
If you are using a stored procedure and it is returning results from a temporary table (a table prepositioned with a #) then you need to have the code "set nocount on" inside of your stored procedure.
Deb
Thanks cmmrfrds!!!!!!!!!!!!!!!!!!!!!!!!
It was the command timeout. I had already tried the connection timeout and it wasn't working for me.
Again, thanks for all of your help and thanks to everyone for thier assistance.
Deborah
Thanks for all of the responses.
I am using ADO code to call the stored procedure. Here is a sample of my code:
Dim cmd As ADODB.Command
Dim rst As ADODB.Recordset
Dim strConnectString As String
'------------------------------------------------------------
' make a connection...
Good Day,
I have a stored procedure (SQL Server 8) that runs for about 2-3 minutes. If I try to run the stored procedure using Access, I get a timeout error. Is there any way around this?
All help is appreciated,
Deborah
Thanks Kelly for the info.
I have implemented the above code in a table for a column named PJ_FY1hours and it works fine. I just wanted to be able to do it directly on the form. If I apply the above code to a text box on the form it does not sum up the correct values. Again Thanks..
Deb
I am currently trying to create a report that only sums certain values. For instance (please note the totals with a * preceding),
Trial
Personal 6
Joint 4
Never Handled 8...
Pezamystik,
I have tried Terry's code and I think the problem is with the 'Null' part of the clause. If nothing is selected txtBranch is blank or "". I have now set it to 'NULL', but I am getting no criteria returned. Is this right? I was thinking that I should get ALL of the...
Terry,
Thanks for your reply. I tried your code and it works fine within VB but when I try to paste the same code in the criteria of the query in the 'query design view' it still does not return what I need.
Do you know of a way that I can use the list box selection in the criteria of the...
Pezamystik,
What do I do if there are no parameters to be passed. Can I use the same command, but somehow modify it?
For example, the User has 6 choices. They can choose some, all or none. None would mean that there is no criteria for that field. How would I represent that using the above...
Pezamystik,
The solution you provided worked perfectly.
Thank you for not only providing a solution, but for also explaining why this is happening.
Happy New Year,
Deborah
You may want to check your syntax.
Is the exact name of your form "Adopting Family - Update Form" and is the EXACT name of the field you are trying to use "Adoptive Family.afnumber"?
Maybe it should read FORMS![Adopting Family].[afnumber]
If the field's name is afnumber...
Thanks for the info Braindead, but that seems to only work with the VBA. I was trying to make the query work using Access 2000 Query Design View.
Any Ideas?
Happy New Year,
Deb
I am currently trying to run a query that will use values in a text box to filter.
For example (taken from the SQL View of the Query Design):
SELECT *
FROM tbl01_CaseTimeDetail
WHERE (((tbl01_CaseTimeDetail.attorney_branch) in ([Forms]![frm02_CaseTime]![txtBranch])));
Now here is the problem...
Actually, I just found that if I perform the same query that you gave me but used min(idtype) and captured that into a temp table, I can then perform your query and get the correct data. Thanks stsuing. Your help is appreciated.
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.