Error Type:
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Open'
/bingohopasp/post.asp, line 428
I am getting this error when trying to insert a record into a recordset. It also locks up access and the only way to free it up again is to reset IIS. The insert works with some data, but not others...I have two examples.
Successful Data:
"
The rules below have been constructed to ensure every member of the Bingo Hop Web Portal has a pleasant and enjoyable experience while here. Please read them and avoid breaking any, as failure to do so may result with your account being suspended or banned permanently.[RETURN][RETURN]
"
Unsuccessful Data:
"
The rules below have been constructed to ensure every member of the Bingo Hop Web Portal has a pleasant and enjoyable experience while here. Please read them and avoid breaking any, as failure to do so may result with your account being suspended or banned permanently.[RETURN][RETURN]
1. Do not insult, make personal attacks or be rude to any members or staff of Bingo Hop.[RETURN]
2. Do not post private information about yourself or other members of Bingo Hop, such as home/e-mail addresses, telephone numbers, credit card details, etc,...[RETURN]
3. Do not post meaningless posts, one word posts or anything that may be considered as spam.[RETURN]
4. Do make random/multiple posts in order to raise your post count.[RETURN]
5. Do not register multiple accounts with Bingo Hop.[RETURN]
6. Do not post racist, sexist or demeaning messages to the forum.[RETURN][RETURN]
We reserve the right to remove offensive posts without notice.[RETURN][RETURN]
While these rules cover most common situations, they cannot anticipate everything. As a result, we reserve the right to take any actions we deem necessary to ensure these forums are not abused in any way.[RETURN][RETURN][RETURN]
Sincerely[RETURN][RETURN]Bingo Hop Admin
"
Here is the asp code:
Set Conn = Server.CreateObject("ADODB.connection")
Conn.Open(ConnStr)
I want to make a bar chart in form with X-axis: [WEEK], Y-axis: [TTL NO] and each bar separated by [FINAL CHECK] liked below which [WEEK] linked to filter in form to choose required period.However, error occurrs and 2 error message boxes as below.
1. The Microsoft Jet database engine does not recognize '[Forms].[Menu].[FM_WK]' as a valid field name or express. 2. An error occurred while sending data to the OLE server (the application used to create the object).
I have a data base of over 40,000 accounts. When I run my quires I am able to find accounts that may have errors and have them reviewed. Is there a way to exclude those accounts when the query is run again? Something like a table of exceptions to the query? I am unable to remove the data from the data base and with more then 40,000 accounts it would take a very long time to manually do it. Thanks.
I've got an activity logging system in which users add their daily activity. As an information check, I would like to generate a report which identifies days where the user has omitted to enter activity for given dates.
Is there an inbuilt function that Access has or can anyone point me in the direction of some code?
I have a field on a form (exception) that is also a column in a query. I would like to create a report an only show those records that had an exception in it. I am not sure what criteria in the query to use, but it would seem creating a report off of this query would work.
I would like to know what the best way to input a duplicate record is with the exception of 1 field that is used to correspond with the proper parent of the record?
Here is an example of the problem, We receive a letter with pertinent information that corresponds to 30 of our facilities. I would need to enter this 30 times so that when the users of this information run their reports for their facility I can ensure that the letter would be referenced.
Basically I have my general employee information in the tblemployee table, the workcenter information in the tblworkcenter, and the manager of the Workcenter in the tblManager. This is correct for 99% of the employee population. however, there are a few employees whose manager isn't the 'general' manager for the employees assigned workcenter.
How I can adjust an individual employees manager, while maintaining my structure? or would i have to go back and add the managers ID to a field in the tblEmployee Table?
I have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.
Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.
Problem: Visual Basic run-time error 7792: You can't open a subform when it is also open in Design view.
I have a subform with properties for SourceObject, LinkMasterFields, LinkChildFields changing according to objects and events in the master form.
The subform was bound to a query before which meant that the subform load event was happening as soon as the master form is loaded. I needed to restrict the subform loading until a certain point so I removed the SourceObject property for the masterform's subform. The subform on the master form is now Unbound.
(This is because I'm now running some code on the FormLoad event for the subform which needs to be restricted until the LinkMasterFields and LinkChild Fields properties have been assigned correctly otherwise it takes ages to load.)
Now I'm getting the above error. Obviously, i do not have the subform open anywhere in design view. No Visual Basic windows are open. I've closed the db, closed access, reopened it and clicked on nothing except the masterform. The error occurs when I raise the event in the master form which assigns the sourceobject property to the subform, i.e.
Me.sfmQryAllOV.SourceObject = "sfmQryAllOV"
Can anyone help me? I've googled this but finding no answers.
when i open a form i want to open another frm at the same time. i have a main form with some buttons in it. when i click on a button and a form opens then i am not able to click on a button to open other forms from the main form.
I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select all of the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from.
I want to open another form automatically when an initial form opens, both are non popup) I have tried open and load events - but still the calling form appears on top of the called form.
How do I get the two forms to open form 1 and then form 2?
Also I cannot use the timer event as this is doing something else.
I have noticed that on our network, certain people can open an Access db that is already open by another person, yet some cannot. We are using the same shortcut (to the mdb file) and all have the same windows read/write permissions.
Is there a way to close a form that is open from another form that has the focus. I tried using the Unload event, but I received an error message "Cant load or unload the object". I would appreciate any help!
I have created a ms access database and it is located on our shared server at work.
However if someone is viewing the database, when another person double clicks the icon to open the database, nothing happens. As soon as the other person exits the database, someone else can access it.
Previously more than one person could access the database at a time, now they can't.
I'm not sure if this can be done with the expression builder. I have a query that brings in a value from an open form when run. The query can be called from two seperate forms.
In my expression, I would like to check which form is open, and port the corresponding value.
In VBA -
If IsOpen(frmPSWork) Then MyVar = Forms!frmPSWork!txtID Else MyVar = Forms!frmCSupdate!txtID End If
In the expression I tried playing around with something simple along these lines without success -
I am goign to try and explain my issue the best I can and hope that one of you has some advice.
I have a form full of text boxes that are populated based on a Combo Box selection. A couple of the fields are Not Visable and house a PDF name and PDF path What I am tryign to do is allow the user to hit a PDF button and bring up the PDF image, although there may be recrods without a PDF image. So I am trying to test for this. I wrote a basic If THen statement that tests for the PDF image name. IF it is there then it says "Its there", if not it says it "Not there". This worked out fine, showing me that I can test for an image name.
BALLFIELD_PDF_NAME = PDf image name BALLFIELD_PDF = PDF Image Path (location of image)
CODE: Dim Test Test = Me.BALLFIELD_PDF_NAME.Value
If Not Test = "" Then MsgBox "Its there" Else MsgBox "Its not there" Exit Sub End If
I then wrote the below code to look for the image name, if there open the image, if not exit Sub.
Results: When I open the form and all teh fields are blank adn try to open PDF from a record that I know does not have an image if get nothing (Exaclty what I want)(it exits the sub) I then choose one that I know has an image and it opens the image (Exaclty what I want, open the image) I then repeat on another that has an image and it opens that image. (Great) My problem arises when I try and open one that does not have an image after opening one that does. It goes into the Else Statement (See below) but still opens the last image I opened..... I cannot figure this out.....
What is the best place to have opendatabase statement ? Currently I have opendatabase in all of my forms. I dont have any modules in my application. I am new to access programming. Is module really necessary in an application? If I can put the opendatabase statement in one place, it will be easier for me to change the database name and path, if I have to..I dont know how to do it.
Can anyone help..I hope this one should easy for many of you people.
I thought my problem would be a common one but after spending enough time on the net and all forums i couldn't find my answer... anyway... here is my problem. The database is about creating reference, the table contains multiple references, i create a folder where i'll put all the files to be attached
I wanna a create a link to a file... the thing are : - i want to open any kind of file (or at least i specify in a table what kind of file to open (jpg, pdf, etc...) - The name of the file is different for ever record... Anyway i think it will be more clear with the code :
Private Sub File_Name_Label_DblClick(Cancel As Integer) Dim rst As New ADODB.Recordset Dim file As String Dim fold As String Dim i As Integer
Hey all I was wondering if there was anyway to open my program when windows opens, I have the XP sytem but I was also wondering if there would be a difference with windows 98... SO What i would like to accomplish is to open my access program without clicking on it when my windows, is loaded, can I open it when it loads automaticly. Does it matter that there are different users on my system or not. Thanks
I've run across a couple issues with our database. The most immediate issue is that I have been unable to open the database on any networked (or non-networked) computer. Me and a assistant typically enter data into this database from two seperate computers. She works on a wireless networked computer with the file on my computers hard drive. I work directly with the file. My computer is wired to the router. (in case that information helps)
We keep getting errors about "cannot access remote computer" and such, they seem to occur when she's entering data and I have the database open, then close Access. It will often give her the error and not allow her to save the record.
But just today she entered something, I closed my database window, then reopened it and I could not get in. All network computers rebooted, and still cannot get into the file. I can enter the password and then it goes to just a blank area (like when your first open access with no database). Older backup versions of the database still work, so it doesn't seem like an Access error. I also noticed that the little "LockFile"s are not being created (I ever faked one just to try it out and it deleted it after i entered the database password)
I can't repair, or convert or anything, it just asks for the password, I give it...and then nothing.