Search results

Thanks for you link and the tip i will try it out

Hi, Just wondering, i'm using Ms Access 2000 and i need to search a drive on my computer eg T: drive and look for all *.jpg and put the name of the file in a table. Do you know how to write this in code please? Thank you in advance

I am trying to add text from one field from another field in ms access 2000 using VBA. Basically i have a table called tblLetters, with field names as LetterId (Number) Letter (Memo) Name (Text) Address (Memo) Postcode (Text) For the field letter i have differet templates eg Letter Id 1...

Hi thanks for your help it work i used the link you supplied me and i went to another link which was on that website

Hi i'm trying to send emails in Outlook 2000 via Ms Access 2000. How do you write in the Subject of an email and in the body part? The information will be coming from a query so different customers have different information. There are 4 different email templates it can be, providing what...

Just like to say thanks, not sure how i forgot about Dlookup. Thanks once again

Hi can anyone please help me. What I’m trying to do is on a form there is a check box, if the check box ChkGW = -1 then I want a price to appear in a text box txtGWP The price is in a table called “PS_tblSettings”, the field name is sName. In the field sname there are lots of records I want...

Hi the replace function does not seem to work in Access 2000. Do you have any other ideas please?

Hi i'm just wondering on a query i have a field called sort code and i am trying to take away the "-" Eg 60-60-50 I want it to be 606050. Is there an easy way to do this is a query as i have over 500 records. Thanks

Hi, just having trouble with saving an excel document on the desktop in Windows XP. As different users log in you cannot select the path see below with the username highlighted C:\Documents and Settings\username\Desktop\ Is there a way in VBA where it just saves it on the desktop just for that...

Hi, In MS Access i'm trying to calculate the difference between one date time to another. for example 26/04/2007 09:00 am 07/03/2007 10:30 am (Current date time) This should work out the: days hours minutes seconds I did want this to be shown on a form Thanks

Hi, I need some help, I’m trying to update 1 database which is in SQL on one server with data from another database which is on another server There are around 8000 records. It is taking for ever updating the data via MS Access Append Query and Update query. Do you know if there is any other...

Thanks allot, i tried that and it was fine.

Hi I'm trying to deleterecords from one table. In the query there are 2 tables both joined. I get an error message come on saying "Specify The Table Containing The Records you want to Delete" Below is the query in SQL DELETE tblStockRequired.StockCode, tblStockRequired.StockQTY...

Hi, I need some help here. (I have attached a word documument as an example) I’m trying to match 2 recordsets where the stock codes match against each other. Table 1 is quantity stock a customer has order. Table 2 is how much quantity of each stock the company holds. A Stock (StockCode) can...

Hi I'm having trouble with my database (Access 2000). I'm trying to export a file into a text file by clicking on a button. Below is the code. Where the code is in bold that is when the runtime error happens. If i export the code manually by right click on the query > Export then this works...

Hi, Does anyone know how to compact a ms access 2000 db in vba code. I want the database to compact evertime it is opened up. Thanks

i put the code in on "ON Exit", As soon as you exit the text box the code will run in the background then i want the focus to go back to that same text box

Hi i'm trying in MS access go to a text box after exiting a certain text box on a form. I thought this would work : me.txtTrack.setfocus It does not work and goes another the next text box which is in the tab order. I do not want to change the tab order. Please can you help Thanks

Hi, I need some help, i keep getting a runtime error when i am running my code in MS ACCESS 2000. Sometimes it works fine sometimes it goes to Degub runtime error. When this happens i just have to close the system and restart it, then it works fine. I do not understand what runtime error 91 is...