Search results

Wow, simple questions, not simple answers, but I will give it a go. No, I wouldn't say so. I would have to say it is Deployability. The advantage being that your data (the Backend) is located in a central location either a shared folder on a server or located on an SQL Server that everyone can...

From the Tools menu, under Database Utilites select Make MDE..., and follow the screens. Read up on MDE files in the Help file. But basically an MDE is a "Microsoft Database Executable (MDE), it will copy your MDB and compile it into an MDE where you can distribute it with out worry of the...

Yes, it's possible but enter the link for that thread and I will post my reply there as not to confuse this thread with a second issue.

A. dont use a macro B. insert into the code under the command button on your Main form that you click on to open the History form. Should read like so: Private Sub cmdOpenHistory_Click() Dim strWhere As String strWhere = "[ID]=" & Me![ID] DoCmd.OpenForm "frmHistory", , , strWhere...

From the database window, the box that lets you select and open Tables, Queries, Forms, Reports, Macros and Modules, Select Modules and select the New button, it will open a new window where you enter VBA code that is blank except for one or two lines of code at the top. Copy and past ChrisO's...

If I understand you right, you should have two separate tables attached to two separate forms, with a relationship setup connecting the Patient table to the History table through a unique ID field instead of the patients name (to eliminate getting patient names mixxed up). When you click on the...

Try inserting ChrisO's code into a public module and change the declaration "Private Function" to "Public Function" and you should be able to use it for other things in addition to just the one report.

Sounds like you've got a good handle on your technology. Keep in mind if you suppress the notification to to convert 97 to 2k2, you may confuse the user's nor will they be able to make changes to the objects and controls of the 97 db only update the data tables. good luck, :)

Pono1, Thanks for the links, it was a great lead. RangerTen, The KB Article explains it all, your "Strange Thing..." Because you keep calling the function from the original memory space, you are reseting (closing) the form that was opened recursively in the previous call before reopening a...

At this point, I'm at a loss, I would have to see it. I'm sorry I've not been of more help.

I know it's possible in .Net but Access 2k and 2k2 are not .Net. Well if someone know's it, I'd love to see it in VBA. Office 2k3 is set to release in November I think, and it will be .Net 2003 equivilant. While Office 2k and 2k2 are VB6 library/syntax equivilant. Office 97 is VB5.

It still sounds like the table is being locked exclusively by the first user, if your absolutly sure that "All Records" is not the selected record locking feature then we'll have to keep trying. The only thing that is coming to mind is that they are both using the same file simultaneously, they...

Dim test As New Form_frmForm1 DoCmd.OpenForm test.Name 'but what's wrong with: DoCmd.OpenForm "frmForm1" but I don't think you can open the same form twice simultaniously:confused:

Check your record locking on the form, is it "Edited Record", "No Locks", or "All Records", make sure it is set to "Edited Record". You should also check the Options (from the Tools menu), once open, select the Advanced tab, and in the upper right corner is "Default open mode", make sure it is...

Try the "Access Programming for Dummies", instead of the regular "Access for Dummies" books. Books exist for both 97 and 2k but not 2k2 yet.

I know exactly what you are talking about, but I'm telling you, you have to use a form. The form that you create will be tied/related/connected to the table of your choice and on the form you add combo boxes, list boxes, text boxes, radio buttons, check boxes, command buttons, the list of...

The simplest answer is "Yes- All of the above". You can do everything you mentioned, it all depends on what will best fit your need. But basically, the development process goes like so: 1. Create a table in Access and/or Import an Excel sheet into a new table or an existing table. 2. Create a...

Ok, so add two combo boxes or add two text box and a 'Go' button to the header of a form. You have to create a form to do this, you cannot do this in Table/Datasheet view like you can in an Excel Sheet, Access is a great deal more powerful than excel, and as a result some simple things in excel...

Welcome, Use a combo box, if your toolbox wizards are turned on, when you add a combo box to the header of a form, a wizard will start and guide you through a basic lookup combo box that will filter records in your form when you select relevant criteria.

I have several develop and test workstations, my three primary workstations are below: Win2k: -Access 97 -Access 2000 -Excel 97 -Excel 2000 -Word 2000 -Outlook 2000 Win NT4: -Access 97 -Access 2000 -Excel 97 -Word 97 -Outlook 97 Win XP Pro: -Access 97 -Access 2000 -Access 2002 -Excel 2002...