Search results

hi could someone please tell me what is wrong here? I have an unbound OptionGroup of checkboxes. I set the group to Null in the double click event and to update the table fields using texts instead of numbers, I used this code: Me!ASAWhy = Choose(Me.Frame23, "Allergy", "UGIB", "GCS<8")...

I tried to adapt John Big Booty's code but it didn't work for me. I have the below code in the OnChange event of my search box. It uses a continuous subform to search the database. It searches as I type and double clicking on the record populates the main form. Before I complete typing in the...

Hi, my VB skills are still beginner and I need help with this please. On my Login form, I have a check box to Remember Password. How can I code this?

For the attached Database, I have the table validation rule: IIf([More MgSO4?]="Yes",Not IsNull([extra dosage]),IsNull([extra dosage])) And IIf([anti HyperT agent?]="Yes",Not IsNull([anti HyperT dosage]),IsNull([anti HyperT dosage])) This works until you try to make a correction on a...

Hi, I have this table validation which I built using the VB expression builder: IIf([More MgSO4?]="Yes",Not IsNull([extra dosage]),MsgBox("Provide the dose!")) It doesn't work. If violated, how can I make this constraint give the message "Provide the dose!"

okay what am I doing wrong? I have a date field on my form and used Input Mask L<LL\-0000;;* and validation rule <=Date$() I want the user input to look like 'Aug-2010' for example. but I get error: The value you entered isn't valid for this field :banghead:

Hi, I made my form a pop up, saved and exited. Now I'd like to reverse this but the Form Design Tools Ribbon does not appear. How do I get the Property sheet for the form at this stage:confused: Could someone please advise?

Someone help me please. This one is driving me bonkers! I'm trying to create a switchboard through which one can access data entry forms. Now there are about 13 of such forms but I've put only 3 here for simplicity. The idea is to have a button (on the main switchboard) represent each category...

Could someone help me please? I have to assign multiple table validations to my table but they are not even working separately. What am I doing wrong here? Any help is most appreciated 1) I have two combo box controls: [Tocolytics] & [multiple_Tocolytics], 3 check boxes and 1 text box. Rule...

Hi, could someone help me with the code to fix this SEARCH button please?:confused: When I type in the searchbox, the subform pulls up the data already. The button gives an error when clicked. I would get rid of the button but the searchbox looks better with it. Any help is appreciated.

hi, I'm a beginner with VB. The SAVE button on my data entry form saves the data but it does not clear the form afterwards i.e. for the next record to be entered. Could someone advise on the code to do this?:confused: I created it using the control wizard. Any help is appreciated

My table has a compound primary key consisting of Trip_ID and Patient_ID. How can I make my data entry form "search as I type" in this key? The form also has a combo box and many tab controls. I really appreciate any help on this one.

help! I used the button wizard to create my SAVE button but it is not working. It is not updating the table. My DELETE button clears the form but does not remove the record from the table. Could someone please advise what I'm doing wrong?

My control wizard was not working and I have figured out why. It was not enabled. I went to the drop down menu of the control group icon and clicked on "use wizard". Very basic but this is a big relief for me. If anyone is helped by this... then good.

hi, I am still green and my VB skills are not strong. I have created a data entry form with many tabs. I DON'T want my save, cancel, update and delete buttons on each page. How can I make them universal on this form? Any help is much appreciated.

Hi there, sorry my VB skills are not strong and I need some help on how to go about this. :confused: On my data entry Form, I have a Combo Box [Condition] and five tab controls. Each tab has as many as 10 controls on it. The purpose of the Form is to populate a table. My questions are: 1) Do I...

Hello, I am creating a Form on which I have many controls. I need to place them in groups, on the Form. I can't find the control command to do that. Could someone please advise me on what to do please? Thanks much in advance

aargh! help me please. I am creating a database with Access 2010. The table in question has as many as 20 columns but the List box selection in Col1 should allow ONLY certain columns to be updated and the other columns disabled for the same row. I am going round and round and have managed to...

Hello Everyone:), I'm Cindy and from Canada. My Access level of expertise is between beginner and intermediate. However I want to learn more! I have read some of the threads in this forum and am excited to be a part of the team. Regards