Recent content by sdk

Hi (without first checking what is in the FAQs) Is the textbox name included in the statement? ie is the name of the control "NoticeDate1", "NoticeDate2", or "NoticeDate3"? Also, the statement should read: =[NoticeDate1] & ", " & [NoticeDate2] & ", " & [NoticeDate3] Cheers S

Hi Is the connection timingout (ODBCTimeout property)? I normally set this to 0, but that may create other issues for you. Cheers S

hi just copy it to where your user community can see it - remember you only want one instance of the database for the users to share, not (or likely not) a seperate database each. There is no need to install as such, unless you are using Runtime. Most database properties are available through...

hi If you want only the full list of weeks, and only those entries that match weeks for your crtiteria, use an outer join. Dbl-click the link between the two tables in the qry design, then select the option that returns all values in Weeks and matching values in TimeLoggedOn. Also remove the...

Hi I have the same issue a couple of times. I cannot put my finger on the cause, but seems to happen after either a dbase compression or a bad value corrupting the dbase necessitating a repair. I am absolutely positive it is not a user-hack - there is not point at the location this occurs...

Hi Does the list have a single value that can be used as a key? - that the Doc-Aircraft is a unique intersection suggests so - then include that key in your subform, make it the first col in you list (hidden if necessary) and link to the subform in a child-master relationship. Alternatively...

Hi take a look at thread181-51747 - options there to consider include mealbreaks, hols and weekends. Cheers S.

Hi my rudimentary understanding is that the Queries are precompiled - unlike embeded sql, and that therefore there will be at least a slight drop in performance. Personally, I prefer to use sql as the source, but acknowledge that data mtce can become a bigger issue (although there are ways to...

Hi The problem is that you are using a cartesian intersection of the results. If one query returns an empty dataset, then there can be no matching results. Duane's advice is correct - look at subreports, or look to shape your dataset differently (unions etc). If there is no data for a...

Hi I think you want 2.x 2.A 2.B 2.C 3.A 3.B to come out as either: x, A, B, C, A, B or 2, 2, 2, 2, 3, 3 is this correct? There is no built-in functions to do this, but the code below, inserted into a module, can give you these results. Pls note I have made the length of the string optional...

Hi mea culpa - didn't read that problem into the question. Cheers

Hi on Duanes behalf: WHERE ((MyTable1.Complete_Date) Between [From-Date] And [To-Date]+0.999); Personally, I would add just one - it won't make any difference to your results, is more correct etc. Also, Duane's advice is correct - you really should look at having a form front-end to control...

Hi I think you will find that running a report wizard will give you the start you are looking for. (It would also be highly unlikely that the wizrd will give you the output format you are looking for :) Cheers S

Hi (You must have a common attribute between the two tables, eg the second table must have the old name and the new, or there is a common identifier between the two tables) Make a backup copy of the table you are changing (more on this later) Create a new query Add both tables join the two...

Hi To get this into the header, you might need to explicity query the dataset and retrieve your value. This might get complicated: copy a clone of the report recordset and loop through counting each chnage in the group spelling (the recordset must be ordered by you group to achieve the desired...