Search results for query: *

I have a VB6 application that I use to compact any version of access using the function below. I use input boxes for the user to input the version, and the password (in any). The only part I can't get working is the Security part for databases using Workgroup security. It does work for all the...

The sync database I've been working with has three replicas and the two laptop replicas sync to the office replica every day, and they are compacted before the sync. Then at the end of the week the office copy is syncronized with the master. We can usually keep going for several months before...

yes, you can make the replica the new master. sounds like you've solved your own problem!!

You will probably not get many responders to Synchronization issues because these databases present ongoing problems. I've kept one limping along for a year that I "inherited" at work. But don't worry, yours CAN be fixed. First of all, the big question is did you save a copy of the...

Danny, Did you set your Switchboard as the start-up form in the new database? Go to Tools - Startup and a dialog box pops up. In it, you need to select the Switchboard from the Display form drop list. Try that and let me know if that takes care of your problem. Luck!! Susan

Danny, Without seeing your code, or having an opportunity to step through it, I can't tell what the problem is. First thing I would suggest though is to check the following: 1. Compare the tables included in your new database to those in the replicated database. You want to be sure you didn't...

Danny, If you no longer have another replica to synchronize with, you should convert your database back to a stand alone. To do this, open a new database and import all objects from the current active replica EXCEPT for the tables. Then close the new database. To get the tables added, open...

Try this: Private Sub cmdParseAddress_Click() Dim varParsed As Variant Dim stNumber As String Dim stStreet As String Dim stStreetAddress As String stStreetAddress = txtAddress 'call function to parse name into array values 'the values of the array in the function "Parse&quot...

Try this out. Dim stNameArray() As String, Name as String Dim Total as Integer, i as Integer Total = 0 Name = G:\Applications\ 'whatever directory 'Get total number of files to set array upper bound FileName = Dir(Name) Do Total = Total + 1...

Since the keyword search is disabled, you can go to groups.google.com to search on your question. Before you enter your keyword or phrase, go down to the forums listed and click on comp. then type in "Resize app to fit screen resolution" and activate the search. You will find a...

Try this: stFile = "ThisFile.txt" StoreFile (stFile) Private Sub StoreFile(stFilename As String) Dim stPutFile As String stPutFile = "C:\SomeFolder\SomeOtherFolder\" & stFilename Open stPutFile For Output As #1 DoCmd.Quit acSaveYes MsgBox "Your file...

For a combobox you can have an unbound combo and in the properties under Row Source write the select statement such as: SELECT Employees.EmployeeLName FROM Employees ORDER BY Employees.EmployeeLName; Similarly, for a list box that is unbound: SELECT ReportNames.tblReports FROM tblReports...

Here is code written for a Visual Basic user interface, but shouldn't be too hard to adapt for Access. I don't remember quite how you use the common dialog control in Access, but I think it's different. Hope this will help. Private Sub GetFile() On Error GoTo Oops Dim stFilename As...

So many useful suggestions and points to consider! The vast majority of the apps. where I work are in '97, so I've not used the MSDE engine. Thanks for that information. I have not done any OOP - something I should be learning, and would also be interested in handling recordsets through...

My thanks to all for responding. I had a feeling I would hear a number of diverse responses. I have been called upon to write up a criteria sheet to be followed regarding database application development using MS Access or some alternative, and at what point should existing Access databases be...

I agree that in the business world MS Access is insufficient and not secure enough to serve as a database. However, wherever information specific to patients is not being stored, Access is commonly used here for the purpose of speedy development, and lower costs than dedicated servers. What...

As a post script, I'm thinking that what you need to uncheck for start up is the "Use Access special keys" under the Advanced button. Hope that works for you.

When I set up the Start up, I uncheck the following: Allow Full Menus Display Database Window Allow Built in Toolbars Then click on the Advanced button and uncheck: Allow Viewing Code after error Use Access Special Keys I suggest that you make a copy of your database and test each of the above...

At my job I've inherited a replicated database with problems. I made a new working model and did the enhancements etc. and tried to make the new master. When making a new replica master, I'm getting the error #3583 &quot;Cannot make the <table name> object in <table name> container...

I'm a Visual Basic/Access developer in a very large metropolitan hospital. Aside from the obvious security/HIPPA legal issues, what are the criteria by which MS Access databases should be changed over to SQL Server or Oracle, OR should not be the database of choice at development time? Areas...