Search results for query: *

I have a table that has old data as well as newly inputted data. The table is named FIBER. The field name is named CABLE and the other field name is NUMBER. I want to find every record that has a value loaded in the CABLE field and then list the value of what is shown in the NUMBER field in...

I have a main form (RingArch)that has a command button on it to open another form,(Est.NewRing), On the Est.NewRing form the user can enter an alphanumberic value in the RingID field for a new ring number to be added. The users do not know if someone else has already entered this number into...

I was given this code back in May and it worked fine for me. I lost my database that I tested this event on and now I'm trying to rebuild the event on a new test database, but its not working for me now. The only difference I am doing today is changing (date)=6 to (date)=3. Assuming '3' is...

Hi, I have an application on Access 2000. At the time, my ofc mgr stated I could not use the runtime version of Access. Now I am being directed to deploy my application to a group of remote users as a runtime application. I'm not certain if the remote group is currently using runtime 2000 or...

Hi, I want to build a form in Access 2000 and export it to Word. Is this possible? I have users who need a fill in form, but do not have Access software loading on their pcs. Thanks.

I have a form built in Access. My problem is that my users do not have Access. They only have MS WORD and EXCEL. Is there any way for me to provide my users with this form thru WORD or Excel? I hav tried 'exporting' the form but I don't see a Word format(.doc) to export the form. Any help...

Hi, I have a database in which one of the fields is defined as "text" with 11 characters. Due to organizational policy changes the field now must be 20 characters. My questions is: Can my existing database table be changed to allow the form to accept 20 characters? Is this change possible...

Hi, I have been surfing thru some of the security threads, but can't seem to find reference to my question. I am using Windows 2000 and my users have permission to the folder in which my database resides in on the server. I created a shortcut on their desktop, but some of them know where the...

Hi, I am ready to split my database, but need some guidance. I want to allow each user to have the FE on their pc and have the BE on the server. How do I create the shortcut on the user's pc so that they will connect to the tables on the BE? Could you give me an example of how the shortcut...

Hi, I have a report that I would like for my user to be able to print the report at their work location but I also want to receive a printed copy of the report at my location. We are in different cities, different states. My database is stored on a network server in which we both have access...

Good day, I have 2 questions. I hope you can help me. Question 1: I have a database that I have just completed building. I have not secured the database or done a split. My users will need to "insert" data into an existing record and will need to "add" data to an existing...

Hi! I would like to make a copy of my database and rename the copy so that I can let users test the database (the copy)without making any changes to the original db. My first thoughts were to right click on the database name and do a copy command and then use the rename command, but I wanted...

Hi Everyone, I'm having problems with accessing my database on our network server. A "padlock" symbol appears beside the right before the file name. Any help would be most appreciated. kat

Hi, I have a mdb database that I converted to a mde database. I now need to make changes to the mde database. I converted my mdb database on May 21. I made a backup copy before I converted the mdb. All of my updated data are in the tables of the mde database. My question is how do I update the...

Hi, I have a MDE database with no security/permission settings established yet. I would like to have permission set on only one of the objects (a command button) on the form. I have one group of users (3 people) who will need for this command button to be active and I have another group of...

I have a report that is formatted to look like a "form". It has blocked pieces of information with frames around each section of the report. As I mentioned, if you saw it you would think the report was a blank form, but its a report. I want to be able to email this report to my users...

Hi All, If you split your mdb and you want the front end to be a mde file, can that be linked to your back end if you want to keep the back end as a mdb? If the FE and BE are both mde files does that cause any problems with adding/modifying records in the BE? Thank you. kat25

Hi All, The users of my database must be able to have permission to insert and modify data. They must be able to add a new record and modify an existing record. My users will be able to do just about the same edits as I can. My question is why bother with security, if the users have to have...

Hey! I'm trying to determine which would be the best solution for deploying my database. Currently, I have my database on a shared network. I have not split the database yet. I am trying to understand what the pros and cons on having my clients access the database,the front end and back end...

Whenever I type in a number with a leading zero on a field in my form, the number is saved without the zero. Example: I key in 0102. The field on the form displays: 102. I need for the leading zero to be apart of the number the value for that field. The data type for the field is...