I have a table with commas in the last name field because I import data. Is there a way for me to use a query to delete these commas and only these commas after the data has been imported.
I have created a vb script that will convert a file to text for me to import those records, but I can't seem to run it from Access. Can someone help me. here's the vb script i'm using.
Option Explicit
Dim oFSO
Set oFSO = CreateObject("Scripting.FileSystemObject")
If...
I have an access database that I want to use in the Application Launcher. Can someone please help me w/ start up information? I know how to create applications,etc. but because an Access file is considering a document, I cannot get it to work.
Thanks!!!
I need some help. To my knowledge, no one changed anything on the server. We already have major server issues. I checked the launcher and also checked the applications tab but the "Novell delivered Application" screen does not come up for any users on the network except the administrator...
I have a laptop that I bought from a pawn shop. The only problem is that I cannot get past the windows 2000 login screen. I would just re-install windows 2000 except there is no CD-rom to do that. Can someone please help me?
Is there a way for me to log out specific users. I have most administrative priviledges in netware except remote console, etc. I have users who can make crazy moves and cause our server to need dumping. As a result, I have to tell all users to log out and then down the server and restart it...
I have several reports that I need to generate at the same time using a macro, however I did not want to see 5 input dialog boxes. Is there a way to put the ID number in one time and it be used for all report/queries????
I know this should be easy but I just can't think of a way to do this. I'm trying to write a query that will select the most recent invoice/transaction for each account. Right now, I have 2 tables: vendor and vendor transactions. Thanks for any help.
I have developed a rather complex access database. I have a handwritten form that's been used in the past before the system was created. i'm trying to continue to use the form as a hard copy while the data is in the database as well. With the form, it would be necessary to circle several...
Our company has a nationwide Paradox database which has all the information that could be needed but its accessible to certain users due to restrictions. However, I need to be able to access some of the paradox tables but i'm running office 97 and its on a server. I do not have the drivers for...
I have a field with the whole name in it with no spaces like Doe,John. I need to have a 2 separate fields in a query: one for the last name and one for the first name. Can anyone help me
I have a form that has the information for about 500 employees indexed by their employee ID. The user wants to be able to click a button and enter only the Employee ID and their information is filtered into the form. Can anyone help me?
Can anyone tell me if a rule can be created to print a message once its received in my Inbox. Eudora and Pegasus both allow this and we were used to this feature. Now we cannot use it anymore w/ Groupwise to my knowledge. Please help.
I have calculated the age in form from a birthdate field using
Int((Date()-[birthday])/365.25)
in my control source of the form. Can someone please tell me how i can get this information stored in the table? Right now, its just on the form and is dynamic I guess.
I'm a office technology instructor. I have all my student grades in a access database. I have created a front-end database for them that displays their grades if they are logged on. I want to check their attendance by using a similar feature. I know that it can be done. When they log in, I...
I'm using Novell 4.11 and I would like to get a log of the lastlogintime into a Microsoft Access database when the user logs on the network. Can anyone please help me?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.