Search results

alll GOOD in the HOOOD program is done....thank you so much ghudson for your help....IT is awesome that there is a comprehensive programming community on the web that is willing to lend resources and time to complete strangers. Your services have not gone unnoticed and i again thank you very...

foiled ghudson, I entered the function freplace into a module and then called it in a query but it will not open the query saying there is an ambigous name. What am I doing wrong?????

foiled ghudson, I entered the function freplace into a module and then called it in a query but it will not open the query saying there is an ambigous name. What am I doing wrong?????

Replace function undefined hey ghudson, when i run that query it is displaying that the Replace() function is undefined? I am running access 2000, has that function net bet defined yet in 2000?

Thank you so much ghudson, That is awesome, thank you so much. If i could just have your quick help i one more thing that would be superb. Now what would the syntax be for an update query, that after this query runs would then delete the 5th and 10th characters which would be the...

thank you the input mask is for writing data to a table i am assuming? For my db, the user is entering the number on a .asp form and the vb script is simply finding that value in the ndc field and returning it to a display on the asp page. So with this update query i can essentially import...

thank you so far people I am going to try that right now, but yes i think that i just want the string formatted before it is submitted. I want the user to type in the number without the hyphens and i want the hyphens to automatically insert themselves as the user is entering the input string...

Hello ALL, I need some VB code that will delete the first character of an 11 digit number string when I am importing this field into an access table??? THanks alot my peoples...

I have a form where a user will enter a 11 digit number (12345043456). Using ASP (VB) this string of numbers queries an access database and returns the entry for that specific number to the user. Unfortunately, the numbers in the access table are an 11 digit number with hyphens seperating...

im new to access, is there anyway that you could describe that process a little better. can i just have a macros that deletes the data in the existing table and then imports the new data. Right now i have a macro to import the new data but all the records are lost. How do i delete that data...

I have a transfertext macro that imports my text file into a table but the table already has data in it so it is not importing and losing all the records. What do i do to clear out the table before i import in.. Can i use another macro ???

I need some kinda code that automatically imports a text file into an exsting table..... The problem is i need this to happen when a batch command is executed !!!!! Does anyone have insight???

Peter thanks for responding. What macro would I use to delete the table data? What macro would I use to append the new data? Do i make an import spec and then reference that within the macro? What code would i run when the DB opens? VB? and where would I find this code and where would I...

hello everyone, i really need some detailed help as the deadline is approaching and I need to find a solution for this. Any help would be greatly appreciated I currently have a batch file that ftps a text file from a Red Hat Linux Server to my W2k C:\. I would like to make another command in...