As mentioned I would take a look at using DoEvents when running anything outside of access is being run. I have seen the code execute many times in a non sequential way unless I use DoEvents which in my eyes forces the execution of the code to go the way you want.
I had the issue quite recently when displaying a "loading" form whilst running a pass through query. The form would simply not open or close at the correct times...
munkee
Last Activity: Oct 17 '12, 01:00 PM
Joined: Feb 23 '10
Location:
-
Thank you for the reply CK a TRUNCATE would not quite fit in this situation as I am deleting using a WHERE clause so I only move related data in and out of the table. I do not mind having my method questioned I am always on the look out for improvement as I am probably quite poorly self taught with a lot of Frankenstein methods to get the job done :-pLeave a comment:
-
MS access updating to SQL Server Identity Column potential weakness
Hi All,
For nearly a year now I have been migrating over various local access databases over to SQL server back end. Access purely acts as a simple front end to display the data.
I have realised in one of the latest applications I am converting that maybe.. well.. quite possibly I have a bit of a flaw in my logic for updating the sql server back end with any new data from the front end.
When opening up a detailed... -
Js/Ajax function problem
Hi All,
I use the following code to query my websql database to see if there are any records.
If records are found then I use an ajax request to submit these to an asp page which in turn pushes the form information on to a sql server.
So far everything is good however I now want to delete each of the records from the WebSql database only when the ajax request returns a success.
I can't for... -
Seems I totally misunderstood the fundamental problem here. By building my app in asp.net/vb.net and utilising server side controls the app would never be able to be made offline in simple terms without a re-write. If the application is running offline the server side controls would not be able to work due to a lack of postback. This can not even be simulated within an offline app that uses these controls.
In order to produce a solution...Leave a comment:
-
Offline web app asp.net help
Hi all,
I have a website written in asp.net using vb.net. It is used to submit issue reports across our business. We are going to be using iPads in the near future and I have found that we often work in remote locations without Internet access in the field.
I have done some research and found I can firstly use HTML 5 Application cache to store my web app offline. I am now however at the point of wanting to understand... -
Thank you for the input NeoPa. I assume this means Jet runs perfectly fine and is adept at working with the client side object manipulation etc but ADODB is the one for working with the serverLeave a comment:
-
OK managed to get this working by switching away from DAO and using ADO as I found a pretty decent tutorial regarding its usage. I have pretty much 0 knowledge of ADO so it would be nice to have found out the solution using DAO but the structure seems quite easy to understand in the new method so for now this will have to do.
My completed code:
...Code:Function ado_test() Dim cnn As New ADODB.Connection Dim rs As New ADODB.RecordsetLeave a comment:
-
I have moved on a small amount with this I have altered my stored procedure and when running this within Sql server query analyser I am returning the desired value.
The trouble now is getting this in to ms access via my function which I cant seem to get my head around.
The new stored procedure:
...Code:-- Add the parameters for the stored procedure here @DteOccur datetime, @Pdetected nvarchar(50),
Leave a comment:
-
Sql server stored procedure output parameter to ms access vba
Hi all,
I use the following function to execute a stored procedure which inserts records in to my sql database. I am trying to return the primary key value so that I can display it on my page however I keep getting the error that the "item is not found in the current collection".
My function is:
...Code:Function Execute_Stored_Procedure(Proc_Name As String, Proc_Values As String, Optional ByVal Output_Return
-
Thank you once again I have been reading numerous articles again to get my head around all of this and it seems in essence I can probably break everything down in to pass through queries for all of my continuous data/searches, utilising views if necessary to reduce the number of joins being sent in the query if applicable. After my searches across multiple records are complete I can then drill in to specific records, only selecting one at a time...Leave a comment:
-
Thanks for the input NeoPa.
If I want to optimise for usage over a wan how can I handle bound forms? At present my main form for updating records is bound to a table with a number of sub forms linking to other tables.
If I wanted to stay bound and also see performance improvement through the usage of sql server would I be looking to bind to the results of a stored procedure?Leave a comment:
-
Pass throughs / UDF / Stored Proc / Views.. The differences in my upsize..
Hi all,
I am jumping in to the world of SQL server with an access front end. I am going to be converting an existing database over so we can use it across a wide area network.
I have been doing a lot of reading around stored procedures, user defined functions, views and pass through queries.
All of the information in isolation has been great and not so hard to understand at a glance but now I have come... -
Vs submit page and retrieve record for success page
Hi all,
I am currently getting to grips with visual studio web developer 2010.
I have created a web form in vb which I have submitting to a SQL express 2008 database.
I want to produce a submission success page where I can show the record that has just been added including the primary key which is incremental that I use as a reference number.
Visual studio seems to have a million and one ways to... -
Thanks for the input NeoPa we have commandeered a old tower pc at work and are using this to host a mysql database that we can do some testing on within our local LAN.
I myself want to purely see how I can utilise ms access front end with mysql back end with some .aspx pages for remote users.
We are also going to try and see the performance benefits of shifting a 4.2million (over 3gb of .txt files) record database from...Leave a comment:
-
I have decided purely for testing to run a tunnel similar to your suggestion using hamachi. I have setup up a mysql server on my home laptop which I can leave on to do some WAN test from work.
I am aware of the issues around WAN and I am wanting to just experiment to see its impacts to get a good idea what the possibilities are.
I have informed our company that a terminal server will be needed in the short term and likely...Leave a comment:
-
Seems this is a none starter after some further researching
http://bytes.com/topic/access/answer...mysql-via-http...Leave a comment:
-
VBA ODBC Connection through proxy
Hi all,
Been a long time since I asked a question on here so here goes.
I am trying to connect to a mysql database to get some data using an odbc connection. However the problem I have is that we use a corporate firewall. I have been given a username / password / IP / port that I can use to connect through the proxy however I have no clue how to set up my connection to do this.
The setup is as follows:... -
Can I just query the reasoning for being unable to use the SMTP?
My company uses some quite crazy security but there is always a way around this.
If you are using outlook then you have direct access to the SMPT even with windows authentication. I can provide the necessary code to do this if required.
Aside from that there is a third party addon for outlook called "outlook redemption" you will...Leave a comment:
-
Form submit to access database. Correct method?
Hi all,
I have taken the plunge to move away from regular html forms with and all client side coding in to asp.net. Server side scripting is totally alien to me but atleast you can write in VB (I am used to VBA but it is close enough to be able to get by).
I have a form which currently submits information to an access database using javascript however I am looking to move this to asp.net. I have looked at numerous tutorials...
No activity results to display
Leave a comment: