Recent content by kannon

Hello All - appreciate the good advise that comes from the good folks on here. In my database I have 5 tables or varying size (fields, records). These tables actually come from our organizations shared database. Very good information that I need. At first I just thought of linking to the...

All - I have a memo data element in a form. I want to capture input information from many users. The users use various means of putting their information in. By default the memo field uses Calibri 10 font. This works well for those who type data in. For others who copy/paste, the data...

You are correct. The Choose Function is used in the query criteria, I do a requery on a list box using the query, triggered when the option group button is updated. Hope that makes sense. So ... First - Option Group - select On Time, Over Due, or (trying) All. When the option group...

Here's the code: SELECT qryAFED.System, qryAFED.Status FROM qryAFED WHERE (((qryAFED.[Status])=Choose([optgrpStatus],"On Time",Over Due", "All"))) ORDER BY qryAFED.System; The optgrpStatus is an Option Group with three buttons - On Time, Over De, and All. When I press On Time, the query...

The Choose function: Choose ([optgrpStatus],"On Time", "Over Due") is part of my query. Using the Query Wizard I put that in the Criteria row. Works fine for On Time and Over Due, just can't figure how to run the query with a criteria to get all entries. I tried "*" but all it looks for is *...

Hi I have an option group that lists a variety of categories which I want to query on. I know that the option group only returns values. In the Option Group, On Time = 1, Over Due =2 ,,,, I am using a Choose function in my query. That is working fine. But ... I would like to have a last...

Picture is worth a million words!! Finally seeing how the Row Source, Control Source, Bound Column play together with the queries. I am keeping that file for a long time!! Many thanks StarGrabber!!

Stargrabber - the example you sent was very helpful. Basically the extra table with the IDs from the other tables provide the linkage. Question - the relationships seem to be all connected yet I cannot make a form with Employee names and the courses they completed (cuts across multiple...

I am trying to generate a report that has two main forms. One form takes up about the whole page. I would like to have what I call a summary report sitting on top of that. The attachment shows what I normally do in Word using tight text wrap. Can't figure how to do it in Access. When I lay...

Hello - inexperienced Access user here. I have a database that I need to sort on 3 key data points - actual start date, planned start date, project name. The database contains about 300 records. What I would like to do is the following: 1) first sort on all records that have an actual...

Hello. This probably is not one of the more earth shuttering questions. I use the Record Buttons for scrolling thru records on a form. Before when using Access 2003 I could hold the left or right button and the records would scroll by quickly. With Access 2007 now I have to click each time...

Hello. I am new to Microsoft Access 2007 - learning by trial and error. I do not yet know how to do programming and was hoping to do the following without programming. Would appreciate any help/insight. Essentially I am trying to make a form that has three different combo boxes. These are key...