Search results for query: *

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

Hi Below is some code I have used to control some aspects of after runtime. This is called in the autoexec macro, but the dbase has to opened twice for the process to work (first time sets, then the second acts on the new settings). One of those is the availability of toolbars. Pls note that...

Hi You must have a highly skilled user base to be this dependable on their typing skills! Why not use a listbox (multiselect) to build the list? Then loop through the selected values to set the target query's criteria? I think the results would be more dependable. Using the results will be...

Hi Is there a table with the names mapped to each other? you need a common key between the two, then run an update query to overwrite the exstg name with the new one. Link the common key from the two tables in a query, change the query type to an update (menubar: Query >> Update Query) and...

Hi, Not sure why the sql isn't happy, but try replacing ORDER BY min(id); with ORDER BY 1; (I find this is often a handy syntax) Cheers S

Hi I tend to think that your solution is the best. Alternatives: - Have a flag (checkbox) that says the date is indicative only - change the field type to a string (but this will introduce mayhem) It does come down to the use of the date. If the attribute is really day-sensitive, then...