After rereading this thread several times I thought I might throw my two cents in...
There are a number of routines that have been written that can grab the handle of the the internet explorer window and return the information you are requesting yet your understanding of VBA may make this difficult to accomplish.
Have you considered using a Web query? You can use the import window to view the page then log in once you...
Denburt
Last Activity: Oct 29 '10, 02:07 PM
Joined: Mar 15 '07
Location: Louisiana
-
Last edited by Denburt; Oct 7 '10, 05:27 PM. -
Sorry I don't have any advice on troubleshooting this issue.
It could be a Killbit issue, I have seen a lot of issues there recently.
The following free program may help in tracing it down though.
http://www.dependencywalker.com/...Last edited by Denburt; Jul 20 '10, 07:00 PM.Leave a comment:
-
In the form you are using there is a Record Source property. This Record Source is then cloned and you actually access those fields and change the records via the cloned recordet. So your Record Source for that form would need to have a field named tmpcontrol or a field named Select in order to use this code. Don't forget to make sure you set the references and the other issues pointed out by mrowe.
One in specific:...Leave a comment:
-
Very well put NeoPa! If only I could put things so eloquently. :)
Oh and Martin I wanted you to know I thought you explained things quite well by the way. Sometimes it can be difficult to get a point across no matter who we are or who we are talking to....Leave a comment:
-
I am just glad I could help.
Everyone has to start somewhere, and I know I have had to stop and say wait I have an issue.... That's one reason I decided to help on this board the members were all so willing to help me whenever I have had or have an issue or two come up.
You have a good evening as well and again I am glad you have a working solution....Leave a comment:
-
Hmm that's an interesting approach. You can probably use that although you would need a slight adjustment.
The way you posted it you were looking for the text [Table2].[FullNameTb2] in the actual field and not the data in [Table2].[FullNameTb2]....Code:SELECT Table1.*, Table2.*, Table1.FullNameTb1 FROM Table1, Table2 WHERE (((Table1.FullNameTb1) Like "*" & [Table2].[FullNameTb2] & "*"));
Leave a comment:
-
Personally in this situation I would think that you could use a union query then you could search both tables for the information and start working on a cleanup solution.
This would have to be done in SQL view of a query, of course and would look something like:
Select [last name], "Table1" as Table1 From [Table one]
Union Select [last name], "Table2" as Table2 From [Table Two]Leave a comment:
-
Ah I see it, you just need to open a recordset for "Select IDRåvare from Halvfabrikat where IDHalvfabrikat = " & rsI!IDArtikkel & "" then you can update IDRåvare instead of trying to update the RSI recordset since you can't update RSI for reasons specified earlier.
Good luck hope all goes well let us know if there is anything else we can do....Leave a comment:
-
I am sorry you have me completely lost now. I read post #12 and you were referring to query A and query B and mentioning items not even in the database that you posted or in the code you have previously posted. The database you posted has one query that sums your figures up but it isn't used in the code either so excuse me if I am a little confused as to where we or you are currently and what your goal is at this point. Maybe you can rephrase your...Leave a comment:
-
I am still a bit confused but I will do my best...
Once you run query B then you can take the ID (IDArticle?) store it in a variable and rerun query B using the ID in a where statement to select that record without "group by article" and make your adjustments...?...Leave a comment:
-
Glad I could help, if you have any trouble setting up the query so it is editable you can post your table structures (pointing out primary keys etc.) and I will be glad to see what I can do. So many time there are people that will not set a simple primary key or something similar and that can prevent a query from updating.
If you need help or would like more information on structuring your tables their primary keys and such then you...Leave a comment:
-
I am still unsure of how or where you are calling the function "fncOverføreHFt ilråvare" from. If you are calling the function from inside of a query then you are definitely going to have problems.
I am not sure exactly what you are trying to do but I will try to help.
1.You will need a form with a button or something, or maybe a macro to call this function and that is where we need to start. Once you have...Leave a comment:
-
Did you try ANY of the changes I suggested?
Looking your post over again I am wondering if the control on the form you are using for the customer code is pulled from a list box, combo box, or are you just typing it into a text box from memory?
The issue for us is to understand exactly how everything is set up and exactly what do you want to see on the form (table normalization for the tables used would help tremendously....Leave a comment:
-
A few questions what event are you using this code in?
I would also like to know if the table "Halvfabrik at" is used in the query built (if you built one) or if that is the table used in the forms Record Source property....Leave a comment:
-
Maybe this will help...
If you are referring to fields in your form then use Me! to help distinguish between a field in the form and a field in the Record Source. I have seen MS Access get a little confused at times if you are not very specific.
Just my opinion but I always try to make sure my field names on the form or report do not have a similar or the same name as a field in the Record Source. Instead of a control on...Leave a comment:
-
Yes so many variables and possibilities as to how things are set up and can be set up it can be really hard to find a solution to an issue like this on a forum.
I don't mind trying though...
1. I was wondering if the page you are trying to send might be an asp page such as default.aspx or index.aspx? I have seen issues there before.
2. Have you tried sending it as a file verses using the HTTP: syntax?...Leave a comment:
-
I would suggest you verify the following then let us know if it helps to resolve the issue or not.
I have quoted the following Note from the following link (hope this helps).
http://technet.microsoft.com/en-us/l...8WS.10%29.aspx
"After you configure a host header or multiple host headers for an IP address, you must register the host headers with the appropriate name resolution system. If your...Leave a comment:
-
I have done some looking and there is a windows update that can break the winsock control and another that fixes it. Forgive me for not providing more info, this is an FYI.
I have also looked a little about using the API and although it can be done I have not found enough info to provide you with any coding that can be of help. If I do find anything worth mentioning I will be back and if you would please post any relevant information...Leave a comment:
-
I did a little digging and found out that you can remove the killbit for the winsock control although I wouldn't recommend it. From what I read upgrading to the latest winsock control should resolve the issue.
Just as an FYI here is the registry key I found that should kill the Killbit for this control:
HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\Interne t Explorer\Active X Compatibility\{ 248DD896-BB45-11CF-9ABC-0080C7E7B78D}
"Compatibil ity...Leave a comment:
-
Just tossing this in http://www.w3schools.com/css/css_intro.aspLeave a comment:
No activity results to display
Leave a comment: