Recent content by eatwork

Hi, I have a question regarding vb.net and databases. I am using visual studio 2005 with an MS Access database as the backend. I have used the server explorer -> data connections to create a connection to the MS access database. My question is whether or not I can create a constant, bound...

Hi, I was able to solve the problem after some more searching on the the topic. Thanks for the help everyone. check out for the solution to this problem: http://groups.google.ca/group/microsoft.public.access.reports/ browse_thread/thread/4283a736355703f7/ d934783b0af20841%23d934783b0af20841

OH forgot: 1) Database: MS Access 2003 2) Report: MS Access Report 3) Bound: Yes, the report is bound to a query within the database

Hi I was wondering if there is a way to order the data shown in a report when I open the report. I know I can filter the data in a report, but the users require the report to order the data based on their selected criteria. eg. DoCmd.OpenReport stDocName, acPreview, , "Order by dDate" does...

Hello sfatz, mgmslate, and all others, Thank you for your posts. Not sure if the slowdown was the query itself or not, but I decided against the automatic updating of the label, would've been nice but it could hold up a user while processing data so I decided against it. mgmslate, I'm not...

Hello JoeAtWork, Thanks for the reply. I will check to make sure all the fields I am searching for are indexed, I think they are already, but it won't hurt to double check. Thanks

Hello TheAceMan1, Whats shakin? I did not know that the dlookup and dcounts were aggregate functions, and that they were the slowest methods available. The dcounts and dlookups I am utilizing are coming from queries already, is there another way to access that data without using the...

Hi mp9, thanks for the post, tried the code, not sure if it made it a lot faster, but I've changed my code. Thanks for the help

Hi, I was wondering if anyone could help with the following method. It seems very slow, and I am calling it from the timer. It has to open some access window to process the function and I wouldn't think a dlookup or dcount would take so long. Public Sub updateStatuses()...

Hi, I was wondering if Multi-threading is possible in access 2003 and if so, how exactly is it done, eg of simple syntax. I have an access form, which on open sets a timer variable. The form timer is then set to call a method which calls a couple dlookups to write text to a label. The dlookups...

HI all, I answered my question, forgot to add the libraries. Thanks

Hi can anyone tell me what the VB.NET equivalent is for the following C# methods? 1)RuntimeHelpers.GetObjectValue() 2)SingleType.FromObject() 3)StringType.FromObject() 4)ObjectType.NotObj(obj1) 5)IntegerType.FromString() 6)DoubleType.FromObject() Thank you

Hi PHV, That worked perfectly! Thank you for your help. I was wondering if you could maybe give a short reasoning so I can try to figure this out on my own in the future. Thank you again

Hi everyone, if I change my From Statement to the code below, my results are close but does not increment the count properly. Any ideas on how to change my FROM to solve this issue? thank you. Data Showing: jId lId lHistId dId dHistId commId dlUnId LUn Cnt 6012 01 01 01 01...

Correction: Data Showing and wanted should be: Data Showing: jId lId lHistId dId dHistId commId dlUnId LUn Cnt 6012 01 01 01 01 2969 5124 L 2 6012 01 01 01 01 2969 5124 U 2 6012 01 01 01 01 3951 5125 L 4...