Recent content by DblDogDare

I have attempted to secure my database , but am running into some problems. I created the new .mdw file. I created groups and set permissions. However, for some reason other people can still log into the DB. Also, the users, including myself do not have to enter any passwords. Now, I cannot...

I am wondering if it is possible to have 2 print buttons on a report. I want the user to have the option of printing the report to a printer or printing to a .snp. If they print to a .snp, I want to be able to set default location of the .snp. Also, is there a way to default the .snp to open...

Problem Solved I figured it out. I found the fix an another forum. I created an index on the 2 fields.

I have a table with two fields ECP and Rev. Duplicates are OK in each field, but not when concatanated. Is there any way to "No Duplicates" on combined fields in a table? I have queries , forms, etc., that concatanate these, but I am finding that my users are duplicating. Any help is...

I have a query that is giving me a problem truncating a memo (table) field. Here is the scenario and some tests I have performed. The table field in question is a memo field. This table has a many to one relationship to another table on a different field. I have created a query using these 2...

Almost there Jeremie, Thanks for the reply. I resolved the issue of the multiple "type". However you have peeked my curiosity with the combo box. I have a switchboard. It would be nice for the users to be able to pick a button, have a combobox open, and select one of the projects and have...

All, I have a report that is based on a Like [type] criteria query. I would like to have a subreport based on the same query to show a list of different data. The problem I am encountering is a prompt several times for the [type]. I want to only have to type the field name once. I basically...

Try this Pangloss14, Sorry I didn't rply back to you on my posting with the similar problem. I have been working on another issue and didn't get the chance to reply back to you. Anyway, the way I got it to work was to put the following into the Afterupdate of the popup form...

Figured it out Ok, I have gotten it to work. For anyone else that may encounter a similar problem, I am including my change to the above code. I deleted the requery and undo statement from my 1st form. I added the following "forms![original form name]!Combo box name.Requery" to my...

Still Confused OK, I am still having difficulty. Should the .Requery point to the "Control Source", or the "Name" in the property window. I am currently pointing to the "Control Source" and the code is automatically adding the square brackets "Me.[ProjectName].Requery". When I add a new...

Any other suggestions?? dcx693 Thanks for the reply to my post, however it didn't work. I entered your suggested code in the OnClose event of the subform. It died on the ".Value = Me.txtNewValue" (as entered). It did not show the new value in the table as it did before. The confusing thing...

I am getting a runtime error 438 on a requery that I can't figure out what I am doing wrong. I have a form with a combo box that I have the users entering a project name in the combo box. If the project name does not exist, I have another pop up (onLoad) form for them to enter the new project...

Thanks Dugantrain. I knew someone with experiance would be able to help me out. I tried resarching before I asked (3 hours) and thought I'll go ahead and ask. Someone out there has probably run into this and can guide me within a few minutes. You came through for me. It worked, however I...

I am having some difficulty with Auto Populating Date fields. I have a form that has multiple (7) signature blocks and each signature block has a corresponding date field where some, or all, are filled while filling out the form. (2) of these signature blocks will always have a name entered...

Problem Solved I did a little more digging in this forum and found the answer to my problem. I found it in tje queries section. For those that may be reading this thread and have the same problem, here is the link to the thread that I used . Thanks everyone...