Search results

I don't really understand what the problem is, but here goes: You have a main form and an additional "small from" with the same record sources. You've possibly created a command button to open the second form: Dim stDocName As String Dim stLinkCriteria As String stDocName =...

GHudson! Hehe....I tried it and it didn't work....but then I realized what I was doing wrong. :rolleyes: Sorry to have asked so many times. I hate being the one to frustrate people, but I guess we all have our turns. I have an alert report that runs before the "EDIT" version of the...

I know this isn't the best way to do it, but...I've done it this way: My client locations (across the nation) have their own database versions. (On 9 servers across the nation) Each of those versions has an Export form...that e-mails the relevant table to the home office (Then resets all of...

Right click for Properties and change the DISPLAY WHEN property to SCREEN Only This will prevent it from printing out, but will make it visible onthe screen! Simple as that;)

ghudson, I appreciate the example, but I'm not going about it the same way that you are. if I had to separate forms that it would be ease to make the titles/captions appear differently. I have ONE from that is opened from the switchboard in either acAdd or acFromEdit mode. So, I need...

I'm not sure if you'd figured this out on your own yet, but if you haven't..hopefully this will help! Create a Command Button without the wizard. Right-click for Properties and then set the Hyperlink Address to your other database file. Use the ... next to the Hyperlink Subaddress property to...

Shot Down Twice:( Okay...I tried them both: If (Me.AllowAdditions = True) Then Me.Form.Caption = "Enter New System Records" Else If (Me.AllowAdditions = False) Then Me.Form.Caption = "Edit Existing Records" End If End If (ALWAYS OPENS WITH "ENTER NEW....") AND THEN: If...

Knight....you can still use the short cut keys. If you're not planning to change the database, then I would convert it to an MDE! If you plan to edit it....holding down the SHIFT button will bypass the startup settings You may either want to consider creating your own security or using the...

I don't know exactly what your fields are...so I can't tell you exactly what to do. It just doesn't sound like have told the forms themselves to open on the same record. Even though you have associated the tables with a promary key...unless you provide the promary key on both form and then...

Okay I'm maintaining a database that has one from which can be opened in Edit mode or Add mode from the switchboard. The users have requested that the Form Name in the title bar coincide with the MODE that they have opened the form in. So, I want to be able to have the title bar read Adding...

Have you set the forms to open based on the unique number from the main for that the user enters data from? Set a filter to run the forms where [PrimaryKey]=froms!formname![PrimaryKey] So the forms open on the same record!

Hmm...I think that you might be going about all of this in the wrong frame of mind. I'm assuming that you have a good idea of the user requirements? You can either start from what the user wants the end product(s) to look like, or start from the elements that they want to track. So..determine...

I think I have implemented something similar to this, but if you could paint a slightly clearer picture..I would really appreciate it. What is it that you want your users to access? A form allowing them to update records or add records to the existing table....which is linked or exported back...

Okay..... I would suggest settin the Stage field to automatically update when certain criteria or fields are filled in! Or make [Stage] a drop down box like I did for testing. The only problem with that is you don't actually want to allow users to return to a previous stage (assumption on...

Wow..thanks for the information! We should ask Jon to create a thread for links just like this....you know...informational links that don't really require responses, but are useful references for all of us! Thanks for sharing!

The Command button wizard will allow you to open a specific .xls or .doc or any other file for the matter through code or a macro. If you're not familiar with writing code or don't want to waste the effort of creating a macro, I would simply suggest that you create a buttn without using the...

Douglas, 1. Place the > before the input mask (to establish an input mask, type "input mask property" into the Access Help index. THis will give you all of the characters that will determine the formate that you will require from your users. 2. Do you need your default to be dynamic? I...

So you've tried locking the fields in the form and that prevents the search from functioning?

RV, I'm not trying to count anything. I'm trying to verify that the unbound field entry exits in one of the two tables. So, I want to first look up the entry in the [MasterSystemsTbl]. If the field matches then I provide a message box telling them to proceed. Else, I want to check...

Douglas, Okay...I'm on my way home, but here is something for you to work on: 1. Use the > greater then symbol to keep everything upper case! 2. You can set a default value to your combo box. Just right click on the combo box, select properties, and scroll down until you see "Default...