Search results

Hi, I have developed a form with a memo field in it. The user selects a value from another combo box on the form and based on this value the application pastes a standard finding (a few paragraphs of data) into the memo field. The user then needs to edit specific fields within the memo field...

Hi, Since Access seems to be very sensitive to abrupt disruptions on our network, I would like to set the application to close automatically if left idle for a specif time frame. Could anyone point me in the right direction on this. Thanks Chris

I am unable to compact & repair my database. The process bar seems to just stop midway and brings me back to the database window, but the bar is left at 50% progress. It does generate a new a Db1 file, but file file size is identicle to the original database. Any Thoughts ? Thanks Chris

Hi , I have a continuous form displaying records, with about five fields in each record. I was trying to write some VB code that would select the [account#] field in the current record, copy the value. go to the next record and paste the value in the same field. I don't want to create a new...

Hi Could anyone help me on on the correct syntax to requery a sub formB once I have updates Subform A. I would like to place code on the After update property of Subform A that requeries Subform B, and I am having difficulty. Thanks Chris

Hi everyone, I have a workgroup set-up with ten users accessing a backend database, with front-end loaded on each workstation. I am using a workgroup, not a Domain. Occasionally users are getting screen freezes, patches, and the the error message "Disk or Network error". I have to...

Hi Does anyone know if it is possible in access to get the file system objects available in vb, (drive list boxes, dir list boxes, and file list box) if not is there some activex control alternatives ? Thanks Chris

Hi, I have a table in my database that has an ole object field. Typically we use the insert object routine to import or link an image to that field in the record. An example of this is an employee photo field (ole object type) in an employee record table. My problem is that when I insert an...

Hi everyone, I am going nuts with problems I am experiancing getting remote frontend workstations to connect with a backend database on a server running win xp. The program runs fine on server, but when I try to link the remote frontend database to the backend server I get the error message...

Hi Everyone, I have a split database that generally has no problems. I loaded this application on a Dell Sever running WinXP Professional, and I have been unable to open in the program using access runtime. I can open the frontend fine by using access directly, but when I try to use the...

Molly, There is a process to undue the security on a databse. I can't elaborate on it in this message, but search on "undue access security" in this forum and I'm sure you'll find the reference to the documentation. Good Luck

Help ! I have developed an application in Access 2000, and packaged it up with Microsoft Development software, which allows you to deploy with the access runtime. When I run my application in straight access, the margins are all set to 1/2 inch, no problems. When I package the software and...

Hi, After reading many books on Access, I am still not able to find a way to filter report data using a form. I know you can use the parameter [prompt for value] in a query, but when you want to allow a user to filter on several field values, having multiple pop-up parameter prompts just looks...

Hi, I am having a problem on something that seems very simple. I have a query with three fields [last name] [first name] and [dateofbirth] I created a string field to uniquely identify each person [firstname]&[lastname]&[dateofbirth] My problem is that even though the [dateofbirth] field is...

Hi I have completed a database in MS Acces & Used the MS Office Developer software to package the application. I have noticed that after loading the "packaged software" when you run the software from the packaged program, it by passes all log-on information (user name & password). If I open...

I have two questions that I am stumpped on. I have developed a somewhat extensive database, which has worked perfectly with no errors except for these two: 1. I have tried on several occasions to split my database and keep getting the same message; "Subscript out of range" . The splitter...

Hi, I am trying to place a command button on a form that will "Lock" the record. By that I mean the specific record can never be edited or deleted again. I know I can set the form properties to do this but the problem there is once you tab to the next field you can no longer edit the previous...

I am trying to split my database and the database spliter wizard seems to get about 90% through the processs and then give me a "Subscript out of range" message, when I click OK , it gives me "Invalid procedure call or arguement" message. It does create the separate database with the tables...

WE HAVE SETUP AN ACCESS DATABASE ON A SMALL PEER-TO-PEER LOCAL-AREA-NETWORK WITH A SERVER AND ONE REMOTE WORKSTATION. WE HAVE BEEN HAVING A CONSISTANT PROBLEM WITH THE SYSTEM FREEZING WHEN THE USER ON THE SERVER CLICKS ON A PARTICULAR FORM. THE ONLY WAY TO GET OUT OF IT IS TO CONTROL-ALT-DELETE...

Could anyone point me in the right direction on this. I would like to have the ability to select multiple values in a field that can string to one another. My problem is that by using drop down menus, I can only place one value in the field. As example, I would like a memo-type field that...