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

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

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

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

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

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

Hi All, I have a query about a replace statement.. Using VFP 6. If I run a select query it retrieves the correct data: select * from table1 where field1 = 'test' and field2 like 'A%' however if I run a replace query with the same criteria I get an error 'Command contains unrecognized...

Hi All, When installing NT server on a server it is giving me an error message after hardware detection. It finds the SCSI controller but then does not find any hard drives installed on the machine. It is a Dell poweredge with scsi raid controller. Any help would be appreciated. Ted

Hi All, I have two quickies.. 1. How do I update a value in a field to 1.5 times it's own value? 2. How do I update a value to the value of another field? Rgds, Ted

Hi, In a command button, how do I run a select query and then query the results. Ideally I don't want to create a table, can the 1st result be stored in memory and then queried? e.g. Select id, date from table where id = '12345' then Select id, date from (above results) where date = '01/01/01'...

Hi, Can I store the result of a sql statement to a variable and if so how? eg. store select max(field) from table to variable Rgds, Ted

Hi, I have a form with a combo box. If I copen and close the form closes normally however if I select an option from the list box and click close button I get 'Cannot access selected table' Do I have to release the combobox? I'm using two tables, 1 for combobox and 1 for query data, the close...

Hi, I am trying to select data from two tables which have no foreign key. Can I join these two tables using two fields in each table? eg. select tbl1.a, table1.b from table1, table2 where table1.a=tbl2.a and table1.b=table2.b I've tried inner joins with no success. Thanks in advance, Mac