Recent content by bob bisquick

I am trying to do this: On MainMenu form, click on a button to open a new form. On the new form there is subform. I want to open the new form with the subform on a new record. A solution posted here often looks like this: DoCmd.OpenForm DataEntry, acNormal, , , acEdit Me!Subform.SetFocus...

I have a switchboard where users can click on a number of available Access database names and those databases open. Those databases use User Level Security. When those databases open, the username and password dialog box appears, but the focus defaults to the password. How do I reference this...

I am trying to open one database from inside another (the user logs in, gets a "switchboard", and can choose from one of several databases from the switchboard). Those other databases have user level security. I tried using the method from the Microsoft Security FAQ: Dim lngReturn As Long...

Bingo. Thanks a lot.

Ultimately, I need a big table to export, that has one record for each patient, and a whole bunch of information about the client that could be imported into SPSS. I had thought of making one field per medication, which I guess would also work. You know med1, med2, etc... But I still am not sure...

Ah. I have those things. A table for patients, a table for meds, and a table with meds prescribed, linked to patients and meds by Primary Key. I am trying to make a report that lists each patient and what meds they are on.

I am trying to do the following: I have a table with patients and medications they are on. One record per med per patient. I would like to make a table that has 1 record per patient, with a field for the patient key, and a single field that has a list of all the meds the patient is on. I...

I figured out a whole different way to present the info that eliminates that problem completely. Thanks.

This is related to some advice I received some time ago <a href="http://www.access-programmers.co.uk/forums/showthread.php?t=64818">here<a> I am runnign some code, it performs some applications, then, if a Count Field is greater than 1, a form opens as a dialog, displaying some information...

ghudson - I have set up error trapping, as per your response, and I am still having the same problem (ie I get the same error with no info). I see several possibilities: 1) Despite your post, I set up error trapping incorrectly. I compiled the code, and eliminated all the typo type errors that...

Thanks. That will take a little while to implement... a lot of subs.

I have an Access database that runs on a machine with a run-time version of Microsoft Access 2000, distrbuted by the original designers of the database. Several times I have designed other databases that function as reporting tools, they generate reports based on data in this original databse...

Well, I found a solution elsewhere on the web: Dim wrkDefault As Workspace Dim dbsNew As DATABASE Dim prpLoop As Property ' Get default Workspace. Set wrkDefault = DBEngine.Workspaces(0) ' Make sure there isn't already a file with the name of ' the new database...

I am trying to extract some data from a database into a new database on a floppy. The extraction process is all set, but currently you have to manually create a database on a floppy. I want to automate the creation of this empty database. This type of issue has been posted here before, but...

Yes, but I am trying to automate this process. Also, I am really more interested in why it works when the code is associated with the form and why it does not work when the code is in a module. I was under the impression a public function should work anywhere in the database.