Search results

Still haven't solved this one. I'm going to try to rephrase. Give a list of all teachers with a status of 1. For all those teachers find how many students with status of 4. If they have 0 students I can get them to come up, if they have students with status of 4 I can display them. I cannot...

Beat me to it on my Ipad. Hi Beetle!

So you are recommending that I divide up my one table that has all fields currently in it and make it two right? This will allow me to better control the information if I am following you correctly. Yes, it will allow you to avoid duplicate data entry and allow for useful display of the input...

Makes a lot of sense. Each client can have many cases. Are there ever more than 1 clients involved with 1 case. For example Table "client" Fields clientID (primary key) LastName FirstName Table "cases" CaseID (primary key) ClientID (foreign key) CaseOpen CaseClosed Maybe some other items...

Welcome to the forum! I'm still a bit new here as well and as such have recently been through many of the issues you are/will find. Can you give us a bit more information about your general needs for having this database? What type of items are in the collection fields table? You mention...

So you should have a primary key in the cust table (custID or similar). Also a primary key in the order table (orderID or similar). You should also have a foreign key in the order table (custID or similar). Having this foreign key in the order table allows the two tables to relate. You won't...

Check for missing references. Open any code module. Tools, references. (not 100% sure of path on 2010, I use 2003) Look for any that are marked as missing: Uncheck, recheck to fix. May need to bring file that the reference points to over to the end user PC.

Read up on me.requery You would want to use it in the after update event of your combo box. Chris

SELECT CFI11Basic.CFI11LastName, CFI11Basic.CFI11FirstName, Count(STD21Basic.STDID) AS CountOfSTDID, STD21Basic.STD21Status FROM (CFI11Basic LEFT JOIN STD21Basic ON CFI11Basic.CFIID = STD21Basic.CFIID) LEFT JOIN STDStatus ON STD21Basic.STD21Status = STDStatus.STDStatus GROUP BY...

Hey all, Attempting to sort out a bug in a code event that was set up by a predecessor. Very new to VBA but willing to play around! Access 2003 I have a text box that sorts the student list dynamically as the person is typing. The first time a student is clicked from the sorted user list it...

You'll need Some event to trigger a requery like a button click or a change of the textbox criteria.

Fire man, Try in the query, add the table you want to search from to the query. Add the field that you want to search to the query builder. In the criteria line type: like * & forms!FormName!txtboxname & * It will probably change to Like "*" & forms!formName!txtboxname & "*" Change formname...

Hey All, Pretty new to using VBA. I can find what I need to do, usually online and amend to use for my application. Can write very basic. Using Access 2003. I have an unbound form with many unbound comboboxes that I'm using to set the filter property of a subform bound to a query. Clear all...

Access 2003 Beginning/intermediate user inherited complex, occasionally poor structure DB How to set up a combobox for a search VBA which isn't text type but is a foreign key to another table? For data integrity I think I need to use the foreign key in my student as the record source in my...

Hey all, I've created a report that calculates several fields from a query in the DB. One of the fields sums about 20 other fields. I'd like to make a hyperlink to another report which shows the details of this calculation. I've found that MS support says that hyperlinks don't work directly in...

Hey Jim, How about posting the solution to help others who in the future may experience the same type of issue? Glad you got it straightened out!

Mark If you're still working on this you may need to tell your cross tab queries to accept parameters. Right click on the design view of the crosstab query and click parameters. In the parameter field type the same thing you use in the criteria for the sort. Choose the approprite data type. Best

Welcome to the forums! I suggest that you start a new thread in the general section. As this is in the introduce yourself many will not view it. Write down and post the specific error and be descriptive on when it happens. It sounds as though you likely have a required field that you didn't...

ended up combining the two desired fields. Not pretty but functional. :)

:confused: well i'm still quite stuck. I've narrowed it down to the three queries. One is a normal select query that pulls all the data. The two crosstabs are what I need to be unioned but can't make the next leap to get them to match up. If anyone with Higher Access Power! than me can take a...