Forms | Forum profile

Hi all, Love to hear your suggestions on the following problem I have: I have one of those invoice type forms (a main form with a continuous subform). In the subform I have a button which opens a popup form which updates the same same record on the subform - in essence it allows the user to update optional fields which aren't displayed in subform. Everything is fine except when the user ...

I have a form with the combo box called cboAgent which is created with a value list. I want a subform to be displayed according to the chosen agent in the combo box. The subform should get the data from the form frmCase which stores all case details.Although I put the code in the After update event of the combo box to set the recordsource of the subform it is giving me runtime error'424'....'...

Hi, Is it possible to put a scroll bar on a listbox so users can navigate horizontally? I cannot change the form width so would like to neatly fix the length of the listbox with a scroll bar if possible.

Hello, Is there any way to have a scrolling label on my Form? I plan on putting a variable amount of data in the control on the form.. I did a search and found someone else was asking a similar question; the reply said look at: http://www.access-programmers.co.uk/...ML/006522.h tml But, when I click on this, it says "Forbidden" Thanks for any help here

I have an option group on my form and when I click on an radio button in the option group I want its label to change yellow. How can I do this? Thanks

I have a date field named "ModifiedDate". After I edit or change the value in the record, I want to change the last modified date in "ModifiedDate". How should I do it?

I have started my database but I'm still a new developer (trainee), I need someone who could help me developing it for better enhancement and useful easy database. · I have faced a problem in the main entry form, I could not make the macro for example when you select the Employee ID Number, the rest of information about the employee will come automatically and access it ...

We have a database that tracks sanitary and storm sewer maintenance. There is a form that I want to order based on the sewer type field (SYSTEM = san or sto). I can do this with a query but this code was written by others so I’m a bit nervous about changing it too much. Currently the form’s Record Source is: Select * from TACTION order by Jet_Seq This works fine for [SYSTEM]=”SAN” ...

Hello All, Since this is my first time here, I apologize if this has been answered, but i'm not quite sure how my search term should go. So if it has been done please direct me to the specified thread. Thanks! My problem is that I have one form called frmMonitor that pulls in data from tblMonitor. The data I am more concerned with is a field in tblMonitor that states who a unit is ...

When I try this VBA code: If Me.ckBoxSortMgaByLastName.Value = True the form crashes with an error: "You entered an expression that has no value." I get this error whether unchecked or checked. For debugging I tried this code: MsgBox (Me.ckBoxSortMgaByLastName.Value) Got the same error msg. I went into the debugger and typed ? Me.ckBoxSortMgaByLastName.Value and ...

I am using a form in access as a main switchboard for a database. The main switchboard takes me to a second switchboard form via control button and macro. I only want limited access to the second switchboard is there any way to password protect the macro fired by the first control button so only aurtherized personel will be able to access the second switchboard?

Please bare with me on this. I am usinging Access 2003. I apoligize for asking this again but .. I did this right once before but I had to redesign the form. Somehow this has got messed up. I am using the syntax I have seen in Bob Larson's post on this. I am using a command button (cmdUpLoadQEtoExcel) on the main form to load an excel spreadsheet. The text boxes I need to load are...

Hello, I can’t figure out how to finish this database and needed some help "Please". 1) I wanted the current day highlighted for the calendar. 2) I also cant figure out how to turn the day the color of the employees attendance code Example: If I enter a vacation day on July 30th then the number 30 would change to the color of the attendance code "Green in ths case". Thanks!

Hey, I'm not incredibly new to Access, but I do need some help on something that may be simple to you guys. I'm updating/improving a database that a Post Office is using to track packages across a college campus, and they want me to build a button that they can click to automatically send an email to the student to let them know, "Hey, your package arrived. Please print this email and bring it ...

I have started my database but I'm still a new developer (trainee), I need someone who could help me developing it for better enhancement and useful easy database. · I have faced a problem in the main entry form, I could not make the macro for example when you select the Employee ID Number, the rest of information about the employee will come automatically and access it ...

can this be put in the table or query? or is it only available to the form fields?

Hi I'm working on a couple projects, and have a similar problem with the two of them. I have a table with X Products. I need to create a form that as soon as you enter, shows all the products currently existing in the table Products. The rest i think i can do just find.. Can someone send me a very simple form that does this. I beleave using a DataGrid is the best way, but if...

I'm sure this is an easy one but I can't find help anywhere. Maybe i'm using the wrong termonology! All I want to do is display a command button in a main form if a date field in the subform is <= Date() - 90. I've managed to do this by doing the following: Code: Private Sub Form_Timer() If Forms!Exams!ExamsSubform!Date <= Date - 90 Then cmdProcess.Enabled = True Else ...

Hi Please can someone help me with an IIF problem. I have 2 fields on a form: VATRegistered (Yes/No) TotalCost (Currency) If the VATRegistered Field is Yes then I want TotalCost *0.175 if not - then just total cost. Here is the IIF Statement: =IIf( -1 ([Forms]![frmInvoices]![VATRegistered]),[TotalCost ]*0.175,[TotalCost]) The bit marked in red is the bit i am ...

I have fought with this for more than an hour. I have tried various combinations to no avail. I finnaly just did it exactly like a previous thread that I found using the search feature. I get an error message=Application defined or Object defined error 2465 Event=AfterUpdate of Combo29 Move focus to next user field Combo13 Form=ChooseActivity Current Field=Combo29 ...