Search results

I have a form that some information is written to tables the form is not based on. (So I have VB code opening the table and populting using the With statment) This all works fine until the user wants to add another record to a new member without closing the form. I have a SAVE button the user...

When I click in a text box that contains a formated date field the curser could be set in the begining middle or end of the field with the format of _/_/_ ... Is there anyway to use the On_Click event to left justify the curser so the user can start typing the date at the begining? It works...

Thanks Bill, I have slept since I posted this but you are correct. My primary key was based on two columns to make it unique and I think I was bound to just one of them. kim

I get this if I field in one table that is a number and field that I am relating it to in another table that is maybe a date or text...

I have a survey form that runs from a query. When the user chooses a members# in the combo box it filters and gives only the Surveys filled out by the member and allows the user to enter a new survey if they want to. This works!! Here is what doesn't.. When I click on the combo box to choose...

You are exactly correct that worked perfectly.... kim

Hay everyone and happy holidays.... I have a question and maybe you have a better solution then the way I am going about it. I have vba code that based on a form sets some checkbox to true. The problem is I have several forms that use this same code so I have written several versions of this...

OK OK sorry guys I got it to work. Now other then the fact that I think I have myself in an infamous loop. Hay my life is great... kim

Hay all, I have a table which contains ProgID and MbrID. I have a form with no record source. On this form I have 3 checkboxes. What I am trying to do is display which program the member is in could be multiple. I have code written as follows: Private Sub Form_Open(Cancel As Integer) Dim db...

Thanks Richie I appreciate your help... kim

I have a questionaire form that basically has y/n answers. but one of the questions could be a multiselectionlist. Such as which of the following have you done. The list may be horseback riding, hiking, snow skiing etc. I would like to capture the anwswers of the questionaire in a table. How...

Thanks Here was my query before Select * from folder where ag_date between blah and blah; Here is my revised query that works magik plus I am able to go back to using my lost focus from previous Select Fld, Fld_Desc Where ag_date between blah and blah Group by Fld, Fld_Desc; Many thanks for...

Location is a good suggestion, but we do not document the call based upon location. I'll tell ya I tried date because I could type that in a text box and then when the user tabed out (lost focus) I then ran a query to the listbox to only show members that placed a call during those dates. My...

I have a reporting database which contains information on the number of times a member has placed a call. I want to report various information about this call. On a form I have a list box that can choose multiple members. (I have 100,000 members but only around 70,000 show up in list box. I...

Thanks I was afraid of that.....

I have code for an Input Box. When a user keys in information, I would like to have ** show to the user instead of what they key. Like the Password inputmask. Can this be done with an Input Box or do I have to create a form and change its input mask to password? Thanks in advance kim

Thanks Travis, This worked. I guess I was trying to by pass putting the text box on the form, but hiding it works ok too. Kim

I have a list box on a form which allows me to choose multiple selections. I have a query whose criteria is set to look at the listbox for information. My problem is if I choose just one item from the list box the query works. If I choose more than one item the query returns nothing. I have...

I have a switchboard that stays maximized the whole time. When I run a parameter query or report the parameters come to the front but once the query or report is done processing the results stay behind the form and I can see it unless I minimize my form. I don't want the users behind messing...

Could someone e-mail me this code too. kstroupe@phsystems.com Thx