Thanks for the reply Jared and no, ::therapy and ::issueid:: are textboxes on a form. I found the problem to be permission changes and had to download different versions of 3 frontpage files to allow an update query to run. Odd issue but, its been resolved.
Bender
MindBender77
Last Activity: Sep 14 '10, 02:46 AM
Joined: Jul 16 '07
Location: Pittsburgh,Pa USA
-
FrontPage 2003 - Update query Error
Hello again, All...
Admin's, I wasn't sure where to post this, please move if in wrong forum.
I'm using FrontPage 2003 to post form data to a second form to be used in an update query. The query then updates a record in an Access database.
I get this when the page is displayed:
Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.
... -
Thanks again for your help sicarie. I think I've narrowed it down to either the ISP or a corrupt antivirus program. The anti-virus keeps giving dll errors and I'm wondering if its the reason that port 80 seems to be blocked. You've given me a starting point so, thanks again.
To answer your question: when I lose connection IP is 192.168 on a PING but, if I open the browser, it tries opening an IP like 63.43.
In the...Leave a comment:
-
Hello sicarie,
No I haven't taken this up with my ISP yet. I wanted to find out more before I do.
As for the ipconfig /all:
I get everything I should, (sorry for not being more descriptive). The lease date is 2 days, IP is assigned.
The oddest symtom is that I can still PING and get responses from like yahoo.com but, get a DNS server not found error when using a browser. Any suggestions?
...Leave a comment:
-
Losing Internet Connect After a few Minutes
Hello All -
I've exhausted all other resources so any feed back will be most helpful. If this question is not in the correct forum, admins please move.
I have an older Compaq Armada laptop and a Zoom cable modem. I can receive an internet connect for about 3 minutes before losing it. My desktop pc, when connected to the same modem has no issue.
My first thought is the IP is not reassigning however, when I release... -
Older Dell laptop won't boot
Hello all,
I have a older dell laptop that is about 5-7 years old. I suspect either processor or MoBo issues. Let me know your opinions. Symtoms:
On pressing the power button, indicator lights come on but, after 3-5 secs shut off. Fans and hard drive don't appear to spool. I've already checked the battery and tried running on AC. No audible beeps are present. Any suggestions?
Regards,
Bender -
I have two questions. First, what is the "new line character"? Is it an actually character? If so, you could possibly do a "Find and Replace". Second, have you tried exporting the file to wordpad (.rtf)?
You could import the text file into say MS Access and remove the characters from there and re-export it back to a text file.
HTH,
BenderLeave a comment:
-
I see. Then you might want to try ZoneAlarm Firewall.
Hope this Helps,
BenderLeave a comment:
-
Hey, Yoda,
I hope i'm understanding your question correctly and might I suggest using an anonymous proxy. Some are free on the net and should be ok for temporary use. It really depends on what type of intrusion your experiencing.
HTH,
BenderLeave a comment:
-
The easiest way to accomplish this is to create a form with its recordsource linked to your table (NumberTable).
On this form add a single textbox and a command button. Naming the textbox (txt_tempnum) and the command button (cmd_count). Next, change the controlsource of the textbox to the Number field of your table. Finally, add this line of code to the OnClick event of your command button:
...Code:Private Sub cmd_count_Click()
Leave a comment:
-
You could set the enable property of the textbox to "false" which should prevent users from changing anything you don't want them to change. It will just gray out the textbox but, retain the data.
Or something like this in OnExit event of your textbox:
...Code:If format(" & Textbox1 & ", "yy") <> format(Date,"yy") Then msgbox("Please Enter the Current year.")Leave a comment:
-
My first question is what type of control is the date field in ie. Textbox?
Second, why do you need to have them enter this manually. You could simply have the control source of the textbox =Date(). Which will produce the current date automatically.
Bender...Leave a comment:
-
The syntax I provided for using the inputbox will work with "OutputTo" as well.
The arguements are:
HTH,Code:Object Type: Query Object Name: Name of Your Query Output Format: Microsoft Excel (*.xls) Output File: ="c:\" & InputBox("Enter the employee name that's in the file name:") & "_Survey.xls"
BenderLeave a comment:
-
I think the easiest way is to call an inputbox from your macro. I'm assuming your using transferspreads heet. Add this to the file name argument:
Hope this helps,Code:="c:\" & InputBox("Enter the employee name that's in the file name:") & "_Survey.xls"
Bender...Leave a comment:
-
Neopa and Linq are most certainly correct.
It really depends to what extent of tracking you wish to achieve but, you can have Access export log files daily. This is done entirely through vba from a form linked to a table. I have incorporated this with several of my projects. You could view minute to minute actions of your users if you wish.
If you decide to go this route let me know and I will provide a snippet to get...Leave a comment:
-
Stewart,
I have also experienced where runsql works but, the other produces an error. This is one of those times. So I did the following.
I shutdown the DB and brought it back up and added the code to a module; created the macro; and called it from the command button on the original form. Voila it works.
I've had instances in the past where bouncing a DB is a "magic" fix for code that appears fine but,...Leave a comment:
-
Thanks for your reply, Stewart. Here is an outline of the table i'm trying to append too. Note, I've ran this using a module during testing and no errors were produced.
TableA
Description - Text - ex. "Tylenol"
NDC - Text - ex. "5555544442 2"
UPCScan - Text - ex. "5555544422 "
HostOrderPerSku - Number - ex. 30
Manufacturer - Text - ex. "Pfizer"
BO_Avail - Number...Leave a comment:
-
Invalid Qualifier In VBA SQL Query
Hello All,
I keep getting an "invalid qualifier" error while trying to execute the following SQL statement from a form.
Bold text represents...Code:strSQL="Insert into TableA ( data1, data2, data3 ) values(@" & txt1 & "@,@" & txt2 & "@,@" & txt3 & "@);" strSQL=replace(strSQL,"@", chr(34)) currentdb.execute [B]strSQL[/B], dbfailonerror
-
Neopa and Linq make very good points. However, might I suggest developing an Intranet site only accessible from your company's server. This should prevent exposure to eyes that are outside of your company.
BenderLeave a comment:
-
I would advise using Google to assist you. There is a plethora of information out there. Just search for: "Access Query Basics" for example.
Here is one to get started.
Query Basics
Hope this helps,
Bender...Leave a comment:
No activity results to display
Leave a comment: