marcf
Last Activity: Jul 24 '08, 03:30 PM
Joined: Mar 13 '08
Location:
-
As an update i've confirmed its he event firing multiple times while its still trying to display, any ideas on how to make the second firing of the event wait until all previous ones have finished? -
Telnet Client, Sockets trouble!
Hello Everyone!
I have so nearly finished a mud client for a customer to the point where I was about to send them the source code. Out of luck I took the project home to try it on my personal PC just to make sure.
At work on my corporate network everything works perfectly but it seems once anyone uses the client on a direct high speed connection to the internet the incoming text seems to all get jumbled up!
... -
Bindingsource Not updating listbox?
Hi everyone,
I'm probably being dim here but here's my problem.
My main form opens a subform for a user to add notes, when they click save it does the following:
---------------------------Start Code -----------------------------------
Dim cmd As New SqlClient.SqlCo mmand()
With cmd
.Connection = New SqlClient.SqlCo nnection("Data Source=MYSSERVE R;Initial... -
I think I kinda sorted it.
Basically you can't assume that your DSN is working correctly, for some odd reason if you use application.cur rentproject.con nection object it works fine unless you try to DELETE or INSERT.
Instead I swapped out the Con= Application.Cur rentproject.Con nection for an SQL connection string (which I thought a machine DSN was supposed to do?)
now it all appears to work fine and aside from...Leave a comment:
-
Access Database just upsized and i'm going to kill someone!
Ello everyone,
Ok i've just upsized the database to SQL Server 2005, here is the code:
Set con = Application.Cur rentProject.Con nection
Set rs = New ADODB.Recordset
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimisti c
sql = "INSERT INTO reminders (CompanyID, [Company Name], [Company Contact], Number, Appointtime, Appointdate, [User]) VALUES ('" &... -
Sorry was trying to do too many things while posting this morning:
Databindings: As I understand it in vs2008 you link a form to data using the databindings. As the example when a user does next record if I use databindings the binding control then goes off and retrieves the next record from the database(or is the data retained locally unless its out of date?)?
If I create a recordset when I open the form then when the...Leave a comment:
-
VB.NET Databindings
Hi everyone,
I've just studio using VS2008 and have a quick question regarding databindings, i'm fairly handy with vb6 so this question really relates to good practice rather than actual coding.
Our backend is SQL 2005 express edition, my application connects to this database fine, it is planned that the database will have approximately 10-20 users.
The application is basically a sales based CMS and I... -
yeah that way you can also have a look at the data its imported and check its all done ok, the only way it will throw up errors is if you've Changed the type of field, the length of field or input masks.Leave a comment:
-
Ok I think I get ya!
Easy fix:
1) Set the window(Jobtaske dit) to Modal, this means it cant be unfocused until its been closed.
2) Disable the red 'X' at the top of that window(jobtaske dit)
That way the user has to exit the form by the close button and you can do all validation knowing that its not being closed by any other windows!
Sorry for the delay in replying for some...Leave a comment:
-
Sorry if it seems a bit scrappy but its probably the simplest way I can think of. By the way when your talking about a SUBFORM you mean a form within your form, or do you mean a separate form opened from your main one?
If Me!JobTask_Edit _JobSubTask_Lis t!SubTaskID.Val ue = "" Then GoTo missing
missing:
Should be:
If Me!JobTask_Edit _JobSubTask_Lis t.SubTaskID.Val ue = "" Then GoTo...Leave a comment:
-
Assuming I get what your asking for then its simple, not that I think your stupid but dont include the <> around subform ;)
if Me!<subform>!fi eldname.value = "" then ....
As a tip I tend to disable the big red X in access and make users close forms via a big close button, that way you can validate all you like without having to muck around with events.
Cheers...Leave a comment:
-
depends on what you are actually ticking, if your ticking the field directly through a datasheet view or if you have tick box controls, for me the sql statement would be:
UPDATE <table> SET tick1=true,tick 2=true,tick3=tr ue,tick4=true WHERE <idnumfield> = <current record idnum>
If you can give more idea on the type of form your using etc I can probably give you an easy solution.
Cheers...Leave a comment:
-
Hi,
I wouldnt say i'm an access guru but to me the safest and simplest solution is to simply import their data into your new version.
Providing you've only added columns and cnot hanged the existing ones it should be very easy!
Let me know if you have any other questions.Leave a comment:
-
As an after thought:
Someone else suggested this could be to do with data corruption in memo fields, the notes field in our database is a memo field but i've tried looping through all memo fields in the database and accessing them without an errors being generated.Leave a comment:
-
Stewart,
We've done two things which seem to have fixed the problem, or at least changed the error message:
1) Split the database properly, now all the tables exist on the server and the forms/queries/reports all sit on the client machines.
2) Purchased more users for the server.
Now i'm getting on occasion, "You cannot you find/replace here" or something along those lines....Leave a comment:
-
As a tip regarding readability of code I always ask people to do the following:
1) Come up with meaningful variable names.
2) Variable names should contain some kind of reference to their declaration ie for strings Stmyvar, integers, Intmyvar and so on.
3) When adding to your code dont just chuck stuff in at random places try to make your code do one thing at a time.
4) While jumping into...Leave a comment:
-
Record is deleted! Access 2003
Hi Everyone,
Hopefully someone will be able to offer a suggestion to this problem.
I have a multi user CMS running at work which I wrote. Aside from a few bugs everything has been going fine except for one annoying problem. Heres the info:
Windows XP workstations connecting to a windows 2003 server with roaming profiles for each user. Access 2003 SP2 on all machines.
Error: Record is deleted...
No activity results to display
Leave a comment: