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

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

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

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

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

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

I have a database that is being used to setup payroll deductions from an employee's account. I have a text box [CallInDate] that marks when the employee calls in to set up a deduction. The deductions can only start on the 1st and the 16th of the month. So, I have a combo box [cboStartDate]...

I have a combo box A where I have different ways of shipping (ie. Fed Ex, UPS, and Airborne Express) I also have a text box A where the account numbers for the above services go. The problem is that I want to change the format of the cell to make it fit the shipping service chosen. For...

I have a few cascading combo boxes on my form. They follow the order below. Everything works exactly as it should. However, once I get to the Items (cboItem1, cboItem2) there is only one value in the combo box. So I want to make the first and only value in the list be the default value...

Simple Question I am trying to write code so that I can trigger the after Update event in a form. I have done this fine with the coding below. It works perfectly for text boxes, combo boxes etc. However now I am trying to write the same type of simple code to set a check box to yes. I know it...

I have a query that has 4 yes and no fields. In the query I want to add all the yes values. ie... [FieldA]=Yes, [FieldB]=No, [FieldC]=Yes, [FieldD]=Yes, [SumField]=3 I know there has to be an easy way to do this. Any help would be great. Thanks!

I have a question about conditional formatting. I am using Access 97 and I am trying to make a field required or not depending on a certain list box (whose values are yes/no). So basically I have [List Box A] whose values can only be yes/no. And when the value is yes I want [Text Box B] to be...

Related to thread http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43238 I have put this formula into my control source. Dcount("[Field Name]","table/query","[Field Name] = [Textbox/Combo]") And it wasn't until after that I realized it wasn't exactly want I wanted. I...

Hello- I am having trouble setting up my tables. I was given the general appearance of how the form should look and am now trying to work backwards to come up with the tables. General Background - When the company I work for brings on a new mutual fund group there are 184 tasks that...

I went to this link http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36332&highlight=update+field+on+current+form+only And I basically want to do the same thing. I want the date to be the current date when the field is entered. However, I tried to set the date field to...

*I have a form where if the word "SEI" appears in a certain field a command button will appear. This command button will appear after this field is updated and on the on current event of the form. *However, sometimes this field is not updated manually. Most of the time this field is input...

I have a main form with several subforms. The main form is linked to a query which asks you to select a code which relates to a specific company. So when you load the form it asks you to enter the company code (ie CA for Company A). Some people at my work are printer happy and want to have...

I have a database with two front ends and one back end. Up until yesterday this was working fine. Both front ends have tables, queries, forms, reports, and macros. Yesterday, front end A worked fine. And everything on front end B worked find EXCEPT for the a certain form. Everytime anyone...

I split my database into a front and back end. Now I need to change the location that the both are located. How can I do this? I tried to copy and paste but it still links to the original backend.