Search results for query: *

Hi All, I have a strange Insert problem (on MySQL v5). If I have a Query Browser window open and somebody else inserts data into a table, when I select * from that table the newly inserted data is not displayed? If I open a new instance of Query Browser and run the same query the data is...

Don't worry, got this sorted myself.

To get the list of order numbers between ranges

Hi All, I have a table with 3 fields detailing number ranges: Number1 ; Number2 ; Qty Number1 = lowest number in range Number2 = highest number in range Qty = number of records in range a record looks like: 500 ; 599 ; 100 900 ; 998 ; 99 What I need is a unique record for each enrty in the...

Unfortunately there would be too many records to do this. I really need it automated.

What is cut© ? Do you mean copy & paste? If so no. If I have 10 records in a table, I need 10 excel workbooks, one for each record with the information inserted. Rgds, Ted

Hi All, I would like to export all individual records in a table to an Excel work for each record, eg. Record1 -> Book1.xls Record2 -> Book2.xls etc.. Any suggestions? Thanks, Ted

Great, Guys, Thanks for the help!

Hi all, I have text in a 20char text field which I want to left align and pad out any remaining spaces with spaces in a query I can left align the data (Format([field1],!)and I can pad out the spaces (Format([field1],"@@@@.."), but I can't seem to do both. Any suggestions would be...

Hi All, I have a subform (based on a query) with criteria pointing at two (and possibly more in the future) drop down boxes. This works fine when all criteria is selected but if one drop down box is not chosen, no results are displayed. How can I prevent this? If only one dropdown is...

Hi All, I have an AccessXP database (upgraded from 2000) with about 20 users, however I'm getting the following error message several times a week - "The database 'Y:\database\db1.mdb' needs to be repaired or isn't a database file. You or another user may have unexpectedly quit Microsoft...

Hi All, I have a subform which is narrowed down by combobox criteria. Is there a way I can flag this subset of records or can I export them and mark them as exported? Rgds, Ted

Thanks Maq, I had the website as www.xyz.com, but it works with http:// before the address. Thanks again, Ed

Thanks Maq, This is exactly what I want to do but I'm getting an error message : "Run-time error 432. File name or class name not found during Automation operation" Any ideas? Rgds, Ed

Hi All, I have a text box where a web address is typed in. How can I use a button to open that site in a browser? Rgds, Ted

What is the easiest way to stop users changing the time on their Win2k machines, and how? Ted

What's the easiest way to stop users changing the time on q Win2k machine, and how? Rgds, Ted

Hi All, I have a form with 3 drop downs, based on a query with the criteria pointing to the forms dropdowns. Each of the criterias are in different 'Or' sections so when the form is refreshed the query works. Is it possible to use the three criteria as 'and' criteria but if only two fields are...

Thanks guys for putting me on the right track, it worked using the 'A*' before the field and with an asterisk. Ted

Hi All, Still stuck on this, even a simple query like select * from table1 where like(field2,'A%') won't work, (and there are records beginning with A) Ted