Search results

Hello, Yes I did mean the *'s as blocking what is typed in for security reasons. Create a form called frmPassword that has a field for the password, and a continue button. From the main menu, each button will open the frmPassword, but have the open arguements passed to the frmPassword set as...

Glad it worked for you! I learned something from this as well, I never realized that the filter property was saved, so good lesson learned. Actually I have a current database where the Record Source changes to a different query depending on who is working with the database, I had to go back...

As missingling said, that is the correct way to "open" a subform. I guess I sort of accidentally assumed that you were doing it this way. Attached is a copy of a database that demonstrates how the subform "opens" with a one to one relationship.

On the subform make sure that the Master/Child link fields are set correctly. The Master Link Field should be "ICF_Case ID Number" and the Child Link Field should be "F1_Case ID Number". This way when you display the subform, it should show the record in the subform where both of those numbers...

Ok thanks for your explanation, that brought me up to speed quite quickly. I don't understand how this machine can be transferred though. I assume you're going to try and hook it up to someone who can either contact the other world, or try to capture one of their out of body experiences...

I'm not sure why I'm getting into this rathole of a thread... but here goes: I've read through all 14 or however many pages this is, and in all honesty I don't understand what Tim is even trying to accomplish here. Maybe it's his bad English, or maybe I'm missing the concept. Do I believe in...

Ah, I misunderstood your method. Thanks for the clarification, I will have to go try it out.

If you already have a PDF printer installed on the PC, you can use the following code. If you don't have a PDF printer I believe the LeBans PDF code is the best, but requires some .DLL files.

Nowadays I make my own password forms so the password enters as "*" and etc. Which may suit your needs better, but this one uses an inputbox to get the password: Dim stDocName As String Dim stLinkCriteria As String Dim password As String Const VALIDPASSWORD As String = "2ez4me"...

Sorry for the double post, but I believe I see your problem. On the form, the Filter is always saved with the form, however FilterOn is set to false whenever the form is opened by default. So even though your form appears to not be filtered (FilterOn is set to False), the Filter Property still...

Instead of using the filter approach on the report itself, why not declare the criteria before you even open the report. Assuming you have a button on your form that opens the report you could do something like this: DoCmd.OpenReport stDocName, acPreview, , Me.Filter This way you can make a...

I would use VB programming personally, but some others may prefer macros. Dim area As Double Dim perimeter As Double If Not IsNull(txtArea) Then area = txtArea End If If Not IsNull(txtPerimeter) Then perimeter = txtPerimeter End If If Not...

I believe you may be misunderstanding how an Access Report can work. An Access report does not have to be columns, the top of your report graphic can be done in Access (The bottom part looks like a subreport list). When you design the report and it's in coliumns, in design view you can remove...

I don't believe there is any set rule, because there are always exceptions. Keeping the number of relationships to n - 1, where n is the number of tables is good for most cases, because having a number of relationships equal to the number of tables means that there is most likely a relationship...

I believe he wants to get rid of the navigation bar and use real buttons. When you create a button and use the wizard, you can go to "Record Navigation" and "Find FIrst", "Find Previous" etc. and then add the text to the button as you please. TO "save" you can have a button with the code as...

I think you're best off just making your own website, and promoting your services that way. This makes it easier to set the price range, show examples of your work, and the quality of it. I'm not too sure about freelance sites, but where I work we sometimes get consultants to do databases that...

I've tried the following code: If CurrentProject.AllForms("frmMainItems").IsLoaded Then If IsNull(Forms![frmMainItems]![ItemNumber]) Then DoCmd.OpenForm "frmMainItems" If Screen.ActiveForm.Dirty = True Then DoCmd.RunCommand...

I am using one of those logout prompts now, however what happens if a user has started entering a record, but there is no primary key entered (assuming autonumber is not used, this system generates the primary key only after the user has filled out info to prevent partial records etc.)...

Here is an example of what I think you want.

I have done something very similar in a recent project. Your main table should have a combobox for "type of record" or whatever you are dealing with, each specific type should look to a certain table. If this does not fit your case, then you would need multiple buttons on which subform to...