Search results for query: *

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

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

Hi everyone, I am attempting to learn about threads and multithreading in VB.net and stumbled across a tutorial online. I was following until the article, which is in C# did this: // update the grid a thread safe fasion! MethodInvoker updateGrid = delegate {...

Hi, does anyone know if it is possible to use separte threads for the different subreport sections in a report or something? I am getting a performance issue when I include subreports or other fields into my report where the report, after including 3 subreports, takes an extra 10 seconds to...

Hi everyone, was wondering if there is anyway to increase the number of groups that the report will sort and group by? I don't have enough groupings for my report and I have used all of the group headers and footers possible. Thank you

Hi everyone, I was wondering if anyone knows how to determinte if a user is connected to the database before I compact and repair the database. I was looking online and I need to ensure no one is connected to the db at the time of compaction to ensure the database does not get corrupted. Thank you

Hi everyone, I was wondering if anyone can tell me what the difference or how to solve this problem: DB: ACCESS VIEW: SELECT QUERY Expression: Expr1: Format([formLoadTime],"mm/dd/yyyy") Between Format([equipmentStartDate],"mm/dd/yyyy") And Format(IIf(nz([equipmentEndDate],"")=""...

DB: MS Access Query In: MS Access Problem: I have two tables, tbl_equipment, tbl_trailercomb. Each item in tbl_equipment can be used like lego to assemble one record in the tbl_trailerComb table. Not quite sure how to accomplish this. Thank you eg. tbl_equipment tbl_trailerComb...

Hi everyone, I was wondering if there is anyway to concatenate a result set from a query into one field. Eg. query returns: quoteId includes: 1 chocolate 2 flour 3 salt from that result set I would like to create a string: "The quote includes chocolate, flour, salt"...

Crystal Reports: .Net Database: MSAccess Report Datasource: XSD Problem: I have a report that has a subreport. This subreport has its own subreports. Eg. Report quote - group quoteId subreport items - group quoteId sub subreport notes - group quoteId, itemId The sub subreport views fine when I...

Hi, is there a way to do a dlookup type function within crystal reports? I have a problem because I have a report that is based on two tables. These two tables have no relation what so ever. The first table is my customer table, and the second table is a table filled with constant data that may...

Hi, does anyone know what this error means and how I can resolve the issue? I have created a UFL for crystal reports in VS2005 and have created the assembly etc. It works fine in preview report, but when I load the program and try to load the report from the viewer it gives me the error...

Hi, I was wondering if it is possible to create multiple functions within a formula field? I have 4 functions that I am importing into a new crystal report and I don't think it will work if I need to merge all of the formulas together. Thank you

Hello everyone, I was wondering if anyone knows how to convert a variable of type single to a single or long that is equivalent in pixels? THE PROBLEM: Declare Sub GetCursorPos Lib "user32" (lpPoint As typPOINTAPI) Type typPOINTAPI X As Single Y As Single End Type This code returns a...

Hi, I was wondering if anyone could tell me how I can determine the x position in a listbox if the user has used the horizontal scroll bar and scrolled over to the right? thank you