Search results

The best way to explain this is with visuals I believe. So I am going to recreate my 2 tables below. Table A (Trades) Fund Number Fund Name State Status 9999 Hippo Fund MD Y 9998 Whale Fund WI...

When I try to type in the UNC name I get the following error. Is there something else that I should be doing? The folder 'G:\\mkefsfp02\Share\TADabases\Backends\OnlineAdjustmentRequest_be.mdb' isn't accessible. The folder maybe be located on an unavailable volume or protected with a...

How would I change this? I have already linked the tables using the Link Manager.

Wayne, I looked at the linked table manager and it links the tables to G://Databases....So, I had them change the links to reference J://Databases....Is there a way to reference the name of the drive as in ServerA://Databases...Instead of the drive letter so that I don't have to change it...

I have a database that is all finished and works fine on my local server (ServerA). The database opens to a switchboard which the users navigate to get to form, reports, etc. My server on my network is the G:// drive. I have another user who's local server is ServerB. She views my database...

I want a number field in my table to be 4 digits. I have set up an input mask. 0000 This is working fine. When someone puts in 766 it tells gives them the warning message that there are not enough digits. My question is: Is there a way to make the number put a default 0 in front if there...

Thanks! This did exactly what I wanted it to do.

I apologize if this has been posted already. I have looked at several examples of coding that people have posted but I cannot figure out my problem. I am sure it is a simple problem for someone who has more coding knowledge than I do. I have a function which prompts you for a fund number...

The subform is basically a summary of the order. Not all the fields are included. There are many more fields on the Add form that are not included in the subform. It is setup in this manner because their old system was setup like this. And they want to keep it as similar as they can. This...

I took out the Cancel=False portion of the code and it still works. So that is good. But as far as the cannot save. I only get that message when I do not select the option group. When I select the option group it closes the form normally as it should. And I have changed nothing in the...

Ok, I changed the IIF to IF and the compile error, but when I left the option group blank I got the error "You can't save the record at this time" Microsoft access may have encountered an error while trying to save a record. If you close this object now, the data changes you made will be...

What you said makes sense. I deleted the old coding and added the following code: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.cbFund = "Catholic Funds" Then IIf IsNull(optGroupCatholic) Then Cancel = True MsgBox ("The record cannot be saved until you answer the...

I used the code below and it works like a charm. It doesn't make the field required, but hopefully they will select no and chose one since it prompts them. Thanks so much. Private Sub Form_Unload(Cancel As Integer) If Me.cbFund = "Catholic Funds" Then If MsgBox("Did you answer the...

There is a subform that shows the orders. The problem is that they overlook this and add a new order anyways. You would think if they see their error they would fix it, but they don't they add a new one. I am trying to dummy proof this as much as possible.

I have a main form called frmClientData. On this form there is a command button that opens another form called frmOrderData. What the frmOrderData does it add a new order to the database for processing. What I want to happen is that after you click this command button once it becomes...

Could you provide a little more detail as to what you are trying to do? If there is no criteria in your query then it should return the same records as in your table.

Working now I tried to use the Nz, but could not get it to work. But when I used Iif: =IIf([Text56] Is Null," ",(DLookUp("[Name]","OptionGroupTable","[OptionGroupNumber] =" & [Text56]))) It worked perfectly. Thanks!

Is it possible to have an if then statement in the control source of a text box. For example: =(If([Text56]=" ", " ", (DLookUp("[Name]","OptionGroupTable","[OptionGroupNumber] =" & [Text56])))) Right now when I do this it asks me to define If. The reason I am doing this (in case there is...

That is a great idea...Thanks! I will give that a try.

I have an option group that is visible when the word "X" is in another combo box. This works fine and is not a problem. But what I would like to do it make the option group required when it is visible and not required when it is not visible. I have searched other posts and they have come up...