Search results

I don't know what I did, but somehow when I click on the tab nothing happens. I checked the internet for a solution but they tell me to open any form in design mode. Go to the immediate window in VBA. How do I get to the immediate window in VBA? I then need to enter CommandBars("Property...

Has anyone been able to figure out a work around to the following issue. Access 2010 leaves the last name that a user typed in after he has done and update. All of the other fields on the form are blanked except the dropdown box . This seems to confuse my users and they would prefer that the...

I keep getting an error 13 type mismatch in the statement where I use DCOUNT I am simply trying to get the number of records for a specific [ClientId] and [Gender] is equal to Male I have implemented the suggestion of my previous post done on yesterday and am still stuck. I tried to change Answ...

I really messed up and am looking for your thoughts to solve problem I designed a table called FAMILIES ClientID text This field is the ID for the entire family composition Lname text Fname text Gender Integer (Which should have been text) (This field is linked to a drop down box table where...

Fields: FoodStamps This is a YES/NO field (printed in the first or second columns) FSAmount This is a numeric field(always printed in the third column) I have a preprint form with three columns The first column is for a YES answer and I want to print YES if FoodStamps is TRUE The second...

I have a simple application where a user clicks on the name of the person he wants to update from a drop down box. The record is then retrieved and the fields are filled on the form. The user will then enter a value in the # in household field. The user is then required to click on the save...

I have a form that is displayed for the user to enter a date. I wrote a query that I want to use this date(parameter) to calculate the number of days from that date. For example: Now()-Max(Date of Distribution,DateAttended) <=180 This would take todays date and subtract the largest...

I have two tables: 1. Client Info table which contains the following fields: Clientid LastName FirstName 2.DatesDistribution table Clientid DateAttended The relationship is one to many for these tables. I have been trying to create a query that will show the following: Clientid LastName...

I have a form that I designed that contains two subforms. The first subform is an entry subform so you can post the current client visits. The second subform I want to just display all prior client visits and make updates or deletions if needed. Now my problem: It does not appear that I can...

The main form has a drop down box for the user to find the client record he wishes to add new visit data in the client visit history subfile. When the client is found, a history subfile is loaded which has all of the prior client visits. The history in the subfile contains two pieces of...

I have a combo box in which the user selects the client he want to update. The top of the form has descriptive data for the client ie. name address etc. The linked subform (on ClientId), below that descriptive data, displays all of the visits the client has made to our pantry. The fields are...

I am new to access 2010 and never programmed VB to interface with my Access database. I would like to learn how to do this and am looking for some text to help me learn VB as it relates to Access 2010. Any suggestions would be appreciated Jim:o

:confused:I have a form (ClientVisits form) that records the number of family members for each client that visits our food pantry. When the composition of a clients household changes I want to be able to click on a button to call up the UpdateHousehold form to add or delete family members...

I have fields that are set to entry equal NO and access automatically fills the background color to a dark gray. It is very difficult to read the data that is displayed in these fields. After trying various things on the property sheet, it seems to take the change, but when I try and display...

I have a table which I store visits by clients to our food pantry. The table contains the following fields" Date of visit date field #members in family number field Received shampoo yes/no field Received toothbrush yes/no field Shampoo rule is the client is entitled to shampoo every 4...

I created a query with two colums; one column is the count the number of records and the other column sums another field based upon a certain criteria being met. This information is printed in a report.(actually a subreport of the main report) If no records in my database meet the defined...

I created VB event on the ClientID field when its focus is lost, to check for a possible duplicate id being entered. When I tab from the ClientID to the next field (lastName) the msgbox appears to warn the user that they just entered a duplicate ClientID. I want to cursor to go back to the...

I have a NEW Client form that the user enters basic data i.e. name and address. This table called "ClientInformation" uses a 6 character key called CLIEDTID and is unique for that table.(ClientID is the 1st 4 characters of last name and first 2 char of first name. ) As part of the NEW...

I am a new user to access 2010. I encountered a puzzling problem in my form. I designed the following form in which the top portion of the form, and is the clients basic information. For example, it contains: First Name Last Name Address City State, zip The above information is stored in a...

I created a form called "Client Printout" that is a tab on my home page. On this form I created a text box to enter the date as mm/dd/yyyy. I also created a button that when clicked on by the user will print the report. This button, no matter how I try, will only display a small picture of a...