Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. eatwork

    Is it possible to bind a dataset to a database connection?

    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...
  2. eatwork

    Docmd.openreport order by

    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
  3. eatwork

    Docmd.openreport order by

    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
  4. eatwork

    Docmd.openreport order by

    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...
  5. eatwork

    Method is too slow...Dlookups Dcounts etc

    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...
  6. eatwork

    Multi Threading in Access

    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
  7. eatwork

    Multi Threading in Access

    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...
  8. eatwork

    Method is too slow...Dlookups Dcounts etc

    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
  9. eatwork

    Method is too slow...Dlookups Dcounts etc

    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()...
  10. eatwork

    Multi Threading in Access

    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...
  11. eatwork

    C# equivelant in VB.NET

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

    C# equivelant in VB.NET

    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
  13. eatwork

    Count Problem

    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
  14. eatwork

    Count Problem

    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...
  15. eatwork

    Count Problem

    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...
  16. eatwork

    Count Problem

    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...
  17. eatwork

    Count Problem

    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...
  18. eatwork

    Report Printing - Efficiency

    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
  19. eatwork

    Report Printing - Efficiency

    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...
  20. eatwork

    Report Printing - Efficiency

    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...

Part and Inventory Search

Back
Top