Search results for query: *

Yup You need the Format function and you can use it in a query. Or on the tables if you know that all the data is correct. Usage: Select Format([table].[telno],"/(000/) 000/-0000") as telephone, format([table].[datefield],"dd mmm yyyy") as TheDate from table Something like...

ahhh hmmm Nope.. not cheers.. Just checked it out. Seems to be sound but when run in ie don't work. Does work if I drop off the #topmenu before the classes. Just so you know.

Cheers

Hi, I read that you are working on getting the forms set up for them all to enter into the same table. As to the formulaes, if you can, forget them and just get the data they are entering into a form for them to use. The formulaes you can come back to at a later date, and get access to loop...

I have a top menu in css, and I am using an external stylesheet. It seems that if the class is set first... (topmenu.gallery) and I use that as the menu background it works. But if I change the html to use the other class (shouold give me a different colour background) it uses the default...

Turned out to be the code for closing the handle. Although it was right, something must have happened during cut n paste because I re0cut n pasted the code and it works fine. Vince

Hi, I have some code I wrote which will allow you to do things until you do a ftpfindfirst/ftpfindnext. Once I encounter the error 18 - no more files and send an internetclosehandle on the search I try to do anything else and it complains saying there is an ftp connection already active and...

Left join table1 to table2 on a key field - look for the null values in table 2 Do Visa versa for missing data in table 1 to table 2. Vince

Create a new blank mdb - import as much of the old one as possible? Vince

Dir$ ??? Or API calls. Inbuilt - you can use dir$ and getAttr (I think) to get what you need. When you feel adventureous, have a look at using API cals to do the same thing. Vince

Or import the spreadsheet first then use the imported table to update the table already there... Vince

1) Depending on what you want in the password - yes. 2) uh? Vince

Perhaps reinstall the add-in table manager..? Vince

Yeah - one of the mdbs you are linking to is on a workgroup or you don't have the rights to a workgroup you are on to a certain mdb. OR.... It may be windoze - in which case see your techie bokes about getting read/write access to the folder (assuming you are at work). Vince

tblPersonelHireDetails PersonelID StartDate StartTime EndTime FactorID tblTaxFactors FactorID - Auto Factor - double You have to store the factors for each period - means more data entry, but easier than getting the computer to divide up the time. Up to you of course, as otherwise you have...

One : Date field, you just format the output as required ... but since you don't want to do this Two : 2 fields, on for month and one for year - both set to integer Three: 1 text field to hold the date in a specified format - must be able to validate the entry the users make. Hope that helps...

Arrays to reports? Difficult, probably easier to create a temp report table, drop the arrays info in as you require and run the report. Vince

Have a look online at catalogs for barcode readers... usually come with req. fonts. I think its simple enough as the reader will put the scanned barcode into a text box and you can do a lookup on it for info etc.. Post up if you have any success. Vince

You could try holding "shift" whilst opening the mdb - if ajdesalvos suggestion doesn't work. Vince

Oliver : listbox.Column(column[,row]) (starts at 0) So column 2 would be listbox.column(1) Mecha: Private Sub OK_Click() Dim RepTo As String Dim frm As Form, ctl As Control Dim lngItem As Long Dim strWhere As String '--- Don't use Str as string as Str is a function!! 'On...