Search results

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...

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...

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...

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...

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...

I have created a public function: Public Function LinkTables(tblName, path As String) On Error GoTo LinkTheTable DoCmd.SelectObject acTable, tblName, True DoCmd.DeleteObject acTable, tblName GoTo LinkTheTable LinkTheTable: DoCmd.TransferDatabase acLink, "Microsoft Access"...

I have some code... It's running... tra la la... I get to a point... If[CountOfDuplicateClients] > 0 Then DoCmd.OpenForm "DuplicateClientList", acNormal Else Continue on with the code.... When the form DuplicateClientList opens, the user has the option to delete the duplicate clients. When...

"Join Expression Not Supported" Does anyone know what this error means? I have several possible places I think it might be coming from... 1) I have one database on my computer that runs on Access 97, but using a runtime version of 97. Everything else I do runs on 2000. Lately, some (but not...

When you run a make table, you can create blank fields (to be updated later) by giving the field a name and then entering a null valur. For example: NewField:0 would create a numeric field with 0 as the value NewField:"" would create a blank text field Is it possible to create a field...

I've got a database with clients and services. ServiceA1 ServiceA2 ServiceA3 ServiceB1 ServiceB2 ServiceB3 I am trying to write a Query to get all the clients who received a B group service, but excluding any clients who got both A and B services. I wrote it thusly (in criteria for service...

Does anyone know if there is a way to change the path to linked tables using the runtime version of Accesss 2000?

I am receiving this error only on some computers. I have a database that I know works. I have it installed on many computers. But for some reason, on one specific network, when I try to install the database I get this error. Even more infuriatingly, if I install as the administrator it works...

I am building a database that is geared towards running a report with some totals of the information in a seperate database. I have created all my queries. They all work. I have created my report. It works. Now I am making a form where the user enters dates to limit the data included in the...

I have a database and security is established using a workgroup... no problem. I have a Set Up form in the database that I want to have extra security, not because the user shouldn't be able to change the form, but there are consequences if they do, so I want the database to re-ask for the...

I am creating a database that will schedule events over the course of three weekends, and I need to reset those weekends each school year. I have created a form for entering those dates, and I think I want to store them in a module as global functions. I set up those global functions, but I am...

OK, so I have to combine two tables with the same information (customers), but the primary keys are totally different. So, I combine the tables, and then I am trying to generate a new set of primary keys. The PK is 03054446100000 then two digits starting with 01 and then consective: Example...

I am having a problem that has been addressed here before, but I am looking for a more elegent solution. I have a Query that generates a list of dated events. I want to limit that list to events falling between certain dates, NOT USING THE [ENTER START DATE] method. I have a nice form where the...