Search results

Do an update on the field with the following Ucase(Left([YourFieldName],1)) & Right([YourFieldName],len([YourFieldName])-1) or if you want to ensure that only the first letter is in upper case then use UCase(Left([YourFieldName],1)) & LCase(Right([YourFieldName],len([YourFieldName])-1))

Check out the Microsoft template available below for DVD collection, it may be of some help. http://search.officeupdate.microsoft.com/TemplateGallery/result.asp?qu=access

The way you have written your if statements is not taking into account that a user may not have selected from one of the earlier list boxes. So you have to account for this, the easiest way being checking if sCriteria contains anything yet as done below. sCriteria = "" If...

It sounds like an append query would solve your problem. You need to append from subcons to test where your criteria is met. If you want to do it in code then just create an Insert SQL statement to do what you want.

Need to use Left, Mid and Right functions Left([YourFieldName],4) - first 4 characters Mid([YourFieldName],5,3) - 5th, 6th and 7th characters Right([YourFieldName],2) - last two characters Keep in mind that if your fields are not all of same length then the above would lead to inconsistencies...

Essentially what I need is to be able to delete records from an Oracle table using A97. I know that it must be something simple but I just don't seem to be getting anywhere. I need to run a delete query on a table and then an append query to append the records for the run week. Each week...

Try the following: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31785

Why not use Time() instead of Now()?

Go into the table design and set the default value for your date field to Date() - gives the date only, dd/mm/yyyy Now() - gives the date and time, dd/mm/yyyy hh:nn:ss

Build a query and format your date field in whatever way you require and then export the query rather than the table. The text file should hold the formatting as in the query. To suit your needs try Format([YourDateField],"mmddyyyyhh:nn:ss")

Check the following: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=33193&highlight=replace

The following should help. It pads out a string with whatever character you wish to make the string the length you require. Thus to pad out your string with spaces to left to length 6 use LPad([Stage]," ",6) or to pad out your string with spaces to right to length 6 use RPad([Stage]," ",6)...

Assuming the 'New Date' is in the table you are querying and has been set to the required date then just use the following as the criteria under the 'New Date' field. Between Date() and Date() + 14

Use the Minute and Second functions like so Seconds=(Minute([YourTimeField])*60)+Second([YourTimeField])

Use the following expression to determine the fiscal year, can be changed to suit any year by changing the 10 to the start month for the year division required. IIf(Month([date1])<10,Year([date1])-1,Year([date1])) If you want it formatted as FY01 then use the following "FY" &...

I am in a similar posistion in that I have been trying to convert from 97 to 2000 and the databases in 2000 are somewhat larger than in 97. Also the databases take longer to run, the application I've converted takes about 1 hour to run in 97 but takes over 2 hours in 2000. I've tried changing...

Assuming the field is set as text and not number then you just need to run a query to update all values for the field to 'X' where the value is '1'. If the field is set as a number then you'll have to change the data type to text and then do the update query.

Try format([YourDateField],"mmmm yyyy")

Check http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=33847

Try format(Month([YourDate]),"mmmm")