matthooper
Last Activity: Feb 1 '08, 01:49 PM
Joined: May 9 '07
Location:
-
actually, i have found out how to do it... and now i could kiss you but i won't cos thats just weird!!! -
forgive me for being stupid, but how do you create those?!Leave a comment:
-
I am trying to make it look like a form on top - I lock all the controls so nothing can change.Leave a comment:
-
matthooper replied to error "database engine could not lock table because it is already in use by other"in Accessand are you using code to add to the list or are you using the horible access control thingie...Leave a comment:
-
matthooper replied to error "database engine could not lock table because it is already in use by other"in AccessDid you have the table open?Leave a comment:
-
Here is an image of what is happening
...Leave a comment:
-
if you have the SQLNative drivers installed on all computers, use:
.Properties("Da ta Provider").Valu e = "SQLNCLI"
MUCH QUICKER!Leave a comment:
-
yes the form loads within the form using the subform controlLeave a comment:
-
whats the code for the connection string? I would recommend using ado:
...Code:Dim rmcn As ADODB.Connection, rmrs As ADODB.Recordset ' Create connection and open connection - remote Set rmcn = New ADODB.Connection With rmcn .Provider = "Microsoft.Access.OLEDB.10.0" .Properties("Data Provider").Value = "SQLOLEDB" .Properties("DataLeave a comment:
-
ah-ha - i have the subform appear in the middle of the screen, and with different screen res it appears all over the screen.Leave a comment:
-
subforms and list boxes
Hi all
I hope this will be an easy one....
I have a subform that hides and appears as and when its needed with forms etc etc etc but when it runs over a listbox, it's hiden behind it unless I run the mouse over everything in a certain way.
I have tried bringing the item to the front but it does not work... any ideas?
Thanks -
one more note to add. Novell runs on windows systems to - it just acts like NT!?Leave a comment:
-
but surly that would not allow them to access the login page?Leave a comment:
-
It's 'windows' but IIS allows anonymous access. Surly its over-ridden by IIS?Leave a comment:
-
Server Sessions and Novell Systems
Hi
I don’t know if anyone has had a similar problem with Novell and IIS, but when a Novell user accesses our website this is what happens:
- User logs into our login.aspx file
- The user details are processed to make sure they match in the database. It is at this stage a session state is added.
- Once they have passed this stage they are passed to intro.aspx where some instructions are given and the... -
It depends on how the tables have been designed.
you will have contact details of the person you are writing to and a case worker assigned to that person. (whether this is in another table and you are using a number to link them) If you link those two bits of information using a query, use the query as a source for the report and within a text box use:
...Code:="TEXT" & [caseworder/fieldname] & "Continue
Leave a comment:
-
I think i am going to have to create a local table with the data that i have just queried and use that as a datasource.Leave a comment:
-
Im guessing no one knows the answer - its okay - i used append instead to copy the data to a local table - did the work and then delete all the data from that table to start the process again.Leave a comment:
-
runtime error 2593
Hello folks
I am trying to use ado in an access report with no luck.
...Code:Private Sub Report_Open(Cancel As Integer) ' Global Vars to be used through code Dim sQl As String ' Declaire remote connection Dim rmcn As ADODB.Connection, rmrs As ADODB.Recordset ' Create connection and open connection - remote Set rmcn = New ADODB.Connection With rmcn
-
ADO recordset
Hi,
I have a make table query and the syntax seems to be fine but I have no idea where the table has been created?!
sql statement: "SELECT field, field1, etc, etc INTO temptable FROM linkname.dbname .dbo.table;"
You may look at that and think why on earth I would want to do that but the ado connect connects to one sql server and then that links to another sql connection. To make the next query...
No activity results to display
Leave a comment: