Search results

This is a question that will continue to allow me to ask questions related to another Thread titled: Combo box issues http://www.access-programmers.co.uk/forums/showthread.php?t=266782 I need a table structure that will allow me to have a repair log data entry form with 3...

If it is a legacy record it will have a repairJob ID < 1500. Can I use that as a the reference for the trigger. Supposing #1 will not work, if I go with #2 can I have them sit on top of eachother? The dataentry form is maxed out on its length :eek:. Another issue may arrise that I would...

Singl record - Form view. It is basically a data entry form with three cascading comboboxes. Each child has approved values for use and values that are no longer approved for use.

I am sorry, I used a very generic term. My actual project does not use "name" for the field. Thanks for the reminder though. I just got carried away overgeneralizing my issue. I do not want the user to even be able to see "not-approved values" in the combobox selection. The little pickle...

I am going to give this a go and open a new thread if I need help still. My project has taken a turn and this part of it got me in the weeds a little bit with my deadline. I appreciate the help and will try to followup with this if my project timeline permits. Your comments are much appreciated!

I have a combo box that needs to only show approved values for any current data input but also be able to show legacy values (that were approved at one time but are no longer approved) My current issue: How can I only allow the user to select from current approved values but still be able to...

I still have many questions on this but for now I can mark this thread solved becuase my immediate question was answered. I am going to formalize my other questions and post new threads if they become pressing. Thanks for you interest in my questions!

The navigation sub form is unbound and so is frmfacilityrecordsearch. The design was recomended by accessallinone.com because I use the browse to comand to inside the DS form. The users can browse to facility details by clicking on facility name or find facility repair information when they...

Reading you post again ...How would I only insert the brackets for that specific character? The user may want to search for part of the facility name including that character(#) and some numbers after the pound sign. Is there some way to detect that # and then convert it to a string using a...

are you suggesting this? Like "*[" & [Forms]![frmMain]![Navigationsubform].Form!DS!SubFormControlName & "]*" According to the source you mention: http://office.microsoft.com/en-gb/access-help/examples-of-wildcard-characters-HA102809757.aspx [ ]Matches characters within the brackets.b[ae]ll...

Level 1 = frmMain --> holds the navigation subform Level 2 = frmFacilityRecordSearch --> Form that holds only a subform control named "DS" Level 3 = frmFacilityRecordSearchDS --> this is where the subform control is located DS is what I named the subform control similar to subform2 in the...

I have records that include # as part of their text string. How can I query for those records and return results containing #?. FacilityTable Facility Unit #141A Facility Unit #241A Facility #2F If I search for "unit #" on the search form control I want the query to return 2 of the...

Hahah I am in agreement with you. I will test now and appreciate your help. As far as unraveling goes... Can I count client visits in the normalization time window and only run the query on clients with 2 or more visits in the normalization time window for example. I will play with this...

I have yanked some data from north wind and made a test database for you. I made a form and query for both scenarios. The second one is the more complicated of the two. I am only really only interested in the SQL statements on the queries for each scenario becuase I will not be using the forms...

(1) Query would select 4/8/2014 as the normalization date for this client (last date visited in window ) (2) Pre Normalization date attendance count: Six visits (not including normalization date's visit shown in blue or the post norm dates in grey) Example on what fields will trigger query to...

(1) I need to determine the last time a client made an appointment inside the window(this example is a 4 month window at the beginning of 2014, later I may change the window to a 4 day window. I want to use Jan 1,2014 - April 30th 2014 for this example). (2) Once I determine the date from...

I need to find the frequency of client's appointment activity after their last appointment in a 4 month window. My question is: (1) Is my SQL going to give me the last time a client was in the office within the 4 month window? (2) What will my SQL need to like to count frequency of...

I will get the error message and test the code changes you recommended. Does it make sense that compact and repair would solve the issue...just for a small time frame?

I have cboCombo1 that cascades to cboCombo2 wich then cascades approved values to cboCascade3. The database is used by at most 3 people at one time and is located on a shared drive. I have recently got complaints that the cboCombo3 triggers an error AFTER a selection is made. (This means that...

Yes, the table was made from a union query. For some reason the data was given to me for a date range (7 months) by monthly reports. I just merged it all into one table. Then I noticed the unique Identifier was a string for the fleet location name . I need to get the names to a value that...