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
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, 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 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...
Hi trainGamer,
Thank you for the post. I have checked out the forums but have not been able to solve the problem I am having. Any Ideas on how I can fix this? thanks
The situation is this.
Data Showing:
jId lId lHistId dId dHistId commId dlUnId LUn Cnt
6012 01 01 01 01...
Hi everyone,
I have a problem with my query. I don't know how to put a record counter into the query that will number each record in the query. eg.
1) record 1
2) record 2
3) record 3
etc...
my query looks like this so far:
SELECT join_tbl_DispatchHist_DispLoadUnload.jobId...
hi everyone,
still having this problem, and wondering if anyone out there knows if it is possible to filter a report with the Docmd.SelectObject method? Thank you
Hi everyone,
I have stumbled onto some new code, but am having a problem filtering the report. This new way does not require me to open the report, but I am lost on how to filter the report to display only the reports the user has chosen. Any ideas would be greatly appreciated. Thank you...
Hi everyone,
I was wondering if anyone knows if this method of printing is the most efficient way to print reports.
Forms!frmKeepopen.Form.chkIsFile = False
DoCmd.OpenReport "rptDispatch", acViewPreview, , rptWhereClause, acHidden
DoCmd.SelectObject acReport...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.