Search results for query: *

if you know where the character is to be placed you could use awk to read the file, write to a new file and add the character at the appropriate point - assuming that it is a text file and that you can uniquely identify the insertion point. John

I assume that you want to return data for the region contained in [Forms]![frmCriteriaDivPM]![txtRegion] only. Simply change the criteria to [Forms]![frmCriteriaDivPM]![txtRegion] and you will only see data for that region. i.e. remove LIKE, the "*" and the ampersands (&). Using...

You can get back to the SRM by issuing: shutdown -h now This will shutdown the system in an orderly manner and halt at the SRM console. Regards, John

Hi, This link should help: http://www.kitebird.com/articles/access-migrate.html John

try: scu scan edt John

Try if isnull(strOld) then doSomething else doSomethingElse end if John

Create a table with two fields: NextNumber and SetDate. Each time you create a record you get the NextNumber, save it with the YY from format(date()"yy-") and rewrite NextNumber to its table after incrementing it by 1. In the OnLoad event of your main form put in some code to compare...

In the report design drag the bottom of the detail section down so that it takes up all of the page. You may need to do a little testing to get exactly the right size. hth John

steroids?

You could also use dupatch to show what patches have been applied. John

First, the till drawer. Usually this will be done via a serial port. You would open the port, say COM1, and write a string to the port. You will need to know the communication parameters required by the till; data bits, stop bit, speed and parity if my memory is correct. Look at OPEN COMx in...

You could try: if not isnull(FieldName) then FieldName = int(FieldName*100) / 100 endif this only acts on a non-null fields. John

This may help you to start: assume your # is 302 in a numeric variable named intNumber 'create an array DIM intNumbers(6) as integer txtNumber = str(intNumber) ' convert to a string intNumber(1) = txtNumber '302 intNumber(2) = left(txtNumber,1) & right(txtNumber,1) &...

If you go to: http://www.mvps.org/access/api/api0001.htm you will find the code you need. It invokes the standard Windows file Open/Save dialog. Regards, John

Try this for your dlookup: varFreightCompany = DLookup("[FreightCompany]", "tblFreightCompany", "[FreightCompany] = '" & FreightCompany & "'") You will notice the pair of ' around the field name you are using to compare with [FreightCompany]. This...

You could try putting the validation on the ON EXIT event for the date field. John

You will need to have an SVGA monitor, kbd and mouse direct connected to the Alpha. Check that the SRM has SET CONSOLE GRAPHICS. good luck

Try: If isnull(StartDate) then DO STUFF endif John

You could put some code onto the ON EXIT event of your text field. You could then test the field for your required contents and display an error message using a message box if it is incorrect. John

try /sbin/vdump -C -u -f /tmp/MY-BACKUP -D /directory-you-want-to-backup John