Meh. Obviously after the 2nd or 3rd time I read more about JET and it's common problem from ancient code. It's quite rare that any files have these problems but what can I say? Are they robust formats, or is JET flawed? Oh well. I was about 9 when LLL the first one came out, with DOS you didn't have to park even though you could, and if I recall correctly it was only in the period around Win 95 that it was a issue.
But anyway you're...
robjens
Last Activity: May 10 '10, 01:45 AM
Joined: Apr 1 '10
Location: Holland
-
Oh my fault sorry. I figured it wouldn't be a problem for like 1 line stuff...guess enough people have problems with English not being their native tongue to start with. I'll keep it in mind and gonna read the forum rules now ;)
CheersLeave a comment:
-
It won't be a problem to spread them evenly if you take for granted that new employees will have less cases assigned. You don't want them to get a burnout on the first week/month so it also comes in handy.
I think you would do with a 1 time full recordset loop, outer one being all the empty "WORK" handler fields, the the inner one all the employees who increment with +1 and rs.movefirst when their loop is done untill all handles...Leave a comment:
-
I had a situation with .pdf too and no real solution since there wasn't any pdf output format in Access. We did have distiller (and thus the pdf printer) so I took this approach
- Set Application.Pri nter = Application.Pri nters("Adobe PDF")
The drawback is that it's hard to automate the user response to the dialog from Acrobat and I went through some length to find short usuable code for sending keystrokes to the dialog...Leave a comment:
-
Is Paramarray a optional argument? I don't see that statement anywhere. Either way, nothing wrong with passing reference of any object from a form class to a function in a code module as long as your scopes are correct which seems to be the case.Leave a comment:
-
hehe a open one? nah...it was at least half a minute after closing the application. And safely removing hardware? I dunno...never ever met anyone who does that..same like parking your harddrive. It was ok,but not really a must to start with.Leave a comment:
-
Tried locals and debug.print / stepping? Also I didn't see gstrwheretyre get declared? Got Option Explicit on? And is it a subform? Then why do you try to open it?
Edit. I think I see what the problem is. Your double quotes aren't quotes but some other char. At CurrentProject. AllForms("frm1" ) (I used the correct one in these. Thats why u rlly should force yourself to use Option Explicit. So you know ur vars ;)Leave a comment:
-
I have the same with 2003 on this machine when I close the application. Everything exits fine but the MDI freezes. Run vista on a quad here and never saw that anywhere else ... weird stuffLeave a comment:
-
So everything works as expected? The way you are doing it is imho the best for beginner/average Access experience. But then again, learning recordssets is easily done and very very rewarding so...DAO all the way.Leave a comment:
-
Oh the joys of JET and abrupt power loss, I/O or even sneezing. I had an Access db corrupted beyond any repair at least 4 times the last 2 months. That was a note to self to wait a few minutes more before I pull the USB stick from the PC.Leave a comment:
-
"printf" perhaps? Go Google :SLeave a comment:
-
Dude this is extremely easy.
Make sure to include the Id in the first dropdown but hide the column, so two columns Id and Name with their width to 0cm;2cm or something. Bound column is Id. Then you take the OnChange event and set that value
Code:Private Sub lstName_Change() Me.lstId.Value = Me.lstName.Value End Sub
Leave a comment:
-
Did you notice the whitespace in (V alue)
I don't really see how you are using reflection though... You scan the form for fields and try to match them somehow or?
Currently I'm just all Xml, all programs love it but it's anyone's poison. There are a 100 ways of doing this but I rarely see adresses like (0x80020003) pop up.
By the way, it should be Excel.Applicati on so I wonder what the underscore is doing there plus...Leave a comment:
-
You have Office Interop reference set?Leave a comment:
-
And reading your post again....you say:
"As program behave differently for local and remote launching.
Hence directory structure is same but scenarios are different."
Why rely on a directory structure to do your verification when you can easily check for the version through either a txt, xml or registry key for that matter. There are literally dozens of options there.
In steps:
1)...Leave a comment:
-
I am wondering, how do the local people obtain their copy of the application? In other words, how do you distribute it? Since you are the creator, you'd be in full control there. In those scenario's where you have virtual machines, the local installs would usually be automatically be ran from some kind of update manager so the network admins can control every aspect of the software package.
You already know that the remote version is...Leave a comment:
-
Your SQL like this won't work. As the the program says, there is something in your query that is wrong. I always check my queries inside the querybuilder sql view to make sure it returns the right values and make sure the syntaxis is correct.
First comment, you are using double quotes in the VBA SQL string, that won't work like this. You need to use single quotes for text values, none for numbers or boolean and sharp for dates. You...Leave a comment:
-
Check out this you will find all you need there and more
http://allenbrowne.com/func-DAO.html...Leave a comment:
-
Thank you so much for sharing that Frinavale. I kinda missed that someone answered this topic so please excuse me for the delayed response.
Partially I have found the stuff I addressed, most easily being the property scoping rules of course. Though for now in my code I mostly use Private and Public (for ease of mind) but where the latter could be replaced with Protected Friend without problems.
My main problem with...Leave a comment:
-
I don't have much experience with the GridView control but for the DataGridView it's quite simple. It's DataSource property allows multiple sources to populate (like DataSet, Xml, DataTable and such) like:
...Code:Dim ds As New DataSet Dim dt As New DataTable Dim xml As New Xml.XmlDocument Dim datagridview1 As DataGridView = Me.DataGridView1 Dim datagridview2 As New DataGridViewLeave a comment:
No activity results to display
Leave a comment: