Search results

Hi all, My problem is that My access is HUGE. i am working on a project where data called SAM files is imported from the server. This has over 290,000 fields. not to metnion other files with aroun 20,000 feilds. The size of my access is 600 MBs and is extremly slow when opening a report. Any...

email problem.. again ! Hi all. I am very much sure that al of you are fed up with E-mail issues. However can anyone please help me on this.. I want access to send e-mails automatically to different (selected) users. Example. if User1 is over due on something. I want access to send him/her...

Hi, Is there any command that i can add in my form (in my button) to compare to tables ?? Example: i have Table1 and Table2. I need a command that would check if these two tables have the same fields ? i just need to check for the field name and not more. Thanx

HI all, I am creating the project in VB and i am using Access as my Database. I have a small question How can i get the data from access to show them in my VB form without using ODBC ? Is there a way i could do that ? Please help ? Thanx

Good morning All, Anyways here is my problem. I want to create a flexiable form. Meaning that i want the user to enter the values in a form and then transfer these data to a query and then send it to a report. Example, i have a table with users full name, fone numbers, DOBs, etc..etc..etc...

Good morning All. This is my problem. I need to import a txt file to access using macros not File<Get External Data. I needed done automatically. Easy right ? Well here is the tricky part. I am using the Import Delimited command in macro but the txt file that i have is <tab> Seperated...

Hi all, How can i import a .txt file into access ? The feilds are seperated by a tab not a ",".. please help

Good Morning All. Can anyone please help me here ? I have a report with 100s of records. Is there a way i could apply a search function so that i can find someone specific in the report ?? Thanx

I am required to create a program that lets the user selects a txt file and then do a search for a particular word in the file. Then i have to take all the words found and inserte it into another txt file. Can anyone help please ? can anyone lead me to where to start ? I am thinking (no...

Good morning All, I was woundering if anyone knows how to import a txt file into Access using macros. I am aware of the TransferText option in the macros but here is my problem. I have a txt file (a SAM file is anyone knows it) and all the feilds are seperated by a "tab" not a comma ",".. This...

Hello All. Anyone know how to transfer an Access DB to oracle ? I mean i have tables and links etc..etc..etc.. I want to move all that to Oracle. Can Anyone Help ?

Good morning all, Everything works fine with me. I created a button that lets the user browse for an excel file and select and it is automatically imported. The problem: 1)When a user click on this button the browse window appears but clicking on cancell on that window a system error message...

God Morning All, Can anyone please help ? I am looking for a way to insert a counter inside the report so that it can count the feilds it just generated ? Thanx All

Hi All, Can anyone please help me ? I have a password feild and i want to validate it when a users enters his/her password.. The validations are must be 6 or longer. Must have at least 1 number digit. Must have atleast one charector (like @ or $). I know how to do one validation which is...

Hi all, Anyone knows the code that would encrypt a string ?? i am sure that there is such code but i totaly forgot iy ;) Thanx ....

Hi, Is there a way where you could deny any unwated user to enter the tables, play with the data and the feilds ?? Thanx

Hi all, I have been looking for this for a long long time. Unfortunatly i dint get lucky. I created a button that lets a user to choose a file by browsing for it. I was successfull in getting the path of the file and saving it in variable.. So far so good.. The question now.... I have a...

Hi, Is it possible to create a button in a form and then add codes to it and when clicked it updates an exsisting macro ?? Example: I want to import an excell sheet, of course i have to use a macro, however, could i create a button that when clicked it updates the macro details like change the...

Hi all, Can anyone help with this ? I created a button that imports a file normaly using Macros. But i was thinking.... Is there a way where you can click a button and then browse for the file ?? you know like choosing the location of the file and then selecting it ? Thanx

Hi, I know this may sound strange but is there a way to Encryption data in the table ??? thanx